I'm finally starting to run tabulations from the new 5 year file ...

John Grumbine over 8 years ago

I've uploaded (to the PUMS group) 3 tabulations from the 2010-2014 PUMS file as follows: In the first (MergedMigration), there was a need to see where people were moving to/from based on age. The problem here is that in the 5 year file there are two vintages of Migsp. In creating this I merged the two vintages (migsp05 and migsp12) into a new dimension called Migsp, which is a lot easier to use, but caution must be applied for those who are affected by the differences in the vintages. E.g. if you are interested in people who came from Israel, realize that Israel was only specified in the migsp05 item, and will appear underrepresented in this tabulation, because some of the people from Israel will be rolled into another category for the data that uses migsp12. If you are only interested in the US States, there are no differences between the two, and the custom migsp dimension can be used comfortably.

In the second (IntroFields), I'm introducing two new data items. The first (ResHBCty) labels everyone who lives in Hillsborough County, FL as “Yes”, and labels everyone else as “No”. The second (MigHBCty) labels everyone who migrated from Hillsborough County, FL as “Mig From HB”, people who migrated from somewhere else as “Mig Other”, and people who did not migrate as “No Mig”. By cross-referencing these two variables we can see some interesting facts, such as about 71,000 people moved out of the county, 81,000 people moved into the county, and 148,000 people moved from one part of the county to another. I also added a volume of personal income, so we can see that the people who moved into the county made about $1.9 billion, while the people who moved out made about $1.6 billion.

The third tabulation is the same as the first, except that the two new dimensions have been added to it to allow “zooming in” on the people moving to/from/within Hillsborough county without losing any of the other detail.

If anyone is interested in validating these tabulations, and you would like to have the serial numbers and person numbers that went into a particular cell (hopefully a small one!) let me know and I'll send them to you.

– John Grumbine

Parents

John Grumbine over 8 years ago

Hi Robin,

The 0-17 group and the 18-34 (which I think is what you were most interested in?) are also in there, e.g. if you look at lines 13,389 to 13,425 you'll see people who live in households where the reference person is 18-34, has at least 1 person who migrated from Hillsborough Cty, FL, and the household is in Hillsborough Cty, FL. One artifact of creating a 7 dimensional tabulation is that you get a lot of lines, which is why I collapsed the age groups from the previous tabulation.

The data is sorted by the categorizations from left to right, which makes 4 'pockets' of 18-34 data in the person level section that correspond to lines 3, 6, 8, and 11 in the household level section. So each of those 'pockets' shows migration of people who made the household income that is aggregated in the top section. The 26,615 millennial households in line 11 (household level) made 1.28 billion dollars, and the migration of the people who live in the households are described in lines 13,389-13,425. You can see that the vast majority of them migrated from FL - 58,942 from Hillsborough County (line 13,426) and 2,728 from other parts of FL (line 13,393) and 9,823 stayed in their previous Hillsborough County homes (line 13,389). That last group is in the 'migrated household' category because someone in their household migrated into their house, though they themselves did not. (and there are 3 other 'pockets' of 18-34 data in the person section - I haven't really looked at them, but they probably have some interesting facts).

There is a lot of documentation on PUMS ... there was a recorded introductory webinar a month or so ago that may now be on youtube - I attended & thought it was well worthwhile. This document lists data items that are available: www2.census.gov/.../PUMS_Data_Dictionary_2010-2014.pdf, and I use it daily.

- John Grumbine
[Updated on 3/23/2016 11:35 AM]

[Updated on 3/23/2016 11:40 AM]
Cancel
Up 0 Down

Reply

Cancel

Reply

John Grumbine over 8 years ago

Hi Robin,

The 0-17 group and the 18-34 (which I think is what you were most interested in?) are also in there, e.g. if you look at lines 13,389 to 13,425 you'll see people who live in households where the reference person is 18-34, has at least 1 person who migrated from Hillsborough Cty, FL, and the household is in Hillsborough Cty, FL. One artifact of creating a 7 dimensional tabulation is that you get a lot of lines, which is why I collapsed the age groups from the previous tabulation.

The data is sorted by the categorizations from left to right, which makes 4 'pockets' of 18-34 data in the person level section that correspond to lines 3, 6, 8, and 11 in the household level section. So each of those 'pockets' shows migration of people who made the household income that is aggregated in the top section. The 26,615 millennial households in line 11 (household level) made 1.28 billion dollars, and the migration of the people who live in the households are described in lines 13,389-13,425. You can see that the vast majority of them migrated from FL - 58,942 from Hillsborough County (line 13,426) and 2,728 from other parts of FL (line 13,393) and 9,823 stayed in their previous Hillsborough County homes (line 13,389). That last group is in the 'migrated household' category because someone in their household migrated into their house, though they themselves did not. (and there are 3 other 'pockets' of 18-34 data in the person section - I haven't really looked at them, but they probably have some interesting facts).

There is a lot of documentation on PUMS ... there was a recorded introductory webinar a month or so ago that may now be on youtube - I attended & thought it was well worthwhile. This document lists data items that are available: www2.census.gov/.../PUMS_Data_Dictionary_2010-2014.pdf, and I use it daily.

- John Grumbine
[Updated on 3/23/2016 11:35 AM]

[Updated on 3/23/2016 11:40 AM]
Cancel
Up 0 Down

Reply

Cancel

Children

No Data