A comprehensive dataset of every US ZIP code mapped to its city, state, county, geographic coordinates, and timezone. Ideal for address validation, shipping zone calculations, demographic analysis, and location-based features in your applications.
Pro tip: Import the CSV into your database and index the ZIP column to enable instant address lookups and distance calculations using the included latitude and longitude values.
Select which columns to include in your download.
About the US ZIP Codes Dataset
This dataset contains every active US ZIP code assigned by the United States Postal Service, enriched with geographic and administrative metadata. Each record includes the ZIP code, primary city name, two-letter state abbreviation, county name, latitude and longitude coordinates, and the IANA timezone identifier. The data is compiled from USPS publications and US Census Bureau geographic reference files to ensure accuracy and completeness.
Common Use Cases
ZIP code data is one of the most frequently used reference datasets in software development and business operations:
- Address validation: Verify that a user-entered ZIP code matches the expected city and state, catching typos and fraudulent entries before they reach your database.
- Shipping and logistics: Calculate shipping zones, estimate delivery times, and assign regional warehouses based on ZIP code proximity using the included coordinates.
- Demographic analysis: Aggregate customer data by ZIP code to identify geographic concentrations, plan marketing campaigns, and allocate sales territories.
- Store locators: Build radius-based search features that find the nearest physical locations to a customer by computing distances from ZIP code centroids.
Column Reference
The dataset is structured with columns designed for both human readability and programmatic use:
- zip — The five-digit ZIP code as a zero-padded string (e.g.
01001,90210). Always stored as text to preserve leading zeros. - city — The primary city or town name associated with the ZIP code as designated by the USPS.
- state — The two-letter USPS state abbreviation (e.g.
CA,NY,TX). - county — The county or equivalent jurisdiction (parish in Louisiana, borough in Alaska) containing the ZIP code.
- latitude — The approximate latitude of the ZIP code centroid in decimal degrees, suitable for distance calculations and map plotting.
- longitude — The approximate longitude of the ZIP code centroid in decimal degrees.
- timezone — The IANA timezone identifier (e.g.
America/New_York,America/Los_Angeles) for the ZIP code area.
Working with ZIP Code Coordinates
The latitude and longitude values represent the geographic centroid of each ZIP code area, not a specific street address. These coordinates are accurate enough for radius searches, zone assignment, and map visualizations at the city level. For applications requiring precise geocoding of individual addresses, use these centroids as a fallback when a full geocoding API is unavailable or as a fast first-pass filter before making more expensive API calls.
Data Format and Integration Notes
ZIP codes must always be treated as strings rather than integers in your application code to preserve leading zeros common in northeastern states. When importing the CSV into a database, define the ZIP column as CHAR(5) or VARCHAR(5) rather than an integer type. The JSON export preserves ZIP codes as strings automatically. For SQL imports, the generated DDL uses the correct string type to prevent data loss. The timezone column uses standard IANA identifiers that are directly compatible with most programming language datetime libraries.