Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start 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.


APDU - Big Data Session 2013

Presentation to APDU in Washington, DC, 9/16/2013

Erika McEntarfer

on 17 September 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of APDU - Big Data Session 2013

Big Data Research & Development @ Census: Local Employment Dynamics
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
Jobs Data
Firm Data
LEHD Linked Employer-Employee Data
Quarterly Workforce Indicators
Job-to-Job Flows
(in development)
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
Job-to-Job Flows
Linked ACS-LEHD jobs data (development)
Additional frame components
(looking for data partners)
Displaced Workers
New: QWI and OntheMap by Firm Age and Firm Size
Detailed employment and wage information by national age of firm (5 age classes)
Young firms
Established firms (including new establishments in established firms)
....And by size of firm (5 size classes)
Small businesses
Medium-sized businesses
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
Startup Separations
Startup Hires
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 
Job creation/Hires
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. (unweighted)
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
from nonemployment
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
Automotive manufacturing
Electrical component
Machinery manufacturing
Employee leasing
Fabricated metal
Computer Manufacturing
Primary metal
Movies & Sound Recording
Performing Arts
Copyright lessors
Professional Services
Amusement & Gambling
R&D projects: where we are:
Still on schedule for 2014 release for job-to-job flows
-- Finalizing methodology and programming stream
ACS/LEHD project:
Person/job blocking works well
Business name and address matcher in development
Microdata discussion paper to follow, hopefully 2014
Quarterly Workforce Indicators (QWI)
Job Creation/Destruction
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
Full transcript