Educational Attainment of Nebraska's Working Age Population via 2016-12 ACS PUMS

20180504 Update: This is a data set that is prepared explicitly for Nebraska Coordinating Commission for Postsecondary Education (Nebraska CCPE) so that they can proceed with their 2018 Progress Report. The reason for this note is  to increase the chance so people can find the data because CCPE refused to cite this web article as the source of the data


This is a data release for Nebraska's working age population.  The working age is defined as 22 to 64 inclusive. The data is based on the PUMS (Public Use Micro Sample) data released by the US Census' American Community Survey.

The table below presented the number of people with various educational attainment with the age between 22 and 64.

Ed. Attainment	Population	Low(90%MOE)	Hi(90%MOE)	Percent
1. LssHsDgr	87,691	85,034	90,348	8.5%
2. HsDgrEqv	241,063	236,468	245,658	23.4%
3. SomeCllg	250,798	245,393	256,203	24.4%
4. AssctDgr	116,124	112,680	119,568	11.3%
5. BchlrDgr	234,181	228,870	239,492	22.7%
6. Mstr	71,874	69,336	74,412	7.0%
7. FP	16,806	15,641	17,971	1.6%
8. Drs	11,309	10,230	12,388	1.1%

Detailed data with sampling weights can be download from here located in Google Drive. The weights can allow users to aggregate the presented educational attainment levels.

Migration of Nebraska Working Age Population via 2016-12 ACS PUMS

20180504 Update: This is a data set that is prepared explicitly for Nebraska Coordinating Commission for Postsecondary Education (Nebraska CCPE) so that they can proceed with their 2018 Progress Report. The reason for this note is  to increase the chance so people can find the data because CCPE refused to cite this web article as the source of the data

This is a data release concerning Nebraska's working age population. The working age is defined as 22 to 64 years old, inclusive.

The table below shows the estimated net number of people that moved into Nebraska per year between 2012 and 2016 with age between 22 and 64.

Ed. Attainment	Net (In) Migration	Low(90%MOE)	Hi(90%MOE)
1. No HS Dgr	-203	-1056	650
2. HS Graduated	447	-680	1574
3. Some College	294	-1111	1699
4. Associate Dgr	366	-545	1277
5. Bachelor Dgr	-953	-2253	347
6. Graduate Dgr	-637	-1547	273

* 20180124 Number verified.
Detailed data with sampling weights can be download from Google drive at here.


.

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).

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