There are 948,928 places matching geoplanet and this is one page of many

0.135322809219 seconds
{'query': {'function_score': {'boost_mode': 'multiply', 'functions': [{'filter': {'term': {'names_preferred': u'geoplanet'}}, 'weight': 10.0}, {'filter': {'term': {'names_all': u'geoplanet'}}, 'weight': 1.0}, {'filter': {'term': {'wof:name': u'geoplanet'}}, 'weight': 6.0}, {'filter': {'not': {'term': {'wof:placetype': 'venue'}}}, 'weight': 2.0}, {'filter': {'term': {'wof:placetype': 'location'}}, 'weight': 5.0}, {'filter': {'exists': {'field': 'wk:population'}}, 'weight': 1.25}], 'query': {'filtered': {'filter': {'and': [{'bool': {'must_not': [{'exists': {'field': 'edtf:deprecated'}}]}}]}, 'query': {'match': {'_all': {'operator': 'and', 'query': u'geoplanet'}}}}}, 'score_mode': 'multiply'}}, 'sort': [{'gn:population': {'mode': 'max', 'order': 'desc'}}, {'geom:area': {'mode': 'max', 'order': 'desc'}}, {'wof:scale': {'mode': 'max', 'order': 'desc'}}, {'wof:megacity': {'mode': 'max', 'order': 'desc'}}]}
Would you like try this query again to include records that have been deprecated ?
  1. 101750367 London — this is a locality in United Kingdom
    • its population is 7,556,900
    • it was last modified on July 17, 2019
  2. 101748799 Berlin — this is a locality in Germany
    • its population is 3,426,354
    • this record has been superseded
    • it was last modified on December 08, 2020
  3. 101909779 Berlin — this is a locality in Germany
    • its population is 3,375,222
    • it was last modified on July 24, 2019
  4. 101748283 Madrid — this is a locality in Spain
    • its population is 3,255,944
    • it was last modified on December 08, 2020
  5. 101752489 Kiev City — this is a locality in Ukraine
    • its population is 2,797,553
    • it was last modified on December 08, 2020
  6. 101752607 Rome — this is a locality in Italy
    • its population is 2,318,895
    • it was last modified on December 08, 2020
  7. 101751119 Paris — this is a locality in France
    • its population is 2,138,551
    • it was last modified on December 08, 2020
  8. 101751703 Budapest — this is a locality in Hungary
    • its population is 1,741,041
    • it was last modified on December 08, 2020
  9. 101748841 Hamburg — this is a locality in Germany
    • its population is 1,739,117
    • it was last modified on July 16, 2019
  10. 101752777 Warszawa — this is a locality in Poland
    • its population is 1,702,139
    • it was last modified on July 19, 2019
  11. 101748073 Wien — this is a locality in Austria
    • its population is 1,691,468
    • it was last modified on December 08, 2020
  12. 101748323 Barcelona — this is a locality in Spain
    • its population is 1,621,537
    • it was last modified on July 16, 2019
  13. 101752963 Харків — this is a locality in Ukraine
    • its population is 1,430,885
    • it was last modified on July 16, 2019
  14. 101748479 München — this is a locality in Germany
    • its population is 1,260,391
    • it was last modified on July 16, 2019
  15. 101752307 Stockholm — this is a locality in Sweden
    • its population is 1,253,309
    • it was last modified on December 08, 2020
  16. 101752703 Milano — this is a locality in Italy
    • its population is 1,236,837
    • it was last modified on July 17, 2019
  17. 101748113 Praha — this is a locality in Czechia
    • its population is 1,165,581
    • it was last modified on December 08, 2020
  18. 101749159 Copenhagen — this is a locality in Denmark
    • its population is 1,153,615
    • it was last modified on December 08, 2020
  19. 101748887 Sofia — this is a locality in Bulgaria
    • its population is 1,152,556
    • it was last modified on December 08, 2020
  20. 101752861 Дніпропетровськ — this is a locality in Ukraine
    • its population is 1,032,822
    • it was last modified on July 16, 2019
  21. 101752891 Донецьк — this is a locality in Ukraine
    • its population is 1,024,700
    • it was last modified on July 16, 2019
  22. 101751737 Dublin — this is a locality in Ireland
    • its population is 1,024,027
    • it was last modified on December 08, 2020
  23. 1175610569 Brussel — this is a locality in Belgium
    • its population is 1,019,022
    • it was last modified on December 08, 2020
  24. 101913231 Brussel — this is a locality in Belgium
    • its population is 1,019,022
    • it was last modified on July 16, 2019
  25. 101913235 Brussel — this is a locality in Belgium
    • its population is 1,019,022
    • it was last modified on July 16, 2019
  26. 101913243 Brussel — this is a locality in Belgium
    • its population is 1,019,022
    • it was last modified on July 16, 2019
  27. 101913245 Brussel — this is a locality in Belgium
    • its population is 1,019,022
    • it was last modified on July 16, 2019
  28. 101913247 Brussel — this is a locality in Belgium
    • its population is 1,019,022
    • it was last modified on July 16, 2019
  29. 101752799 Одеса — this is a locality in UK
    • its population is 1,001,558
    • it was last modified on July 16, 2019
  30. 101752771 Köln — this is a locality in Germany
    • its population is 963,395
    • it was last modified on July 16, 2019
  31. 101752555 Napoli — this is a locality in Italy
    • its population is 959,470
    • it was last modified on July 17, 2019
  32. 101752697 Turin — this is a locality in Italy
    • its population is 870,456
    • it was last modified on July 17, 2019
  33. 101748241 Valencia — this is a locality in Spain
    • its population is 814,208
    • it was last modified on July 16, 2019
  34. 101752845 Запоріжжя — this is a locality in Ukraine
    • its population is 796,217
    • it was last modified on July 16, 2019
  35. 101749199 Marseille — this is a locality in France
    • its population is 794,811
    • it was last modified on July 16, 2019
  36. 101913783 Łódź — this is a locality in Poland
    • its population is 768,755
    • it was last modified on July 19, 2019
  37. 101913781 Łódź — this is a locality in Poland
    • its population is 768,755
    • it was last modified on July 19, 2019
  38. 101912923 Antalya — this is a locality in Turkey
    • its population is 758,188
    • it was last modified on July 17, 2019
  39. 101752117 Kraków — this is a locality in Poland
    • its population is 755,050
    • it was last modified on July 19, 2019
  40. 101751789 Rīga — this is a locality in Latvia
    • its population is 742,572
    • it was last modified on December 08, 2020
  41. 101751893 Amsterdam — this is a locality in Netherlands
    • its population is 741,636
    • it was last modified on December 08, 2020
  42. 101752483 Львів — this is a locality in Ukraine
    • its population is 717,803
    • it was last modified on July 16, 2019
  43. 101748225 Sevilla — this is a locality in Spain
    • its population is 703,206
    • it was last modified on July 16, 2019
  44. 101751659 Zagreb — this is a locality in Croatia
    • its population is 698,966
    • it was last modified on December 08, 2020
  45. 101748361 Zaragoza — this is a locality in Spain
    • its population is 674,317
    • it was last modified on July 16, 2019
  46. 1175612731 Athens — this is a locality in Greece
    • its population is 664,046
    • it was last modified on December 08, 2020
  47. 101752837 Кривий Ріг — this is a locality in Ukraine
    • its population is 652,380
    • it was last modified on July 16, 2019
  48. 101913837 Frankfurt am Main — this is a locality in Germany
    • its population is 650,000
    • it was last modified on July 16, 2019
  49. 101752517 Palermo — this is a locality in Italy
    • its population is 648,260
    • it was last modified on July 17, 2019
  50. 1175613685 Diyarbakır — this is a locality in Turkey
    • its population is 644,763
    • it was last modified on July 17, 2019
  51. 101751793 Chisinau — this is a locality in Moldova, Republic of
    • its population is 635,994
    • it was last modified on December 08, 2020
  52. 101752181 Wrocław — this is a locality in Poland
    • its population is 634,893
    • it was last modified on July 19, 2019
  53. 101751843 Rotterdam — this is a locality in Netherlands
    • its population is 598,199
    • it was last modified on July 17, 2019
  54. 101748709 Essen — this is a locality in Germany
    • its population is 593,085
    • it was last modified on July 16, 2019
  55. 101905809 Stuttgart — this is a locality in Germany
    • its population is 589,793
    • it was last modified on July 16, 2019
  56. 101748719 Dortmund — this is a locality in Germany
    • its population is 588,462
    • it was last modified on July 16, 2019
  57. 101752663 Genova — this is a locality in Italy
    • its population is 580,223
    • it was last modified on July 17, 2019
  58. 101751917 Oslo — this is a locality in Norway
    • its population is 580,000
    • it was last modified on July 19, 2019
  59. 101748671 Düsseldorf — this is a locality in Germany
    • its population is 573,057
    • it was last modified on July 16, 2019
  60. 101752223 Poznań — this is a locality in Poland
    • its population is 570,352
    • it was last modified on July 19, 2019
  61. 101748185 Málaga — this is a locality in Spain
    • its population is 568,305
    • it was last modified on July 16, 2019
  62. 101748417 Helsinki — this is a locality in Finland
    • its population is 558,457
    • it was last modified on December 08, 2020
  63. 101913887 Bremen — this is a locality in Germany
    • its population is 546,501
    • it was last modified on July 16, 2019
  64. 101748829 Bremen — this is a locality in Germany
    • its population is 546,501
    • this record has been superseded
    • it was last modified on July 16, 2019
  65. 101753031 Vilnius — this is a locality in Lithuania
    • its population is 542,366
    • it was last modified on December 08, 2020
  66. 101913223 İçel — this is a locality in Turkey
    • its population is 537,842
    • it was last modified on July 17, 2019
  67. 101752087 Lisboa — this is a locality in Portugal
    • its population is 517,802
    • it was last modified on December 08, 2020
  68. 101748819 Hannover — this is a locality in Germany
    • its population is 515,140
    • it was last modified on July 16, 2019
  69. 101752809 Миколаїв — this is a locality in Ukraine
    • its population is 510,840
    • it was last modified on July 16, 2019
  70. 101748685 Leipzig — this is a locality in Germany
    • its population is 504,971
    • it was last modified on July 16, 2019
  71. 101748713 Duisburg — this is a locality in Germany
    • its population is 504,358
    • it was last modified on July 16, 2019
  72. 101752295 Göteborg — this is a locality in Sweden
    • its population is 504,084
    • it was last modified on July 17, 2019
  73. 101905935 Nürnberg — this is a locality in Germany
    • its population is 495,121
    • it was last modified on June 29, 2019
  74. 101752773 Dresden — this is a locality in Germany
    • its population is 486,854
    • it was last modified on July 16, 2019
  75. 101752849 Маріуполь — this is a locality in Ukraine
    • its population is 481,626
    • it was last modified on July 16, 2019
  76. 101752763 The Hague — this is a locality in Netherlands
    • its population is 474,292
    • it was last modified on December 08, 2020
  77. 101749431 Lyon — this is a locality in France
    • its population is 472,317
    • it was last modified on July 16, 2019
  78. 101750547 Liverpool — this is a locality in United Kingdom
    • its population is 468,945
    • it was last modified on July 17, 2019
  79. 101752271 Gdańsk — this is a locality in Poland
    • its population is 461,865
    • it was last modified on July 19, 2019
  80. 101748099 Antwerpen — this is a locality in Belgium
    • its population is 459,805
    • it was last modified on July 16, 2019
  81. 101750579 Leeds — this is a locality in United Kingdom
    • its population is 455,123
    • it was last modified on July 17, 2019
  82. 101752959 Луганськ — this is a locality in Ukraine
    • its population is 452,000
    • it was last modified on July 16, 2019
  83. 101911225 Sanliurfa — this is a locality in Turkey
    • its population is 449,549
    • it was last modified on July 17, 2019
  84. 101750529 Sheffield — this is a locality in United Kingdom
    • its population is 447,047
    • it was last modified on July 17, 2019
loading facets from the sky

Log


There are 948,928 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 11,297 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?