Thanks Matthew for the prompt reply.
I realize that MET2013 won’t cover all PUMAs, but since I am only interested in large MSA’s I think this should be fine. I will makes sure to use the crosswalk and error sheets to understand the limitations.
And yes the NSFG restricted access files contain State and County FIPS codes. IPUMS USA contains the variables [STATEFIP] and [COUNTYFIP] which will be used to link to the NSFG. And then linked to MSA via MET2013.
I first looked at American Fact Finder hoping to be able to get the summary data I needed at the MSA level without needing to extract microdata. But the measures I need are not available.
I am using the National Survey of Family Growth (NSFG) to looks at trends in Hispanic fertility and reproductive behaviors from 2006-2017. To account for the impact of the Great Recession I will be merging NSFG individual-level data with MSA-level data from the ACS.
To be able to look at the area-level economic conditions of the MSA’s women lived in at the time they were interviewed I need to create the MSA-level measures listed in the table below. These will then be merged to NSFG individual-level data using restricted geocode variables by NSFG staff. I have looked within American Fact Finder and IPUMS and was not able to find an easy way to create the measures below for each of the MSA’s for 6 different time periods. So I extracted data from the IPUMS USA and I am now trying to figure out the most efficient way to create these measures. And would appreciate any tips/suggestions. Most of my work and research has been quantitative so I am moving slowly and need to get this to them ASAP.
Period 1 (2006-2007)
Period 2 (2008)
Period 3 (2009-2010)
Period 4 (2011-2013)
Period 5 (2013-2015)
Period 6 (2015-2017)
These are some of the measures I need to create:
|Women of reproductive age (15-44 years old)||
|Hispanic women of reproductive age (15-44 years old)||
|Proportion of population that is Hispanic or Latino|Population of Hispanic/Total Population|
|Proportion of population that is foreign-born Hispanic or Latino |Population that is Hispanic foreign born (calculated from place of birth)/Total Hispanic Population|
|Proportion of Hispanic foreign-born population that entered the US: less than 5/5-10/or more than 10 years ago |Population of Hispanic foreign-born who entered the US X years ago/All Hispanic foreign-born population|
|Median Household Income |The median divides the income distribution into two equal parts: one-half of the cases falling below the median income and one-half above the median. For households and families, the median income is based on the distribution of the total number of households and families including those with no income. |
|Median household income of households with householder Hispanic or Latino |Same as above but among households with householder Hispanic or Latino |
|Proportion of population with income below poverty level |Population with income below poverty level/total population |
|Proportion of population Hispanic or Latino with income below poverty level |Hispanic Population with income below poverty level/total Hispanic population|
|Proportion of households that received Food Stamp/SNAP benefits |Number of households that received Food Stamp/SNAP benefits÷total number of households |
|Employment/Population Ratio|Percentage of all working-age civilians who are employed |
|Labor Force Participation Rate |Proportion of the population that is in the labor force|
|Unemployment rate for total population|Number of unemployed persons divided by the labor force|
|Unemployment rate for population Hispanic or Latino|Number of unemployed Hispanic persons divided by the Hispanic labor force|
|Proportion of employed civilians aged 16+ employed in construction|Employed civilians aged 16+ employed in construction/All employed civilians aged 16+|
|Fertility|Aggregate number of women who had a birth in the past 12 months in a specified category, per 1,000- women to calculate Total Fertility Rate |
|Health Insurance coverage |Aggregate of dichotomous series of questions about 8 types of health insurance coverage|
Thanks!