Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
11-29-2017 13:18 PM
For each of the fifty states and the District of Columbia, the IRS Statistics of Income (SOI) provide data on the number of tax returns filed in that state, the number of tax exemptions taken on those returns, and the amount of adjusted gross income declared on those returns.
The SOI provide data on the outflow of tax filers from each state to all other states and on the inflow of tax filers to each state from all other states. The number of tax returns was relabeled “households,” as the number of tax returns moving between states very closely approximates the number of moving households. Note that for tax purposes, two spouses in a married couple who file separately are considered distinct households.
The net values in these visuals were calculated by subtracting each outflow measure from each inflow measure for each state pair for each year.
For example: the net migration of taxable income between California and all other states for 2014-15 was calculated by subtracting California’s outflow of adjusted gross income to all other states from California’s inflow of adjusted gross income from all other states. The resulting negative value indicates that more money flowed from California to all other states than vice-versa in the 2014-15 tax year.
California Inflow from other states: $1,166,914,145,000 in Adjustable Gross Income
California Outflow to other states: $1,168,927,588,000 in Adjustable Gross Income
California Net Migration to other states = Inflow – Outflow = $1,166,914,145,000 - $1,168,927,588,000 = -$2,013,443,000
Related report:
More information:
eyJrIjoiMzJjMDk4MzgtMmY0ZS00YTliLWJjZDYtMjdlY2FhYmFhZTNkIiwidCI6IjU5ZWE3YmI0LTYxYTAtNGE0Mi1iMmU0LTJhYmU4NmY0YzdjOSIsImMiOjZ9
This is a great chart. I am wondering if you could share the .pbix file or the data set. my email is: Andrew.Anh.Dang@gmail.com
Thanks;
Andrew
I attached the dataset, or it can be downloaded from here (https://usafacts.org/reports/interstate-population-migration).
Sorry for the late response.
John