This gets data from the Quarterly Workforce Indicators (QWI) via the Census API. It's an alternative to censusapi that fetches a set of variables (employees and payroll) but makes a somewhat more dynamic API call. The API returns a maximum of 10 years of data; calling this function with more than 10 years will require multiple API calls, which takes a little longer.
qwi_industry(
years,
industries = cwi::naics_codes[["industry"]],
state = "09",
counties = NULL,
annual = FALSE,
key = NULL,
retry = 5
)A numeric vector of one or more years for which to get data
A character vector of NAICS industry codes; default is the 20 sectors plus "All industries" from the dataset naics_codes.
A string of length 1 representing a state's FIPS code, name, or two-letter abbreviation; defaults to "09" for Connecticut
A character vector of county FIPS codes, or "all" for all counties. If NULL (the default), will return data just at the state level. For Connecticut, these now need to be COGs; data has been changed retroactively.
Logical, whether to return annual averages or quarterly data (default) .
A Census API key. If NULL, defaults to the environmental variable "CENSUS_API_KEY", as set by tidycensus::census_api_key().
The number of times to retry the API call(s), since the server this comes from can be a bit finicky.
A data frame / tibble
Note that when looking at data quarterly, the payroll reported will be for that quarter, not the yearly payroll that you may be more accustomed to. As of November 2021, payroll data seems to be missing from the database; even the QWI Explorer app just turns up empty.
if (FALSE) {
qwi_industry(2012:2017, industries = c("23", "62"), counties = "009")
}