README.md

In eloualiche/entrydatar: Download and process data of firm entry from BLS, Census, etc...

entrydatar: download and clean data on U.S. firms' entry

Downloads and aggregates flat tables of entry statistics from the Quarterly Census of Employment and Wages and Business Employment Dynamics program and the County Business Patterns. See details of this file and the vignettes for other commands for other public downloads.

Available data

Quarterly Census of Employment and Wages (QCEW)

• See the BLS website for more information.
• Establishment level entry data.
• NAICS available from 1990 to 2016 and SIC from 1975 to 2000.
• Files can be manually downloaded from this page.

Business Employment Dynamics (BED)

• See the BLS website for more information
• Establishment level entry data.
• Data is available at the naics (3 digits level) from 1992Q3 to 2015Q1.
• We download an industry flat file directly from the BLS

County Business Pattern (CBP)

• See the Census website for more information.
• Annual data on business employment at the county level.
• Files can be manually downloaded from this page.
• Left to Do on CBP: [ ] Some of the data is on naics and some on sic. Is there an harmonized dataset. [ ] tidy function on cbp is not finished

Other datasets (In progress)

• Local Area Unemployment Statistics from the BLS: LAU get_lau_data(years = seq(1990, 2016), path_data = "./")
• Business Dynamics Statistics from the Census: BDS get_bds_cut(1977, 2014, "firm", "agesic")
• Business Formation from the BEA, Survey of Current Business: NBF get_nbf(years = seq(1948, 1994))

Vignettes:

• How to download specific cuts of the QCEW
• How to download a clean version of the CBP
• How to download a clean version of the BED
• How to download a clean version of the BDS
• How to download a clean version of the NBF

Examples

• How to construct a Bartik shock using the CBP

Installation

• Install the current version from github with

library(devtools)
devtools::install_github("eloualiche/entrydatar")

Work in progress (to do list)

• [ ] Tidy qcew move from gather to melt?
• [ ] Load QCEW directly from local downloaded files
• [ ] Stable version of Quarterly Workforce Indicator. See vignette for documentation QWI

(c) Erik Loualiche

eloualiche/entrydatar documentation built on Aug. 20, 2023, 1:56 p.m.