I’m trying to pull the number of people who have moved from NY to TX and TX to NY according to the 2020 1-year ACS. Here is my query:
Variables included:
- STATEFIP
- COUNTYFIP
- MIGPLAC1
Cases selected:
- STATEFIP (TX and NY)
- MIGPLAC1 (TX and NY)
When I groupby STATEFIP and MIGPLAC1 while summing PERWT I get the following results:
- TX > TX = 6,840,031
- TX > NY = 40,231
- NY > NY = 3,071,512
- NY > TX = 22,846
Because the totals for each origin state do not add up to the total population for that state, I wanted to be sure I’m reading these results correctly.
- TX > TX = 6,840,031 = 6.8 million Texas residents moved to a different part of Texas in the last year
- TX > NY = 40,231 = 40k Texas residents moved to NY in the last year
- NY > NY = 3,071,512 = 3.1 million New York residents moved to a different part of New York in the last year
- NY > TX = 22,846 = 23k NY residents moved to Texas in the last year
I also wanted to clarify that the reason so many Texas and NY residents are missing from these data is that most residents didn’t move between counties or states last year?
Thank you!