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.
$225.00
U.S. ZIP Code Tabulation Area Geography Database List

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

33,791 Postal Records

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

License Database Purchase Options

Pick the right license ZCTA GEOGRAPHY DIRECTORY
USAGE LICENSE
$45.00
 COUNTY RELATIONSHIP DATA
PUBLICATION LICENSE
$110.00
 COMPLETE PLACE RELATIONSHIP DATA
MASTER LICENSE
$225.00
Data Tracking Seeds
Data Modification
Importing
Exporting
Merge
Web Usage
Multiple PC's or Websites
Mobile Development
Updates Available
All Data File Formats
Custom File Formats
Distribution
Copyright Endorsement
  BUY NOW BUY NOW BUY NOW

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 Postal Records Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Lyrics Baby Names Historical Events Postal Records

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 own schema, record total, fields, distinct values, and missing-value coverage.

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

Postal Records 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.

Build a broader dataset

Extend this dataset around your project

Combine this database with compatible business, location, or specialty records. Oddity can also scope a custom package by geography, fields, format, and intended use.

Related datasetsField selectionCustom geography
Explore compatible data Discuss a custom package

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