There are 30,993,530 places matching whosonfirst and this is one page of many

3.52638292313 seconds
{'query': {'function_score': {'boost_mode': 'multiply', 'functions': [{'filter': {'term': {'names_preferred': u'whosonfirst'}}, 'weight': 10.0}, {'filter': {'term': {'names_all': u'whosonfirst'}}, 'weight': 1.0}, {'filter': {'term': {'wof:name': u'whosonfirst'}}, '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'whosonfirst'}}}}}, '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 August 01
  2. 85632469 India — this is a country
    • its population is 1,173,108,018
    • it was last modified on April 14, 2021
  3. 85633009 Brazil — this is a country
    • its population is 201,103,330
    • it was last modified on September 28
  4. 85672205 Uttar Pradesh — this is a region in India
    • its population is 199,812,341
    • it was last modified on March 30, 2021
  5. 85632659 Pakistan — this is a country
    • its population is 184,404,791
    • it was last modified on September 28
  6. 85632475 Bangladesh — this is a country
    • its population is 156,118,464
    • it was last modified on September 28
  7. 85632735 Nigeria — this is a country
    • its population is 154,000,000
    • it was last modified on September 13
  8. 85632685 Russia — this is a country
    • its population is 140,702,000
    • it was last modified on September 13
  9. 85632429 Japan — this is a country
    • its population is 127,288,000
    • it was last modified on September 28
  10. 85633293 Mexico — this is a country
    • its population is 112,468,855
    • it was last modified on September 28
  11. 85672171 Maharashtra — this is a region in India
    • its population is 112,374,333
    • it was last modified on December 08, 2020
  12. 85669743 Guangdong — this is a region in China
    • its population is 104,303,132
    • it was last modified on September 28
  13. 85672225 Bihar — this is a region in India
    • its population is 104,099,452
    • it was last modified on March 04, 2021
  14. 85632509 Philippines — this is a country
    • its population is 99,900,177
    • it was last modified on September 28
  15. 85669801 Henan — this is a region in China
    • its population is 94,290,000
    • it was last modified on September 28
  16. 85669813 Shandong — this is a region in China
    • its population is 94,170,000
    • it was last modified on September 28
  17. 85672219 West Bengal — this is a region in India
    • its population is 91,276,115
    • it was last modified on March 04, 2021
  18. 85632763 Vietnam — this is a country
    • its population is 89,571,130
    • it was last modified on September 28
  19. 85632257 Ethiopia — this is a country
    • its population is 88,013,491
    • it was last modified on September 28
  20. 85669787 Sichuan — this is a region in China
    • its population is 87,250,000
    • it was last modified on September 28
  21. 85675753 Punjab — this is a region in Pakistan
    • its population is 85,579,866
    • it was last modified on September 28
  22. 85633111 Germany — this is a country
    • its population is 81,802,257
    • it was last modified on September 28
  23. 85632581 Egypt — this is a country
    • its population is 80,471,869
    • it was last modified on September 28
  24. 85632393 Turkey — this is a country
    • its population is 77,804,122
    • it was last modified on September 28
  25. 85632361 Iran — this is a country
    • its population is 76,923,300
    • it was last modified on September 13
  26. 85669827 Jiangsu — this is a region in China
    • its population is 76,770,000
    • it was last modified on September 28
  27. 85672239 Madhya Pradesh — this is a region in India
    • its population is 72,626,809
    • it was last modified on December 08, 2020
  28. 85672245 Tamil Nadu — this is a region in India
    • its population is 72,147,030
    • it was last modified on March 04, 2021
  29. 85632643 Democratic Republic of the Congo — this is a country
    • its population is 70,916,439
    • it was last modified on September 13
  30. 85669797 Hebei — this is a region in China
    • its population is 69,890,000
    • it was last modified on September 28
  31. 85672201 Rajasthan — this is a region in India
    • its population is 68,548,437
    • it was last modified on January 05
  32. 85669781 Hunan — this is a region in China
    • its population is 66,980,000
    • it was last modified on September 28
  33. 85633147 France — this is a country
    • its population is 64,768,389
    • it was last modified on September 28
  34. 85669739 Anhui — this is a region in China
    • its population is 64,610,000
    • it was last modified on September 28
  35. 85672165 Karnataka — this is a region in India
    • its population is 61,095,297
    • it was last modified on December 08, 2020
  36. 85672249 Gujarat — this is a region in India
    • its population is 60,439,692
    • it was last modified on December 08, 2020
  37. 85633253 Italy — this is a country
    • its population is 60,340,328
    • it was last modified on September 28
  38. 85669777 Hubei — this is a region in China
    • its population is 57,110,000
    • it was last modified on September 28
  39. 85632181 Myanmar — this is a country
    • its population is 53,414,374
    • it was last modified on September 28
  40. 85669835 Zhejiang — this is a region in China
    • its population is 51,200,000
    • it was last modified on September 28
  41. 85672141 Andhra Pradesh — this is a region in India
    • its population is 49,386,799
    • it was last modified on March 04, 2021
  42. 85633813 South Africa — this is a country
    • its population is 49,000,000
    • it was last modified on August 01
  43. 85632231 South Korea — this is a country
    • its population is 48,422,644
    • it was last modified on September 28
  44. 85632519 Colombia — this is a country
    • its population is 47,790,000
    • it was last modified on September 13
  45. 85669009 Dhaka — this is a region in Bangladesh
    • its population is 47,424,418
    • it was last modified on September 28
  46. 85633129 Spain — this is a country
    • its population is 46,505,963
    • it was last modified on October 08
  47. 890432803 Luzon — this is a locality in Philippines
    • its population is 46,228,000
    • it was last modified on August 01
  48. 85669791 Yunnan — this is a region in China
    • its population is 45,430,000
    • it was last modified on September 28
  49. 85633805 Ukraine — this is a country
    • its population is 45,415,596
    • it was last modified on September 28
  50. 85671983 Jawa Barat — this is a region in Indonesia
    • its population is 45,278,744
    • it was last modified on September 28
  51. 102020393 Provinsi Jawa Barat — this is a locality in Indonesia
    • its population is 45,278,744
    • it was last modified on August 01
  52. 85669823 Jiangxi — this is a region in China
    • its population is 44,000,000
    • it was last modified on September 28
  53. 85669807 Liaoning — this is a region in China
    • its population is 43,150,000
    • it was last modified on September 28
  54. 85672157 Odisha — this is a region in India
    • its population is 41,974,218
    • it was last modified on December 08, 2020
  55. 85632227 Tanzania — this is a country
    • its population is 41,892,895
    • it was last modified on September 28
  56. 85632505 Argentina — this is a country
    • its population is 41,343,201
    • it was last modified on September 28
  57. 85632329 Kenya — this is a country
    • its population is 40,046,566
    • it was last modified on September 13
  58. 85633723 Poland — this is a country
    • its population is 38,500,000
    • it was last modified on September 28
  59. 85669849 Heilongjiang — this is a region in China
    • its population is 38,250,000
    • it was last modified on September 28
  60. 85669721 Guizhou — this is a region in China
    • its population is 37,930,000
    • it was last modified on September 28
  61. 85669735 Fujian — this is a region in China
    • its population is 36,040,000
    • it was last modified on September 28
  62. 85675757 Sindh — this is a region in Pakistan
    • its population is 35,992,288
    • it was last modified on September 28
  63. 890501051 Telengana — this is a locality in India
    • its population is 35,286,757
    • it was last modified on April 21, 2020
  64. 85632751 Sudan — this is a country
    • its population is 35,000,000
    • it was last modified on September 13
  65. 85632451 Algeria — this is a country
    • its population is 34,586,184
    • it was last modified on September 28
  66. 85669773 Shanxi — this is a region in China
    • its population is 34,110,000
    • it was last modified on September 28
  67. 85671987 Jawa Tengah — this is a region in Indonesia
    • its population is 34,087,148
    • it was last modified on September 28
  68. 102020389 Provinsi Jawa Tengah — this is a locality in Indonesia
    • its population is 34,087,148
    • it was last modified on August 01
  69. 85633041 Canada — this is a country
    • its population is 33,679,000
    • it was last modified on September 28
  70. 85672149 Kerala — this is a region in India
    • its population is 33,406,061
    • it was last modified on March 04, 2021
  71. 85632625 Uganda — this is a country
    • its population is 33,398,682
    • it was last modified on September 28
  72. 85672213 Jharkhand — this is a region in India
    • its population is 32,988,134
    • it was last modified on March 04, 2021
  73. 85632693 Morocco — this is a country
    • its population is 31,627,428
    • it was last modified on September 28
  74. 85672181 Assam — this is a region in India
    • its population is 31,205,576
    • it was last modified on March 30, 2021
  75. 85632521 Peru — this is a country
    • its population is 29,907,003
    • it was last modified on September 28
  76. 85632191 Iraq — this is a country
    • its population is 29,671,605
    • it was last modified on September 28
  77. 85632229 Afghanistan — this is a country
    • its population is 29,121,286
    • it was last modified on September 28
  78. 85632465 Nepal — this is a country
    • its population is 28,951,852
    • it was last modified on September 28
  79. 85669023 Chittagong — this is a region in Bangladesh
    • its population is 28,423,019
    • it was last modified on September 28
  80. 85632645 Uzbekistan — this is a country
    • its population is 27,865,738
    • it was last modified on September 13
  81. 85672195 Punjab — this is a region in India
    • its population is 27,743,338
    • it was last modified on January 05
  82. 85669843 Jilin — this is a region in China
    • its population is 27,340,000
    • it was last modified on September 28
  83. 85632317 Venezuela — this is a country
    • its population is 27,223,228
    • it was last modified on September 28
  84. 85669711 Gansu — this is a region in China
    • its population is 26,280,000
    • it was last modified on September 28
loading facets from the sky

Log


There are 30,993,530 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 368,971 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?