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
Muhafazat Lahij 752102 13.17 44.58
Ta'if 530848 21.27 40.42
Houston-Sugar Land-Baytown 5728143 29.74 -95.31
Comunidad de Madrid 6386932 40.43 -3.69
Barcelona 1621537 41.4 2.13
Ahvaz 841145 31.32 48.67
Estado de Morelos 1680239 18.75 -99.0
Dorset 701100 50.75 -2.33
Republic of Slovenia 2007000 46.25 15.17
Provincia de Guipuzcoa 705698 43.17 -2.17
Cebu City 799768 10.3 123.9
Region Picardie 1900354 50.0 3.5
Lancaster County 519445 40.25 -76.25
Landkreis Esslingen 514109 48.67 9.36
Kirovohrads'ka Oblast' 1090921 48.5 32.0
Wojewodztwo Kujawsko-Pomorskie 2068000 53.0 18.0
Republic of Austria 8205000 47.33 13.33
Autonomous Region in Muslim Mindanao 4120795 7.1 124.39
West Yorkshire 2161200 53.7 -1.58
Accra 1963264 5.56 -0.2

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query