Is this data not free from the government?

Yes. The source files are public and we link to them. You pay for the cleaning, the joins, the documented schema and the refresh, not for the data itself.

As Parquet or CSV files, by download link or to your own cloud bucket. The same tables load into Snowflake with the scripts we include. A Snowflake Marketplace listing is being set up and is not live yet.

Can I see the data before paying?

Yes. Ask for a sample and we send the Vermont rows from every table, plus the full data dictionary.

Is this a USPS ZIP code list?

No. It uses Census ZIP Code Tabulation Areas, which approximate ZIP codes. It has no ZIP+4.

Are the shares weighted by population?

No. Shares are land-area shares only. There are no population weights.

Available now

US ZIP code to county, tract, metro and congressional district crosswalk

One row per ZIP Code Tabulation Area with its county, metro area, place, congressional district and time zone, plus the full overlap tables for areas that cross a line.

Request a sample See the full catalog

Coverage: 33,791 ZIP Code Tabulation Areas in the 50 states, the District of Columbia, Puerto Rico and the island areas. 2020 Census geography, 119th Congress districts, and metro areas from OMB Bulletin 23-01.

Why pay for public data

The Census relationship files, the Gazetteer, the metro delineation file and the time zone file come from different places with different keys. 10,194 ZIP areas cross a county line and 137 cross a state line, so a one-to-one lookup is wrong for those unless it says which county holds the largest share. This one does, and ships the full overlap tables too.

How it is built

1
Pull the Census 2020 relationship files, the Gazetteer, FIPS codes, the OMB metro delineation and the National Weather Service county time zone file.
2
Build one row per ZIP area with its primary county, metro area, place, county subdivision and congressional district, each with its share of the ZIP area’s land.
3
Keep every overlap as its own table, add 2010-to-2020 ZIP area and tract relationships and county adjacency, and document all 289 columns. Rebuilt annually.

What is in each record

Field	Notes
ZCTA	ZIP Code Tabulation Area
STATE_ABBR, COUNTY_FIPS, COUNTY_NAME	The county with the largest share of the ZIP area’s land
COUNTY_PCT_OF_ZCTA_LAND, COUNTY_COUNT, STATE_COUNT	How much of the area the primary county holds, and how many it touches
CBSA_CODE, CBSA_TITLE	Metro or micro area
PLACE_GEOID, COUSUB_GEOID, CD_GEOID	Place, county subdivision and congressional district
TIME_ZONE, UTC_OFFSET_STANDARD, OBSERVES_DST, TIME_ZONE_IANA	From the primary county. 147 areas sit in a county split between two zones, so TIME_ZONE names both and TIME_ZONE_IANA is empty
ZCTA_COUNTY, ZCTA_TRACT, ZCTA_PLACE, ZCTA_COUSUB, ZCTA_CD	Full overlap tables with land shares in both directions
ZCTA_2010_2020, TRACT_2010_2020	Relationships between 2010 and 2020 geography
COUNTY_ADJACENCY	Neighboring counties, with SHARED_BOUNDARY_M and IS_CROSS_STATE

Who uses it

Analysts joining ZIP-level data to county or tract data
Marketing operations and territory-planning teams
Data engineers who need one documented geography key table

Pricing

$149 a year, including each annual refresh.

No personal contact data is collected or sold in any QuestionPunk dataset.

Questions

Is this data not free from the government?: Yes. The source files are public and we link to them. You pay for the cleaning, the joins, the documented schema and the refresh, not for the data itself.
How is it delivered?: As Parquet or CSV files, by download link or to your own cloud bucket. The same tables load into Snowflake with the scripts we include. A Snowflake Marketplace listing is being set up and is not live yet.
Can I see the data before paying?: Yes. Ask for a sample and we send the Vermont rows from every table, plus the full data dictionary.
Is this a USPS ZIP code list?: No. It uses Census ZIP Code Tabulation Areas, which approximate ZIP codes. It has no ZIP+4.
Are the shares weighted by population?: No. Shares are land-area shares only. There are no population weights.

Tell us what you need

Geography, size and fields. A two-line email is enough, and a person replies.

Request a sample