econ_tracker_employment: United States Employment Data from Econ Tracker and...

In seandavi/sars2pack: COVID-19 data resources and analysis tools

United States Employment Data from Econ Tracker and Opportunity Insights

Description

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.

Usage

econ_tracker_employment_city_data()

econ_tracker_employment_county_data()

econ_tracker_employment_state_data()

econ_tracker_employment_national_data()

Details

Data Sources: Paychex, Intuit, Earnin, Kronos

Breakdowns are by:

Wages

• High Income (wage greater than $60,000 per year)

• Middle Income (wage between $27,000 per year and $60,000 per year)

• Low Income (wage less than $27,000 per year)

Industry by NAICS supersector.

• Professional and Business Services

• Education and Health Services

• Retail and Transportation

• Leisure and Hospitality

Value

a data.table with geographic details and a variable column with the following values representing the reported value:

• emp_combined: Employment level for all workers.

• emp_combined_inclow: Employment level for workers in the bottom quartile of the income distribution (incomes approximately under $27,000).

• emp_combined_incmiddle: Employment level for workers in the middle two quartiles of the income distribution (incomes approximately $27,000 to $60,000).

• emp_combined_inchigh: Employment level for workers in the top quartile of the income distribution (incomes approximately over $60,000).

• emp_combined_ss40: Employment level for workers in trade, transportation and utilities (NAICS supersector 40).

• emp_combined_ss60: Employment level for workers in professional and business services (NAICS supersector 60).

• emp_combined_ss65: Employment level for workers in education and health services (NAICS supersector 65).

• emp_combined_ss70: Employment level for workers in leisure and hospitality (NAICS supersector 70).

Note

For low income workers, the change in employment is calculated using Paychex and Earnin data. For medium and high income workers, the change in employment is calculated using Paychex and Intuit data.

In order to provide closer to real time data, we forecast the most recent employment measures beyond those available in the combined Earnin, Intuit, and Paychex dataset alone. To do so, we leverage two sources of higher frequency data: Kronos timestamp data and the Paychex weekly pay cycle sample. Using this higher frequency data we forecast more recent changes in employment using a distributed lag model, constructed by regressing a given week’s employment measure on the corresponding week’s Kronos measure, as well as its current and 3 previous lagged weeks’ Paychex weekly pay cycle measure. For more details, please refer to the appendix of the accompanying paper

Author(s)

Sean Davis [e-mail]

See Also

Other data-import: acaps_government_measures_data(), acaps_secondary_impact_data(), apple_mobility_data(), beoutbreakprepared_data(), cci_us_vaccine_data(), cdc_aggregated_projections(), cdc_excess_deaths(), cdc_social_vulnerability_index(), coronadatascraper_data(), coronanet_government_response_data(), cov_glue_lineage_data(), cov_glue_newick_data(), cov_glue_snp_lineage(), covidtracker_data(), descartes_mobility_data(), ecdc_data(), econ_tracker_consumer_spending, econ_tracker_unemp_data, economist_excess_deaths(), financial_times_excess_deaths(), google_mobility_data(), government_policy_timeline(), jhu_data(), jhu_us_data(), kff_icu_beds(), nytimes_county_data(), oecd_unemployment_data(), owid_data(), param_estimates_published(), test_and_trace_data(), us_county_geo_details(), us_county_health_rankings(), us_healthcare_capacity(), us_hospital_details(), us_state_distancing_policy(), usa_facts_data(), who_cases()

Other economics: acaps_secondary_impact_data(), econ_tracker_consumer_spending, econ_tracker_unemp_data, us_county_health_rankings()

Examples

res = econ_tracker_employment_city_data()
res

res = econ_tracker_employment_county_data()
res


res = econ_tracker_employment_state_data()
res

res = econ_tracker_employment_national_data()
res

library(ggplot2)
ggplot(res, aes(x=date,y=value,color=variable,lty=variable_type)) + 
    geom_line() + 
    ggtitle('Proportion of workforce employed in the United States', 
            subtitle='Broken down by industry and income level, normalized to January 2020') +
    ylab('Proportion of workforce') 

seandavi/sars2pack documentation built on May 13, 2022, 3:41 p.m.