Population migration derived from ACS 2011 5-year PUMS dataset

This is data release of working-age-population migration based on the ACS 2011 5-year PUMS. This article provides the same info as in my previous article Population migration derived from ACS 2011 5-year PUMS dataset.

The released spreadsheet table shows the population migration moved from each US State or foreign country into each US State, including in-state moves. It is to be emphasized that since these are based on sampling, the number is for references only. To get a sense of  possible errors, the MOE should be consulted. The spreadsheet can be accessed via Google Drive.

As an example, the spreadsheet show that, from 2007 to 2011, on average, there are about 46, 117, and 15 people per year with doctoral degree moved into Nebraska from France, China, and Jamaica respectively.

Educational Attainment of Nebraska's Working Age Population via 2011-07 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

For this data release, the working age is defined as 22 to 64, inclusive.

This is a quick release of Nebraska's data, the full data for every State will follow.

Last year I was summarizing data manually - basically, wrote database queries with a temporary mapping table that translates ACS' education attainment levels to our desired levels. This year, I formalized some features in the database and try to build queries based on those formalized features.

The Nebraska data is presented in the following table:

Ed. Attainment Level	Head Count	90% MOE	Possible Range
1. No High School Diploma	84,417	3,198	81,219 to 87,614
2. Has High School Diploma	258,046	4,404	253,641 to 262,450
3. Some College Exp. - No Degree	255,970	5,053	250,917 to 261,022
4. Associate's Degree	109,736	2,995	106,740 to 112,731
5. Bachelor's Degree	212,931	3,753	209,178 to 216,683
6. Master's Degree	59,012	2,146	56,865 to 61,158
7. First Professional Degree	17,250	1,020	16,230 to 18,269
8. Doctor's Degree	9,335	975	8,359 to 10,310

The released data can be accessed through Google drive here. The released data includes all estimates that can be used to combine different degree levels. For data related to other states, please follow this link.

Related articles: 
Nebraska Brain Drain Migration and Ed. Attainment, 2015 United States ACS 

Migration of Nebraska Working Age Population via 2011-07 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 simply a release of migration data for Nebraska working age population based on the ACS (American Community Survey) 2011-2007 5-year PUMS (Public Use Microdata Sample) data released by US Census Bureau.

Last year, after publishing the serials of articles about the population migration in the US, I re-examined what I did and spent times in revise the approach using more R codes than manually preparing and running SQL queries. This year, after comparing my R process for 2015-2011 and 2010-2006, I decide to restructure the R codes in an attempt to extract most of the common code to be shared and, hopefully, it will reduce the time spend in maintaining the code in the future. I intended to create R code to replace last year's process for education attainment too.

For this data release, the working age is defined as 22 to 64, inclusive.

Education Degree	Net (In) Migration	90% MOE	Possible Range
1. No High School Diploma	2,130	1,037.3	1092 to 3167
2. Has High School Diploma	35	1,247.1	-1213 to 1282
3. Some College Exp. - No Degree	1,501	1,493.2	7 to 2994
4. Associate's Degree	153	824.8	-672 to 977
5. Bachelor's Degree	89	1,260.9	-1172 to 1349
6. Graduate Degree	-1,733	935.0	-2669 to -798

As can be seen from the above table, for every year during that five-years period, there are, in net, estimated 1,733 people with graduate degree moved out of Nebraska. Since the number is derived from sampling, with 90% of certainty, the true number can lie between 2,669 and 798. So it is very likely (90% certainty) that Nebraska loses about 2,669 to 798 people with graduate degree every year during the five year period.

For population with bachelor degree, the net migration pattern isn't as clear cut as those with graduate degree since, with 90% certainty, the net can vary from 1,172 moving out to 1,349 moving in.


The released data file can be accessed here through Google Drive. The released data includes all weights that is needed to combine education categories if so desired. For data concerning other states, please follow this link.


Related articles: 
Nebraska Brain Drain Migration and Ed. Attainment, 2015 United States ACS