https://api.dol.gov/V1/Safety/Accidents
This dataset contains information on all accidents, injuries and illnesses reported by mine operators and contractors beginning with 1983. The data in the table is obtained from the Mine Accident, Injury and Illness Report form (MSHA Form 7000-1). Document number is the unique key for this data. It provides information about the accident/injury/illness such as type, mine location, lost days and the degree of injury.
This complete dataset can be found at https://catalog.data.gov/dataset/mine-accident-injuries
Dataset Tables
mineAccidents
| Column Name | Data Type | Column Description |
|---|---|---|
| Column Name id | Data Type bigint | Column Description Record id. - Primary Key |
| Column Name mineId | Data Type varchar (10) | Column Description Mine Id. |
| Column Name controllerId | Data Type varchar (10) | Column Description Controller Id. |
| Column Name controllerName | Data Type varchar (100) | Column Description Controller name. |
| Column Name operatorId | Data Type varchar (10) | Column Description Operator Id. |
| Column Name operatorName | Data Type varchar (100) | Column Description Operator name. |
| Column Name contractId | Data Type varchar (10) | Column Description Contract Id. |
| Column Name documentNumber | Data Type varchar (50) | Column Description Document number. |
| Column Name subUnitCode | Data Type varchar (10) | Column Description Sub unit code. |
| Column Name subUnit | Data Type varchar (50) | Column Description Sub unit. |
| Column Name accidentDate | Data Type varchar (50) | Column Description Accident date. |
| Column Name calendarYear | Data Type smallint | Column Description Calendar year. |
| Column Name calendarQuarter | Data Type smallint | Column Description Calendar quarter. |
| Column Name fiscalQuarter | Data Type smallint | Column Description Fiscal quarter. |
| Column Name accidentTime | Data Type varchar (10) | Column Description Accident time. |
| Column Name degreeInjuryCode | Data Type varchar (10) | Column Description Degree injury code. |
| Column Name degreeInjury | Data Type varchar (50) | Column Description Degree injury. |
| Column Name fipsStateCode | Data Type varchar (10) | Column Description Fips state code. |
| Column Name ugLocationCode | Data Type varchar (10) | Column Description UG locationc code. |
| Column Name ugLocation | Data Type varchar (100) | Column Description UG location. |
| Column Name ugMiningMethodCode | Data Type varchar (100) | Column Description UG mining method code. |
| Column Name ugMiningMethod | Data Type varchar (100) | Column Description UG mining method. |
| Column Name miningEquipmentCode | Data Type varchar (10) | Column Description Mining equipment code. |
| Column Name miningEquip | Data Type varchar (100) | Column Description Mining equipment. |
| Column Name equipmentManufacturerCode | Data Type varchar (10) | Column Description Equipment manufacturer code. |
| Column Name equipmentManufacturerName | Data Type varchar (100) | Column Description Equipment manufacturer name. |
| Column Name equpmentModelNumber | Data Type varchar (50) | Column Description Equpment model number. |
| Column Name shiftBeginTime | Data Type varchar (6) | Column Description Shift begin time. |
| Column Name classificationCode | Data Type varchar (10) | Column Description Classification code. |
| Column Name classification | Data Type varchar (100) | Column Description Classification. |
| Column Name accidentTypeCode | Data Type varchar (10) | Column Description Accident type code. |
| Column Name accidentType | Data Type varchar (100) | Column Description Accident type. |
| Column Name noInjuries | Data Type varchar (10) | Column Description No injuries. |
| Column Name totalExperience | Data Type varchar (10) | Column Description Total experience. |
| Column Name mineExperience | Data Type varchar (10) | Column Description Mine experience. |
| Column Name jobExperience | Data Type varchar (10) | Column Description Job experience. |
| Column Name occupationCode | Data Type varchar (10) | Column Description Occupation code. |
| Column Name occupation | Data Type varchar (100) | Column Description Occupation. |
| Column Name activityCode | Data Type varchar (10) | Column Description Activity code. |
| Column Name activity | Data Type varchar (100) | Column Description Activity. |
| Column Name injurySourceCode | Data Type varchar (10) | Column Description Injury source code. |
| Column Name injurySource | Data Type varchar (50) | Column Description Injury source. |
| Column Name natureInjuryCode | Data Type varchar (50) | Column Description Nature injury code. |
| Column Name natureInjury | Data Type varchar (100) | Column Description Nature injury. |
| Column Name injuredBodyPartCode | Data Type varchar (10) | Column Description Injured body part code. |
| Column Name injuredBodyPart | Data Type varchar (100) | Column Description Injured body part. |
| Column Name scheduleCharge | Data Type varchar (10) | Column Description Schedule charge. |
| Column Name daysRestrict | Data Type varchar (10) | Column Description Days restrict. |
| Column Name daysLost | Data Type varchar (10) | Column Description Days lost. |
| Column Name transTerm | Data Type varchar (10) | Column Description Trans term. |
| Column Name returnToWorkDate | Data Type varchar (12) | Column Description Return to work date. |
| Column Name immedNotifyCode | Data Type varchar (10) | Column Description Immed notify code. |
| Column Name immedNotify | Data Type varchar (50) | Column Description Immed notify. |
| Column Name investBeginDate | Data Type varchar (12) | Column Description Invest begin date. |
| Column Name narrative | Data Type varchar (4000) | Column Description Narrative. |
| Column Name closedDocNumber | Data Type varchar (50) | Column Description Closed doc number. |
| Column Name coalMetalInd | Data Type varchar (10) | Column Description Coal metal ind. |