Baselight

Minerals

@owid.minerals

Loading...
Loading...

About this Dataset

Minerals

This dataset contains world production statistics for over 88 nonfuel mineral commodities.

Tables

Minerals

@owid.minerals.owid_minerals
  • 898.23 KB
  • 8380 rows
  • 305 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.