U.S. ZIP Code Tabulation Area Geography Database

Work with 33,791 current Census ZIP Code Tabulation Areas in a normalized, multi-table release for mapping, territory analysis, directory enrichment, demographic joins, and geographic resear...

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated September 1, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
ZCTA Geography DirectoryCurrent ZCTA identifiers, areas, internal points, and three-digit prefixes for internal use.
$45.00
Complete Place Relationship DataEverything in County Relationship Data plus Census place intersections and land-share measures with update eligibility.Current update offer$10.00For eligible earlier Master purchases
$225.00
Records
33,791
Version
2.0.0
Release date
Sep 1, 2026
Before you choose
Explore the samples
U.S. ZIP Code Tabulation Area Geography Database List

U.S. ZIP Code Tabulation Area Geography Database v.2.0.0

33,791 Current Census ZIP Code Tabulation Areas

U.S. ZIP Code Tabulation Area Geography Database catalog icon U.S. ZIP Code Tabulation Area Geography Database Download
U.S. ZIP Code Tabulation Area Geography Database artwork

U.S. ZIP Code Tabulation Area Geography Database

Work with 33,791 current Census ZIP Code Tabulation Areas in a normalized, multi-table release for mapping, territory analysis, directory enrichment, demographic joins, and geographic research.

Structured geographic coverage

The core table includes five-character ZCTA identifiers, three-digit prefixes, land and water area, fully qualified Census GEOIDs, and internal latitude and longitude. Higher tiers add 46,960 county intersections and 53,319 incorporated-place or census-designated-place intersections with area-share measures.

Important limitations

ZCTAs are Census statistical geographies. They are not a complete USPS delivery ZIP Code directory, address validator, routing product, or guarantee that a postal code is active for delivery. Relationship tables use official 2020 intersection geography joined only to identifiers still present in the current 2025 ZCTA population.

33,791 Current Census ZIP Code Tabulation Areas Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Lyrics Baby Names Historical Events Postal Records

License Database Purchase Options

USAGE

ZCTA Geography Directory

$45.00

Internal work

Import, modify, combine and analyze within one organization, including work by supervised contractors.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Usage License

Choose this package above

PUBLICATION

County Relationship Data

$110.00

Publish and build for clients

All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Publication License

Choose this package above

MASTER

Complete Place Relationship Data

$225.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$10.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

Table Schema Database Field Statistics

Release structure

U.S. ZIP Code Tabulation Area Geography Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#41
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
zcta_geographyzcta5, geoid_fq, zip3_prefix, land_area_sq_m, water_area_sq_m, land_area_sq_mi, water_area_sq_mi, internal_latitude, internal_longitude, geography_vintage, geography_type
zcta_county_relationshipsrelationship_id, zcta5, county_geoid, county_name, intersection_land_sq_m, intersection_water_sq_m, zcta_land_share_pct, county_land_share_pct, relationship_vintage
zcta_place_relationshipsrelationship_id, zcta5, place_geoid, place_name, intersection_land_sq_m, intersection_water_sq_m, zcta_land_share_pct, place_land_share_pct, relationship_vintage

Release at a glance

What is inside this database

Explore 33,791 current Census ZIP Code Tabulation Areas with geometry measures and normalized county and place relationships.

33,791ZCTA geography records
46,960County intersections
53,319Place intersections
896Represented 3-digit prefixes

Table and column statistics

Select a table to review its schema, record total and fields. Distinct and missing-value counts appear where measured.

zcta geography33,791 records · 11 fields
zcta5
Distinct
33,791
Missing
0 (0.0%)
geoid_fq
Distinct
33,791
Missing
0 (0.0%)
zip3_prefix
Distinct
896
Missing
0 (0.0%)
land_area_sq_m
Distinct
33,783
Missing
0 (0.0%)
water_area_sq_m
Distinct
28,446
Missing
0 (0.0%)
land_area_sq_mi
Distinct
28,018
Missing
0 (0.0%)
water_area_sq_mi
Distinct
6,108
Missing
0 (0.0%)
internal_latitude
Distinct
33,751
Missing
0 (0.0%)
internal_longitude
Distinct
33,779
Missing
0 (0.0%)
geography_vintage
Distinct
1
Missing
0 (0.0%)
geography_type
Distinct
1
Missing
0 (0.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

zcta geographyDownload this sample CSV
zcta5geoid_fqzip3_prefixland_area_sq_mwater_area_sq_mland_area_sq_miwater_area_sq_miinternal_latitudeinternal_longitudegeography_vintagegeography_type
00601860Z200US0060100616683645079861364.4160.30818.180555-66.7499612025Census ZIP Code Tabulation Area
00602860Z200US0060200678546196442842830.3271.7118.361945-67.1755972025Census ZIP Code Tabulation Area
00603860Z200US0060300688980553625331634.3562.41418.457399-67.1248672025Census ZIP Code Tabulation Area
00606860Z200US006060061148256451222844.3340.00518.15832-66.9329282025Census ZIP Code Tabulation Area
00610860Z200US0061000696150185428968837.1241.65618.295304-67.125182025Census ZIP Code Tabulation Area
00611860Z200US0061100627581406363110.6490.00118.276316-66.8071652025Census ZIP Code Tabulation Area
00612860Z200US006120061974982151501451876.2545.79718.416727-66.700092025Census ZIP Code Tabulation Area
00616860Z200US006160062816814418053810.8760.0718.420408-66.6719862025Census ZIP Code Tabulation Area
00617860Z200US0061700647509243169310318.3430.65418.446889-66.5611542025Census ZIP Code Tabulation Area
00622860Z200US00622006807208331958712431.1667.56317.988103-67.1603572025Census ZIP Code Tabulation Area
00623860Z200US006230061015229681419214939.1985.4818.084371-67.1587652025Census ZIP Code Tabulation Area
00624860Z200US006240061217247361530142746.9985.90818.051808-66.7217112025Census ZIP Code Tabulation Area
00627860Z200US00627006120296556338181046.4471.30618.412423-66.8637082025Census ZIP Code Tabulation Area
00631860Z200US0063100680959447093693.1260.27418.184294-66.8307952025Census ZIP Code Tabulation Area
00636860Z200US0063600694981900.3670.18.1636-67.0800972025Census ZIP Code Tabulation Area
00637860Z200US00637006910659252624235.1610.0118.080103-66.9479752025Census ZIP Code Tabulation Area
00638860Z200US0063800618492878347895771.4010.18518.280188-66.5131112025Census ZIP Code Tabulation Area
00641860Z200US00641006217818756343503684.11.32618.268074-66.7017852025Census ZIP Code Tabulation Area
00646860Z200US0064600654525349325476421.0521.25718.432897-66.2864992025Census ZIP Code Tabulation Area
00647860Z200US0064700640920382797379515.7993.07917.963613-66.9471272025Census ZIP Code Tabulation Area

Current Census ZIP Code Tabulation Areas Records Information

Contains 33,791 current ZCTA rows, 46,960 county intersection rows, and 53,319 place intersection rows. The five-character ZCTA identifier anchors every table and preserves leading zeroes.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.
Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Support

How can we help?

Browse all Help topics

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details