Public Transportation Fact Book Appendix C - Urbanized Area Population Comparison

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

Wide comparison table for urbanized-area population, density, land area, and growth measures from APTA Fact Book Appendix C. One row is an urbanized area with side-by-side decennial census fields from 1950 through 2010; the profile contains 544 rows and many optional historical columns are null for areas not yet delineated in earlier censuses.

american-public-transportation-association-factbook-c-uza-population-comparison·39 columns·138 KB·APTA statistical publication reuse terms / site copyright notice·updated 2d ago

Source: American Public Transportation Association · connector code

Schema

2010_urbanized_area_name	string
2010_population	int64
2010_land_area_square_miles	double
2010_density_persons_per_square_mile	double
2000_urbanized_area_name	string
2000_population	int64
2000_land_area_square_miles	double
2000_density_persons_per_square_mile	double
1990_urbanized_area_name	string
1990_population	int64
1990_land_area_square_miles	double
1990_density_persons_per_square_mile	double
1980_urbanized_area_name	string
1980_population	int64
1980_land_area_square_miles	double
1980_density_persons_per_square_mile	double
1970_urbanized_area_name_urbanized_areas_with_asterisk_were_delineated_in_1974	string
1970_population	int64
1970_land_area_square_miles	double
1970_density_persons_per_square_mile	double
1960_urbanized_area_name	string
1960_population	int64
1960_land_area_square_miles	double
1960_density_persons_per_square_mile	double
1950_urbanized_area_name	string
1950_population	int64
1950_land_area_square_miles	double
1950_density_persons_per_square_mile	double
primary_state	string
secondary_state	string
third_state	string
fourth_state	string
2000_2010	string
1990_2000	string
1980_1990	string
1970_1980	string
1960_1970	string
1950_1960	string
1950_2010	double

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-comparison\" 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.