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
Iowa 2955010 42.0 -93.5
Republic of Cameroon 19294149 6.0 12.0
Montenegro 666730 42.5 19.3
District de Bamako 971351 12.65 -8.0
Lucknow 2472011 26.85 80.92
Yono 1077730 35.88 139.63
Cali 2392877 3.44 -76.52
Estado de Sonora 2351427 29.33 -110.67
Atsimo-Atsinana 621200 -23.2 47.4
Aydin 1009186 37.75 28.0
Capitale d'Etat-Zone Speciale de Conakry 1871242 9.57 -13.65
Hellenic Republic 11000000 39.0 22.0
Johnson County 544179 38.87 -94.87
Altayskiy Kray 2586976 52.5 83.0
Nyanza Province 4392196 -0.5 34.5
Kuching 570407 1.55 110.33
Osmaniye 500480 37.24 36.25
Joao Pessoa 650883 -7.12 -34.86
Provincia di Roma 4154684 41.97 12.67
Delaware County 558979 40.0 -75.37

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query