Mineral Commodity Summaries
@owid.mineral_commodity_summaries
@owid.mineral_commodity_summaries
CREATE TABLE owid_mineral_commodity_summaries (
"country" VARCHAR,
"year" INTEGER,
"commodity" VARCHAR,
"sub_commodity" VARCHAR,
"reserves" FLOAT,
"notes_reserves" VARCHAR,
"notes_production" VARCHAR,
"production" FLOAT,
"unit" VARCHAR,
"unit_production" VARCHAR,
"unit_reserves" VARCHAR
);
CREATE TABLE owid_mineral_commodity_summaries_flat (
"country" VARCHAR,
"year" INTEGER,
"production_gypsum_mine_tonnes" UINTEGER,
"production_helium_mine_tonnes" FLOAT,
"production_nitrogen_fixed_ammonia_tonnes" UINTEGER,
"production_phosphate_rock_mine_tonnes" UINTEGER,
"production_diamond_mine_industrial_tonnes" FLOAT,
"production_gemstones_mine_tonnes" FLOAT,
"production_diatomite_mine_tonnes" UINTEGER,
"production_gold_mine_tonnes" INTEGER,
"production_lithium_mine_tonnes" UINTEGER,
"production_molybdenum_mine_tonnes" UINTEGER,
"production_perlite_mine_tonnes" UINTEGER,
"production_sand_and_gravel_mine_industrial_tonnes" UINTEGER,
"production_silver_mine_tonnes" INTEGER,
"production_strontium_mine_tonnes" UINTEGER,
"production_rhenium_mine_tonnes" FLOAT,
"production_alumina_refinery_tonnes" UINTEGER,
"production_aluminum_smelter_tonnes" UINTEGER,
"production_antimony_mine_tonnes" UINTEGER,
"production_bauxite_mine_tonnes" UINTEGER,
"production_cadmium_refinery_tonnes" INTEGER,
"production_cobalt_mine_tonnes" UINTEGER,
"production_copper_mine_tonnes" UINTEGER,
"production_copper_refinery_tonnes" UINTEGER,
"production_garnet_mine_tonnes" UINTEGER,
"production_iron_ore_mine_crude_ore_tonnes" UINTEGER,
"production_iron_ore_mine_iron_content_tonnes" UINTEGER,
"production_lead_mine_tonnes" UINTEGER,
"production_lime_processing_tonnes" UINTEGER,
"production_magnesium_compounds_mine_tonnes" UINTEGER,
"production_manganese_mine_tonnes" UINTEGER,
"production_nickel_mine_tonnes" UINTEGER,
"production_rare_earths_mine_tonnes" UINTEGER,
"production_salt_mine_tonnes" UINTEGER,
"production_silicon_processing_tonnes" UINTEGER,
"production_sulfur_processing_tonnes" UINTEGER,
"production_tantalum_mine_tonnes" INTEGER,
"production_tin_mine_tonnes" UINTEGER,
"production_titanium_mine_ilmenite_tonnes" UINTEGER,
"production_titanium_mine_rutile_tonnes" UINTEGER,
"production_tungsten_mine_tonnes" UINTEGER,
"production_vanadium_mine_tonnes" UINTEGER,
"production_zinc_mine_tonnes" UINTEGER,
"production_zirconium_and_hafnium_mine_tonnes" UINTEGER,
"production_graphite_mine_tonnes" UINTEGER,
"production_bromine_processing_tonnes" UINTEGER,
"production_iodine_mine_tonnes" INTEGER,
"production_potash_mine_tonnes" UINTEGER,
"production_arsenic_processing_tonnes" INTEGER,
"production_indium_refinery_tonnes" INTEGER,
"production_selenium_refinery_tonnes" INTEGER,
"production_bismuth_refinery_tonnes" INTEGER,
"production_soda_ash_natural_tonnes" UINTEGER,
"production_asbestos_mine_tonnes" UINTEGER,
"production_beryllium_mine_tonnes" INTEGER,
"production_cement_processing_tonnes" BIGINT,
"production_feldspar_mine_tonnes" UINTEGER,
"production_iron_smelter_pig_iron_tonnes" UINTEGER,
"production_magnesium_metal_smelter_tonnes" UINTEGER,
"production_niobium_mine_tonnes" UINTEGER,
"production_steel_processing_crude_tonnes" UINTEGER,
"production_fluorspar_mine_tonnes" UINTEGER,
"production_mica_mine_scrap_and_flake_tonnes" UINTEGER,
"production_platinum_group_metals_mine_palladium_tonnes" FLOAT,
"production_platinum_group_metals_mine_platinum_tonnes" FLOAT,
"production_barite_mine_tonnes" UINTEGER,
"production_gallium_processing_tonnes" INTEGER,
"production_germanium_refinery_tonnes" INTEGER,
"production_mercury_mine_tonnes" INTEGER,
"production_mica_mine_sheet_tonnes" INTEGER,
"production_chromium_mine_gross_weight_tonnes" UINTEGER,
"production_talc_and_pyrophyllite_mine_tonnes" UINTEGER,
"production_soda_ash_natural_and_synthetic_tonnes" UINTEGER,
"production_soda_ash_synthetic_tonnes" UINTEGER,
"reserves_gypsum_mine_tonnes" UINTEGER,
"reserves_helium_mine_tonnes" UINTEGER,
"reserves_phosphate_rock_mine_tonnes" BIGINT,
"reserves_diamond_mine_industrial_tonnes" FLOAT,
"reserves_diatomite_mine_tonnes" UINTEGER,
"reserves_gold_mine_tonnes" INTEGER,
"reserves_lithium_mine_tonnes" UINTEGER,
"reserves_molybdenum_mine_tonnes" UINTEGER,
"reserves_perlite_mine_tonnes" UINTEGER,
"reserves_silver_mine_tonnes" UINTEGER,
"reserves_strontium_mine_tonnes" UINTEGER,
"reserves_rhenium_mine_tonnes" FLOAT,
"reserves_antimony_mine_tonnes" UINTEGER,
"reserves_bauxite_mine_tonnes" BIGINT,
"reserves_cobalt_mine_tonnes" UINTEGER,
"reserves_copper_mine_tonnes" UINTEGER,
"reserves_garnet_mine_tonnes" UINTEGER,
"reserves_iron_ore_mine_crude_ore_tonnes" BIGINT,
"reserves_iron_ore_mine_iron_content_tonnes" BIGINT,
"reserves_lead_mine_tonnes" UINTEGER,
"reserves_magnesium_compounds_mine_tonnes" BIGINT,
"reserves_manganese_mine_tonnes" UINTEGER,
"reserves_nickel_mine_tonnes" UINTEGER,
"reserves_rare_earths_mine_tonnes" UINTEGER,
"reserves_tantalum_mine_tonnes" UINTEGER
);
Anyone who has the link will be able to view this.