countries.yml is from countries gem https://github.com/hexorx/countries import_geonames downloads and imports geonames db. http://download.geonames.org/export/dump/ free-zipcode-database-Primary.csv is from http://federalgovernmentzipcodes.us/