Minerals
@owid.minerals
@owid.minerals
CREATE TABLE owid_minerals (
"country" VARCHAR,
"year" INTEGER,
"production_aluminum_smelter_tonnes" UINTEGER,
"production_antimony_mine_tonnes" UINTEGER,
"production_arsenic_processing_tonnes" UINTEGER,
"production_asbestos_mine_tonnes" UINTEGER,
"production_barite_mine_tonnes" UINTEGER,
"production_bauxite_mine_tonnes" UINTEGER,
"production_beryllium_mine_tonnes" INTEGER,
"production_bismuth_mine_tonnes" INTEGER,
"production_bismuth_refinery_tonnes" INTEGER,
"production_boron_mine_tonnes" UINTEGER,
"production_cadmium_refinery_tonnes" FLOAT,
"production_cement_processing_tonnes" BIGINT,
"production_chromium_mine_gross_weight_tonnes" UINTEGER,
"production_chromium_mine_tonnes" UINTEGER,
"production_coal_mine_tonnes" BIGINT,
"production_cobalt_mine_tonnes" UINTEGER,
"production_cobalt_refinery_tonnes" UINTEGER,
"production_coltan_mine_columbite_tantalite_tonnes" INTEGER,
"production_coltan_mine_columbite_tonnes" INTEGER,
"production_coltan_mine_tantalite_tonnes" INTEGER,
"production_copper_mine_tonnes" UINTEGER,
"production_copper_refinery_tonnes" UINTEGER,
"production_copper_smelter_tonnes" UINTEGER,
"production_diamond_mine_and_synthetic_industrial_tonnes" FLOAT,
"production_diamond_mine_industrial_tonnes" FLOAT,
"production_feldspar_mine_tonnes" UINTEGER,
"production_fluorspar_mine_tonnes" UINTEGER,
"production_gallium_processing_tonnes" INTEGER,
"production_gallium_refinery_tonnes" FLOAT,
"production_garnet_mine_tonnes" UINTEGER,
"production_gemstones_mine_tonnes" FLOAT,
"production_germanium_refinery_tonnes" FLOAT,
"production_gold_mine_tonnes" FLOAT,
"production_graphite_mine_tonnes" UINTEGER,
"production_gypsum_mine_tonnes" UINTEGER,
"production_helium_mine_tonnes" FLOAT,
"production_iodine_mine_tonnes" FLOAT,
"production_iron_ore_mine_crude_ore_tonnes" UINTEGER,
"production_iron_ore_mine_iron_content_tonnes" UINTEGER,
"production_iron_smelter_pig_iron_tonnes" UINTEGER,
"production_lead_mine_tonnes" UINTEGER,
"production_lead_refinery_tonnes" UINTEGER,
"production_lime_processing_tonnes" UINTEGER,
"production_lithium_mine_tonnes" UINTEGER,
"production_magnesium_compounds_mine_tonnes" UINTEGER,
"production_magnesium_metal_smelter_tonnes" UINTEGER,
"production_manganese_mine_tonnes" FLOAT,
"production_mercury_mine_tonnes" FLOAT,
"production_mica_mine_scrap_and_flake_tonnes" UINTEGER,
"production_mica_mine_sheet_tonnes" FLOAT,
"production_mica_mine_tonnes" UINTEGER,
"production_molybdenum_mine_tonnes" FLOAT,
"production_nickel_mine_tonnes" UINTEGER,
"production_nickel_processing_tonnes" UINTEGER,
"production_niobium_mine_pyrochlore_tonnes" UINTEGER,
"production_niobium_mine_tonnes" UINTEGER,
"production_nitrogen_fixed_ammonia_tonnes" UINTEGER,
"production_petroleum_crude_tonnes" BIGINT,
"production_phosphate_rock_guano_tonnes" UINTEGER,
"production_phosphate_rock_mine_aluminum_phosphate_tonnes" UINTEGER,
"production_phosphate_rock_mine_tonnes" UINTEGER,
"production_platinum_group_metals_mine_iridium_tonnes" FLOAT,
"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_platinum_group_metals_mine_rhodium_tonnes" FLOAT,
"production_platinum_group_metals_mine_ruthenium_tonnes" FLOAT,
"production_potash_mine_chloride_tonnes" UINTEGER,
"production_potash_mine_polyhalite_tonnes" UINTEGER,
"production_potash_mine_potassic_salts_tonnes" UINTEGER,
"production_potash_mine_tonnes" UINTEGER,
"production_potash_unspecified_tonnes" UINTEGER,
"production_rare_earths_mine_tonnes" FLOAT,
"production_salt_mine_tonnes" UINTEGER,
"production_sand_and_gravel_mine_construction_tonnes" BIGINT,
"production_sand_and_gravel_mine_industrial_tonnes" UINTEGER,
"production_selenium_refinery_tonnes" INTEGER,
"production_silicon_processing_tonnes" UINTEGER,
"production_silver_mine_tonnes" FLOAT,
"production_steel_processing_crude_tonnes" UINTEGER,
"production_strontium_mine_tonnes" UINTEGER,
"production_sulfur_processing_tonnes" UINTEGER,
"production_talc_and_pyrophyllite_mine_pyrophyllite_tonnes" UINTEGER,
"production_talc_and_pyrophyllite_mine_tonnes" UINTEGER,
"production_tantalum_mine_tonnes" INTEGER,
"production_tin_mine_tonnes" UINTEGER,
"production_tin_smelter_tonnes" UINTEGER,
"production_titanium_mine_ilmenite_tonnes" UINTEGER,
"production_titanium_mine_rutile_tonnes" UINTEGER,
"production_tungsten_mine_tonnes" UINTEGER,
"production_uranium_mine_tonnes" INTEGER,
"production_vanadium_mine_tonnes" FLOAT,
"production_zinc_mine_tonnes" UINTEGER,
"production_zinc_refinery_tonnes" UINTEGER,
"production_zirconium_and_hafnium_mine_tonnes" UINTEGER,
"reserves_antimony_mine_tonnes" UINTEGER,
"reserves_asbestos_mine_tonnes" UINTEGER,
"reserves_barite_mine_tonnes" UINTEGER
);
Anyone who has the link will be able to view this.