Dataset: World Mineral Statistics

About this Dataset

World Mineral Statistics

The World Mineral Statistics dataset is a compilation of production and trade statistics on a wide range of mineral commodities since 1913.
However, data prior to 1960 is only available a scanned PDF books, whose content, currently, cannot successfully be extracted programmatically.

Tables

World Mineral Statistics

@owid.world_mineral_statistics.owid_world_mineral_statistics

966.27 KB
91105 rows
7 columns


CREATE TABLE owid_world_mineral_statistics (
  "country" VARCHAR,
  "year" INTEGER,
  "commodity" VARCHAR,
  "sub_commodity" VARCHAR,
  "unit" VARCHAR,
  "production" FLOAT,
  "notes_production" VARCHAR
);

World Mineral Statistics

@owid.world_mineral_statistics.owid_world_mineral_statistics_flat

494.72 KB
8121 rows
82 columns


CREATE TABLE owid_world_mineral_statistics_flat (
  "country" VARCHAR,
  "year" INTEGER,
  "production_coal_mine_tonnes" BIGINT,
  "production_barite_mine_tonnes" UINTEGER,
  "production_asbestos_mine_tonnes" UINTEGER,
  "production_gypsum_mine_tonnes" UINTEGER,
  "production_chromium_mine_gross_weight_tonnes" UINTEGER,
  "production_petroleum_crude_tonnes" BIGINT,
  "production_fluorspar_mine_tonnes" UINTEGER,
  "production_copper_mine_tonnes" UINTEGER,
  "production_copper_smelter_tonnes" UINTEGER,
  "production_iron_ore_mine_crude_ore_tonnes" UINTEGER,
  "production_nickel_mine_tonnes" UINTEGER,
  "production_copper_refinery_tonnes" UINTEGER,
  "production_nickel_processing_tonnes" UINTEGER,
  "production_cobalt_mine_tonnes" UINTEGER,
  "production_salt_rock_salt_tonnes" UINTEGER,
  "production_salt_sea_salt_tonnes" UINTEGER,
  "production_bauxite_mine_tonnes" UINTEGER,
  "production_cobalt_refinery_tonnes" UINTEGER,
  "production_steel_processing_crude_tonnes" UINTEGER,
  "production_iron_smelter_pig_iron_tonnes" UINTEGER,
  "production_antimony_mine_tonnes" UINTEGER,
  "production_diatomite_mine_tonnes" UINTEGER,
  "production_lead_mine_tonnes" UINTEGER,
  "production_mercury_mine_tonnes" FLOAT,
  "production_phosphate_rock_mine_tonnes" UINTEGER,
  "production_silver_mine_tonnes" FLOAT,
  "production_zinc_mine_tonnes" UINTEGER,
  "production_strontium_mine_tonnes" UINTEGER,
  "production_zinc_refinery_tonnes" UINTEGER,
  "production_lead_refinery_tonnes" UINTEGER,
  "production_feldspar_mine_tonnes" UINTEGER,
  "production_gold_mine_tonnes" FLOAT,
  "production_helium_mine_tonnes" FLOAT,
  "production_coltan_mine_columbite_tonnes" INTEGER,
  "production_graphite_mine_tonnes" UINTEGER,
  "production_phosphate_rock_guano_tonnes" UINTEGER,
  "production_salt_other_salt_tonnes" UINTEGER,
  "production_talc_and_pyrophyllite_mine_pyrophyllite_tonnes" UINTEGER,
  "production_tin_mine_tonnes" UINTEGER,
  "production_tin_smelter_tonnes" UINTEGER,
  "production_tungsten_mine_tonnes" UINTEGER,
  "production_uranium_mine_tonnes" INTEGER,
  "production_aluminum_smelter_tonnes" UINTEGER,
  "production_mica_mine_tonnes" UINTEGER,
  "production_perlite_mine_tonnes" UINTEGER,
  "production_molybdenum_mine_tonnes" UINTEGER,
  "production_rhenium_mine_tonnes" INTEGER,
  "production_bismuth_mine_tonnes" INTEGER,
  "production_selenium_refinery_tonnes" INTEGER,
  "production_coltan_mine_columbite_tantalite_tonnes" INTEGER,
  "production_platinum_group_metals_mine_other_tonnes" FLOAT,
  "production_platinum_group_metals_mine_palladium_tonnes" FLOAT,
  "production_platinum_group_metals_mine_platinum_tonnes" FLOAT,
  "production_titanium_mine_ilmenite_tonnes" UINTEGER,
  "production_titanium_mine_rutile_tonnes" UINTEGER,
  "production_zirconium_and_hafnium_mine_tonnes" UINTEGER,
  "production_alumina_refinery_tonnes" UINTEGER,
  "production_coltan_mine_tantalite_tonnes" INTEGER,
  "production_vanadium_mine_tonnes" UINTEGER,
  "production_salt_evaporated_salt_tonnes" UINTEGER,
  "production_germanium_refinery_tonnes" INTEGER,
  "production_salt_salt_in_brine_tonnes" UINTEGER,
  "production_iodine_mine_tonnes" FLOAT,
  "production_potash_unspecified_tonnes" UINTEGER,
  "production_bromine_processing_tonnes" FLOAT,
  "production_arsenic_processing_tonnes" UINTEGER,
  "production_indium_refinery_tonnes" INTEGER,
  "production_soda_ash_natural_tonnes" UINTEGER,
  "production_niobium_mine_pyrochlore_tonnes" UINTEGER,
  "production_magnesium_metal_smelter_tonnes" UINTEGER,
  "production_potash_mine_chloride_tonnes" UINTEGER,
  "production_platinum_group_metals_mine_iridium_tonnes" FLOAT,
  "production_platinum_group_metals_mine_rhodium_tonnes" FLOAT,
  "production_platinum_group_metals_mine_ruthenium_tonnes" FLOAT,
  "production_gallium_processing_tonnes" INTEGER,
  "production_diamond_mine_industrial_tonnes" FLOAT,
  "production_potash_mine_potassic_salts_tonnes" UINTEGER,
  "production_salt_brine_salt_tonnes" UINTEGER,
  "production_phosphate_rock_mine_aluminum_phosphate_tonnes" UINTEGER,
  "production_potash_mine_polyhalite_tonnes" UINTEGER
);