There are 4,359,763 places matching geonames and this is one page of many

0.944300889969 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 October 28
  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 July 25
  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 July 25
  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. 890437281 Lagos — this is a locality in Nigeria
    • its population is 9,000,000
    • it was last modified on November 23
  26. 102031307 Tokyo — this is a locality in Japan
    • its population is 8,336,599
    • it was last modified on March 30, 2021
  27. 1125377885 驻马店市 — this is a localadmin in China
    • its population is 8,263,100
    • it was last modified on August 25, 2019
  28. 85632657 South Sudan — this is a country
    • its population is 8,260,490
    • it was last modified on August 13, 2019
  29. 85977539 New York — this is a locality in United States
    • its population is 8,175,133
    • it was last modified on February 20, 2021
  30. 102018953 Provinsi Sulawesi Selatan — this is a locality in Indonesia
    • its population is 8,034,776
    • it was last modified on March 02, 2021
  31. 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
  32. 102027633 Dongguan — this is a locality in China
    • its population is 8,000,000
    • it was last modified on December 23, 2020
  33. 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
  34. 1125867167 台北 — this is a locality in Taiwan, Province of China
    • its population is 7,871,900
    • it was last modified on April 21, 2020
  35. 102018939 Provinsi Sumatera Selatan — this is a locality in Indonesia
    • its population is 7,743,794
    • it was last modified on March 02, 2021
  36. 421186805 Lima — this is a locality in Peru
    • its population is 7,737,002
    • it was last modified on December 23, 2020
  37. 101750367 London — this is a locality in United Kingdom
    • its population is 7,556,900
    • it was last modified on March 30, 2021
  38. 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
  39. 85632513 Tajikistan — this is a country
    • its population is 7,487,489
    • it was last modified on August 13, 2019
  40. 102027689 Chongqing — this is a locality in China
    • its population is 7,457,600
    • it was last modified on December 23, 2020
  41. 102027703 Chengdu — this is a locality in China
    • its population is 7,415,590
    • it was last modified on December 23, 2020
  42. 85633755 Serbia — this is a country
    • its population is 7,344,847
    • it was last modified on May 10
  43. 102027291 Nanjing — this is a locality in China
    • its population is 7,165,292
    • it was last modified on December 23, 2020
  44. 102027293 Nanchong — this is a locality in China
    • its population is 7,150,000
    • it was last modified on November 10, 2021
  45. 1125290269 南充市 — this is a localadmin in China
    • its population is 7,150,000
    • it was last modified on August 25, 2019
  46. 421186687 Bogotá — this is a locality in Colombia
    • its population is 7,102,602
    • it was last modified on December 08, 2020
  47. 890437279 Hong Kong — this is a locality in Hong Kong
    • its population is 7,012,738
    • it was last modified on March 30, 2021
  48. 85672963 Rift Valley — this is a region in Kenya
    • its population is 6,987,036
    • it was last modified on February 22, 2020
  49. 85632483 Hong Kong S.A.R. — this is a country
    • its population is 6,898,686
    • it was last modified on April 07, 2021
  50. 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
  51. 102027041 Xi’an — this is a locality in China
    • its population is 6,501,190
    • it was last modified on March 30, 2021
  52. 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
  53. 85632425 Jordan — this is a country
    • its population is 6,407,085
    • it was last modified on April 14, 2021
  54. 102027875 Shenyang — this is a locality in China
    • its population is 6,255,921
    • it was last modified on December 23, 2020
  55. 102027571 Hangzhou — this is a locality in China
    • its population is 6,241,971
    • it was last modified on December 23, 2020
  56. 101953261 Rio de Janeiro — this is a locality in Brazil
    • its population is 6,023,699
    • it was last modified on November 09, 2021
  57. 102027921 Harbin — this is a locality in China
    • its population is 5,878,939
    • it was last modified on December 23, 2020
  58. 85632761 Kyrgyzstan — this is a country
    • its population is 5,776,500
    • it was last modified on April 07, 2021
  59. 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
  60. 102027127 Tai’an — this is a locality in China
    • its population is 5,499,000
    • it was last modified on December 23, 2020
  61. 85633769 Slovakia — this is a country
    • its population is 5,455,000
    • it was last modified on August 13, 2019
  62. 102027777 Suzhou — this is a locality in China
    • its population is 5,345,961
    • it was last modified on November 10, 2021
  63. 102027175 Shantou — this is a locality in China
    • its population is 5,329,024
    • it was last modified on December 23, 2020
  64. 102025263 Bangkok — this is a locality in Thailand
    • its population is 5,104,476
    • it was last modified on March 30, 2021
  65. 102030819 Bangalore — this is a locality in India
    • its population is 5,104,047
    • it was last modified on July 25
  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 March 02, 2021
  68. 85633341 Norway — this is a country
    • its population is 5,009,150
    • it was last modified on April 07, 2021
  69. 1125342789 岳阳市 — this is a localadmin in China
    • its population is 5,000,000
    • it was last modified on August 25, 2019
  70. 102020815 Kabupaten Bogor — this is a locality in Indonesia
    • its population is 4,985,585
    • it was last modified on March 02, 2021
  71. 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
  72. 102016915 Santiago — this is a locality in Chile
    • its population is 4,837,295
    • it was last modified on November 09, 2021
  73. 102020027 Provinsi Lampung — this is a locality in Indonesia
    • its population is 4,817,226
    • it was last modified on March 02, 2021
  74. 1126008595 开封 — this is a locality in China
    • its population is 4,800,000
    • it was last modified on August 25, 2019
  75. 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
  76. 85672959 Eastern — this is a region in Kenya
    • its population is 4,631,779
    • it was last modified on November 09, 2021
  77. 102030585 Kolkata — this is a locality in India
    • its population is 4,631,392
    • it was last modified on July 25
  78. 85633163 Georgia — this is a country
    • its population is 4,630,000
    • it was last modified on April 14, 2021
  79. 85633241 Ireland — this is a country
    • its population is 4,622,917
    • it was last modified on December 09, 2021
  80. 85632609 Bosnia and Herzegovina — this is a country
    • its population is 4,590,000
    • it was last modified on April 07, 2021
  81. 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
  82. 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
  83. 85633229 Croatia — this is a country
    • its population is 4,491,000
    • it was last modified on May 10
  84. 890443751 Rangoon — this is a locality in Myanmar
    • its population is 4,477,638
    • it was last modified on January 09, 2021
loading facets from the sky

Log


There are 4,359,763 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,902 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?