There are 4,352,843 places matching geonames and this is one page of many

0.890326023102 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. 85632763 Vietnam — this is a country
    • its population is 89,571,130
    • it was last modified on April 07, 2021
  2. 890432803 Luzon — this is a locality in Philippines
    • its population is 46,228,000
    • it was last modified on April 21, 2020
  3. 102020393 Provinsi Jawa Barat — this is a locality in Indonesia
    • its population is 45,278,744
    • it was last modified on March 02, 2021
  4. 890501051 Telengana — this is a locality in India
    • its population is 35,286,757
    • it was last modified on April 21, 2020
  5. 85632751 Sudan — this is a country
    • its population is 35,000,000
    • it was last modified on August 13, 2019
  6. 102020389 Provinsi Jawa Tengah — this is a locality in Indonesia
    • its population is 34,087,148
    • it was last modified on March 02, 2021
  7. 85633041 Canada — this is a country
    • its population is 33,679,000
    • it was last modified on April 07, 2021
  8. 85632403 Taiwan — this is a country
    • its population is 22,894,384
    • it was last modified on April 07, 2021
  9. 85903649 上海市 — this is a neighbourhood in China
    • its population is 22,315,474
    • it was last modified on April 21, 2020
  10. 102020387 Provinsi Jawa Timur — this is a locality in Indonesia
    • its population is 22,200,177
    • it was last modified on March 02, 2021
  11. 85632313 Sri Lanka — this is a country
    • its population is 21,513,990
    • it was last modified on April 07, 2021
  12. 102020795 Borneo — this is a locality in Indonesia
    • its population is 19,000,000
    • it was last modified on March 02, 2021
  13. 85633337 Netherlands — this is a country
    • its population is 16,645,000
    • it was last modified on April 07, 2021
  14. 102030609 Mumbai — this is a locality in India
    • its population is 12,691,836
    • it was last modified on March 30, 2021
  15. 102027745 Beijing — this is a locality in China
    • its population is 11,716,620
    • it was last modified on December 23, 2020
  16. 890460455 Istanbul — this is a locality in Turkey
    • its population is 11,174,257
    • it was last modified on September 08, 2021
  17. 102027107 Tianjin — this is a locality in China
    • its population is 11,090,314
    • it was last modified on March 30, 2021
  18. 102027597 Guangzhou — this is a locality in China
    • its population is 11,071,424
    • it was last modified on March 30, 2021
  19. 102030425 Delhi — this is a locality in India
    • its population is 10,927,986
    • it was last modified on April 21, 2020
  20. 102003033 Moscow — this is a locality in Russian Federation
    • its population is 10,381,222
    • it was last modified on December 23, 2020
  21. 102027165 Shenzhen — this is a locality in China
    • its population is 10,358,381
    • it was last modified on March 30, 2021
  22. 102026327 Seoul — this is a locality in Korea, Republic of
    • its population is 10,349,312
    • it was last modified on March 30, 2021
  23. 102027061 Wuhan — this is a locality in China
    • its population is 9,785,388
    • it was last modified on December 23, 2020
  24. 102018311 Provinsi Sumatera Utara — this is a locality in Indonesia
    • its population is 9,630,873
    • it was last modified on March 02, 2021
  25. 102031307 Tokyo — this is a locality in Japan
    • its population is 8,336,599
    • it was last modified on March 30, 2021
  26. 1125377885 驻马店市 — this is a localadmin in China
    • its population is 8,263,100
    • it was last modified on August 25, 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 February 20, 2021
  29. 102018953 Provinsi Sulawesi Selatan — this is a locality in Indonesia
    • its population is 8,034,776
    • it was last modified on March 02, 2021
  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 November 09, 2021
  31. 102027633 Dongguan — this is a locality in China
    • its population is 8,000,000
    • it was last modified on December 23, 2020
  32. 102026641 Taipei — this is a locality in Taiwan, Province of China
    • its population is 7,871,900
    • it was last modified on March 30, 2021
  33. 1125867167 台北 — this is a locality in Taiwan, Province of China
    • its population is 7,871,900
    • it was last modified on April 21, 2020
  34. 102018939 Provinsi Sumatera Selatan — this is a locality in Indonesia
    • its population is 7,743,794
    • it was last modified on March 02, 2021
  35. 421186805 Lima — this is a locality in Peru
    • its population is 7,737,002
    • it was last modified on December 23, 2020
  36. 101750367 London — this is a locality in United Kingdom
    • its population is 7,556,900
    • it was last modified on March 30, 2021
  37. 85669975 Équateur — this is a region in Congo, The Democratic Republic of the
    • its population is 7,500,000
    • it was last modified on March 04, 2021
  38. 85632513 Tajikistan — this is a country
    • its population is 7,487,489
    • it was last modified on August 13, 2019
  39. 102027689 Chongqing — this is a locality in China
    • its population is 7,457,600
    • it was last modified on December 23, 2020
  40. 102027703 Chengdu — this is a locality in China
    • its population is 7,415,590
    • it was last modified on December 23, 2020
  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 December 23, 2020
  43. 102027293 Nanchong — this is a locality in China
    • its population is 7,150,000
    • it was last modified on November 10, 2021
  44. 1125290269 南充市 — this is a localadmin in China
    • its population is 7,150,000
    • it was last modified on August 25, 2019
  45. 421186687 Bogotá — this is a locality in Colombia
    • its population is 7,102,602
    • it was last modified on December 08, 2020
  46. 890437279 Hong Kong — this is a locality in Hong Kong
    • its population is 7,012,738
    • it was last modified on March 30, 2021
  47. 85672963 Rift Valley — this is a region in Kenya
    • its population is 6,987,036
    • it was last modified on February 22, 2020
  48. 85632483 Hong Kong S.A.R. — this is a country
    • its population is 6,898,686
    • it was last modified on April 07, 2021
  49. 85669979 Orientale — this is a region in Congo, The Democratic Republic of the
    • its population is 6,828,888
    • it was last modified on November 09, 2021
  50. 102027041 Xi’an — this is a locality in China
    • its population is 6,501,190
    • it was last modified on March 30, 2021
  51. 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 March 04, 2021
  52. 85632425 Jordan — this is a country
    • its population is 6,407,085
    • it was last modified on April 14, 2021
  53. 102027875 Shenyang — this is a locality in China
    • its population is 6,255,921
    • it was last modified on December 23, 2020
  54. 102027571 Hangzhou — this is a locality in China
    • its population is 6,241,971
    • it was last modified on December 23, 2020
  55. 101953261 Rio de Janeiro — this is a locality in Brazil
    • its population is 6,023,699
    • it was last modified on November 09, 2021
  56. 102027921 Harbin — this is a locality in China
    • its population is 5,878,939
    • it was last modified on December 23, 2020
  57. 85632761 Kyrgyzstan — this is a country
    • its population is 5,776,500
    • it was last modified on April 07, 2021
  58. 85670015 Katanga — this is a region in Congo, The Democratic Republic of the
    • its population is 5,600,000
    • it was last modified on November 09, 2021
  59. 102027127 Tai’an — this is a locality in China
    • its population is 5,499,000
    • it was last modified on December 23, 2020
  60. 85633769 Slovakia — this is a country
    • its population is 5,455,000
    • it was last modified on August 13, 2019
  61. 102027777 Suzhou — this is a locality in China
    • its population is 5,345,961
    • it was last modified on November 10, 2021
  62. 102027175 Shantou — this is a locality in China
    • its population is 5,329,024
    • it was last modified on December 23, 2020
  63. 102025263 Bangkok — this is a locality in Thailand
    • its population is 5,104,476
    • it was last modified on March 30, 2021
  64. 102030819 Bangalore — this is a locality in India
    • its population is 5,104,047
    • it was last modified on March 04, 2021
  65. 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
  66. 102018941 Provinsi Sumatera Barat — this is a locality in Indonesia
    • its population is 5,014,112
    • it was last modified on March 02, 2021
  67. 85633341 Norway — this is a country
    • its population is 5,009,150
    • it was last modified on April 07, 2021
  68. 1125342789 岳阳市 — this is a localadmin in China
    • its population is 5,000,000
    • it was last modified on August 25, 2019
  69. 102020815 Kabupaten Bogor — this is a locality in Indonesia
    • its population is 4,985,585
    • it was last modified on March 02, 2021
  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 November 09, 2021
  71. 102016915 Santiago — this is a locality in Chile
    • its population is 4,837,295
    • it was last modified on November 09, 2021
  72. 102020027 Provinsi Lampung — this is a locality in Indonesia
    • its population is 4,817,226
    • it was last modified on March 02, 2021
  73. 1126008595 开封 — this is a locality in China
    • its population is 4,800,000
    • it was last modified on August 25, 2019
  74. 102018559 Nanggroe Aceh Darussalam Province — this is a locality in Indonesia
    • its population is 4,748,085
    • it was last modified on March 02, 2021
  75. 85672959 Eastern — this is a region in Kenya
    • its population is 4,631,779
    • it was last modified on November 09, 2021
  76. 102030585 Kolkata — this is a locality in India
    • its population is 4,631,392
    • it was last modified on March 04, 2021
  77. 85633163 Georgia — this is a country
    • its population is 4,630,000
    • it was last modified on April 14, 2021
  78. 85633241 Ireland — this is a country
    • its population is 4,622,917
    • it was last modified on December 09, 2021
  79. 85632609 Bosnia and Herzegovina — this is a country
    • its population is 4,590,000
    • it was last modified on March 21, 2021
  80. 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 24, 2019
  81. 102019651 Propinsi Nusa Tenggara Barat — this is a locality in Indonesia
    • its population is 4,500,212
    • it was last modified on March 02, 2021
  82. 85633229 Croatia — this is a country
    • its population is 4,491,000
    • it was last modified on August 13, 2019
  83. 890443751 Rangoon — this is a locality in Myanmar
    • its population is 4,477,638
    • it was last modified on January 09, 2021
  84. 102020321 Provinsi Kalimantan Barat — this is a locality in Indonesia
    • its population is 4,395,983
    • it was last modified on March 02, 2021
loading facets from the sky

Log


There are 4,352,843 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,820 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?