OUR BUSINESS is building mobile solutions for YOUR BUSINESS

The internet is going mobile. Give your business the edge - Whether you need to mobile enable your customers, suppliers or staff, we can design and build YOUR SOLUTION... Websites, iPhone and Android.

US Zip Codes

Below is a link to a .csv file of U.S. Zip Codes. The fields (in order) are:

  • id - just the id from my database
  • zip_code - the 5 digit zip code
  • cty_id - the Country Id (232 for U.S.)
  • State_id - The Foreign Key for the State Table
  • state_code - The 2 digit state code
  • state_name - always null in this table because we use the State Table
  • zip_latitude - roughly the center point of the state
  • zip_longitude - roughly the center point of the state
  • zip_geography - It's an object so unusable from this file
  • city_name - the major city for this zip code

Enjoy:

uszipcodes.csv

Please register or login to post comments