Data: Explore > Jobs > Wage & Salary: break down by commodity

[shawnbot]

In my first pass at this I was only able to get the total extractives numbers from BLS. We need to break these down by commodity.

@Isabelle1512, I could use some help in listing out the different NAICS codes that correspond to our commodities. You mentioned the codes for renewables in the data catalog, but I'm not sure what the others are.

[Isabelle1512]

@shawnbot, updated data catalog with the following: 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.

[Isabelle1512]

It depends a little bit on how you want to do it. These codes are not inclusive of oneanother:
Mining 21
Renewables

Within Mining, these codes are not inclusive of one another, and should cover the entire Mining category:
Oil and Gas (211)
Coal (2121)
Nonenergy Minerals (2122 + 2123)

Within Nonenergy Minerals, these codes are distinct, but do not cover the entire category:
Iron (21221)
Gold (212221)
Copper and Nickel (212234)

Unfortunately cannot separate Oil from Gas, or Copper from Nickel.

[shawnbot]

OK, thanks @Isabelle1512! Would you mind listing out some of the figures that you used in the report so that I can check my work against those?

[Isabelle1512]

@shawnbot : we didn't really include this level of analysis in the Exec Sum, since we knew it would be better in an online format. The amount of detail we go into is Extractive Industries in IL (9,993) vs. All Other Industries in IL, One with some renewables: 29,866 for Extractive Industries in CA. If you'd like, I can spot check your work just using that relevant data sources.

[shawnbot]

Sounds good, @Isabelle1512. 🍻

[meiqimichelle]

I think we're done here. Closing.