DOL Mine Inspections Dataset
|
List of Tables
|
Description
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.
This complete dataset can be found at
http://explore.data.gov/Energy-and-Utilities/Mine-Inspections/wt25-mkey
Dataset Location
http://api.dol.gov/V1/Compliance/MineInspection
Dataset Metadata
http://api.dol.gov/V1/Compliance/MineInspection/$metadata
Dataset Sample
Sample this dataset.
mineInspections
Mine Inspections.
|
Column Name |
Column Description |
Data Type |
|---|---|---|
|
id |
Record Id. - Primary Key |
bigint |
|
eventNumber |
Event number. |
bigint |
|
mineId |
Mine Id. |
bigint |
|
inspectionBeginDate |
Inspection begin date. |
datetime |
|
inspectionEndDate |
Inspection end date. |
datetime |
|
controllerId |
Controller Id. |
varchar (20) |
|
controllerName |
Controller name. |
varchar (200) |
|
operatorId |
Operator Id. |
varchar (20) |
|
operatorName |
Operator name. |
varchar (200) |
|
calendarYear |
Calendar year. |
bigint |
|
calendarQuarter |
Calendar quarter. |
bigint |
|
fiscalYear |
Fiscal year. |
bigint |
|
fiscalQuarter |
Fiscal quarter. |
bigint |
|
inspectionOfficeCode |
Inspection office code. |
varchar (5) |
|
activityCode |
Activity code. |
varchar (10) |
|
activity |
Activity. |
varchar (200) |
|
activitySections |
Activity sections. |
bigint |
|
idleSections |
Idle sections. |
bigint |
|
shaftSlopeSink |
Shaft slope sink. |
bigint |
|
impoundConstr |
Impound constr. |
bigint |
|
buildingConstrSites |
Building constr sites. |
bigint |
|
draglines |
Draglines. |
bigint |
|
unclassifiedConstr |
Unclassified constr. |
bigint |
|
coRecords |
CO records. |
varchar (1) |
|
surfUgMine |
Surf UG mine. |
varchar (1) |
|
surfFacilityMine |
Surf facility mine. |
varchar (1) |
|
refusePile |
Refuse pile. |
varchar (1) |
|
explosiveStorage |
Explosive storage. |
varchar (1) |
|
outbyArea |
Out by area. |
varchar (1) |
|
majorConst |
Major const. |
varchar (1) |
|
shaftsSlopes |
Shafts slopes. |
varchar (1) |
|
impoundments |
Impoundments. |
varchar (1) |
|
miscArea |
Misc area. |
varchar (1) |
|
programArea |
Program area. |
varchar (200) |
|
sumOfSampleCntAir |
Sum of sample cnt air. |
bigint |
|
sumOfSampleCntDustspot |
Sum of sample cnt dust spot. |
bigint |
|
sumOfSampleCntDustSurvey |
Sum of sample cnt dust survey. |
bigint |
|
sumOfSampleCntRespDust |
Sum of sample cnt resp dust. |
bigint |
|
sumOfSampleCntNoise |
Sum of sample cnt noise. |
bigint |
|
sumOfSampleCntOther |
Sum of sample cnt other. |
bigint |
|
nbrInspector |
Number inspector. |
bigint |
|
sumOfTotalInspHours |
Sum of total insp hours. |
bigint |
|
sumOfTotalOnSiteHours |
Sum of total on site hours. |
bigint |
|
coalMetalInd |
Coal metal ind |
varchar (10) |
|
sumOfTotalInspHrsSpvrTrainee |
Sum of total insp hrs spvr trainee. |
bigint |
|
sumOfTotalOnSiteHrsSpvrTrainee |
|
bigint |
