Looking into the BEA (US Bureau of Economic Analysis) API - there is ton of data available, but I can't figure out how to get labor data by sector per county. Anyone has experience with it?
In July I wrote to BEA with a similar question--getting regional employment and wages by industry. They confirmed that these tables (specifically, I wanted SQ6N, SQ7N, and SA27N) aren't yet available via API. "Later this year, I hope," they said.
In the meantime, I've been getting data from BEA's interactive tool and bulk download page (http://www.bea.gov/regional/downloadzip.cfm) and loading it to our internal API.
I've not seen this API before, but I tried some examples. It does not appear the RegionalData dataset has a parameter to breakdown results by industry sector. But you can get results by county by setting the parameter: GeoFIPS=COUNTY .
The results look very similar to the IRS Statistics of Income (SOI) datasets.
The NIPA dataset does have a parameter for breaking down by industry sector (TableID) but does not have a parameter to breakdown geographically. The counts appear to be national values.
I reviewed the documentation on all the other datasets (very interesting stuff). Except for RegionalData, none of the others support the GeoFIPS US geographic parameter.
Quarterly Census of Employment and Wages (QCEW) data may be of interest. It is a major input to BEA Personal Income. I work for the QCEW program.
QCEW provides employment and wage data by industry at the county, MSA, State, and national levels. Go to http://www.bls.gov/cew/opendata.htm to access the open data version of the dataset. Available for 2012-forward, QCEW open data is a csv-based static API.
We built it with users like you in mind. We are using it as the input for all our future QCEW data front ends, so it has to be great!
For data prior to 2012, (back to 1975 at some levels of aggregation), see the flat files available at http://www.bls.gov/cew/datatoc.htm Many of the resources at this location are zip archives of csv files.
The US Department of Labor has a new website and API and dev portal (Quarry). See here for details