Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.
APDU - Big Data Session 2013
Transcript of APDU - Big Data Session 2013
What is 'big data'?
Using collected data as an input to your production process
In the case of the federal government, using data already collected by public programs to craft data-driven public policy
LEHD Linked Employer-Employee Data
Quarterly Workforce Indicators
UI wage data
Social Security (age, sex)
OPM data (federal workers)
Schedule C (self-employed)
Decennial Census (race, education)
American Community Survey (race, education)
LBD (firm age & size)
2009 vs. Today
Next wave of R&D projects
Linked ACS-LEHD jobs data (development)
Additional frame components
(looking for data partners)
New: QWI and OntheMap by Firm Age and Firm Size
Detailed employment and wage information by national age of firm (5 age classes)
Established firms (including new establishments in established firms)
....And by size of firm (5 size classes)
Large firms (including smaller establishments of large national firms)
New: QWI and OnTheMap Federal Employment
Federal Workers are not in state UI data and those jobs have been unavailable in previous releases of QWI and OnTheMap.
Federal jobs are now included in OnTheMap
A supplemental QWI for federal workers is now available.
-- Young firms have an important role in job creation and employment growth
-- Yet little is known about the characteristics of the jobs created by new firms
Calculated from Quarterly Workforce Indicators, 23-state sample, 1998-2011
New firms contribute disproportionately to job creation, relative to employment share
Youngest firms 4% of employment, 15% of job creation
Why care about jobs at young firms?
Use a 28-state pooled sample of QWI states from 1998-2011 (56% of US employment).
All results are seasonally adjusted, private sector employment only (universe of QWI-FAS)
Some findings from the QWI on young firms
Hires & Separations as a Share of Employment:
Young vs. Established Firms
Young firms hire many workers relative to their size
Shares of Hires and Separations due to Job Creation
and Destruction in Young vs. Established Firms
Despite high churn, job creation is 40% of hiring at young firms
Ratio of Real Wages: Young/Established, Small/Large
Wages at young firms (relative to established firms) have been falling
We have used to new QWI data to examine hiring, separations, and wages at startups.
Findings to appear in a Kaufman Foundation brief in next few months
Young/Est. (industry weighted)
Job-to-job flows are a major opportunity for development of new employment statistics
Several employment series measure worker separations & hires:
Job Openings and Labor Turnover Survey (JOLTS)
Quarterly Workforce Indicators (QWI)
But do not link them across time....
Census is developing a new public use data product that will link job flows across employers, industries, and geographies
hires in Manufacturing
nationally per quarter, average over 2010
directly from another manufacturing job
What we know now from current statistics:
What we will know with additional job-to-job flow statistics:
directly from an employee leasing firm
Retail, Restaurants, & Bars
Job-to-job flows allow us to see the interconnectedness of labor markets:
...and understand the interconnectedness of industries
Movies & Sound Recording
Amusement & Gambling
R&D projects: where we are:
Still on schedule for 2014 release for job-to-job flows
-- Finalizing methodology and programming stream
Person/job blocking works well
Business name and address matcher in development
Microdata discussion paper to follow, hopefully 2014
Quarterly Workforce Indicators (QWI)
By detailed geography and industry as well as worker characteristics.
Shows where workers live, where they work (this map shows where residents of Vancouver, WA work)
Partially synthetic data product, worker characteristics (including residence geography) are synthesized
Characteristics of jobs and workers by locations
By industry and worker characteristics
Starting wages college educated men in high-tech industries in CA
Two Public Use Data Products are Derived From the LEHD Data
ACS/LEHD Linked Data Project
Link ACS jobs data to LEHD jobs data
Create infrastructure to:
improve LEHD establishment imputations
improve ACS POW imputations
better understand differences between QCEW establishment reporting and ACS POW reporting
Scope of my talk today:
Big Data challenges
Overview of LEHD/LED
Recent R&D project releases
R&D projects in development