Open database on global coal and metal mine production

This data set covers global extraction and production of coal and metal ores on an individual mine level. It covers<br> 1171 individual mines, reporting mine-level production for 80 different materials in the period 2000-2021. Furthermore, also data on mining coordinates, ownership, mineral reserves, mining waste, transportation of mining products, as well<br> as mineral processing capacities (smelters and mineral refineries) and production is included. The data was gathered manually from more than 1900 openly available sources, such as annual or sustainability reports of mining companies. All datapoints are linked to their respective sources. After manual screening and entry of the data, automatic cleaning, harmonization and data checking was conducted. Geoinformation was obtained either from coordinates available in company reports, or by retrieving the coordinates via Google Maps API and subsequent manual checking. For mines where no coordinates could be found, other geospatial attributes such as province, region, district or municipality were recorded, and linked to the GADM data set, available at www.gadm.org. The data set consists of 12 tables. The table “facilities” contains descriptive and spatial information of mines and processing facilities, and is available as a GeoPackage (GPKG) file. All other tables are available in comma-separated values (CSV) format. A schematic depiction of the database is provided as in PNG format in the file database_model.png.本数据集涵盖全球各单体矿山的煤炭与金属矿石开采与生产活动。其覆盖1171座独立矿山，统计了2000年至2021年间80种不同物料的矿山级产量数据。此外，数据集还收录矿山坐标、所有权归属、矿产储量、采矿废弃物、矿产品运输数据，以及矿物加工产能（冶炼厂与矿物精炼厂）相关信息与产量数据。本数据集的采集工作系通过手动方式从1900余个公开可获取的渠道完成，例如矿业公司的年度报告或可持续发展报告。所有数据点均关联至其对应的原始来源。在完成手动数据筛查与录入后，研究团队开展了自动化数据清洗、标准化与校验工作。地理信息的获取途径包括两类：一是直接取自公司报告中的坐标，二是通过谷歌地图API（Google Maps API）获取坐标后进行手动核查。对于无法获取坐标的矿山，研究团队会记录其省份、区域、县或市政辖区等其他地理空间属性，并将这些属性与可从www.gadm.org获取的GADM数据集（GADM data set）进行关联。本数据集共包含12张数据表。其中"facilities"数据表收录矿山与加工设施的描述性及空间信息，以GeoPackage (GPKG)格式发布。其余所有数据表均以逗号分隔值（CSV）格式提供。数据库的架构示意图以PNG格式存储于database_model.png文件中。