There are 4,355,719 places matching geonames and this is one page of many

0.368407011032 seconds
{'query': {'function_score': {'boost_mode': 'multiply', 'functions': [{'filter': {'term': {'names_preferred': u'geonames'}}, 'weight': 10.0}, {'filter': {'term': {'names_all': u'geonames'}}, 'weight': 1.0}, {'filter': {'term': {'wof:name': u'geonames'}}, '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'geonames'}}}}}, '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. 102191569 Asia — this is a continent
    • its population is 3,812,366,000
    • it was last modified on July 17, 2019
  2. 85632763 Vietnam — this is a country
    • its population is 89,571,130
    • it was last modified on August 13, 2019
  3. 102020393 Provinsi Jawa Barat — this is a locality in Indonesia
    • its population is 45,278,744
    • it was last modified on July 16, 2019
  4. 85632751 Sudan — this is a country
    • its population is 35,000,000
    • it was last modified on August 13, 2019
  5. 102020389 Provinsi Jawa Tengah — this is a locality in Indonesia
    • its population is 34,087,148
    • it was last modified on July 16, 2019
  6. 85633041 Canada — this is a country
    • its population is 33,679,000
    • it was last modified on August 12, 2019
  7. 85632403 Taiwan — this is a country
    • its population is 22,894,384
    • it was last modified on August 13, 2019
  8. 85903649 上海市 — this is a neighbourhood in China
    • its population is 22,315,474
    • it was last modified on July 17, 2019
  9. 102020387 Provinsi Jawa Timur — this is a locality in Indonesia
    • its population is 22,200,177
    • it was last modified on July 16, 2019
  10. 85632313 Sri Lanka — this is a country
    • its population is 21,513,990
    • it was last modified on August 13, 2019
  11. 102020795 Borneo — this is a locality in Indonesia
    • its population is 19,000,000
    • it was last modified on July 26, 2019
  12. 85633337 Netherlands — this is a country
    • its population is 16,645,000
    • it was last modified on August 13, 2019
  13. 102030609 Mumbai — this is a locality in India
    • its population is 12,691,836
    • it was last modified on July 17, 2019
  14. 102027745 Beijing — this is a locality in China
    • its population is 11,716,620
    • it was last modified on July 17, 2019
  15. 102027107 Tianjin — this is a locality in China
    • its population is 11,090,314
    • it was last modified on July 17, 2019
  16. 102027597 Guangzhou — this is a locality in China
    • its population is 11,071,424
    • it was last modified on July 17, 2019
  17. 102030425 Delhi — this is a locality in India
    • its population is 10,927,986
    • it was last modified on July 17, 2019
  18. 1125783031 Devli — this is a locality in India
    • its population is 10,927,986
    • it was last modified on October 30, 2017
  19. 102003033 Moscow — this is a locality in Russian Federation
    • its population is 10,381,222
    • it was last modified on July 16, 2019
  20. 102027165 Shenzhen — this is a locality in China
    • its population is 10,358,381
    • it was last modified on July 17, 2019
  21. 102026327 Seoul — this is a locality in Korea, Republic of
    • its population is 10,349,312
    • it was last modified on July 16, 2019
  22. 102020435 Daerah Khusus Ibukota Jakarta — this is a locality in Indonesia
    • its population is 9,953,016
    • it was last modified on July 16, 2019
  23. 102027061 Wuhan — this is a locality in China
    • its population is 9,785,388
    • it was last modified on July 17, 2019
  24. 102018311 Provinsi Sumatera Utara — this is a locality in Indonesia
    • its population is 9,630,873
    • it was last modified on July 16, 2019
  25. 102020439 Jakarta — this is a locality in Indonesia
    • its population is 8,540,121
    • it was last modified on July 16, 2019
  26. 102031307 Tokyo — this is a locality in Japan
    • its population is 8,336,599
    • it was last modified on July 26, 2019
  27. 85632657 South Sudan — this is a country
    • its population is 8,260,490
    • it was last modified on August 13, 2019
  28. 85977539 New York — this is a locality in United States
    • its population is 8,175,133
    • it was last modified on July 17, 2019
  29. 102018953 Provinsi Sulawesi Selatan — this is a locality in Indonesia
    • its population is 8,034,776
    • it was last modified on July 16, 2019
  30. 85669985 Bandundu — this is a region in Congo, The Democratic Republic of the
    • its population is 8,000,000
    • it was last modified on August 13, 2019
  31. 102027633 Dongguan — this is a locality in China
    • its population is 8,000,000
    • it was last modified on July 17, 2019
  32. 102026641 Taipei — this is a locality in Taiwan, Province of China
    • its population is 7,871,900
    • it was last modified on July 16, 2019
  33. 1125867167 台北 — this is a locality in Taiwan, Province of China
    • its population is 7,871,900
    • it was last modified on July 16, 2019
  34. 102018939 Provinsi Sumatera Selatan — this is a locality in Indonesia
    • its population is 7,743,794
    • it was last modified on July 16, 2019
  35. 101750367 London — this is a locality in United Kingdom
    • its population is 7,556,900
    • it was last modified on July 17, 2019
  36. 85669975 Équateur — this is a region in Congo, The Democratic Republic of the
    • its population is 7,500,000
    • it was last modified on August 13, 2019
  37. 85632513 Tajikistan — this is a country
    • its population is 7,487,489
    • it was last modified on August 13, 2019
  38. 102027689 Chongqing — this is a locality in China
    • its population is 7,457,600
    • it was last modified on July 17, 2019
  39. 102027703 Chengdu — this is a locality in China
    • its population is 7,415,590
    • it was last modified on July 17, 2019
  40. 1125371489 成都市 — this is a localadmin in China
    • its population is 7,415,590
    • it was last modified on October 30, 2017
  41. 85633755 Serbia — this is a country
    • its population is 7,344,847
    • it was last modified on June 29, 2019
  42. 102027291 Nanjing — this is a locality in China
    • its population is 7,165,292
    • it was last modified on July 17, 2019
  43. 102027293 Nanchong — this is a locality in China
    • its population is 7,150,000
    • it was last modified on July 17, 2019
  44. 1125290269 南充市 — this is a localadmin in China
    • its population is 7,150,000
    • it was last modified on October 30, 2017
  45. 85672963 Rift Valley — this is a region in Kenya
    • its population is 6,987,036
    • it was last modified on August 13, 2019
  46. 85632483 Hong Kong S.A.R. — this is a country
    • its population is 6,898,686
    • it was last modified on August 13, 2019
  47. 85669979 Orientale — this is a region in Congo, The Democratic Republic of the
    • its population is 6,828,888
    • it was last modified on August 13, 2019
  48. 102027041 Xi’an — this is a locality in China
    • its population is 6,501,190
    • it was last modified on July 17, 2019
  49. 85670011 Kasaï-Oriental — this is a region in Congo, The Democratic Republic of the
    • its population is 6,500,000
    • it was last modified on August 13, 2019
  50. 85632425 Jordan — this is a country
    • its population is 6,407,085
    • it was last modified on August 13, 2019
  51. 102027875 Shenyang — this is a locality in China
    • its population is 6,255,921
    • it was last modified on July 17, 2019
  52. 102027571 Hangzhou — this is a locality in China
    • its population is 6,241,971
    • it was last modified on July 17, 2019
  53. 1125371469 杭州市 — this is a localadmin in China
    • its population is 6,241,971
    • it was last modified on October 30, 2017
  54. 101953261 Rio de Janeiro — this is a locality in Brazil
    • its population is 6,023,699
    • it was last modified on July 16, 2019
  55. 102027921 Harbin — this is a locality in China
    • its population is 5,878,939
    • it was last modified on July 17, 2019
  56. 85632761 Kyrgyzstan — this is a country
    • its population is 5,776,500
    • it was last modified on August 13, 2019
  57. 85670015 Katanga — this is a region in Congo, The Democratic Republic of the
    • its population is 5,600,000
    • it was last modified on August 13, 2019
  58. 102027127 Tai’an — this is a locality in China
    • its population is 5,499,000
    • it was last modified on July 17, 2019
  59. 85633769 Slovakia — this is a country
    • its population is 5,455,000
    • it was last modified on August 13, 2019
  60. 102027777 Suzhou — this is a locality in China
    • its population is 5,345,961
    • it was last modified on July 17, 2019
  61. 1125371549 苏州市 — this is a localadmin in China
    • its population is 5,345,961
    • it was last modified on October 30, 2017
  62. 102027175 Shantou — this is a locality in China
    • its population is 5,329,024
    • it was last modified on July 17, 2019
  63. 1125359339 Województwo Mazowieckie — this is a localadmin in Poland
    • its population is 5,164,000
    • it was last modified on October 30, 2017
  64. 102025263 Bangkok — this is a locality in Thailand
    • its population is 5,104,476
    • it was last modified on July 16, 2019
  65. 102030819 Bangalore — this is a locality in India
    • its population is 5,104,047
    • it was last modified on July 17, 2019
  66. 102008119 Leningrad — this is a locality in Russian Federation
    • its population is 5,028,000
    • this record has been superseded
    • it was last modified on November 09, 2017
  67. 102018941 Provinsi Sumatera Barat — this is a locality in Indonesia
    • its population is 5,014,112
    • it was last modified on July 16, 2019
  68. 85633341 Norway — this is a country
    • its population is 5,009,150
    • it was last modified on August 13, 2019
  69. 102020815 Kabupaten Bogor — this is a locality in Indonesia
    • its population is 4,985,585
    • it was last modified on July 16, 2019
  70. 85670021 Nord-Kivu — this is a region in Congo, The Democratic Republic of the
    • its population is 4,908,824
    • it was last modified on August 13, 2019
  71. 102016915 Santiago — this is a locality in Chile
    • its population is 4,837,295
    • it was last modified on July 20, 2019
  72. 102020027 Provinsi Lampung — this is a locality in Indonesia
    • its population is 4,817,226
    • it was last modified on July 16, 2019
  73. 102018559 Nanggroe Aceh Darussalam Province — this is a locality in Indonesia
    • its population is 4,748,085
    • it was last modified on July 16, 2019
  74. 85672959 Eastern — this is a region in Kenya
    • its population is 4,631,779
    • it was last modified on August 13, 2019
  75. 102030585 Kolkata — this is a locality in India
    • its population is 4,631,392
    • it was last modified on July 17, 2019
  76. 85633163 Georgia — this is a country
    • its population is 4,630,000
    • it was last modified on August 13, 2019
  77. 85633241 Ireland — this is a country
    • its population is 4,622,917
    • it was last modified on August 13, 2019
  78. 85632609 Bosnia and Herzegovina — this is a country
    • its population is 4,590,000
    • it was last modified on July 16, 2019
  79. 85669989 Kasaï-Occidental — this is a region in Congo, The Democratic Republic of the
    • its population is 4,545,940
    • it was last modified on August 13, 2019
  80. 102019651 Propinsi Nusa Tenggara Barat — this is a locality in Indonesia
    • its population is 4,500,212
    • it was last modified on July 16, 2019
  81. 85633229 Croatia — this is a country
    • its population is 4,491,000
    • it was last modified on August 13, 2019
  82. 102020321 Provinsi Kalimantan Barat — this is a locality in Indonesia
    • its population is 4,395,983
    • it was last modified on July 16, 2019
  83. 85672955 Nyanza — this is a region in Kenya
    • its population is 4,392,196
    • it was last modified on August 13, 2019
  84. 102027459 Jinan — this is a locality in China
    • its population is 4,335,989
    • it was last modified on July 17, 2019
loading facets from the sky

Log


There are 4,355,719 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 51,854 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?