U.S. demographics spreadsheet by city

Name: U.S. City and Census Place Market Screen
Creator: Every City in the USA
License: https://www.everycityintheusa.com/data/packages/national-city-place-market-screen/terms/license_commercial_national_city_place_market_screen_2f10d1118979/

Population and demographics for U.S. cities and Census places, ready for Excel and CSV.

19,483 cities with annual population estimates
32,330 Census places with five-year demographics
Excel workbook and CSVs, with sources and documentation

One-time purchase

Map of one-year population percentage change, 2024 to 2025, for 19,329 cities in the contiguous United States, over shaded terrain relief. Green dots gained population, rust dots lost population, and gray dots did not change. Dot size reflects each city's one-year percentage change. Sources: U.S. Census Bureau Population Estimates Program, Vintage 2025, and U.S. Geological Survey 3D Elevation Program. — **City population change, 2024 to 2025.** Green dots gained, rust dots lost, gray dots did not change. The motion is illustrative, not a time series.
Contiguous U.S. PEP cities, a subset of the package. Sources: U.S. Census Bureau PEP, Vintage 2025; shaded relief from USGS 3DEP.

**City population change, 2024 to 2025.** Green dots gained, rust dots lost, gray dots did not change. The motion is illustrative, not a time series.
Contiguous U.S. PEP cities, a subset of the package. Sources: U.S. Census Bureau PEP, Vintage 2025; shaded relief from USGS 3DEP.

Annual population and five-year demographics

Population: Census annual estimates for 19,483 cities, with change from 2024 to 2025 and from 2020 to 2025.
Demographics: American Community Survey five-year estimates for 32,330 Census places: age, sex, income, race, households and housing, with margins of error and quality metadata.
Files: A six-sheet Excel workbook, two CSV tables and documentation.

Download sample

Live previewClose preview

Choose a file to browse every sample file and sheet.

Selected sample rows. Not a representative statistical sample.

PEP Cities: up to eight sample rows and columns. Enable JavaScript to explore other files. Key columns are shown first; the file's column order is unchanged.
name	state_name	geoid	name_source	name_short	state_fips	state_abbr	place_fips
Hardy city	Arkansas	0529920	sub_est	Hardy	05	AR	29920
Belle Glade city	Florida	1205200	sub_est	Belle Glade	12	FL	05200
Minneola city	Florida	1245900	sub_est	Minneola	12	FL	45900
Palos Park village	Illinois	1757407	sub_est	Palos Park	17	IL	57407
Mauckport town	Indiana	1847628	sub_est	Mauckport	18	IN	47628
Newton city	Kansas	2050475	sub_est	Newton	20	KS	50475
Elsmere city	Kentucky	2124778	sub_est	Elsmere	21	KY	24778
Monticello city	Minnesota	2743774	sub_est	Monticello	27	MN	43774

Read-only examples from the download. Sorting and search apply to these sample rows, not the full files.

Only in the sample download, not in the full package:

sample_manifest.json: The example dataset's selection, source references and file inventory.

Questions before you buy

What does the package cover?

19,483 cities with annual population estimates and 32,330 places with five-year demographic estimates, including Puerto Rico in the demographic table. These are different Census lists, so not every place appears in both. Their population figures are not interchangeable.

Vintage 2025, July 1, 2025 estimate: U.S. Census Bureau, Population Estimates Program
2020 to 2024 5-year estimates: U.S. Census Bureau, American Community Survey
2025: U.S. Census Bureau, Gazetteer files

Census incorporated places, consolidated cities and Census-designated places, by table. Every City in the USA is independent and not affiliated with the U.S. Census Bureau.

What's included in the download?

A six-sheet Excel workbook, two CSV tables and documentation. The demographic worksheet has 26 core columns; its CSV has 432 selected columns. Every file is listed below.

16 files. 15 are previewed in the sample above. The rest are marked Not in the sample.

market_screen.xlsx: Six-sheet Excel workbook with annual PEP population estimates, key place demographics, field definitions and coverage. Identifiers retain leading zeros.
CITATION.txt: Suggested citation for the data release.
LICENSE.txt: The approved named-release customer license included in this download.
README.md: How to use the package, its two geography universes and its source vintages.
SOURCE_LINEAGE.json: Source releases and transformation lineage for the delivered data.
acs_annotations.csv: Published annotations and open-ended value bounds.
acs_missingness.csv: Missing-value records and reasons. Missing values are not zero.
acs_places_2024_5yr.csv: Five-year demographic estimates for 32,330 Census places in this package. All 432 selected columns, including published margins of error.
acs_quality_flags.csv: Relative-margin-of-error communication flags for selected demographic fields. These thresholds are not statistical quality grades.
coverage_report.json: Published and missing-value counts for each selected field.
field_dictionary.csv: Column definitions, units, geography universes and source references in CSV format.
field_dictionary.json: The same field definitions in machine-readable JSON.
pep_cities_2025.csv: Annual population estimates for 19,483 PEP places in this package, with 2020 to 2025 history and geography identifiers.
xlsx_sanitization.csv: A record of any text transformations needed for safe Excel delivery.
SHA256SUMS: SHA-256 checksums to verify the files in the archive you downloaded.
PACKAGE_MANIFEST.json: The full package's release identity, source evidence and file inventory.Not in the sampleFull-download metadata. The example dataset includes its own sample_manifest.json instead.

Release commercial-38b14f553325d5abd23e9111

The field dictionary in each release is the authoritative column list.

How does the sample relate to the full package?

Sample rows come from the full release, with the same columns and workbook sheets. Sample documentation describes its scope and selection. The sample is for inspecting the files, not a representative statistical sample.

How should I read the numbers?

Missing values are recorded, never set to zero. American Community Survey figures retain their published margins of error. Nothing here predicts market performance. Read the methodology and source files before comparing estimates.

How is this different from the free CSV?

The population-only CSV is free. This package adds nationwide demographics, an Excel workbook, field definitions, uncertainty and missing-value documentation, and support.

Can I buy a single state?

Choose the geography you need.

How do purchase and access work?

Complete checkout. No account needed.
Open your emailed download link to access your library.
Download from your library, including corrections to your release.

One named release and its corrections. Future editions are not included.

Use of the package follows the license. Refunds follow the refund policy. Hosted redownloads follow the hosted retention policy; keep a local copy of the files you download.

Buy the package

Checking availability