CTData Conference Recap: Census Bureau Longitudinal Employer-Household Dynamics Demo
The Longitudinal-Employer Household Dynamics Data (LEHD) Products combine state administrative data with census data to understand various aspects of the workforce. With the LEHD data products, you can explore questions such as:
How have the wages of people in a sector (ex. manufacturing) changed over time by age?
When workers leave a sector (ex. manufacturing), what sector do they change to?
How many workers commute into our region or out of our region, and how many live in our region?
What is the size of the population over age 65 in a region facing a severe weather event? How many older structures are in the area at risk? How many people may be at risk of power loss?
What is the career trajectory for people majoring in education, business, or computers and technology 1, 5, and 10 years after graduation?
What are the earnings for veterans with various military specializations 1, 5, and 10 years after discharge in Connecticut?
This program was developed in 1990 and is not dependent on any one survey. It links employer and employee data. It’s a voluntary state partnership, and under this partnership, states send their Unemployment Insurance or wage records and their Quarterly Census of Wage data to LEHD. They are then combined with census and surveys to create public use data products.
Each of the applications is briefly described below. Watch the video to see a walk-through of how to use the applications. And explore the applications, along with their documentation, here.
The products demo’d in this session include:
05:06 QWI Explorer (Quarterly Workforce Indicators). “QWI Explorer…enables comprehensive access to the full depth and breadth of the Quarterly Workforce Indicators (QWI) dataset. Through charts, maps and interactive tables, users can compare, rank and aggregate QWIs across time, geography, and/or firm and worker characteristics on the fly” (LEHD Applications).
10:22 J2J Explorer (Job-to-Job Flows Explorer). This tool “enables comprehensive access to an innovative set of statistics on worker reallocation in the United States. Workers often build their careers through job-hopping and these flows between jobs are a primary means by which workers move up their career ladders. Flows of workers across employers, industries, and labor markets are subsequently quite large - about half of hires and separations in 2000 were job-to-job flows…. Using longitudinal administrative data on workers' job histories, J2J traces worker earnings and movements through industries, geographic labor markets, and to/from employment” (LEHD Applications).
14:36 LODES ( LEHD Origin Destination Employment Statistics) OnTheMap. “OnTheMap is an online mapping and reporting application showing where workers are employed and where they live with companion reports on worker characteristics and optional filtering by age, earnings, or industry groups. The interactive map viewer displays workplace and residential distributions by user-defined geographies at census block level detail” (LEHD Applications).
22:13 LODES OnTheMap for Emergency Management. “OnTheMap for Emergency Management is a public data tool that provides an intuitive web-based interface for accessing U.S. population and workforce statistics, in real time, for areas being affected by natural disasters. The tool allows users to easily retrieve reports containing detailed workforce, population, and housing characteristics for hurricanes, floods, wildfires, winter storms, and federal disaster declaration areas” (LEHD Applications).
26:41 PESO Explorer (Post-Secondary Employment Outcome). “PSEO Explorer is an interactive visualization tool that enables access to an innovative new set of statistics on employment outcomes of graduates of select post-secondary institutions in the United States.” The tool illuminates “employment and earnings outcomes for college and university graduates. By matching university transcript data with a national database of jobs, PSEO traces graduate movements from a post-secondary institution, degree level, and degree major to employment by industry and geographic labor markets.” (LEHD Applications).
31:02 VEO Explorer (Veteran Employment Outcomes) This interactive tool allows data users to explore the “broad distribution of labor market outcomes for recent veterans, highlighting the role of industry, military occupation, and rank in determining post-military earnings. Users can compare earnings data for different military specializations by industry or paygrade using grouped bar charts. Users can also explore line charts showing earnings data over time by years of service, AFQT scores, demographic characteristics, or industry” (LEHD Applications).
FOR MORE INFORMATION
You can watch other sessions from the CTData 2022 Mini-Conference at the conference hub. If you are interested in learning more about CTData, check out our mission and values and the services we provide. For training and tips on how to use data to inform your personal and professional life, register for one of our CTData Academy workshops or browse our blog. You can keep up with us by subscribing to the CTData newsletter and following us on Twitter, Facebook, and LinkedIn.