https://api.dol.gov/V1/Mining/FullMineInfo/
The Full Mine Info dataset lists all Coal and Metal/Non-Metal mines under MSHA's jurisdiction since 1/1/1970. It includes such information as the current status of each mine (Active, Abandoned, NonProducing, etc.), the current owner and operating company, commodity codes and physical attributes of the mine. Mine ID is the unique key for this data.
Dataset Tables
MSHA_mines
| Column Name | Data Type | Column Description |
|---|---|---|
| Column Name id | Data Type bigint | Column Description Primary key of the table - Primary Key |
| Column Name MINE_ID | Data Type varchar (14) | Column Description Identification number assigned to the mine by MSHA - Primary Key |
| Column Name CURRENT_MINE_NAME | Data Type varchar (50) | Column Description Name of the mine as designated on the Legal ID Form |
| Column Name COAL_METAL_IND | Data Type varchar (1) | Column Description Identifies if the mine is a Coal or Metal/Non-Metal mine |
| Column Name CURRENT_MINE_TYPE | Data Type varchar (20) | Column Description From the Legal ID (LID) form. The types are Facility, Surface or Underground |
| Column Name CURRENT_MINE_STATUS | Data Type varchar (50) | Column Description Current status of the mine. |
| Column Name CURRENT_STATUS_DT | Data Type datetime | Column Description Date the mine obtained the current status |
| Column Name CURRENT_CONTROLLER_ID | Data Type varchar (7) | Column Description Identification number assigned by MSHA |
| Column Name CURRENT_CONTROLLER_NAME | Data Type varchar (72) | Column Description Either the business name or a person's name for the Legal Entity |
| Column Name CURRENT_OPERATOR_ID | Data Type varchar (7) | Column Description Identification number assigned by MSHA Assessments Center |
| Column Name CURRENT_OPERATOR_NAME | Data Type varchar (60) | Column Description The latest operator name |
| Column Name STATE | Data Type varchar (2) | Column Description State in which the mine is located |
| Column Name BOM_STATE_CD | Data Type varchar (2) | Column Description Bureau of Mines (BOM) assigned state codes |
| Column Name FIPS_CNTY_CD | Column Name varchar (3) | Column Description Federal Information Processing Standard county code |
| Column Name FIPS_CNTY_NM | Data Type varchar (80) | Column Description FIPS county code name |
| Column Name CONG_DIST_CD | Data Type varchar (2) | Column Description The Congressional District of the state |
| Column Name COMPANY_TYPE | Data Type varchar (80) | Column Description Unique description for each legal entity type |
| Column Name CURRENT_CONTROLLER_BEGIN_DT | Data Type datetime | Column Description Start date of the operating period at the mine |
| Column Name DISTRICT | Data Type varchar (3) | Column Description The first three characters of the Coal districts |
| Column Name OFFICE_CD | Data Type varchar (5) | Column Description MSHA code that identifies the office |
| Column Name OFFICE_NAME | Data Type varchar (80) | Column Description The name of the office to which the mine is assigned |
| Column Name ASSESS_CTRL_NO | Data Type varchar (20) | Column Description The most recent Assessment Control Number |
| Column Name PRIMARY_SIC_CD | Data Type varchar (6) | Column Description This is a code derived from the SIC codes |
| Column Name PRIMARY_SIC | Data Type varchar (80) | Column Description Description of the SIC |
| Column Name PRIMARY_SIC_CD_1 | Data Type varchar (4) | Column Description Standard Industrial Classification Code |
| Column Name PRIMARY_SIC_CD_SFX | Data Type varchar (2) | Column Name Suffix to the SIC |
| Column Name SECONDARY_SIC_CD | Data Type varchar (6) | Column Description This is a code derived from the SIC |
| Column Description SECONDARY_SIC | Column Name varchar (80) | Column Description Description of the SIC |
| Column Name SECONDARY_SIC_CD_1 | Data Type varchar (4) | Column Description Standard Industrial Classification Code (SIC) |
| Column Name SECONDARY_SIC_CD_SFX | Data Type varchar (2) | Column Description Suffix to the SIC |
| Column Name PRIMARY_CANVASS_CD | Data Type varchar (20) | Column Description Canvass code associated with the primary |
| Column Name PRIMARY_CANVASS | Data Type varchar (20) | Column Description Unique code abbreviation for the primary |
| Column Name SECONDARY_CANVASS_CD | Data Type varchar (20) | Column Description Canvass code associated with the secondary |
| Column Name SECONDARY_CANVASS | Data Type varchar (20) | Column Description Unique code abbreviation for the secondary |
| Column Name CURRENT_103I | Data Type varchar (80) | Column Description This is the description of the Mine 103I Classification Code |
| Column Name CURRENT_103I_DT | Data Type datetime | Column Description The date the mine entered the current 103I status |
| Column Name PORTABLE_OPERATION | Data Type varchar (1) | Column Description Indicates whether this is a portable mine or not |
| Column Name PORTABLE_FIPS_ST_CD | Data Type varchar (2) | Column Description FIPS state code if it is a portable mine |
| Column Name DAYS_PER_WEEK | Data Type float | Column Description Number of days per week |
| Column Name HOURS_PER_SHIFT | Data Type float | Column Description Number of hours per shift at the mine |
| Column Name PROD_SHIFTS_PER_DAY | Data Type float | Column Description Number of production shifts per 24-hour day |
| Column Name MAINT_SHIFTS_PER_DAY | Data Type float | Column Description Number of maintenance-only shifts per 24-hour day |
| Column Name NO_EMPLOYEES | Data Type float | Column Description Number of workers employed at the mine |
| Column Name PART48_TRAINING | Data Type varchar (1) | Column Description Indicates whether MSHA is restricted |
| Column Name LONGITUDE | Data Type float | Column Description Longitude denoting the mine location |
| Column Name LATITUDE | Data Type float | Column Description Latitude denoting the mine location |
| Column Name AVG_MINE_HEIGHT | Data Type float | Column Description Average mining height in inches |
| Column Name MINE_GAS_CATEGORY_CD | Data Type varchar (20) | Column Description This categorization is used by underground |
| Column Name METHANE_LIBERATION | Data Type float | Column Description Methane Liberation on Section (cubic feet each 24 hrs). |
| Column Name NO_PRODUCING_PITS | Data Type float | Column Description Number of pits that are actively producing |
| Column Name NO_NONPRODUCING_PITS | Data Type float | Column Description Number of pits that are not producing |
| Column Name NO_TAILING_PONDS | Data Type float | Column Description Number of tailing ponds (Metal/Non-Metal mines only). |
| Column Name PILLAR_RECOVERY_USED | Data Type varchar (1) | Column Description Indicator denoting whether or not a mine uses pillar |
| Column Name HIGHWALL_MINER_USED | Data Type varchar (1) | Column Description Indicator denoting whether or not a mine uses a highwall |
| Column Name MULTIPLE_PITS | Data Type varchar (1) | Column Description Indicates whether there are multiple pits |
| Column Name MINERS_REP_IND | Data Type varchar (1) | Column Description Indicates where there is a miners' representative |
| Column Name SAFETY_COMMITTEE_IND | Data Type varchar (1) | Column Description Values are 'Y' or 'N'. |
| Column Name MILES_FROM_OFFICE | Data Type float | Column Description Driving distance to the mine/mill |
| Column Name DIRECTIONS_TO_MINE | Data Type varchar (300) | Column Description Free-form description of directions |
| Column Name NEAREST_TOWN | Data Type varchar (30) | Column Description Nearest town or city |