Data dictionary
The zipcodemax US ZIP code database is a single CSV with one row per ZIP code (Census ZCTA, plus 299 USPS-only ZIPs with limited data) and 54 columns. The national file has 34,073 rows; a single-state file has every ZIP in that state. US Census Bureau, American Community Survey (ACS) 5-year estimates, joined to Census ZCTA Gazetteer. Plus a small set of standard-delivery USPS ZIPs with no Census ZCTA, included with city, state, county and an IRS-based population estimate only. Figures reflect the 2019–2023 American Community Survey 5-year estimates.
| # | Column | Description |
|---|---|---|
| 1 | zipcode | 5-digit ZIP code. Nearly all are Census ZIP Code Tabulation Areas (ZCTAs); a few hundred standard-delivery USPS ZIPs with no ZCTA are also included, with limited data (see Total Population). |
| 2 | state | State or territory name. |
| 3 | county | County (or counties, semicolon-separated) the ZCTA overlaps. |
| 4 | city | USPS-recognized place name(s) for the ZIP, semicolon-separated. |
| 5 | Median Household Income | Median annual household income, US dollars. Blank means the Census published no estimate for this ZIP (typically very small ZIPs). |
| 6 | Average Household Income | Mean annual household income, US dollars. Blank means the Census published no estimate for this ZIP (typically very small ZIPs). |
| 7 | Per Capita Income | Income per person, US dollars. Blank means the Census published no estimate for this ZIP (typically very small ZIPs). |
| 8 | total households | Number of occupied households. |
| 9 | households above $100k | Households with income of $100,000 or more. |
| 10 | households above 150k | Households with income of $150,000 or more. |
| 11 | Total Population | Total resident population. For the USPS-only ZIPs that have no Census ZCTA, this is an IRS-based estimate (blank where none exists) and every other demographic column in that row is blank. |
| 12 | White Population | Population identifying as White alone. |
| 13 | Black Population | Population identifying as Black or African American alone. |
| 14 | Native American Population | Population identifying as American Indian / Alaska Native alone. |
| 15 | Asian Population | Population identifying as Asian alone. |
| 16 | Other Population | Population identifying as some other race, or two or more races. |
| 17 | Hispanic Latino Population | Population of Hispanic or Latino origin (any race). |
| 18 | Population Density (people per square mile) | Total population divided by land area in square miles. |
| 19 | female 0-9 | Female residents aged 0–9. |
| 20 | female 10-19 | Female residents aged 10–19. |
| 21 | female 20-29 | Female residents aged 20–29. |
| 22 | female 30-39 | Female residents aged 30–39. |
| 23 | female 40-49 | Female residents aged 40–49. |
| 24 | female 50-59 | Female residents aged 50–59. |
| 25 | female 60-69 | Female residents aged 60–69. |
| 26 | female 70+ | Female residents aged 70 or older. |
| 27 | male 0-9 | Male residents aged 0–9. |
| 28 | male 10-19 | Male residents aged 10–19. |
| 29 | male 20-29 | Male residents aged 20–29. |
| 30 | male 30-39 | Male residents aged 30–39. |
| 31 | male 40-49 | Male residents aged 40–49. |
| 32 | male 50-59 | Male residents aged 50–59. |
| 33 | male 60-69 | Male residents aged 60–69. |
| 34 | male 70+ | Male residents aged 70 or older. |
| 35 | Median Age | Median age of all residents, years. Blank means the Census published no estimate for this ZIP (typically very small ZIPs). |
| 36 | Housing Units | Total housing units (occupied + vacant). |
| 37 | Occupied Units | Occupied housing units. |
| 38 | Owner-Occupied | Owner-occupied housing units. |
| 39 | Renter-Occupied | Renter-occupied housing units. |
| 40 | Median Value Owner-Occupied Units | Median value of owner-occupied homes, US dollars. Blank means the Census published no estimate for this ZIP (typically very small ZIPs). |
| 41 | land area sq mi | Land area of the ZCTA, square miles. |
| 42 | geoid | Census GEOID for the ZCTA. |
| 43 | Male Population | Total male population. |
| 44 | Female Population | Total female population. |
| 45 | Male Population Percent | Male population as a percent of (male + female) population. |
| 46 | Female Population Percent | Female population as a percent of (male + female) population. |
| 47 | Total Homeowner Income | Owner-occupied units x median household income -- an estimate of aggregate income earned by homeowner households in this ZIP, in US dollars. Blank when median household income is blank. |
| 48 | Income Density (per square mile) | Total households x median household income, divided by land area -- an estimate of aggregate household income per square mile, in US dollars. Blank when median household income is blank. |
| 49 | Homeowner Income Density (per square mile) | Total Homeowner Income divided by land area, in US dollars per square mile. Blank when median household income is blank. |
| 50 | Housing Unit Density (per square mile) | Total housing units divided by land area in square miles. |
| 51 | Owner-Occupied Unit Density (per square mile) | Owner-occupied housing units divided by land area in square miles. |
| 52 | Renter-Occupied Unit Density (per square mile) | Renter-occupied housing units divided by land area in square miles. |
| 53 | High-Income Homeowner Density (per square mile) | Estimated households earning $100k+ that are also homeowners, divided by land area. The source doesn't cross-tabulate income by owner/renter status, so this approximates it by applying the ZIP's overall homeownership rate to its $100k+ household count -- a proxy for how many affluent homeowners are packed into each square mile, not an official statistic. |
| 54 | Area Code(s) | Telephone area code(s) (NANPA NPA) serving this ZIP, most common first, semicolon-separated. From a third-party phone-exchange-to-ZIP crosswalk, not the Census -- coverage isn't complete (blank for some rural ZIPs) and a handful of overlay ZIPs list more than one. |