Microproduct Data GuideBeginner

Census ACS 2024 Five-Year Table Summary Files

Census Bureau table-based ACS estimate and margin files for building tract and county housing-context tools.

Start the Guide Open Official Source Open in Colab
Report a Problem

At a Glance

Difficulty
Beginner — comfortable for a first prototype
Size
Small · 0.01–0.1 GB
Formats
DAT
Access
Download
API Key
Not Required
Provider
U.S. Census Bureau
Updates
Annual
Last Verified
Sep 28, 2026
Source Type
Government Source
Data Terms
U.S. Census Bureau public-use statistics; cite the ACS release and retain margins of error.
  • Python Syntax Checked
  • Runnable Notebook

From Source to Product Signal

Test a Product Idea in Four Steps

The 2024 table-based Summary File publishes each detailed table as a pipe-delimited .dat file with estimates and margins. HouseHunter pins B25034, B25035, B25103, B25077, and B08303. Start with one bounded read of B25103; a table value is a survey estimate, and a GEO_ID must be joined to its geography label.

1

Check the Setup

  • Python 3.10 or newer
  • An internet connection
  • The requests Python package
2

Access the Data

  1. 1.Read the Census table-based Summary File instructions and citation guidance.
  2. 2.Request the first complete records from one pinned 2024 five-year table.
  3. 3.Inspect the GEO_ID, estimate, and margin fields before a geography join.
Open Official Source
3

Run the Python Example

Install the packages, then run the notebook cell.

python -m pip install requests

import csv
import io
import requests

url = ("https://www2.census.gov/programs-surveys/acs/summary_file/2024/"
       "table-based-SF/data/5YRData/acsdt5y2024-b25103.dat")
response = requests.get(url, headers={"Range": "bytes=0-2047"}, timeout=30)
response.raise_for_status()
lines = response.text.splitlines()
rows = csv.DictReader(io.StringIO("\n".join(lines[:-1])), delimiter="|")
for row in list(rows)[:2]:
    print(row["GEO_ID"], row["B25103_E001"], row["B25103_M001"])
4

Test a Useful Signal

Inspect ACS Housing Estimates

Compare a small set of housing estimates with their margins of error.

  1. 01Read B25103 estimates and margins for two geographies.
  2. 02Join GEO_ID to the matching ACS geography labels.
  3. 03Explain why a five-year survey estimate is not a current property count.

Related Datasets

Dataset Details

U.S. Census Bureau is a government source. Last verified 2026-09-28. Temporal coverage: 2020-2024 ACS five-year estimates.

Domains

Housing

Formats

DAT

Provider

U.S. Census Bureau

Data Terms

U.S. Census Bureau public-use statistics; cite the ACS release and retain margins of error.

Send Feedback