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
Departamento de Caldas 968740 5.25 -75.5
Changwat Surin 1491395 14.83 103.75
Provincia de Huelva 513403 37.67 -7.0
Ondo State 4011407 7.17 5.08
West Midlands 2600100 52.5 -1.97
Mintaqat Tabuk 708860 27.5 37.33
Region Hovedstaden 1680271 55.83 12.33
Yueyang 5000000 29.33 113.09
Tangshan 1596949 39.63 118.18
Kirovskaya Oblast' 1457862 58.0 50.0
Hohhot 774477 40.81 111.65
Land Berlin 3442675 52.5 13.42
Kabardino-Balkarskaya Respublika 928519 43.5 43.5
Djibouti 623891 11.59 43.14
New York City 8175133 40.71 -74.01
Novokuznetsk 539616 53.76 87.11
Provincia de Pontevedra 959764 42.5 -8.5
Honolulu County 953207 21.47 -157.97
Al Mawsil al Jadidah 2065597 36.33 43.1
Mashonaland East Province 1167065 -17.5 32.0

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query