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: