Selected Variables From the 2019 - 2023 American Community Survey 5-Year Estimates
CSV and GeoJSON files are available for states, counties, census tracts, core-based statistical areas (CBSA), and zip codes (ZCTA).
Variable names for the data profile table variables are followed by USCB API variable names.
R code for generating these files using the USCB API
US Census Bureau. n.d. "2019 - 2023 American Community Survey 5-Year Estimates." Accessed 26 January 2025. https://data.census.gov.
Geography
Polygons are from the USCB TIGER/Line cartographic boundary files.
- GEOIDFQ: Fully-qualified GEOID code composed of a prefix and FIPS code that can be used to unambiguously join with US Census Bureau data from data.census.gov.
- ST (STUSPS): USPS two-letter state code (states, counties, tracts, and ZCTA only)
- Name (NAME): State name / county name / zip code / tract name / CBSA name / zip code
- Latitude: WGS 1984 latitude of the centroid calculated from the area polygons with st_centroid()
- Longitude: WGS 1984 longitude of the centroid calculated from the area polygons with st_centroid()
- Square_Miles: Land area in square miles calculated by dividing ALAND + AWATER (square meters) by 2,589,988
Table DP02 - Selected Social Characteristics in the United States
- Total_Households (DP02_0001E): Total number of households
- Average_Household_Size (DP02_0016E): Average number of persons per household
- Percent_Single_Mothers (DP02_0038PE): Percent of women 15 to 50 years old who had a birth in the past 12 months who were widowed, divorced, or never married
- Percent_In_College (DP02_0058PE): Percent of population 3 years or older enrolled in college or graduate school
- Percent_Bachelors_Degree (DP02_0065PE): Percent of population 25 years or older with a bachelor's degree
- Percent_Graduate_Degree (DP02_0066PE): Percent of population 25 years or older with a graduate or professional degree
- Percent_Veterans (DP02_0070PE): Percent of population over 18 years of age that are civilian veterans of the armed forces
- Percent_Disabled (DP02_0072PE): percent of the total civilian noninstitutionalized population with a disability. Disability types include hearing difficulty, vision difficulty, cognitive difficulty, ambulatory difficulty, self-care difficulty, and independent living difficulty
- Percent_Foreign_Born (DP02_0094PE): Percent of population born outside the USA
Table DP03 - Selected Economic Characteristics
- Workforce_Participation (DP03_0002PE): Percent of population 16 years and over in the labor force
- Percent_Unemployed (DP03_0009PE): Percent of civillian labor force unemployed. Note that this is a value captured in the survey period that may not accurately reflect either current or long-term structural conditions
- Percent_Commute_Alone (DP03_0019PE): Percent of workers 16 years or over that drive to work alone in a car, truck, or van
- Percent_Commute_Transit (DP03_0021PE): Percent of workers 16 years or over that commute to work by public transportation, exclusing taxicabs
- Percent_Commute_Walk (DP03_0022PE): Percent of workers 16 years or over that commute to work by walking
- Percent_Work_at_Home (DP03_0024PE): Percent of workers 16 years or over that commute to work at home
- Mean_Commute_Minutes (DP03_0025E): Mean travel time to work in minutes for workers 16 years of age and older
- Percent_Jobs_Management (DP03_0027PE): Percent of civillian employed population 16 years or over in management, business, science, and arts occupations
- Percent_Jobs_Service (DP03_0028PE): Percent of civillian employed population 16 years or over in service occupations
- Percent_Jobs_Sales (DP03_0029PE): Percent of civillian employed population 16 years or over in sales and office occupations
- Percent_Jobs_Nat_Resources (DP03_0030PE): Percent of civillian employed population 16 years or over in natural resources, construction, and maintenance occupations
- Percent_Jobs_Production (DP03_0031PE): Percent of civillian employed population 16 years or over in production, transportation, and material moving occupations
- Percent_Industry_Ag_Mining (DP03_0033PE): Percent of civillian employed population 16 years or over working in agriculture, forestry, fishing and hunting, and mining
- Percent_Industry_Construction (DP03_0034PE): Percent of civillian employed population 16 years or over working in construction
- Percent_Industry_Manufacturing (DP03_0035PE): Percent of civillian employed population 16 years or over working in manufacturing
- Percent_Industry_Wholesale (DP03_0036PE): Percent of civillian employed population 16 years or over working in wholesale trade
- Percent_Industry_Retail (DP03_0037PE): Percent of civillian employed population 16 years or over working in retail trade
- Percent_Industry_Transport (DP03_0038PE): Percent of civillian employed population 16 years or over working in transportation and warehousing, and utilities
- Percent_Industry_Information (DP03_0039PE): Percent of civillian employed population 16 years or over working in information
- Percent_Industry_Finance (DP03_0040PE): Percent of civillian employed population 16 years or over working in finance and insurance, and real estate and rental and leasing
- Percent_Industry_Pro_Services (DP03_0041PE): Percent of civillian employed population 16 years or over working in professional, scientific, and management, and administrative and waste management services
- Percent_Industry_Education (DP03_0042PE): Percent of civillian employed population 16 years or over working in educational services, and health care and social assistance
- Percent_Industry_Recreation (DP03_0043PE): Percent of civillian employed population 16 years or over working in arts, entertainment, and recreation, and accommodation and food services
- Percent_Private_Employed (DP03_0047PE): Percent civilian employed population 16 years and over as private wage and salary workers
- Percent_Govt_Employed (DP03_0048PE): Percent civilian employed population 16 years and over as government workers
- Percent_Self_Employed (DP03_0049PE): Percent civilian employed population 16 years and over that are self-employed in own not incorporated business workers
- Median_Household_Income (DP03_0062E): Median household income and benefits in 2023 inflation-adjusted dollars
- Percent_Health_Insurance (DP03_0096PE): Percent of the civilian noninstitutionalized population with health insurance coverage
Table DP04 - Selected Housing Characteristics
- Total_Housing_Units (DP04_0001E): Total housing units
- Percent_Vacant_Units (DP04_0003PE): Percent vacant housing units
- Percent_Pre_War_Units (DP04_0026PE): Percent of housing units built in 1939 or earlier
- Homeownership_Percent (DP04_0046PE): Percent of occupied housing units occupied by the owner
- Percent_Renters (DP04_0047PE): Percent of housing units occupied by a renter
- Percent_No_Vehicle (DP04_0058PE): Percent of occupied housing units where no vehicle is available
- Median_Home_Value (DP04_0089E): Median value of owner-occupied housing units
- Median_Monthly_Mortgage (DP04_0101E): Median selected monthly owner costs in dollars for housing units with a mortgage
- Median_Monthly_Rent (DP04_0134E): Median monthly rent in dollars for occupied housing units paying rent
- Percent_Unaffordable_Rent (DP04_0142PE): Percent of occupied units paying rent that is 35% or more of household income
Table DP05 - Demographic and Housing Estimates
- Total_Population (DP05_0001E): Total population
- Median_Age (DP05_0018E): Median age in years
- Percent_Under_5 (DP05_0005PE): Percent of total population under five years of age
- Percent_Under_18 (DP05_0019PE): Percent of total population under 18 years of age
- Percent_Over_64 (DP05_0024PE): Percent of total population 65 years of age or older
- Pop_per_Square_Mile: Total_Population divided by Square_Miles