< Return to Datasets Menu

Full Mine Information Mines

Full Mine Information Mines

http://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.

Browse Metadata Explore This Data

Dataset Tables

MSHA_mines

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