Public Transportation Fact Book Appendix C - Urbanized Area Population by Census Year

Name: Public Transportation Fact Book Appendix C - Urbanized Area Population by Census Year
Creator: American Public Transportation Association
License: APTA statistical publication reuse terms / site copyright notice

Decennial census population reference table for urbanized areas from APTA Fact Book Appendix C. One row is an urbanized area and census year with population, land area, and density fields; a verification query found 4,800 rows for 794 areas covering census years 1950 through 2010.

american-public-transportation-association-factbook-c-uza-population-by-census-year·9 columns·83 KB·APTA statistical publication reuse terms / site copyright notice·updated 17d ago

Source: American Public Transportation Association · connector code

Schema

census_year	int32
urbanized_area	string
population	int64
land_area_sq_mi	double
density_per_sq_mi	double
primary_state	string
secondary_state	string
third_state	string
fourth_state	string

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small   # or medium, or large
subsets serve   # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →

Bash

subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"american-public-transportation-association-factbook-c-uza-population-by-census-year\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.