https://api.dol.gov/V1/Mining/Violation
This dataset contains violations issued from 1/1/1978 to 1/1/2000 as a result of MSHA inspections. Each inspection results in a unique Event Number that can be associated with many violations and is a direct link to the Inspections Data Set. The violator name at the time of the violation, the actual date the violation occurred and the date the violation was issued are in this file. This table contains details about the specific citation/order/safeguard issued, such as Section of the Act, relevant dates and the conditions or practices which caused and constituted a violation or an imminent danger. The data is captured from (MSHA form 7000-3).
Dataset Tables
MSHA_violations
| Column Name | Data Type | Column Description |
|---|---|---|
| Column Name ID | Data Type bigint | Column Description Primary key - Primary Key |
| Column Name EVENT_NO | Data Type varchar (14) | Column Description A preassigned number used to identify each inspection, investigation, audit, survey, etc. Use to join to the Inspections table. |
| Column Name INSPECTION_BEGIN_DT | Data Type varchar (50) | Column Description Start date of the inspection (mm/dd/yyyy). |
| Column Name INSPECTION_END_DT | Data Type varchar (50) | Column Description Inspection close out date (mm/dd/yyyy). |
| Column Name VIOLATION_NO | Data Type varchar (60) | Column Description Citation/order number assigned to each citation written during an inspection. This is a unique key to the file. |
| Column Name CONTROLLER_ID | Data Type varchar (14) | Column Description Identification number assigned by MSHA Assessments for a Legal Entity acting as a controller of an operator at the time the violation was cited. May not contain data (null values) if this record pertains to a violation issued to a contractor. |
| Column Name CONTROLLER_NAME | Data Type varchar (144) | Column Description Name of the controller active at the time the violation was cited. May not contain data (null values) if this record pertains to a violation issued to a contractor. |
| Column Name VIOLATOR_ID | Data Type varchar (14) | Column Description Identification number assigned by MSHA for a Legal Entity acting as an operator at a mine at the time the violation was cited. May not contain data (null values) if this record pertains to a violation issued to a contractor. |
| Column Name VIOLATOR_NAME | Data Type varchar (120) | Column Description Name of the operator active at the time the violation was cited. May not contain data (null values) if this record pertains to a violation issued to a contractor. |
| Column Name VIOLATOR_TYPE_CD | Data Type varchar (40) | Column Description Each Violator record represents an entity (Operator, Contractor, Agent or Miner) that has one or more violations at a mine. |
| Column Name MINE_ID | Data Type varchar (14) | Column Description Mine id of the mine where the violation was issued. |
| Column Name MINE_NAME | Data Type varchar (100) | Column Description Name of the mine where the violation was issued. |
| Column Name MINE_TYPE | Data Type varchar (40) | Column Description Mine type of the mine where the violation has been issued: Facility, Surface or Underground. |
| Column Name COAL_METAL_IND | Data Type varchar (3) | Column Description Identifies if the record is for a Coal or Metal/Non-Metal mine |
| Column Name CONTRACTOR_ID | Data Type varchar (20) | Column Description Code identifying the contractor to whom the citation or order was issued. May not contain data (null values) if the contractor was not cited. |
| Column Name VIOLATION_ISSUE_DT | Data Type varchar (50) | Column Description Date the citation or order was issued by the MSHA inspector. |
| Column Name VIOLATION_OCCUR_DT | Data Type varchar (50) | Column Description Actual date of occurrence of the violation. |
| Column Name CAL_YR | Data Type bigint | Column Description Calendar year during which the citation/order was issued by the MSHA inspector. |
| Column Name CAL_QTR | Data Type bigint | Column Description Calendar Quarter of the date the citation or order was issued by the MSHA inspector |
| Column Name FISCAL_YR | Data Type bigint | Column Description Fiscal Year of the date the citation or order was issued by the MSHA inspector. MSHA's fiscal year begins October 1 and ends September 30 |
| Column Name FISCAL_QTR | Data Type bigint | Column Description Fiscal Quarter of the date the citation or order was issued by the MSHA inspector. |
| Column Name IOLATION_ISSUE_TIME | Data Type varchar (8) | Column Description Time (24 hour) the citation or order was issued by the MSHA inspector. |
| Column Name SIG_SUB | Data Type varchar (3) | Column Description An indicator as to whether or not the gravity is determined by the inspector to be significant and substantial.If this is 'Y', the inspector has indicated that based upon the particular facts surrounding the violation there exists a reasonable likelihood the hazard contributed to will result in an injury or illness of a reasonably serious nature. |
| Column Name SECTION_OF_ACT | Data Type varchar (20) | Column Description Section of the Act under which the citation/order was issued. May not contain data (null values). |
| Column Name PART_SECTION | Data Type varchar (40) | ColumnDescription Code of Federal Regulations: Part/section of Title 30 CFR violated in format PPSSSSSXXXX where (P) Part, (S) Section and (X) Suffix. Four-digit section numbers are expanded to five within one leading zero. May not contain data (null values). |
| Column Name SECTION_OF_ACT_1 | Data Type varchar (40) | Column Description Primary Section of Act which gives the MSHA Inspector the authority to take the action specified by this Issuance. More than one type of action may be cited. |
| Column Name SECTION_OF_ACT_2 | Data Type varchar (40) | Column Description Secondary Section of Act which gives the MSHA Inspector the authority to take the action specified by this Issuance at Metal/Non-Metal mines only. More than one type of action may be cited. |
| Column Name CIT_ORD_SAFE | Data type varchar (40) | Column Description Specifies the type of Citation: Citation, Order, Safeguard, Written Notice or Notice |
| Column Name ORIG_TERM_DUE_DT | Data Type varchar (50) | Column Description Original date by which the cited condition was to be abated. Original time by which the cited condition was to be abated. |
| Column Name ORIG_TERM_DUE_TIME | Data Type varchar (8) | Column Description Original time by which the cited condition was to be abated. |
| Column Name LATEST_TERM_DUE_DT | Data type varchar (50) | Column Description Date by which the conditions cited in the citation/order are to be abated. For Metal mines, this can be the termination due date to which the citation/order is extended. |
| Column Name LATEST_TERM_DUE_TIME | Data Type varchar (8) | Column Description Time by which the conditions cited on the citation/order are to be abated. |
| Column Name TERMINATION_DT | Data Type varchar (50) | Column Description Date on which the citation/order was terminated. May not contain data (null values) if citation has not yet been terminated. |
| Column Name TERMINATION_TIME | Data Type varchar (10) | Column Description Time of day (24 hour) at which the citation/order was terminated. May not contain data (null values) if citation has not yet been terminated. |
| Column Name TERMINATION_TYPE | Data Type varchar (40) | Column Descrpition Code identifying the type of termination: Issued, ReplacedByOrder or Terminated. |
| Column Name ACATE_DT | Data Type varchar(50) | Column Description Date on which the citation/order was vacated. May not contain data (null values) if the violation was not vacated. |
| Column Name VACATE_TIME | Data Type varchar (10) | Column Description Time of day (24 hour) at which the citation/order was vacated. May not contain data (null values) if the violation was not vacated. |
| Column Name INITIAL_VIOL_NO | Data Type varchar(60) | Column Description This is the preceding citation record when there is a need to relate a citation to a previous one. For example this would apply when an order follows a citation. This relationship is needed to calculate the good faith reduction penalty points. May not contain data (null values). |
| Column Name REPLACED_BY_ORDER_NO | Data Type varchar (60) | Column Description Order number which replaced the original citation. May not contain data (null values) if situation does not apply. |
| Column Name LIKELIHOOD | Data Type varchar(40) | Column Description This is a measure of the seriousness of the violation being cited as measured by the likelihood of the occurrence of an accident: Highly, NoLikelihood, Occurred, Reasonably or Unlikely. May not contain data (null values) if situation does not apply. |
| Column Name INJ_ILLNESS | Data Type varchar(40) | Column Description Value assigned to a violation for gravity of injury. Measure of seriousness of violation being cited as measured by severity of the injury or illness to persons if accident were to occur due to the conditions of the violation: Fatal, LostDays, NoLostDays or Permanent. |
| Column Name NO_AFFECTED | Data Type bigint | Column Description This is a measure of the number of persons affected or potentially affected by the conditions at the Mine due to the violation. Can be zero. |
| Column Name NEGLIGENCE | Data Type varchar(40) | Column Description Codes representing the degree of negligence that the Inspector assigned to the violator due to the violation: HighNegligence, LowNegligence, ModNegligence, NoNegligence or Reckless. A high degree of negligence is assigned when the operator was in a position to be aware of the condition that contributed to a dangerous situation and there were no mitigating circumstances, or if there are unique aggravating circumstances associated with the violation, such as repeated past violations of the same standard at the mine. |
| Column Name WRITTEN_NOTICE | Data Type varchar(3) | Column Description Indicates if this citation is a result of a Miner or Agent notice of complaint to MSHA (written notice 103(g)): ('Y' or 'N'). May not contain data (null values). |
| Column Name ENFORCEMENT_AREA | Data Type varchar (40) | Column Description Specifies the enforcement areas affected by the violating condition or practice constitute a health hazard, safety hazard, both or other type of hazard. May not contain data (null values). |
| Column Name SPECIAL_ASSESS | Data Type varchar (3) | Column Description Specifies whether this citation has been designated for Special Assessment based on Special Assessment Review (Y or N). |
| Column Name PRIMARY_OR_MILL | Data Type varchar (40) | Column Description A code indicating if the Violation was observed in the Primary Mine location or in an associated Mill (Metal/Non-Metal only). May not contain data (null values). |
| Column Name RIGHT_TO_CONF_DT | Data Type varchar (50) | Column Description Date the operator was advised of his right to a conference (Metal/Non-Metal only). May not contain data (null values). |
| Column Name ASMT_GENERATED_IND | Data Type varchar(3) | Column Description If the violator is an Operator or Contractor, the indicator is 'N'. If the violator is an Agent, the indicator is 'Y'. If the violator is a Miner, the indicator can be 'Y' or 'N'. If none of the above, the indicator is '?'. |
| Column Name FINAL_ORDER_ISSUE_DT | Data Type varchar (50) | Column Description Date that this assessment becomes a Final Order. This date is set when the Certified Return Receipt date (CRR) is set. Note that this can be a projected future date that is set as soon as the CRR is entered. |
| Column Name PROPOSED_PENALTY | Data Type bigint | Column Description The original dollar value of the proposed penalty prior to any modifications such as those possibly resulting from a decision on a contested case. |
| Column Name AMOUNT_DUE | Data Type bigint | Column Description The current dollar value of the proposed assessment, reflecting any modifications that have been made since it was originally assessed |
| Column Name AMOUNT_PAID | Data Type bigint | Column Description The total dollar value of all payments applied to this proposed assessment to date. |
| Column Name BILL_PRINT_DT | Data Type varchar(50) | Column Description Date the bill was printed. This date always represents the first time the bill was printed |
| Column Name LAST_ACTION_CD | Data Type varchar(60) | Column Description Last action taken against this violation such as 1stDemandPrinted, BillingReady, ApprovedforTreasury and Proposed. |
| Column Name LAST_ACTION_DT | Data Type varchar (50) | Column Description Date the last action taken against this violation |
| Column Name DOCKET_NO | Data Type varchar (40) | Column Description The Docket Number assigned by the Court to this group of Assessments being contested. |
| Column Name DOCKET_STATUS_CD | Data Type varchar (10) | Column Description Denotes the current status of this docket: Approved (approved by the court) or Proposed (not yet been approved by the court). |
| Column Name CONTESTED_IND | Data Type varchar (3) | Column Description Indicates if this violation has been assessed and is being contested (Y or N). |
| Column Name CONTESTED_DT | Data Type varchar (50) | Column Description Date of the most recent docket status for this violation. |
| Column Name VIOLATOR_VIOLATION_CNT | Data Type bigint | Column Description Total number of assessed violations for this violator at this time during the violation history period. Used in penalty calculation. Applies to an Operator or a Contractor. Calculation for VPID is Violator Violation Count / Violator Inspection Day Count. |
| Column Name VIOLATOR_INSPECTION_DAY_CNT | Data Type bigint | Column Description Total number of inspections for this Operator at a mine during the violation history period. Used in penalty calculation. Does not apply to Contractor. Calculation for VPID is Violator Violation Count / Violator Inspection Day Count. |