New York State - In-migration
From the "New York (all counties)" tab of the spreadsheet, calculate how many people moved to all New York counties (i.e., the total state) from other US states and overseas. Specifically, remove anyone who simply moved from one NY county to another to calculate how many people moved to the NY state from (1) other US states and (2) abroad. Also, provide another 'total' table in an additional tab.
New York State — Total Inflow (2013-2017)
- In-migration data for New York state is presented in the "NY State (all counties)" tab of the shared spreadsheet.
- After carefully sifting through the entire dataset in this tab (over 14,000 rows), we have removed thousands of entries (over 3,000 rows) where people moved from one NY state county to another NY state county.
- An analysis of the data thus obtained indicate that a total of 417,953 people moved to NY state from all other US states and abroad.
- To provide a breakdown of migrants (US states vs abroad), we started calculating the number of overseas migrants by county but were unable to complete the calculations for all counties due to the shortage of time.
Proposed next steps:
You need to be the project owner to select a next step.
In this round of research, we were able to remove all entries where people moved from one NY county to another. We were also able to find the total number of people who moved to NY state from other US states and abroad. We now recommend continuing with research to provide the breakdown of migrants to NY state from all other US states vs other countries from the refined dataset in a separate totals table. We will include the number of migrants from "Puerto Rico" in the abroad migrants category, unless otherwise instructed.
Alternatively, we suggest finding the number of people who move to NY state from other US states vs abroad from published reports and articles.