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 g.geonameid, g.asciiname, g.population FROM altnames a JOIN geonames g ON (a.geonameid=g.geonameid) WHERE a.name = 'alexandria' AND g.population>0 ORDER BY g.population DESC

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

geonameid asciiname population
361058 Alexandria 3811516
361059 Muhafazat al Iskandariyah 3811516
3183298 Provincia di Alessandria 439414
4744091 Alexandria 139966
3183299 Alessandria 85438
686502 Alexandria 49346
4314550 Alexandria 47723
736929 Alexandreia 13665
6319030 Alexandria 13475
2657513 Alexandria 13079
5016108 Alexandria 11070
3407977 Alexandria 9769
4282342 Alexandria 8477
4917537 Alexandria 5145
2178136 Alexandria 4203
4829861 Alexandria 3917
3491593 Alexandria 1927
5082573 Alexandria 1415
4602270 Alexandria 966
5225919 Alexandria 615
5145537 Alexandria 517
5178012 Alexandria 346
5062851 Alexandria 177
5053881 Alexandria 159

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query