Data dictionary
The zipcodemax US ZIP code database is a single CSV with one row per ZIP code (Census ZCTA) and 53 columns. The national file has 33,774 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. Figures reflect the 2019–2023 American Community Survey 5-year estimates.
| # | Column | Description |
|---|---|---|
| 1 | zipcode | 5-digit ZIP Code Tabulation Area (ZCTA). |
| 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. |
| 6 | Average Household Income | Mean annual household income, US dollars. |
| 7 | Per Capita Income | Income per person, US dollars. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 49 | Homeowner Income Density (per square mile) | Total Homeowner Income divided by land area, in US dollars per square mile. |
| 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 | 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. |