https://api.dol.gov/V1/Employment
This dataset contains the annual summation of employee hours and coal production reported by mine operators where the average quarterly employment is greater than zero with grouping by calendar year, subunit code and mine ID beginning with 1983. The subunit code identifies the location or operation of the mine relating to the: (01) Underground; (02) Surface at underground; (03) Strip, quarry, open pit; (04) Auger; (05) Culm bank/refuse pile; (06) Dredge; (12) Other mining; (17) Independent shops or yards; (30) Mill operation/preparation plant; (99) Office workers at mine site.
Dataset Tables
MSHA_employmentProduction
| Column Name | Data Type | Column Description |
|---|---|---|
| Column Name id | Data Type bigint | Column Description Record ID - Primary Key |
| Column Name mineID | Data Type bigint | Column Description Mine ID |
| Column Name mineName | Data Type varchar (150) | Column Description Mine Name |
| Column Name state | Data Type varchar (150) | Column Description State where mine is |
| Column Name subUnitCode | Data Type int | Column Description Sub Unit code of the mine |
| Column Name subUnit | Data Type varchar (150) | Column Description Sub Unit of the mine |
| Column Name calendarYear | Data Type int | Column Description Mine Calendar Year |
| Column Name annualHours | Data Type int | Column Description Miner Annual Hour |
| Column Name annualCostProduction | Data Type bigint | Column Description Annual Cost Production |
| Column Name averageEmployeeCount | Data Type int | Column Description Average Employee Count |
| Column Name averageEmployeeHours | Data Type int | Column Description Average Employee Hours |
| Column Name coalMetalInd | Data Type varchar (3) | Column Description Coal Metal Indicator |