Brain Drain - 2015 ACS State Migration for Working Age
Updated on Feb. 27, 2017:
An attempt has been made to rank states by brain drain indexes based on migration. See article Brain drain - ranking and analysis with 2015 ACS data.
As will be discussed in my upcoming article about various possible conception/perceptions about the idea of 'brain' in the context of 'brain drain', one of the definition or interpretation would be the education attainment of the workforce, hence, the age range of 22 to 64 years old.
As mentioned in my previous article: Population migration derived from ACS 2015 5-year PUMS dataset, I was in the process of producing a more detailed result from the ACS 2015 5-year PUMS dataset and here it is. For this article, we ignored the in-migration from foreign counties, which was included in the previous article. Time allowed, we will look into foreign country migration in details.
Basically, we look at all samples with age between 22 and 64 years old in the PUMS file along with each sample's education attainment level and the state of residing a year ago. By analyzing these data, we can estimate the number of people moving in and out of a state and with what kind of education attainment level.
It happened that I was attending a Tableau promotion meeting recently and decided to give it a try even though I would have preferred an open source solution, which I did try to look up, but did not have enough time to evaluate them yet.
The rest of this article will simply provide notes to the presentation since I have the baggage of an old IT worker that abbreviates almost everything.
First, the cite of the data source: ACS 2015-2011 5-year PUMS file processed by Dr. Duncan Hsu.
The Brain Drain Migration between states presentation can be found at Tableau Public and below are some of the summaries:
The first tab/page/slide, "Map - Migrated to To_State", is the in-migration map for the state of interest specified by the right-hand side dropdown control: the To_State. The map will show the number of people moving from each state to the To_State, with the education attainment level you specified by the second dropdown list labeled EdAttnmnt. To see the numbers, hover your mouse above a state of interest. For example, the following chart show that there were 724 people moved from Kansas to Nebraska, which was selected as the 'To_State'. Possible values for the EdAttnmnet dropdown are: Less than High School Degree (LssHsDgr), High School Degree or Equivalent (HsDgrEqv), Some College Experience/Course-work but no degree (SomeCllg), Associate Degree (AssctDgr), Bachelor Degree (BchlrDgr), Master Degree (Mstr), First Professional Degree (FP), and Doctor's Degree (Drs).
The second tab, "Map - Migrated out From_State", is the out-migration map for the state of interest. Operational wise, this is very similar to the first tab. In the map below, it shows that there were 421 people migrated to Iowa from Nebraska, which was selected as the 'From_State'.
The third tab, "Map - Net migration", shows the net migration. By hover over each state, it shows three numbers, the HdCnt (head count; negative for out-migration and positive for in-migration) and the upper and lower bound for the 90% confidence level. The dropdown to the right displays 6 education attainment levels with the Graduates (Grdts) encompassing Master, First Professional, and Doctor's degree.
The fourth tab, is the net migration bar chart for each state where the bar indicated the Margin of Error (MOE) at the 90% confidence level. Again, dropdowns are on the right.
The fifth tab provides the data used in the fourth tab in table format with the upper and lower bound of the 90% MOE.
The Sixth tab allows selecting states with the map.
An attempt has been made to rank states by brain drain indexes based on migration. See article Brain drain - ranking and analysis with 2015 ACS data.
As will be discussed in my upcoming article about various possible conception/perceptions about the idea of 'brain' in the context of 'brain drain', one of the definition or interpretation would be the education attainment of the workforce, hence, the age range of 22 to 64 years old.
As mentioned in my previous article: Population migration derived from ACS 2015 5-year PUMS dataset, I was in the process of producing a more detailed result from the ACS 2015 5-year PUMS dataset and here it is. For this article, we ignored the in-migration from foreign counties, which was included in the previous article. Time allowed, we will look into foreign country migration in details.
Basically, we look at all samples with age between 22 and 64 years old in the PUMS file along with each sample's education attainment level and the state of residing a year ago. By analyzing these data, we can estimate the number of people moving in and out of a state and with what kind of education attainment level.
It happened that I was attending a Tableau promotion meeting recently and decided to give it a try even though I would have preferred an open source solution, which I did try to look up, but did not have enough time to evaluate them yet.
The rest of this article will simply provide notes to the presentation since I have the baggage of an old IT worker that abbreviates almost everything.
First, the cite of the data source: ACS 2015-2011 5-year PUMS file processed by Dr. Duncan Hsu.
The Brain Drain Migration between states presentation can be found at Tableau Public and below are some of the summaries:
The first tab/page/slide, "Map - Migrated to To_State", is the in-migration map for the state of interest specified by the right-hand side dropdown control: the To_State. The map will show the number of people moving from each state to the To_State, with the education attainment level you specified by the second dropdown list labeled EdAttnmnt. To see the numbers, hover your mouse above a state of interest. For example, the following chart show that there were 724 people moved from Kansas to Nebraska, which was selected as the 'To_State'. Possible values for the EdAttnmnet dropdown are: Less than High School Degree (LssHsDgr), High School Degree or Equivalent (HsDgrEqv), Some College Experience/Course-work but no degree (SomeCllg), Associate Degree (AssctDgr), Bachelor Degree (BchlrDgr), Master Degree (Mstr), First Professional Degree (FP), and Doctor's Degree (Drs).
 |
| In-Migration to Nebraska |
The second tab, "Map - Migrated out From_State", is the out-migration map for the state of interest. Operational wise, this is very similar to the first tab. In the map below, it shows that there were 421 people migrated to Iowa from Nebraska, which was selected as the 'From_State'.
 |
| Out-Migration from Nebraska |
The third tab, "Map - Net migration", shows the net migration. By hover over each state, it shows three numbers, the HdCnt (head count; negative for out-migration and positive for in-migration) and the upper and lower bound for the 90% confidence level. The dropdown to the right displays 6 education attainment levels with the Graduates (Grdts) encompassing Master, First Professional, and Doctor's degree.
 |
| Net-Migration for Nebraska |
The fourth tab, is the net migration bar chart for each state where the bar indicated the Margin of Error (MOE) at the 90% confidence level. Again, dropdowns are on the right.
 |
| Net-Migration with 90% MOE |
The fifth tab provides the data used in the fourth tab in table format with the upper and lower bound of the 90% MOE.
 |
| Net-Migration for Nebraska's neighboring states |
The Sixth tab allows selecting states with the map.
 |
| Selecting States with Map |
Labels: 2015, ACS, attainment, brain drain, Census, education, migration, open source, PUMS, Tableau
posted by Duncan @ 5:45 AM
0 Comments
