Skip to the content.

Data Sources — state-migration

All data used in this project is from authoritative sources. Crowd-edited references (Wikipedia, etc.) are not used as primary sources.

Document every data source here before ingesting it. Include enough detail that someone else could independently locate and verify the original data.


Source Template

Copy and fill in for each source. The How the source collects the data, How the source defines the data, and Methodology changes / series breaks sections are required — they are what keep our analysis honest and prevent apples-to-oranges comparisons.

[Source Name]


Sources

IRS Statistics of Income (SOI) — State-to-State Migration Data

IRS Statistics of Income (SOI) — County-to-County Migration Data

Census Bureau — ACS State-to-State Migration Flows


Column Glossary

Definitions for the fields used across the raw sources and the prepared migration_flows / nonmigrants tables.

IRS SOI raw fields

Census ACS raw fields

Prepared migration_flows fields

Prepared nonmigrants fields

Prepared county_migration_flows fields

Prepared county_nonmigrants / county_income_class fields


Notes on Data Quality

Series breaks & comparability (read before any multi-year comparison)


Source Provenance in DuckDB

Every table in data/project.duckdb has a corresponding entry in the _sources metadata table:

SELECT duckdb_table, source_name, methodology, series_breaks FROM _sources;

Alongside source_name, url, license, notes, retrieved, the table carries methodology (how the source collects/defines the data) and series_breaks (the IRS 2011–12 / 2022–23 breaks and the ACS 2020 gap), so provenance travels with the data. Keep these in sync with the per-source sections above.