Transcript Session II: Scouting Economic and

Data Available in the RDC
Katie Genadek, PhD
RMRDC Administrator
University of Colorado
[email protected]
IBS Room 423
Types of Restricted Data Available
• Economic Data
• Demographic Data
• Linked Data
Economic data available in RDCs
• Microdata that is not available elsewhere
• Detailed geographies and industries
• Data linked over time
• Employee and employer linked data
• Full business register for the US
• Can link own data to individual businesses
Economic Data Advantages
Establishment and firm level characteristics
• Detailed industry and geography
• Addresses, newer data had latitude and longitude
Linking Data
• Consistent identifiers
• Business register
• Outside data
Types of Economic data available in RDCs
• Business Register
• Firm Surveys
• Establishment Surveys
• Economic Censuses
• Transaction or Trade data
Business Register Data
Data Set
Compustat-SSEL Bridge (CSB)
Form 5500 Bridge File
Integrated Longitudinal Business Database (ILBD)
Longitudinal Business Database (LBD)
Ownership Change Database (OCD)
Standard Statistical Establishment List / Business Register (SSEL)
Firm Surveys
Data Set
Annual Capital Expenditures Survey (ACES)
Annual Retail Trade Survey (ARTS)
Business Expenditures Survey (BES)
Business Research & Development and Innovation Survey (BRDIS)
Enterprise Summary Report (ESR)
Exporter Database (EDB)
Quarterly Financial Report (QFR)
Service Annual Survey (SAS)
Survey of Business Owners (SBO)
Survey of Industrial Research and Development (SIRD)
Establishment Surveys
Data Set
Annual Survey of Manufacturers (ASM)
Current Industrial Reports (CIR)
Manufacturing Energy Consumption Survey (MECS)
Medical Expenditure Panel Survey – Insurance Component (MEPS-IC)
National Employer Survey (NES)
Quarterly Survey of Plant Capacity Utilization (QPC)
Survey of Manufacturing Technology (SMT)
Survey of Plant Capacity Utilization (PCU)
Survey of Pollution Abatement Costs and Expenditures (PACE)
Economic Censuses
Data Set
Census of Auxiliaries (AUX)
Census of Construction Industries (CCN)
Census of Finance, Insurance, Real Estate (CFI)
Census of Manufacturers (CMF)
Census of Mining (CMI)
Census of Retail Trade (CRT)
Census of Services (CSR)
Census of Transportation, Communications, Utilities (CUT)
Census of Wholesale Trade (CWH)
Transactions Data
Data Set
Commodity Flow Survey (CFS)
Foreign Trade Data - Export (EXP)
Foreign Trade Data - Import (IMP)
Longitudinal Foreign Trade Transactions Data (LFTTD)
Linked Employer Household Dynamics (LEHD)
LEHD data combine administrative data from states’
Unemployment Insurance systems with Census Bureau data.
Workers: Employer history and quarterly wages, Individual characteristics
(sex, age, race), Point in time residence and place of birth
Employers: Industry, employment, total payroll, location
Linkages between workers and employers
Links to other Census data: Virtually any RDC data on businesses; SIPP;
CPS March supplement; ACS
Mining, Oil and Gas Data in the RDC
• Census of Mineral Industries
• Every 5 years, 2012
• Information:
https://www.census.gov/econ/www/mi0100.html
• Forms: https://bhs.econ.census.gov/ec12/mi-21/mi21_form_default.html
Related data in the RDC
• Census of Transportation, Communications, and Utilities
• Every 5 years, last 2012
• Pollution Abatement Costs and Expenditures Survey (PACE)
• Sponsored by CB and EPA
• Various years, last 2005
• Manufacturing Energy Consumption Survey (MECS)
• Sponsored by Energy Information Administration
• Various years, last 2010
Examples of research using business data
• Environmental regulation and productivity: evidence
from oil refineries
• E Berman, LTM Bui - Review of Economics and Statistics, 2001
• Industrial Investments in Energy Efficiency: A Good
Idea?
• Mary Jialin Li – CES Working Paper 2017
• State Taxation and the Reallocation of Business
Activity: Evidence from Establishment-Level Data
• Xavier Giroud & Joshua Rauh – CES Working Paper 2017
Census Data: Demographic data available in
RDCs
• More geographic detail
• Additional variables
• More observations
• Variables not censored (income)
• Additional detail within variables
Data Available
• Decennial Censuses
• Yearly ACS (American Community Survey)
• Current Population Survey Supplements
• American Housing Survey
• Survey of Income and Program Participation
• National Crime Victimization Survey
• National Longitudinal Mortality Study
• National Longitudinal Surveys (NLS)
Data Available
• Decennial Censuses
• 1950-2010 full count long and short form census data (mostly)
• Household and individual level demographic, socio-economic,
program participation, education, household characteristics, etc
• Yearly ACS (American Community Survey)
• 2006 – 2015 (full), 2000-2005 (small, no GQ), 1996-1999 (limited)
• 1.5% of US population
• Long form from 2000 decennial + a few extra questions
Data Available
• Current Population Survey Supplements
• ASEC (Annual Social and Economic Supplement) or March 1967-2015
• Fertility Supplement (1998-2012), Food Security (2001-2012), School
enrollment (2004-2014), Tobacco Use (1998-2011), Unbanked (20092013), Volunteer (2002-2015), Voter Reg (1998-2012)
• American Housing Survey
• Some years from 1984-2015; ~50,000 households per year
• Core questions: Home condition, occupant characteristics, home
improvements, housing costs, home values, characteristics of recent
movers, etc
• Topical questions vary by year
Data Available
• Survey of Income and Program Participation
• 2-4 year household panels; interviews ~every 4 months; 19842014; 14,000 to 52,000 households each wave
• Core: labor force, income dynamics, government transfers
• Topical modules vary
• National Crime Victimization Survey
• Yearly 2006-2014; ~90,000 households
• Non-fatal and property crimes, reported and unreported;
demographic information for respondent; demographic
information of perpetrator, exp with CJ system
Data Available
• National Longitudinal Mortality Study
• CPS-ASEC data linked to national death index
• CPS cohorts 1973-1998
• National Longitudinal Survey (NLS)
• Original cohorts (1966, 1968)
• Labor market, demographic, and other data collected over
20 years
• ~5,000 respondents per cohort
More information
• https://www.census.gov/ces/dataproducts/demographicdat
a.html
• Public data and metadata
Linking to Demographic Data
• Link data by geographic area to demographic and survey data
• Local data
• Survey data
• Proprietary data
• Linked data within the RDC
Detailed Geography
Data Set
Geography
Decennial Census
Block
American Community Survey (ACS)
Block
Survey of Income and Program Participation
(SIPP)
Tract
Current Population Survey* (CPS) – ASEC
Supplement & Food Supplement
Tract
American Housing Survey (AHS)
Tract
National Longitudinal Survey (NLS) –
Young/Mature Women
Lat/Lon
Block Group
National Longitudinal Survey (NLS) – Young/Old
Men
County
National Longitudinal Mortality Study (NLMS)
County
Person Identification Keys (PIKs)
• 9 digit, unique identifiers called Protected Identification Keys
(PIKs) via probabilistic matching techniques to surveys and
decennial data
• PIKs are used to facilitate record linkage
• Once ‘PIKed,” data can be linked to any other data with PIKS
• Some data is PIKed and linked already
Current RDC projects of interest – Census
Data
• Interracial couples and children’s race – how are they
reported, how does that change over time
• The effects of 1960 individual housing conditions on
urban renewal
Current RDC projects using linked data
• Linking 2010, 2000 full count census to asses race
response changes and how is racial identity influenced
by neighborhood characteristics
• Migration and duration of international student
graduates (NSCG merged to ACS data)
Useful Websites
• Census Bureau Data: Center for Economic Studies
http://www.census.gov/ces/