Tax Migration Data: Difference between revisions
From charlesreid1
| Line 11: | Line 11: | ||
==Data Files== | ==Data Files== | ||
===State to State | ===State to State Outflow=== | ||
The data sets | The data sets provide a CSV file for state to state outflow. The headers in these CSV files look like this: | ||
The headers in these CSV files look like this: | |||
<pre> | <pre> | ||
| Line 30: | Line 28: | ||
01,48,TX,Texas,3602,7789,203940 | 01,48,TX,Texas,3602,7789,203940 | ||
</pre> | </pre> | ||
The documentation section E1 covers this data set: | |||
{{Quote| | |||
The state to state outflow migration files represent the migration flows from the origin state in year 1 to the destination state in year 2. There are 51 files for each state plus the D of C. Included inthe list of outflow states are the number of returns that migrated to a foreign location. Each file tabulates the number of returns, number of exemptions, and adjusted gross income (AGI). | |||
Each state outflow records file contains five header records that show (1) the total US and foreign out-migration for that state, (2) the total US out-migration, (3) the total foreign out-migration, and (4) the total same state migration for that state, and (5) the total non-migrants. | |||
}} | |||
Naming convention: stateoutflow1516.csv covers years 2015 and 2016. | |||
Columns are as follows: | |||
* y1 state fips - state fips code of origin from year 1 | |||
* y2 state fips - state fips code of destination from year 2 | |||
* y2 state - state abbrev or postal code | |||
* y2 state name - name of state | |||
* n1 - number of returns | |||
* n2 - number of exemptions | |||
* agi - adjusted gross income | |||
===State to State Inflow=== | |||
Similar to the outflow file - the inflow file shows data about inflow migration patterns into a given state. | |||
Inflow record columns are as follows: | |||
* y2 state fips - state fips code of destination from year 2 | |||
* y1 state fips - state fips code of origin from year 1 | |||
* y1 state - abbreviation or postal code of origin from year 1 | |||
* y1 state name - state name of origin from year 1 | |||
* n1 - number of returns | |||
* n2 - number of exemptions | |||
* agi - adjusted gross income | |||
===County to County Inflow/Outflow=== | ===County to County Inflow/Outflow=== | ||
Revision as of 03:45, 26 February 2018
SOI Tax Stats: migration data: https://www.irs.gov/statistics/soi-tax-stats-migration-data
Referenced by the folks at CensusReporter.org
What is it?
The data that's given is migration data for individuals moving between states. There are data provided going back to 2011.
There is a detailed guide to this data set here: https://www.irs.gov/pub/irs-soi/1516inpublicmigdoc.pdf
Data Files
State to State Outflow
The data sets provide a CSV file for state to state outflow. The headers in these CSV files look like this:
$ head -n10 stateoutflow1516.csv y1_statefips,y2_statefips,y2_state,y2_state_name,n1,n2,AGI 01,96,AL,AL Total Migration-US and Foreign,44461,89926,2507957 01,97,AL,AL Total Migration-US,43638,88139,2460974 01,98,AL,AL Total Migration-Foreign,823,1787,46982 01,97,AL,AL Total Migration-Same State,56323,115151,2486684 01,01,AL,AL Non-migrants,1586719,3527365,98693046 01,13,GA,Georgia,8103,16268,379251 01,12,FL,Florida,6493,12760,398129 01,47,TN,Tennessee,4043,7929,273599 01,48,TX,Texas,3602,7789,203940
The documentation section E1 covers this data set:
The state to state outflow migration files represent the migration flows from the origin state in year 1 to the destination state in year 2. There are 51 files for each state plus the D of C. Included inthe list of outflow states are the number of returns that migrated to a foreign location. Each file tabulates the number of returns, number of exemptions, and adjusted gross income (AGI).Each state outflow records file contains five header records that show (1) the total US and foreign out-migration for that state, (2) the total US out-migration, (3) the total foreign out-migration, and (4) the total same state migration for that state, and (5) the total non-migrants.
Naming convention: stateoutflow1516.csv covers years 2015 and 2016.
Columns are as follows:
- y1 state fips - state fips code of origin from year 1
- y2 state fips - state fips code of destination from year 2
- y2 state - state abbrev or postal code
- y2 state name - name of state
- n1 - number of returns
- n2 - number of exemptions
- agi - adjusted gross income
State to State Inflow
Similar to the outflow file - the inflow file shows data about inflow migration patterns into a given state.
Inflow record columns are as follows:
- y2 state fips - state fips code of destination from year 2
- y1 state fips - state fips code of origin from year 1
- y1 state - abbreviation or postal code of origin from year 1
- y1 state name - state name of origin from year 1
- n1 - number of returns
- n2 - number of exemptions
- agi - adjusted gross income
County to County Inflow/Outflow
$ head -n10 countyoutflow1516.csv y1_statefips,y1_countyfips,y2_statefips,y2_countyfips,y2_state,y2_countyname,n1,n2,agi 01,000,96,000,AL,Total Migration-US and Foreign,100784,205077,4994641 01,000,97,000,AL,Total Migration-US,99961,203290,4947658 01,000,97,001,AL,Total Migration-Same State,56323,115151,2486684 01,000,97,003,AL,Total Migration-Different State,43638,88139,2460974 01,000,98,000,AL,Total Migration-Foreign,823,1787,46982 01,001,96,000,AL,Autauga County Total Migration-US and Foreign,1677,3928,88748 01,001,97,000,AL,Autauga County Total Migration-US,1652,3855,86815 01,001,97,001,AL,Autauga County Total Migration-Same State,1081,2293,50574 01,001,97,003,AL,Autauga County Total Migration-Different State,571,1562,36241
Gross Migration File
The gross
The columns in the CSV files look like this: