As I promised earlier, I’ve downloaded earthquakes from NCEDC’s web site (1898 to date), reverse-geocoded them via GeoNames and K-D Trees (thereby obtaining their country, state, county, and city/village values), archived the resulting files via 7-ZIP and uploaded both the CSV and SQLite datasets to:

• NCEDC_earthquakes_18980101_thru_20160531_reverse_geocoded.csv.7z
  • pipe-separated values, approximately 67 MB in size
• NCEDC_Earthquakes_18980101_thru_20160531_reverse_geocoded.sqlite.7z
  • SQLite 3 database, approximately 208 MB in size

I have authored a program in Python 3 that reverse-geocodes (via GeoNames and K-D Trees) the lat/longs into their respective countries, states, counties, and cities/villages.  I will post a link to the open-source project shortly once I’ve vetted its license and repository.  The program processes nearly 3 million rows in approximately 240 seconds.