US ZIP Code Database — Download or API Access
A complete database of 42,000+ US ZIP codes with city, state, county, latitude/longitude, timezone, and population. Available as a one-time download or via live REST API.
| Field | Type | Sample value | Description |
|---|---|---|---|
| zip_code | text(5) | 90210 | 5-digit US ZIP code, zero-padded |
| city | text | Beverly Hills | Primary city name for the ZIP code |
| state | text(2) | CA | 2-letter USPS state abbreviation |
| state_full | text | California | Full state name |
| county | text | Los Angeles | County name (without "County") |
| latitude | decimal | 34.0901 | Latitude in decimal degrees |
| longitude | decimal | -118.4065 | Longitude in decimal degrees |
| timezone | text | America/Los_Angeles | IANA timezone identifier |
| utc_offset | integer | -8 | UTC offset in hours (standard time) |
| dst | boolean | 1 | Observes Daylight Saving Time (1=yes) |
| population | integer | 21741 | Estimated population for the ZIP code area |
CSV
Plain comma-separated values. Opens in any spreadsheet application, imports directly into databases, and works with every programming language. No proprietary format dependencies.
Excel (.xlsx)
Microsoft Excel workbook with formatted columns, proper data types, and ready-to-use column headers. Ideal for business users who need to work with the data directly without technical setup.
Access (.mdb)
Microsoft Access database with pre-built table structure, indexed on ZIP code for fast lookups. Ready to link to existing Access applications or use as a standalone reference database.
Database Download
One-time purchase- Works offline — no internet dependency
- No rate limits or API calls to count
- Bulk process all 42,000+ ZIP codes at once
- Load into SQL, PostgreSQL, SQLite, or Excel
- Own the data permanently after purchase
- No per-request costs as usage scales
- Ideal for analytics, reporting, and enrichment pipelines
One-time purchase · Instant download
REST API
Free tier + paid plans from $19/mo- Real-time lookups — always current data
- No file to maintain or re-import
- Integrate directly into apps, forms, and backends
- Works in JavaScript, Python, PHP, and any HTTP client
- Free tier available — 100 calls/day, no credit card
- Scales with paid plans up to unlimited calls
- Ideal for checkout validation, live apps, and SaaS
No credit card · Instant access
Seed a local database, run batch geocoding, or build a lookup service without API dependencies.
Download → CSVEnrich datasets with city, county, and region data. Join on ZIP code to add geographic dimensions to reports.
Download → Excel or CSVSegment customer lists by city, state, or county. Add geographic fields to CRM exports for targeting.
Download → ExcelValidate ZIP codes at checkout, auto-fill city and state, or build delivery coverage tools in your app.
API → Free or PaidPlan service areas, build radius tools, or cross-reference coverage zones against ZIP code geography.
Both — Download + APIAdd ZIP code lookup to WooCommerce, contact forms, or custom plugins with a few lines of PHP.
API → PHP IntegrationUS ZIP Code Database — Complete Reference Data for All 42,000+ ZIP Codes
A ZIP code database is a structured dataset containing all active United States ZIP codes along with associated geographic and demographic data. It is used by developers, analysts, marketers, and operations teams to enrich records, build location features, and perform geographic analysis without requiring a live internet connection or per-request API calls.
What is a ZIP code database used for?
The most common uses are data enrichment (appending city, state, and county to records that contain only a ZIP code), geographic segmentation (grouping customers or locations by region), distance calculations using latitude and longitude, timezone assignment for scheduling systems, and seeding application databases with reference data for local ZIP code lookups.
Download vs. API: choosing the right format
The database download is the right choice when you need to process data in bulk, work offline, load data into a SQL database, or avoid per-request costs at scale. The ZIP Code API is the right choice when your application needs real-time lookups — for example, validating a ZIP code entered in a form, auto-filling city and state at checkout, or looking up timezone data at runtime. Many teams use both: the download for analytics pipelines and the API for live application features.
ZIP code database formats: CSV, Excel, and Access
The CSV format is the most portable — it imports into PostgreSQL, MySQL, SQLite, Google Sheets, Python (pandas), R, and any other tool that reads delimited text. The Excel format is formatted for direct business use with column headers and proper data types, suitable for analysts who work in spreadsheets. The Access format provides a pre-structured relational database ready to link to existing Microsoft Office workflows or legacy Access applications.
ZIP code data fields: city, state, county, lat/lng, timezone
Each record in the database includes the ZIP code, city, state abbreviation, full state name, county, latitude, longitude, IANA timezone identifier, UTC offset, DST flag, and population estimate. This covers the full range of fields needed for geocoding, address validation, timezone detection, and demographic analysis.
Free ZIP code data vs. paid database
Free ZIP code data is available from various public sources, but quality varies significantly — many free datasets are outdated, missing fields, or limited to city and state only. The ZipCodesToGo database is maintained and updated, includes all key geographic and demographic fields, and is available for commercial use. For applications that only need occasional lookups, the free API tier provides 100 calls/day at no cost.