https://api.dol.gov/V1/Mining/BasicMineInfo
The Basic Mine Info dataset lists basic information on 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.
Note: This dataset used to be "Address of record". The name was changed due to content organization so did the location.
This complete dataset can be found at https://catalog.data.gov/dataset/basic-mine-information-mine-address-of-record
Dataset Tables
MSHA_addressOfRecord
Column Name | Data Type | Column Description |
---|---|---|
Column Name id | Data Type bigint | Column Description Record id. - Primary Key |
Column Name mineId | Data Type bigint | Column Description Mine id. |
Column Name mineName | Data Type varchar (150) | Column Description Mine name. |
Column Name contactTitle | Data Type varchar (150) | Column Description Contact title. |
Column Name nearestTown | Data Type varchar (150) | Column Description Nearest town. |
Column Name businessName | Data Type varchar (150) | Column Description Business name. |
Column Name street | Data Type varchar (150) | Column Description Street address. |
Column Name poBox | Data Type float | Column Description Post office box number. |
Column Name city | Data Type varchar (150) | Column Description City. |
Column Name stateAbbr | Data Type varchar (2) | Column Description State abbreviation. |
Column Name fipsStateCode | Data Type int | Column Description Fips state code. |
Column Name state | Data Type varchar (150) | Column Description State. |
Column Name zipCode | Data Type int | Column Description Zip code. |
Column Name country | Data Type varchar (150) | Column Description Country. |
Column Name province | Data Type varchar (150) | Column Description Province. |
Column Name postalCode | Data Type varchar (150) | Column Description Postal code. |
Column Name mineTypeCode | Data Type varchar (150) | Column Description Mine type code. |
Column Name mineStatus | Data Type varchar (150) | Column Description Mine status. |
Column Name mineStatusDate | Data Type datetime | Column Description Mine status date. |
Column Name primarySicCode | Data Type varchar (150) | Column Description Primary SIC code. |
Column Name coalMetalInd | Data Type varchar (3) | Column Description Coal metal ind. |