Number of Active Employees by Industry

data.ct.gov | Last Updated 2 Aug 2023

Number of active employees, aggregating information from multiple data providers. This series is based on firm-level payroll data from Paychex and Intuit, worker-level data on employment and earnings from Earnin, and firm-level timesheet data from Kronos. This data is compiled by Opportunity Insights. Data notes from Opportunity Insights: Data Source: Paychex, Intuit, Earnin, Kronos Update Frequency: Weekly Date Range: January 15th 2020 until the most recent date available. The most recent date available for the full series depends on the combination of Paychex, Intuit and Earnin data. We extend the national trend of aggregate employment and employment by income quartile by using Kronos timecard data and Paychex data for workers paid on a weekly paycycle to forecast beyond the end of the Paychex, Intuit and Earnin data. Data Frequency: Daily, presented as a 7-day moving average Indexing Period: January 4th - January 31st Indexing Type: Change relative to the January 2020 index period, not seasonally adjusted. More detailed documentation on Opportunity Insights data can be found here: https://github.com/OpportunityInsights/EconomicTracker/blob/main/docs/oi_tracker_data_documentation.pdf

Tags: economic recovery, employment, active employees

This dataset has the following 7 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Datedate_daycalendar_dateDate
State FIPS CodestatefipsnumberState FIPS Code
State Namestate_nametextState Name
emp_ss40emp_ss40numberEmployment level for workers in trade, transportation and utilities (NAICS supersector 40).
emp_ss60emp_ss60numberEmployment level for workers in professional and business services (NAICS supersector 60).
emp_ss65emp_ss65numberEmployment level for workers in education and health services (NAICS supersector 65).
emp_ss70emp_ss70numberEmployment level for workers in leisure and hospitality (NAICS supersector 70).