U.S. Department of Commerce

Longitudinal Employer-Household Dynamics

Skip top of page navigation

QWI Explorer

QWI Explorer is a new, web-based analysis tool that enables comprehensive access to the full depth and breadth of the Quarterly Workforce Indicators (QWI) dataset. Through bar charts and interactive tables, users can compare, rank and aggregate QWIs across time, geography, and/or firm and worker characteristics on the fly.

The Beta release of QWI Explorer makes the entire QWI dataset available in a simple chart/table interface. The application's intuitive dashboard allows for the construction of pivot tables to compare and rank labor-force indicators such as employment, job creation and destruction, wages, and hires across a wide range of firm and worker characteristics. Potential analyses include a longitudinal look at wages by worker sex and age across counties, ranking job creation rates of young firms across NAICS industry groups, and comparing hiring levels by worker race and education levels across a selection of Metropolitan Areas.

QWI Explorer was developed to replace the QWI Online and Industry Focus tools. At the completion of the Beta testing period, QWI Online and Industry Focus will be retired.

Learn more about QWI Explorer PDF icon (104 KB)

QWI Explorer help and documentation

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. It provides an easy-to-use interface for creating, viewing, printing and downloading workforce related maps, profiles, and underlying data.

Based on 2002–2011 LEHD Origin Destination Employment Statistics (LODES), OnTheMap is a unique resource for mapping the travel patterns of workers and identifying small-area workforce characteristics.

A total of 50 state partners are currently featured, showing data for 9 years (2002 through 2011). OnTheMap Version 6 was released in January 2012.

Learn more about OnTheMap PDF icon (117 KB)

OnTheMap help and documentation

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.

Learn more about OnTheMap for Emergency Management PDF icon (157 KB)

OnTheMap for Emergency Management help and documentation

LED Extraction Tool

The LED Extraction Tool provides easy access to the raw data products produced through the Local Employment Dynamics (LED) Partnership. The Beta release of this tool makes the entire Quarterly Workforce Indicators (QWI) dataset available through a simple query-building interface (LODES data is scheduled to be available by the end of 2013).

The LED Extraction Tool provides:

  • Access to all 30 QWIs, all available years/quarters, all firm and worker characteristics, and 50 states in regular production (including DC, but not MA). New quarters of data will be made available on a rolling state-by-state basis.
  • A streamlined interface that walks users through the process of selecting the data they need and ignoring the data they don't. Grab only a single tabulation, all the data for a particular cluster of industries or geographies, or a state's full longitudinal set of data using the intuitive query-building interface.
  • Fast processing of the requested data tables, which are available for download as CSV and/or ZIP files (complete with metadata).

Learn more about the LED Extraction Tool PDF icon (116 KB)

LED Extraction Tool help and documentation

QWI Online

In the LEHD data, Unemployment Insurance data on workers and QCEW data on firms are both reported quarterly. The LEHD program uses these data, additional administrative data and data from censuses and surveys to create thirty QWI, eight of which are published in QWI Online. These include total employment, measures of change such as job flows, new hires and separations, and average earnings. The complete set of thirty labor force indicators is available through the Cornell VirtualRDC.

QWI Online provides:

  • Detailed demographics
  • Geography detail, including state, county, and metro/micropolitan areas
  • Ownership information (all-ownership and private only)
  • Industry information (NAICS sectors, subsectors, and industry groups)
  • 4-quarter rolling averages
  • Recent and historical data

Using the Comparison Report feature in QWI Online, you can tabulate labor market information by time, geography, sex, age and other variables. Users can also download the data to create their own custom tables and charts.

QWI Online help and documentation

Industry Focus

Industry Focus is a powerful analytic tool that quickly reports the top industries for an area, age group or sex. It allows users to focus in on a particular industry to see how it ranks among others and look at the characteristics of those who work in that industry.

Like QWI Online, Industry Focus is based on eight quarterly workforce indicators, including total employment, measures of change such as job flow, new hires and separations, and average earnings. It is a powerful analytic tool that quickly reports the top industries for your area, your age group or sex.

Cornell VirtualRDC

The Cornell VirtualRDC, hosted by Cornell University, provides access to public-use LEHD Quarterly Workforce Indicators (QWI), synthetic U.S. Census Bureau data, including LEHD Origin Destination Employment Statistics (LODES) data, and zero-observation datasets of data available in the Census RDCs. Synthetic data is constructed to statistically approximate the underlying data without compromising confidentiality.

All data on the VirtualRDC have been released for public purposes, and no confidential data are stored on the VirtualRDC. Public-use QWI and historical LODES data can be downloaded from the VirtualRDC. The most up to date LODES data can be accessed on the VirtualRDC through the Social Science Gateway or are available through the LEHD website.

Contact the VirtualRDC administrators at virtualrdc@cornell.edu for additional information about how to access and use the VirtualRDC.

[PDF] or PDF denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Acrobat® Reader This link to a non-federal Web site does not imply endorsement of any particular product, company, or content. available free from Adobe. This symbol Off site indicates a link to a non-government web site. Our linking to these sites does not constitute an endorsement of any products, services or the information found on them. Once you link to another site you are subject to the policies of the new site.