https://api.dol.gov/V1/Compliance/MineInspection
The Mine Inspections dataset lists every mine inspection conducted by MSHA dating back to 1/1/1978. The data includes the name of the mine inspected, MSHA's internal inspection number (event number), the type of inspection and the start and end dates of the inspection. Event Number is the unique key for this dataset. It also includes the Mine ID associated with the inspections which can be used to relate it to the Mines Data Set.
Dataset Tables
mineInspections
| Column Name | Data Type | Column Description |
|---|---|---|
| Column Name id | Data Type bigint | Column Description Record Id. - Primary Key |
| Column Name eventNumber | Data Type bigint | Column Description Event number. |
| Column Name mineId | Data Type bigint | Column Description Mine Id. |
| Column Name inspectionBeginDate | Data Type datetime | Column Description Inspection begin date. |
| Column Name inspectionEndDate | Data Type datetime | Column Description Inspection end date. |
| Column Name controllerId | Data Type varchar (20) | Column Description Controller Id. |
| Column Name controllerName | Data Type varchar (200) | Column Description Controller name. |
| Column Name operatorId | Data Type varchar (20) | Column Description Operator Id. |
| Column Name operatorName | Data Type varchar (200) | Column Description Operator name. |
| Column Name calendarYear | Data Type bigint | Column Description Calendar year. |
| Column Name calendarQuarter | Data Type bigint | Column Description Calendar quarter. |
| Column Name fiscalYear | Data Type bigint | Column Description Fiscal year. |
| Column Name fiscalQuarter | Data Type bigint | Column Description Fiscal quarter. |
| Column Name inspectionOfficeCode | Data Type varchar (5) | Column Description Inspection office code. |
| Column Name activityCode | Data Type varchar (10) | Column Description Activity code. |
| Column Name activity | Data Type varchar (200) | Column Description Activity. |
| Column Name activitySections | Data Type bigint | Column Description Activity sections. |
| Column Name idleSections | Data Type bigint | Column Description Idle sections. |
| Column Name shaftSlopeSink | Data Type bigint | Column Description Shaft slope sink. |
| Column Name impoundConstr | Data Type bigint | Column Description Impound constr. |
| Column Name buildingConstrSites | Data Type bigint | Column Description Building constr sites. |
| Column Name draglines | Data Type bigint | Column Description Draglines. |
| Column Name unclassifiedConstr | Data Type bigint | Column Description Unclassified constr. |
| Column Name coRecords | Data Type varchar (1) | Column Description CO records. |
| Column Name surfUgMine | Data Type varchar (1) | Column Description Surf UG mine. |
| Column Name surfFacilityMine | Data Type varchar (1) | Column Description Surf facility mine. |
| Column Name refusePile | Data Type varchar (1) | Column Description Refuse pile. |
| Column Name explosiveStorage | Data Type varchar (1) | Column Description Explosive storage. |
| Column Name outbyArea | Data Type varchar (1) | Column Description Out by area. |
| Column Name majorConst | Data Type varchar (1) | Column Description Major const. |
| Column Name shaftsSlopes | Data Type varchar (1) | Column Description Shafts slopes. |
| Column Name impoundments | Data Type varchar (1) | Column Description Impoundments. |
| Column Name miscArea | Data Type varchar (1) | Column Description Misc area. |
| Column Name programArea | Data Type varchar (200) | Column Description Program area. |
| Column Name sumOfSampleCntAir | Data Type bigint | Column Description Sum of sample cnt air. |
| Column Name sumOfSampleCntDustspot | Data Type bigint | Column Description Sum of sample cnt dust spot. |
| Column Name sumOfSampleCntDustSurvey | Data Type bigint | Column Description Sum of sample cnt dust survey. |
| Column Name sumOfSampleCntRespDust | Data Type bigint | Column Description Sum of sample cnt resp dust. |
| Column Name sumOfSampleCntNoise | Data Type bigint | Column Description Sum of sample cnt noise. |
| Column Name sumOfSampleCntOther | Data Type bigint | Column Description Sum of sample cnt other. |
| Column Name nbrInspector | Data Type bigint | Column Description Number inspector. |
| Column Name sumOfTotalInspHours | Data Type bigint | Column Description Sum of total insp hours. |
| Column Name sumOfTotalOnSiteHours | Data Type bigint | Column Description Sum of total on site hours. |
| Column Name coalMetalInd | Data Type varchar (10) | Column Description Coal metal ind |
| Column Name sumOfTotalInspHrsSpvrTrainee | Data Type bigint | Column Description Sum of total insp hrs spvr trainee. |
| Column Name sumOfTotalOnSiteHrsSpvrTrainee | Data Type bigint | Column Description Sum of total on site hrs spvr trainee |