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