There are 4,253,231 places matching geonames and this is one page of many

1.06637310982 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. 890432803 Luzon — this is a locality in Philippines
    • its population is 46,228,000
    • it was last modified on August 01, 2023
  2. 102020393 Provinsi Jawa Barat — this is a locality in Indonesia
    • its population is 45,278,744
    • it was last modified on August 01, 2023
  3. 890501051 Telengana — this is a locality in India
    • its population is 35,286,757
    • it was last modified on April 21, 2020
  4. 102020389 Provinsi Jawa Tengah — this is a locality in Indonesia
    • its population is 34,087,148
    • it was last modified on August 01, 2023
  5. 85632403 Taiwan — this is a country
    • its population is 22,894,384
    • it was last modified on August 01, 2023
  6. 85903649 上海市 — this is a neighbourhood in China
    • its population is 22,315,474
    • it was last modified on April 21, 2020
  7. 102020387 Provinsi Jawa Timur — this is a locality in Indonesia
    • its population is 22,200,177
    • it was last modified on August 01, 2023
  8. 102020795 Borneo — this is a locality in Indonesia
    • its population is 19,000,000
    • it was last modified on March 02, 2021
  9. 102030609 Mumbai — this is a locality in India
    • its population is 12,691,836
    • it was last modified on August 01, 2023
  10. 102027745 Beijing — this is a locality in China
    • its population is 11,716,620
    • it was last modified on December 23, 2020
  11. 890460455 Istanbul — this is a locality in Turkey
    • its population is 11,174,257
    • it was last modified on August 01, 2023
  12. 102027107 Tianjin — this is a locality in China
    • its population is 11,090,314
    • it was last modified on March 30, 2021
  13. 102027597 Guangzhou — this is a locality in China
    • its population is 11,071,424
    • it was last modified on March 30, 2021
  14. 102030425 Delhi — this is a locality in India
    • its population is 10,927,986
    • it was last modified on August 01, 2023
  15. 102003033 Moscow — this is a locality in Russian Federation
    • its population is 10,381,222
    • it was last modified on August 01, 2023
  16. 102027165 Shenzhen — this is a locality in China
    • its population is 10,358,381
    • it was last modified on March 30, 2021
  17. 102026327 Seoul — this is a locality in Korea, Republic of
    • its population is 10,349,312
    • it was last modified on August 02, 2023
  18. 102027061 Wuhan — this is a locality in China
    • its population is 9,785,388
    • it was last modified on December 23, 2020
  19. 102018311 Provinsi Sumatera Utara — this is a locality in Indonesia
    • its population is 9,630,873
    • it was last modified on August 01, 2023
  20. 890437281 Lagos — this is a locality in Nigeria
    • its population is 9,000,000
    • it was last modified on August 01, 2023
  21. 102031307 Tokyo — this is a locality in Japan
    • its population is 8,336,599
    • it was last modified on March 30, 2021
  22. 1125377885 驻马店市 — this is a localadmin in China
    • its population is 8,263,100
    • it was last modified on August 25, 2019
  23. 85977539 New York — this is a locality in United States
    • its population is 8,175,133
    • it was last modified on August 01, 2023
  24. 102018953 Provinsi Sulawesi Selatan — this is a locality in Indonesia
    • its population is 8,034,776
    • it was last modified on August 01, 2023
  25. 85669985 Bandundu — this is a region in Congo, The Democratic Republic of the
    • its population is 8,000,000
    • it was last modified on September 28, 2023
  26. 102027633 Dongguan — this is a locality in China
    • its population is 8,000,000
    • it was last modified on December 23, 2020
  27. 102026641 Taipei — this is a locality in Taiwan, Province of China
    • its population is 7,871,900
    • it was last modified on August 01, 2023
  28. 1125867167 台北 — this is a locality in Taiwan, Province of China
    • its population is 7,871,900
    • it was last modified on August 01, 2023
  29. 102018939 Provinsi Sumatera Selatan — this is a locality in Indonesia
    • its population is 7,743,794
    • it was last modified on August 01, 2023
  30. 421186805 Lima — this is a locality in Peru
    • its population is 7,737,002
    • it was last modified on August 01, 2023
  31. 1880762729 Greater London — this is a region in United Kingdom
    • its population is 7,556,900
    • it was last modified on November 23, 2023
  32. 101750367 London — this is a locality in United Kingdom
    • its population is 7,556,900
    • it was last modified on November 22, 2023
  33. 85669975 Équateur — this is a region in Congo, The Democratic Republic of the
    • its population is 7,500,000
    • it was last modified on September 28, 2023
  34. 102027689 Chongqing — this is a locality in China
    • its population is 7,457,600
    • it was last modified on December 23, 2020
  35. 102027703 Chengdu — this is a locality in China
    • its population is 7,415,590
    • it was last modified on December 23, 2020
  36. 102027291 Nanjing — this is a locality in China
    • its population is 7,165,292
    • it was last modified on December 23, 2020
  37. 102027293 Nanchong — this is a locality in China
    • its population is 7,150,000
    • it was last modified on November 10, 2021
  38. 1125290269 南充市 — this is a localadmin in China
    • its population is 7,150,000
    • it was last modified on August 25, 2019
  39. 421186687 Bogotá — this is a locality in Colombia
    • its population is 7,102,602
    • it was last modified on August 01, 2023
  40. 890437279 Hong Kong — this is a locality in Hong Kong
    • its population is 7,012,738
    • it was last modified on August 01, 2023
  41. 85672963 Rift Valley — this is a region in Kenya
    • its population is 6,987,036
    • it was last modified on September 12, 2023
  42. 85669979 Orientale — this is a region in Congo, The Democratic Republic of the
    • its population is 6,828,888
    • it was last modified on September 28, 2023
  43. 102027041 Xi’an — this is a locality in China
    • its population is 6,501,190
    • it was last modified on March 30, 2021
  44. 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 September 28, 2023
  45. 102027875 Shenyang — this is a locality in China
    • its population is 6,255,921
    • it was last modified on December 23, 2020
  46. 102027571 Hangzhou — this is a locality in China
    • its population is 6,241,971
    • it was last modified on December 23, 2020
  47. 101953261 Rio de Janeiro — this is a locality in Brazil
    • its population is 6,023,699
    • it was last modified on August 01, 2023
  48. 102027921 Harbin — this is a locality in China
    • its population is 5,878,939
    • it was last modified on December 23, 2020
  49. 85670015 Katanga — this is a region in Congo, The Democratic Republic of the
    • its population is 5,600,000
    • it was last modified on September 28, 2023
  50. 102027127 Tai’an — this is a locality in China
    • its population is 5,499,000
    • it was last modified on December 23, 2020
  51. 102027777 Suzhou — this is a locality in China
    • its population is 5,345,961
    • it was last modified on November 10, 2021
  52. 102027175 Shantou — this is a locality in China
    • its population is 5,329,024
    • it was last modified on December 23, 2020
  53. 102025263 Bangkok — this is a locality in Thailand
    • its population is 5,104,476
    • it was last modified on August 01, 2023
  54. 102030819 Bangalore — this is a locality in India
    • its population is 5,104,047
    • it was last modified on August 01, 2023
  55. 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
  56. 102018941 Provinsi Sumatera Barat — this is a locality in Indonesia
    • its population is 5,014,112
    • it was last modified on August 01, 2023
  57. 1125342789 岳阳市 — this is a localadmin in China
    • its population is 5,000,000
    • it was last modified on August 25, 2019
  58. 102020815 Kabupaten Bogor — this is a locality in Indonesia
    • its population is 4,985,585
    • it was last modified on August 01, 2023
  59. 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 September 28, 2023
  60. 102016915 Santiago — this is a locality in Chile
    • its population is 4,837,295
    • it was last modified on August 01, 2023
  61. 102020027 Provinsi Lampung — this is a locality in Indonesia
    • its population is 4,817,226
    • it was last modified on August 01, 2023
  62. 1126008595 开封 — this is a locality in China
    • its population is 4,800,000
    • it was last modified on August 25, 2019
  63. 102018559 Nanggroe Aceh Darussalam Province — this is a locality in Indonesia
    • its population is 4,748,085
    • it was last modified on August 01, 2023
  64. 85672959 Eastern — this is a region in Kenya
    • its population is 4,631,779
    • it was last modified on September 12, 2023
  65. 102030585 Kolkata — this is a locality in India
    • its population is 4,631,392
    • it was last modified on August 01, 2023
  66. 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 September 28, 2023
  67. 102019651 Propinsi Nusa Tenggara Barat — this is a locality in Indonesia
    • its population is 4,500,212
    • it was last modified on August 01, 2023
  68. 890443751 Rangoon — this is a locality in Myanmar
    • its population is 4,477,638
    • it was last modified on August 02, 2023
  69. 102020321 Provinsi Kalimantan Barat — this is a locality in Indonesia
    • its population is 4,395,983
    • it was last modified on August 01, 2023
  70. 85672955 Nyanza — this is a region in Kenya
    • its population is 4,392,196
    • it was last modified on September 12, 2023
  71. 102027459 Jinan — this is a locality in China
    • its population is 4,335,989
    • it was last modified on December 23, 2020
  72. 102029537 Chennai — this is a locality in India
    • its population is 4,328,063
    • it was last modified on August 01, 2023
  73. 102026899 Zhengzhou — this is a locality in China
    • its population is 4,253,913
    • it was last modified on December 23, 2020
  74. 101933229 Melbourne — this is a locality in Australia
    • its population is 4,246,375
    • it was last modified on August 01, 2023
  75. 102027947 Changchun — this is a locality in China
    • its population is 4,193,073
    • it was last modified on December 23, 2020
  76. 102027669 Dalian — this is a locality in China
    • its population is 4,087,733
    • it was last modified on December 23, 2020
  77. 1125330775 Yorkshire — this is a localadmin in United Kingdom
    • its population is 3,978,484
    • it was last modified on September 12, 2017
  78. 1125371489 成都市 — this is a localadmin in China
    • its population is 3,950,437
    • it was last modified on August 25, 2019
  79. 85670003 Sud-Kivu — this is a region in Congo, The Democratic Republic of the
    • its population is 3,909,135
    • it was last modified on September 28, 2023
  80. 102027417 Kunming — this is a locality in China
    • its population is 3,855,346
    • it was last modified on December 23, 2020
  81. 890429453 Alexandria — this is a locality in Egypt
    • its population is 3,811,516
    • it was last modified on August 01, 2023
  82. 85923517 Los Angeles — this is a locality in United States
    • its population is 3,792,621
    • it was last modified on August 01, 2023
  83. 85672947 Central — this is a region in Kenya
    • its population is 3,724,159
    • it was last modified on September 12, 2023
  84. 102031017 Ahmedabad — this is a locality in India
    • its population is 3,719,710
    • it was last modified on August 01, 2023
loading facets from the sky

Log


There are 4,253,231 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 50,634 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?