cpbR: Get the firm count data from the County Business Patterns...

In jtilly/cbpR: Working with Census County Business Patterns Data

Description

This is an R Package that downloads and prepares panel data sets from the Census County Business Patterns (CBP).

Details

It downloads the CPB data on the county level and then allows the user to aggregate the data up into larger geographic entities such as Metropolitan Statistical Areas, Micropolitan Statistical Areas, or some user defined collection of counties.

The file demo/cardealers.R contains a demonstration. It generates a panel data set for "New Car Dealers" (NAICS 441110). The data set ranges from 2000 to 2009. It aggregates the firm count data from the County Business Patterns into Micropolitan Statistical Areas and returns a dataset with annual data on the firm count, employment (if available), firm count by employment, and population figures for each Micropolitan Statistical Area. The population estimates are taken from the Annual Estimates of the Population of Metropolitan and Micropolitan Statistical Areas: April 1, 2000 to July 1, 2009 (CBSA-EST2009-01). The Micropolitan Statistical Area definitions are taken from the Census 2003-2009 Delineation Files.

The data frame firms contains the following columns

• fips the fips code

• fipsstate the state fips code

• fipscty the county fips code within the state

• year the year of observation

• est the number of establishments

• n1_4 the number of establishments with between 1 and 4 employees

• n5_9 the number of establishments with between 5 and 9 employees

• n10_19 ... with between 10 and 19 employees

• n20_49 ... with between 20 and 49 employees

• n50_99... with between 50 and 99 employees

• n100_249 ... with between 100 and 249 employees

• n250_499 ... with between 250 and 499 employees

• n500_999 ... with between 500 and 999 employees

• n1000plus ... with between more than 1000 employees

jtilly/cbpR documentation built on May 20, 2019, 3:13 a.m.