Descendants of The West End filtering out any place that is visiting Null Island right now

0.0273959636688 seconds
{'query': {'filtered': {'filter': {'and': [{'bool': {'must_not': [{'term': {'geom:latitude': 0.0}}, {'term': {'geom:longitude': 0.0}}, {'exists': {'field': 'edtf:deprecated'}}]}}]}, 'query': {'term': {'wof:belongsto': 1158859031}}}}, 'sort': [{'wof:name': 'asc'}]}
Would you like try this query again to include records that have been deprecated ?
  1. 136186175 H 2 0 Interiors — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  2. 336780895 007 Licence To Thrill The James Bond Ride — this is a venue in United Kingdom
    • it is tagged entertainer
    • it was last modified on December 22, 2017
  3. 287079413 South Eastern Close 01 Plc — this is a venue in United Kingdom
    • it is tagged club
    • it was last modified on December 23, 2017
  4. 287145523 Aon 04 Ltd. — this is a venue in United Kingdom
    • it is tagged society and friendly
    • it was last modified on December 22, 2017
  5. 924273299 West 1 Barber Shop — this is a venue in United Kingdom
  6. 924598441 Zone 1 Recruitment Ltd — this is a venue in United Kingdom
    • it is tagged consultant
    • it was last modified on December 23, 2017
  7. 320330975 The Stage 1 Music Co Ltd — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  8. 907994531 A 1 Food & Wine — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  9. 119009233 Admin Realisation No 1 Ltd. — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  10. 119351351 Baltic Fund 1 Llc — this is a venue in United Kingdom
    • it was last modified on December 22, 2017
  11. 119240283 Unit 1 Dry Cleaning — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  12. 202720021 Alpha 1 Fish Restaurant — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  13. 303210845 Satman Developments (No. 1) Limited — this is a venue in United Kingdom
    • it is tagged property
    • it was last modified on December 23, 2017
  14. 303704809 A 1 Digital Printing — this is a venue in United Kingdom
    • it is tagged t-shirt
    • it was last modified on December 23, 2017
  15. 319920681 Trade Credit Finance No 1 Ltd. — this is a venue in United Kingdom
    • it is tagged consultant
    • it was last modified on December 23, 2017
  16. 303672921 Atelier 1 Ltd. — this is a venue in United Kingdom
  17. 118527599 Television Francaise 1 — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  18. 924146923 10 Hyde Park Square Ltd — this is a venue in United Kingdom
    • it is tagged club
    • it was last modified on December 22, 2017
  19. 135391705 10 Manchester Street Hostelerie Ltd. — this is a venue in United Kingdom
    • it was last modified on December 22, 2017
  20. 118754395 Number 10 — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  21. 119303387 100 Percent — this is a venue in United Kingdom
    • it was last modified on December 22, 2017
  22. 119024627 100 Club Ltd. — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  23. 119082275 Reuters 1000 — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  24. 923891435 101 Financial Consultancy — this is a venue in United Kingdom
    • it is tagged consultant
    • it was last modified on December 22, 2017
  25. 135602509 101 Snackbar — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  26. 269506711 101 Cafe — this is a venue in United Kingdom
    • it is tagged tea and room
    • it was last modified on December 22, 2017
  27. 135291593 103 Exchange — this is a venue in United Kingdom
    • it was last modified on December 22, 2017
  28. 924838183 111pix — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  29. 303725981 Swift 112 Limited — this is a venue in United Kingdom
    • it is tagged excursion
    • it was last modified on December 22, 2017
  30. 286875983 112 Harley Street Ltd. — this is a venue in United Kingdom
    • it is tagged home
    • it was last modified on December 23, 2017
  31. 908004557 1/2 Cut Recruitment Ltd — this is a venue in United Kingdom
    • it is tagged consultant
    • it was last modified on December 22, 2017
  32. 908004647 1/2 Cut Productions Ltd — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  33. 118527587 Television Tokyo Channel 12 — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  34. 924253133 120 Wigmore Street Limited — this is a venue in United Kingdom
    • it is tagged club
    • it was last modified on December 23, 2017
  35. 907869885 The Sun & 13 Cantons — this is a venue in United Kingdom
    • it is tagged pubs and inn
    • it was last modified on December 23, 2017
  36. 336950347 13 Dover Street Limited — this is a venue in United Kingdom
    • it is tagged club
    • it was last modified on December 23, 2017
  37. 119024593 14 Queens Avenue Ltd — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  38. 135880201 Red 14 (Fourteen) Ltd. — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  39. 923919329 15 Cheyne Place Ltd. — this is a venue in United Kingdom
    • it is tagged property
    • it was last modified on December 22, 2017
  40. 119390215 15 Mount Street Ltd. — this is a venue in United Kingdom that we believe to be open
    • it was last modified on December 22, 2017
  41. 924314497 173 Sutherland Avenue Limited — this is a venue in United Kingdom
    • it is tagged property
    • it was last modified on December 23, 2017
  42. 135781021 Oval (1773a) Ltd. — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  43. 136182311 18 & 19 Lowndes Square Limited — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  44. 286623087 Cerruti 1881 — this is a venue in United Kingdom
    • it is tagged menswear
    • it was last modified on December 22, 2017
  45. 203408103 Cerruti Femme 1881 — this is a venue in United Kingdom
    • it is tagged clothing
    • it was last modified on December 22, 2017
  46. 924749909 Citaco (1957) Limited — this is a venue in United Kingdom
    • it is tagged accomodation
    • it was last modified on December 22, 2017
  47. 907781341 J Golding & Sons (1960) — this is a venue in United Kingdom
    • it is tagged newsagent
    • it was last modified on December 22, 2017
  48. 119240103 Undeserved 1988 Generosity Ltd. — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  49. 907444913 Safin Investments (1989) Ltd. — this is a venue in United Kingdom
    • it is tagged consultant
    • it was last modified on December 23, 2017
  50. 924723329 Cork & Bottle (Wines) 1991 Ltd. — this is a venue in United Kingdom
    • it was last modified on December 22, 2017
  51. 924402487 Belvedere Smith Holdings (1993) Ltd — this is a venue in United Kingdom
    • it is tagged property
    • it was last modified on December 22, 2017
  52. 924777543 1ST Alert Security Ltd — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  53. 119434325 1ST Class — this is a venue in United Kingdom
    • it was last modified on December 22, 2017
  54. 119434363 1ST Class Accommodation Addresses — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  55. 135570787 1st Class Computer Services — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  56. 303719749 1st Service Ltd — this is a venue in United Kingdom
    • it is tagged distributor and film
    • it was last modified on December 23, 2017
  57. 135927399 1st Transnational Translations — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  58. 924067581 Recruitment 2 — this is a venue in United Kingdom
    • it is tagged consultant
    • it was last modified on December 23, 2017
  59. 924645387 2 D Video Facilities Ltd. — this is a venue in United Kingdom
    • it is tagged broadcasting
    • it was last modified on December 22, 2017
  60. 924687493 2 Brydges Place — this is a venue in United Kingdom
    • it is tagged club
    • it was last modified on December 22, 2017
  61. 924749287 Cr Estates (No. 2) Ltd — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  62. 320311297 4 2 2 Video Graphics London — this is a venue in United Kingdom
    • it is tagged broadcasting
    • it was last modified on December 23, 2017
  63. 336923383 2 C S Communications Ltd. — this is a venue in United Kingdom
  64. 336924453 G 2 Communications Ltd. — this is a venue in United Kingdom
    • it is tagged audio-visual
    • it was last modified on December 22, 2017
  65. 924809969 2 D Design Ltd. — this is a venue in United Kingdom
    • it is tagged graphic and designer
    • it was last modified on December 23, 2017
  66. 907752193 2 C V Ltd — this is a venue in United Kingdom
    • it is tagged market
    • it was last modified on December 23, 2017
  67. 119197383 2 P Films — this is a venue in United Kingdom
    • it was last modified on December 22, 2017
  68. 235932707 Cover 2 Cover International Ltd — this is a venue in United Kingdom
  69. 136069007 T T O 2 Ltd. — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  70. 219933461 Efes 2 — this is a venue in United Kingdom that we believe to be open
    • it was last modified on December 23, 2017
  71. 219611755 2 KO International Ltd — this is a venue in United Kingdom
    • it is tagged consultant
    • it was last modified on December 23, 2017
  72. 186413665 K 2 Outdoor Equipment Ltd — this is a venue in United Kingdom
  73. 203311069 S 2 Ltd — this is a venue in United Kingdom
  74. 303891287 B 2 — this is a venue in United Kingdom
    • it was last modified on December 23, 2017
  75. 303891869 A 3 D 2 Ltd. — this is a venue in United Kingdom
    • it is tagged pubs and inn
    • it was last modified on December 23, 2017
  76. 303926421 Anatomia (back 2) Ltd — this is a venue in United Kingdom
    • it is tagged orthopaedic
    • it was last modified on December 23, 2017
  77. 286867631 2 Select Events — this is a venue in United Kingdom
    • it is tagged party and organiser
    • it was last modified on December 23, 2017
  78. 236975111 Recruitment 2 — this is a venue in United Kingdom
    • it is tagged consultant
    • it was last modified on December 23, 2017
  79. 119084505 2 Montagu Square Ltd — this is a venue in United Kingdom that we believe to be open
    • it was last modified on December 23, 2017
  80. 118527585 France 2 Television — this is a venue in United Kingdom
    • it was last modified on December 22, 2017
  81. 924190671 Rxd 2000 Ltd. — this is a venue in United Kingdom
    • it is tagged accountant
    • it was last modified on December 23, 2017
  82. 924556787 Europorscha 2000 Ltd. — this is a venue in United Kingdom
    • it is tagged part and accessory
    • it was last modified on December 23, 2017
  83. 907599893 Capricorn 2000 Ltd — this is a venue in United Kingdom
    • it is tagged caterer
    • it was last modified on December 22, 2017
  84. 135360491 Transcend 2000 Ltd — this is a venue in United Kingdom
    • it was last modified on December 22, 2017
loading facets from the sky

Log


There are 14,595 results

There are so many results for this query that the Spelunker database can't do page1, page2, page3... style pagination without getting sad. There are actually 174 pages worth of results for this query but as of this writing there is only the "next page" of results. We all have our limits, right? Speaking of limits, these query results have a pretty short shelf life. As long as you are paging through the results everything will be okay but if left idle for too long (about 5 minutes) they will expire and you'll need to perform a new query. It's good to have constraints to work against, right?