Skip to content
This repository has been archived by the owner on Nov 10, 2020. It is now read-only.

Consider adding renewables to wage and salary job counts #2168

Closed
shawnbot opened this issue Nov 30, 2016 · 1 comment
Closed

Consider adding renewables to wage and salary job counts #2168

shawnbot opened this issue Nov 30, 2016 · 1 comment
Assignees
Labels
data-mgmt Use this label for adding and/or updating data on the site. Also can be used for data management too

Comments

@shawnbot
Copy link
Contributor

We're not currently pulling in renewable (wind, solar, and geothermal) wage and salary job counts; only NAICS code 21 (Mining and other extractives).

Here are some relevant snippets that we've removed from the data documentation for now, and which might help:

Geographic considerations:

  • At the state level, break out by natural resource type, while at the county level, provide a total for extractive industries
  • At the county level, do not break out by natural resource type because there are too many anomalies to get a 10 year trend. Instead, just provide one extractive industry wide number.

Gotchas:

  • To get renewables, you have to look in a different NAICS sector, 22 for Utilities instead of 21 for Mining. Renewable codes are: Solar 221114, Wind 221115, Geothermal 221116.
  • To get nonrenewable subindustries, use 21 for Mining as the overarching category. Within Mining, these codes are mutually exclusive and address relevant subindustries: Oil and Gas 211, Coal 2121, Iron 21221, Gold 212221, Copper and Nickel 212234. To get a nonenergy mineral total, add Metal Ore Mining 2122 and Nonmetallic Mineral Mining and Quarrying 2123.
  • In the county level extractive industry wide number, need to decide whether to include renewables, which won't be included in self-employment and some other data sources. Given that renewables are only a few thousand people nationally, may not be worth it to try and figure it out at the county level.
Commodity NAICS code
Oil and gas 211
Coal 2121
Iron 21221
Gold 212221
Copper 212234
Solar 221114
Wind 221115
Geothermal 221116

To do this right, we'll need to change this Makefile to extract the solar, wind, and geothermal CSVs, then update this join script to read in all four (extractives, solar, et al) CSVs and sum those up to derive the Total column in the joined TSVs.

@shawnbot shawnbot added size:days data-mgmt Use this label for adding and/or updating data on the site. Also can be used for data management too labels Nov 30, 2016
shawnbot pushed a commit that referenced this issue Nov 30, 2016
@coreycaitlin
Copy link
Contributor

I think we can close this with #2156, and open new issues to refine further as needed.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
data-mgmt Use this label for adding and/or updating data on the site. Also can be used for data management too
Projects
None yet
Development

No branches or pull requests

2 participants