Home / Tutorials / Data

Selected Variables From the 2019 - 2023 American Community Survey 5-Year Estimates

CSV and GeoJSON files are available for states, counties, census tracts, 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
• Name (NAME): State name / county name / zip code / tract 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