NOTE: This page is experimental. Bug reports to carter.barry@gmail.com. Query language is SQLite3.

Prepend rss. to the URL for an RSS feed, csv. to the URL for CSV output.

QUERY: SELECT asciiname, population, ROUND(latitude/93206.744,2) AS truelat, ROUND(longitude/46603.37,2) AS truelon FROM geonames WHERE population > 500000 ORDER BY RANDOM() LIMIT 20

To edit query (or if query above is munged), see textbox at bottom of page

Empty result may indicate error: I'm not sure why my error checking code isn't working.

Source code

asciiname population truelat truelon
Departement de la Haute-Savoie 706708 46.0 6.33
West Midlands 2600100 52.5 -1.97
Northern Bahr el Ghazal State 812334 8.85 27.0
Wojewodztwo Warminsko-Mazurskie 1427118 53.83 21.0
Republic of Indonesia 242968342 -5.0 120.0
Castilla y Leon 2563521 41.67 -4.25
Multnomah County 735334 45.5 -122.42
Somerset 895700 51.08 -3.0
Region de Sikasso 1773516 10.92 -7.0
Bikaner 576015 28.02 73.3
Departamento de Cundinamarca 2280037 5.0 -74.17
Mary Welayaty 1536553 37.0 62.5
Departement de la Moselle 1039023 49.0 6.5
Changwat Lop Buri 795094 14.93 100.75
Morelia 592797 19.7 -101.18
Zhanjiang 637790 21.28 110.34
Estado de Minas Gerais 19595309 -18.0 -44.0
Middlesex County 809858 40.43 -74.4
Peshawar 1218773 34.01 71.58
Panshan 625040 41.19 122.05

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query