home / whosonfirst-metadata-only

whosonfirst

728,992 rows

View and edit SQL

This data as .json, .jsono

Linkidnameplacetypeparent_idcountrybboxarea_square_m
0 0 Earth planet -1 [-180.0,-90.0,180.0,90.0]  
1 1 Null Island country 0 XN [-0.0005,-0.000282,0.000379,0.000309] 3448.94394
85632161 85632161 Macao S.A.R country 102191569 MO [113.5284917212756,22.10944366500013,113.59126869699799,22.21715303857508] 26489652.931184
85632163 85632163 Guam dependency 136253057 GU [144.61795043900008,13.23202800800004,144.95625305200008,13.65294456500004] 560017182.036934
85632167 85632167 Bahrain country 102191569 BH [50.31004715999995,25.54705619800006,50.82552719100005,26.34538841200003] 686317989.137218
85632169 85632169 United States Virgin Islands dependency 136253057 VI [-65.09960937499994,17.67286109900004,-64.56375122099996,18.41536140400007] 373103979.460312
85632171 85632171 Bhutan country 102191569 BT [88.746474,26.702016,92.12512680000003,28.246987] 38725431920.49498
85632173 85632173 Lesotho country 102191573 LS [27.011189,-30.677733,29.456192,-28.57060685699997] 30598378881.461914
85632177 85632177 Spratly Islands disputed 102191569 XX [111.91375,6.32768,116.473801,11.462083] 22513453.903267
85632179 85632179 Panama country 102191575 PA [-83.052241,7.20475006100008,-77.158488,9.64836120600006] 75751986936.92851
85632181 85632181 Myanmar country 102191569 MM [92.17180802700051,9.59288883200003,101.17027200000047,28.54783500000042] 670769667999.5724
85632185 85632185 Sint Maarten country 102191575 SX [-63.13794411999993,18.00699996900005,-63.01358031207337,18.06417065900007] 37751469.09725
85632187 85632187 Vatican country 102191581 VA [12.445909,41.900276,12.458336,41.907417] 520036.247412
85632189 85632189 Ghana country 102191573 GH [-3.26067599999988,4.73541688900013,1.19947914281181,11.16666700000042] 240118653281.37363
85632191 85632191 Iraq country 102191569 IQ [38.79367400000012,29.06120800000014,48.61173652071295,37.06394920268241] 398442964166.97986
85632193 85632193 Valley near Chumur disputed 85632469 XX [78.569364,32.599974,78.641037,32.642949] 22742158.736229
85632195 85632195 Lawa Headwaters disputed 85633147 XX [-54.55440349999992,2.11398200000019,-53.9728507079999,3.30067800000023] 3500675660.571769
85632197 85632197 Korean islands under UN jurisdiction disputed 102312305 XX [124.61374664300001,37.60202789300007,125.97953033400006,37.98374939000007] 79079528.702268
85632199 85632199 Saint Barthelemy dependency 136253037 BL [-62.95130538899997,17.87202835100004,-62.79291534399994,17.97708320600003] 25011900.083756
85632203 85632203 Indonesia country 102191569 ID [95.00708007800006,-10.99251469635779,141.02215100000012,6.08125019100004] 1903001258183.8687
85632205 85632205 Turks and Caicos Islands dependency 136253055 TC [-72.481313,21.290107,-71.128896,21.959215] 446419087.007711
85632207 85632207 Oman country 102191569 OM [52.0,16.65008377100003,59.83791732800006,26.50547218300005] 309299138779.4037
85632211 85632211 Falkland Islands dependency 136253055 FK [-61.45586013799993,-52.93544387799994,-57.71086120599995,-50.99791717499994] 12370103505.084385
85632213 85632213 Burkina Faso country 102191573 BF [-5.521112,9.393889,2.404293,15.085111] 273990722868.5126
85632215 85632215 Jamaica country 102191575 JM [-78.374664,17.703192,-76.187978,18.525092] 11068808619.143784
85632217 85632217 Western Sahara country 102191573 EH [-17.1088886259999,20.77006617297997,-8.66666521399992,27.66876720000022] 91740496657.62852
85632221 85632221 Golan Heights disputed 85632315 XX [35.5868980000003,32.67755500000015,35.88807255000012,33.33256414047224] 1149613435.917738
85632223 85632223 Madagascar country 102191573 MG [43.222911,-25.598565,50.503917,-11.943617] 594793700158.5634
85632227 85632227 Tanzania country 102191573 TZ [29.34,-11.76125399999989,40.44544601400003,-0.98440649999986] 944304049915.6377
85632229 85632229 Afghanistan country 102191569 AF [60.475769,29.377217,74.889862,38.490733] 642112906233.4608
85632231 85632231 South Korea country 102191569 KR [125.07458496100003,33.11286163300008,130.95039367700008,38.61841203000012] 99437054838.02727
85632233 85632233 French Guiana country -1 FR [-54.475744,2.10928700000022,-51.62335967999996,5.74976548913691] 79369931282.1696
85632235 85632235 Botswana country 102191573 BW [19.998903,-26.907545,29.375304,-17.778158] 579683363205.898
85632239 85632239 Heard Island and McDonald Islands dependency 136253039 HM [72.58080291700003,-53.19794464099994,73.84755706800007,-52.91291809099994] 390176216.268295
85632241 85632241 Laos country 102191569 LA [100.083872,13.90972,107.69483,22.502872] 230759070421.84293
85632243 85632243 Zimbabwe country 102191573 ZW [25.237368,-22.421999,33.06816385700006,-15.609319] 391951775043.1923
85632245 85632245 Cameroon country 102191573 CM [8.505056,1.654551,16.207723,13.081141] 466363241042.3469
85632247 85632247 Benin country 102191573 BJ [0.776667,6.23006142600002,3.843343,12.40855233300005] 115776415177.24583
85632249 85632249 Liberia country 102191573 LR [-11.49926562460797,4.35280561400015,-7.369255,8.55198600000017] 96342712239.62614
85632251 85632251 Mayotte disputed 85633147 XX [46.45715904000008,-12.35133494999997,46.45865682000004,-12.35050451999996] 11464.675108
85632253 85632253 Saudi Arabia country 102191569 SA [34.572765,16.370945,55.637565,32.121348] 1926139030461.1345
85632257 85632257 Ethiopia country 102191573 ET [32.997734,3.404137,48.001056,14.894214] 1133677223277.1997
85632259 85632259 Comoros country 102191573 KM [43.213227,-12.380304,44.529063,-11.361261] 1678898637.171167
85632261 85632261 Ecuador country 102191577 EC [-92.01155853299997,-5.01397502099991,-75.18879394499999,1.66583335400003] 257216514851.16245
85632263 85632263 Vanuatu country 102191583 VU [166.52207946800002,-20.25124931299996,170.21374511700003,-13.07124996199997] 12547939195.650087
85632265 85632265 Abyei Special Administrative Area disputed -1 XX [27.83333332700005,9.347221,29.00000102000007,10.16666711700003] 10460753204.682858
85632267 85632267 Rep. Srpska region 85632609 BA [16.19684265631374,42.55653,19.62193500000012,45.27658200000013] 24513858339.60397
85632269 85632269 Niger country 102191573 NE [0.166667,11.693756,15.999034,23.49999996400004] 1183942322680.4556
85632271 85632271 Trinidad and Tobago country 102191575 TT [-61.93372344999995,10.04113864900006,-60.49460983299997,11.36347198500005] 5201498033.747381
85632275 85632275 Lakshadweep region -1 XX [71.73147923825437,8.26010799308371,74.12313345241216,12.40315149708248] 665678588.291538
85632277 85632277 Siachen Glacier disputed 102191569 XX [76.76043836500008,35.00875953900004,77.82316993600006,35.675788] 2799668755.146498
85632279 85632279 Brcko Distrikt region 85632609 BA [18.51909978728051,44.72238056412787,19.0067434822446,44.96586689982631] 482404976.073915
85632281 85632281 Angola country 102191573 AO [11.67455577900006,-18.0391039999999,24.084445,-4.387944] 1252026249223.237
85632283 85632283 Anguilla dependency 136253055 AI [-63.42966842699996,18.16113853500005,-62.92627716099996,18.60783386200005] 85507434.770917
85632285 85632285 Burundi country 102191573 BI [29.00099300000016,-4.46918049999994,30.85017300000015,-2.30998699999987] 26946965846.80351
85632287 85632287 Equatorial Guinea country 102191573 GQ [5.60211134000002,-1.46127772299997,11.3333,3.78705549200004] 27056599863.69194
85632289 85632289 Shebaa Farms disputed 85632315 XX [35.62451968682916,33.2621726930002,35.72754029762848,33.32633152491661] 16324538.884126
85632293 85632293 Thailand country 102191569 TH [97.34339600000038,5.61289550000043,105.63681200000042,20.46504700000048] 516821377058.45605
85632295 85632295 Aruba country 102191575 AW [-70.062408,12.41767,-69.87682,12.632148] 170433169.976521
85632299 85632299 Qatar country 102191569 QA [50.75047302200005,24.471118,52.42124939000007,26.18372154200006] 11568456613.7941
85632301 85632301 South Georgia and South Sandwich Islands dependency 136253055 GS [-42.032541308865,-59.487140656,-26.234193802,-53.542455380025] 3963542758.8809
85632303 85632303 Rwanda country 102191573 RW [28.861754,-2.83984,30.899118,-1.047572] 25406779560.601738
85632305 85632305 Maldives country 102193527 MV [72.64375305200008,-0.70294445799993,73.74541473400006,7.10874986600004] 300322968.810714
85632307 85632307 Kazakhstan country 102191569 KZ [46.49367200000012,40.5685840000001,87.31539950000018,55.44198400000022] 2712265276514.635
85632313 85632313 Sri Lanka country 102191569 LK [79.52162184000002,5.91455555000005,81.88038635300006,9.83208370200003] 66483187820.3019
85632315 85632315 Israel country 102191569 IL [34.26725779999998,29.48116349200018,35.66992250000015,33.290743] 20777514414.402477
85632317 85632317 Venezuela country 102191577 VE [-73.35155799999973,0.64752900000025,-59.80566599999986,12.49905586200003] 916447469563.1764
85632319 85632319 Djibouti country 102191573 DJ [41.75972200000029,10.93194400000016,43.44452667200005,12.71369725567922] 21708940846.06876
85632323 85632323 Honduras country 102191575 HN [-89.355961,12.984225,-82.38913726799996,17.41872215300003] 112620818867.5625
85632325 85632325 Chad country 102191573 TD [13.47,7.442975,24.000001,23.449228] 1275217817180.2263
85632329 85632329 Kenya country 102191573 KE [33.90982900000017,-4.68005580899995,41.90683820000015,4.6310390000001] 585365892142.2255
85632331 85632331 Palau country 102191583 PW [131.17208862300004,2.91038894700006,134.72708129900002,8.09205532100003] 499621102.760972
85632333 85632333 United States Minor Outlying Islands dependency 136253057 UM [-177.389597,-0.388767,166.652354,28.215318] 28103914.842974
85632335 85632335 Grenada country 102191575 GD [-61.80588912999997,11.98299980200005,-61.37883377099996,12.53786087000003] 372520502.530012
85632337 85632337 Bassas da India dependency 85633147 TF [39.728282,-49.721612,77.585216,-11.550632] 7257455813.993595
85632339 85632339 The Bahamas country 102191575 BS [-80.48630523699995,20.91205596900005,-72.71291351299993,27.27461051900008] 13421996922.650755
85632343 85632343 Andorra country 102191581 AD [1.41376,42.428743,1.786576,42.655765] 463722940.917973
85632347 85632347 Papua New Guinea country 102191583 PG [140.849211,-11.636326,155.96754,-1.346368] 467182605252.73254
85632349 85632349 Tiran and Sanafir Is. disputed 85632581 XX [34.49955368000008,27.90374946600008,34.74039077800006,28.01124954200003] 90541854.046586
85632351 85632351 Reunion country 102193527 FR [55.219,-21.372,55.845,-20.857] 3718764855.102356
85632353 85632353 Dokdo disputed 85632231 XX [131.8630826266343,37.23825403891198,131.87223071409733,37.24423199705615] 153308.959379
85632355 85632355 Paraguay country 102191577 PY [-62.638051,-27.588334,-54.258562,-19.287659] 400576241522.5643
85632357 85632357 Mauritius country 102193527 MU [56.57202911400003,-20.52872276299996,63.50208282500006,-10.32633304599995] 2035686684.223476
85632359 85632359 Cambodia country 102191569 KH [102.333542,9.90705585500007,107.627687,14.690179] 182303811926.7435
85632361 85632361 Iran country 102191569 IR [44.0318910000002,25.0603885650001,63.33320050000015,39.78167600000012] 1624180797794.8083
85632365 85632365 Senegal country 102191573 SN [-17.546278,12.30728900000031,-11.348607,16.693054] 197167499061.84793
85632367 85632367 Mbane Island disputed 85632407 XX [9.36152856000001,0.7986948300001,9.41190444000011,0.81012294000004] 130803.684253
85632369 85632369 Saint Lucia country 102191575 LC [-61.08127593999995,13.70475006100003,-60.87330627399996,14.10841655700006] 620726064.919725
85632371 85632371 Saint Pierre and Miquelon country 136253037 PM [-56.40861129799998,46.74841690100004,-56.08235931399997,47.14250183100006] 236871290.305573
85632373 85632373 Macedonia country 102191581 MK [20.452423,40.85334400000011,23.034093,42.3736305] 25405473606.20144
85632375 85632375 Northern Cyprus disputed 102191569 XX [32.59916687000009,35.00272247300012,34.59452819800015,35.69708252000004] 3331453280.53299
85632377 85632377 Demchok disputed 85632469 XX [79.138206,32.519093,79.561282,33.237886] 1489625325.495903
85632379 85632379 Somalia country 102191573 SO [40.965385,-1.696283,51.417038,11.989119] 473904374562.32776
85632383 85632383 Malawi country 102191573 MW [32.678889,-17.135278,35.924166,-9.36718124999993] 119295851164.18692
85632385 85632385 Guatemala country 102191575 GT [-92.23115315199993,13.74002800000011,-88.23105729849766,17.815687] 109397740596.74101
85632387 85632387 Dhekelia Sovereign Base Area dependency 136253055 XY [33.67370500000027,34.94277954100022,33.91655500000013,35.12373100000025] 130590339.521703
85632391 85632391 Central African Republic country 102191573 CF [14.415098,2.223053,27.458305,11.017957] 622802559648.0167
85632393 85632393 Turkey country 102191569 TR [25.66452789300007,35.80768,44.818128,42.104165] 780182557701.808
85632395 85632395 Belarus country 102191581 BY [23.178943,51.262011,32.77682,56.172485] 206746938528.5629
85632397 85632397 Guyana country 102191577 GY [-61.41472799999985,1.16472400000026,-57.13347037198884,8.52589858981401] 197365850591.95676

Next page

CREATE TABLE whosonfirst (
  id integer primary key,
  name text,
  placetype text,
  parent_id integer,
  country text,
  bbox text,
  area_square_m float
)
Powered by Datasette · Query took 431.609ms