Skip to main content

Data Planet LibGuides Blog

Quarterly Workforce Indicators Added to Data Planet

by Data Planet ™ on 2019-06-03T15:59:55-04:00 in Labor and Employment, About Data Planet Premium Datasets | Comments

Data Planet now offers the massive Quarterly Workforce Indicators (QWI) database, produced by the US Census Bureau, as a premium add-on to the Data Planet basic collection. QWI includes 32 indicators providing labor market statistics by industry group and sector, firm size and age, and worker demographics, with statistics dating as far back as 1990 for some geographic areas. Economists, researchers, and policymakers in economics, business development, industrial relations, and more rely on this remarkable source of local labor market statistics providing critical information on employment, unemployment, job creation and elimination, payroll, and wages.

The sheer power of the Data Planet Statistical Datasets platform is especially apparent in exploring the enormous amount of data in QWI. Because the QWI source data are unique job-level data that link workers to their employers, statistics can be researched by worker age, sex, educational attainment, and race/ethnicity, which allows for analysis by demographics of a particular local labor market or industry – for instance, identifying industries with aging workforces. Links between workers and firms also make it possible to identify worker flows – hires, separations, and turnover – as well as net employment growth. Trends can also be tracked by firm size and firm age. As example of the detail available, the chart below ranks hiring of males vs females by age group for the motion picture and video industry in California:

A sampling of questions to explore in QWI - Insight include:

  • Where are large manufacturing firms located? This chart shows states with firms employing 500+ persons and compares employment for two quarters.
  • Where is job loss highest? This map shows job losses by state for firms age 11+ years.
  • Which industries are hiring new workers? Are there racial patterns evident in hiring? This trend compares new hires in colleges, universities, and professional schools by worker race.
  • Of those rehired, are younger or older workers more likely to be rehired? Men or women? A look at this chart shows a relatively higher number of recall hires in finance and insurance in New York City metropolitan area in Q2 of 2011. Take a closer look at the age composition of the recalled workforce here, and the gender composition here, and the racial composition here
  • What are the largest industries in a geographic area in terms of total payroll? This chart ranks total payroll by industry group for the Agriculture, Forestry, Fishing, and Hunting industry in Nebraska. Cattle ranching and farming has by far the largest payroll. Here, view a map showing where this payroll is spread across counties.

A subset of this database – QWI - Industry - is also available in the basic Data Planet collection. A sampling of questions to explore in QWI - Industry include:

  • Which industries have the highest separations? This chart compares industries with respect to the number of workers whose job with a given employer ended during Q3 of 2015-2017 in Connecticut.
  • Which industries are hiring the most workers? This chart compares hiring in the Mining, Quarrying, and Oil and Gas Extraction industry sector in Colorado in Q4 2016 vs Q4 2017.
  • Which industries have the most churn in an area? This chart ranks industry sectors by turnover rate in Randolph County, West Virginia.

For more information on QWI and QWI - Industry, including more examples of the types of questions that can be answered using these valuable databases, please visit the QWI search guide, available here.

 Add a Comment



Enter your e-mail address to receive notifications of new posts by e-mail.


  Return to Blog
This post is closed for further discussion.

Contact support