In jjchern/qcewAPI: Access QCEW Data from the Bureau of Labor Statistics

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "README-"
)

About

The goal of qcewAPI is to wrap the QCEW Open Data Access RScript provided by the Bureau of Labor Statistics in an R package, and provide more documentations and examples.

• QCEW Overview:

  Publicly available files include data on the number of establishments, monthly employment, and quarterly wages, by NAICS industry, by county, by ownership sector, for the entire United States.

  Employment data under the QCEW program represent the number of covered workers who worked during, or received pay for, the pay period including the 12th of the month. Excluded are members of the armed forces, the self-employed, proprietors, domestic workers, unpaid family workers, and railroad workers covered by the railroad unemployment insurance system.

  The QCEW data are used as the benchmark source for employment by the Current Employment Statistics program and the Occupational Employment Statistics program.

Installation

# install.packages("devtools")
devtools::install_github("jjchern/qcewAPI")

Usage

Get Annual Average QCEW Data for Michigan in 2013

qcewAPI::get_area(year = "2013", qtr = "a", area = "26000")

Get Q1-2013 QCEW Data for the Construction Industry

qcewAPI::get_industry(year = "2013", qtr = "1", industry = "1012")

Get 2013 QCEW Data for Establishment Size of 100--249

qcewAPI::get_size(year = "2013", size = "6")

Related Documentation

Browse QCEW

• QCEW News Releases
• QCEW Databases
• QCEW Publications
• QCEW FAQs
• QCEW Related Links

Data Access and File Layouts

• All QCEW data files
• QCEW Data Guide
• Open Data Access Guide
• Documentation Guide
  • Codes and Titles for NAICS coded data
    • QCEW Aggregation Level Codes
    • QCEW Area Titles
    • QCEW Area Titles (for the pre-2013 area changes)
    • QCEW MSA Area Titles for some pre-2004 areas (primarily for SIC coded data)
    • QCEW Datatype Codes and Titles
    • QCEW Industry Codes and Titles
    • QCEW Industry Codes and for high level industries
    • QCEW Ownership Codes and Titles
    • QCEW Size Codes and Titles
  • SIC-based Codes and Titles
    • QCEW Aggregation Level Codes for SIC coded data
    • QCEW MSA Area Titles for some pre-2004 areas (primarily for SIC coded data)
    • QCEW Area Titles for SIC coded data
    • QCEW Datatype Codes for SIC coded data
    • QCEW Industry Codes and Titles for SIC coded data
    • QCEW Ownership Codes and Titles for SIC coded data
    • QCEW Size Codes and Titles for SIC coded data
  • File Layouts: Excel Files
    • Layout for QCEW High Level County Files
  • File Layouts: CSV Files
    • Layout for QCEW CSV files of annual data
    • Layout for QCEW CSV files of quarterly data
    • Layout for QCEW CSV files of SIC coded annual data
    • Layout for QCEW CSV files of SIC coded quarterly data
  • File Layouts: Legacy Flat-Files
    • Layout for QCEW .enb and .end formatted files
    • Layout for QCEW .ewb (SIC) formatted files

jjchern/qcewAPI documentation built on May 19, 2019, 11:39 a.m.