Critical Minerals Dataset
@owid.critical_minerals
@owid.critical_minerals
CREATE TABLE owid_demand_by_scenario (
"scenario" VARCHAR,
"year" INTEGER,
"demand_graphite_battery_grade_grid_battery_storage" FLOAT,
"demand_cobalt_grid_battery_storage" FLOAT,
"demand_copper_grid_battery_storage" FLOAT,
"demand_lithium_grid_battery_storage" FLOAT,
"demand_manganese_grid_battery_storage" FLOAT,
"demand_nickel_grid_battery_storage" FLOAT,
"demand_silicon_grid_battery_storage" FLOAT,
"demand_vanadium_grid_battery_storage" FLOAT,
"demand_graphite_battery_grade_electric_vehicles" FLOAT,
"demand_cobalt_electric_vehicles" FLOAT,
"demand_copper_electric_vehicles" FLOAT,
"demand_lithium_electric_vehicles" FLOAT,
"demand_manganese_electric_vehicles" FLOAT,
"demand_nickel_electric_vehicles" FLOAT,
"demand_silicon_electric_vehicles" FLOAT,
"demand_cobalt_hydrogen_technologies" FLOAT,
"demand_copper_hydrogen_technologies" FLOAT,
"demand_iridium_hydrogen_technologies" FLOAT,
"demand_nickel_hydrogen_technologies" FLOAT,
"demand_pgms_other_than_iridium_hydrogen_technologies" FLOAT,
"demand_yttrium_hydrogen_technologies" FLOAT,
"demand_zirconium_hydrogen_technologies" FLOAT,
"demand_arsenic_solar_pv" FLOAT,
"demand_cadmium_solar_pv" FLOAT,
"demand_copper_solar_pv" FLOAT,
"demand_gallium_solar_pv" FLOAT,
"demand_germanium_solar_pv" FLOAT,
"demand_indium_solar_pv" FLOAT,
"demand_lead_solar_pv" FLOAT,
"demand_molybdenum_solar_pv" FLOAT,
"demand_nickel_solar_pv" FLOAT,
"demand_selenium_solar_pv" FLOAT,
"demand_silicon_solar_pv" FLOAT,
"demand_silver_solar_pv" FLOAT,
"demand_tellurium_solar_pv" FLOAT,
"demand_tin_solar_pv" FLOAT,
"demand_zinc_solar_pv" FLOAT,
"demand_boron_wind" FLOAT,
"demand_chromium_wind" FLOAT,
"demand_copper_wind" FLOAT,
"demand_manganese_wind" FLOAT,
"demand_molybdenum_wind" FLOAT,
"demand_nickel_wind" FLOAT,
"demand_zinc_wind" FLOAT,
"demand_magnet_rare_earth_elements_electric_vehicles" FLOAT,
"demand_magnet_rare_earth_elements_wind" FLOAT,
"demand_graphite_other_than_battery_grade_grid_battery_storage" FLOAT,
"demand_graphite_other_than_battery_grade_electric_vehicles" FLOAT
);
CREATE TABLE owid_demand_by_technology (
"technology" VARCHAR,
"year" INTEGER,
"demand_graphite_battery_grade_refinery_base_case_annou_e2b1e60c" UINTEGER,
"demand_graphite_battery_grade_refinery_base_case_net_z_1251363c" UINTEGER,
"demand_graphite_battery_grade_refinery_base_case_state_19a28fc9" UINTEGER,
"demand_cobalt_refinery_base_case_announced_pledges" FLOAT,
"demand_cobalt_refinery_base_case_net_zero_by_2050" FLOAT,
"demand_cobalt_refinery_base_case_stated_policies" FLOAT,
"demand_copper_refinery_base_case_announced_pledges" FLOAT,
"demand_copper_refinery_base_case_net_zero_by_2050" FLOAT,
"demand_copper_refinery_base_case_stated_policies" FLOAT,
"demand_lithium_refinery_base_case_announced_pledges" FLOAT,
"demand_lithium_refinery_base_case_net_zero_by_2050" FLOAT,
"demand_lithium_refinery_base_case_stated_policies" FLOAT,
"demand_manganese_refinery_base_case_announced_pledges" FLOAT,
"demand_manganese_refinery_base_case_net_zero_by_2050" FLOAT,
"demand_manganese_refinery_base_case_stated_policies" FLOAT,
"demand_nickel_refinery_base_case_announced_pledges" FLOAT,
"demand_nickel_refinery_base_case_net_zero_by_2050" FLOAT,
"demand_nickel_refinery_base_case_stated_policies" FLOAT,
"demand_silicon_refinery_base_case_announced_pledges" FLOAT,
"demand_silicon_refinery_base_case_net_zero_by_2050" FLOAT,
"demand_silicon_refinery_base_case_stated_policies" FLOAT,
"demand_vanadium_refinery_base_case_announced_pledges" UINTEGER,
"demand_vanadium_refinery_base_case_net_zero_by_2050" UINTEGER,
"demand_vanadium_refinery_base_case_stated_policies" FLOAT,
"demand_copper_refinery_wider_direct_current_dc_technol_d982256e" UINTEGER,
"demand_copper_refinery_wider_direct_current_dc_technol_899368ba" UINTEGER,
"demand_copper_refinery_wider_direct_current_dc_technol_5ab92baf" UINTEGER,
"demand_graphite_battery_grade_refinery_faster_uptake_o_9c287d0a" UINTEGER,
"demand_graphite_battery_grade_refinery_faster_uptake_o_cfe659e9" UINTEGER,
"demand_graphite_battery_grade_refinery_faster_uptake_o_e392308f" UINTEGER,
"demand_cobalt_refinery_faster_uptake_of_solid_state_ba_55946774" FLOAT,
"demand_cobalt_refinery_faster_uptake_of_solid_state_ba_a0368d17" FLOAT,
"demand_cobalt_refinery_faster_uptake_of_solid_state_ba_fa979425" FLOAT,
"demand_copper_refinery_faster_uptake_of_solid_state_ba_f7567ba3" UINTEGER,
"demand_copper_refinery_faster_uptake_of_solid_state_ba_8e937262" UINTEGER,
"demand_copper_refinery_faster_uptake_of_solid_state_ba_5e028106" UINTEGER,
"demand_lithium_refinery_faster_uptake_of_solid_state_b_371bacd5" UINTEGER,
"demand_lithium_refinery_faster_uptake_of_solid_state_b_e6e3e268" UINTEGER,
"demand_lithium_refinery_faster_uptake_of_solid_state_b_7ca33a30" UINTEGER,
"demand_manganese_refinery_faster_uptake_of_solid_state_8a593208" FLOAT,
"demand_manganese_refinery_faster_uptake_of_solid_state_db8a960d" FLOAT,
"demand_manganese_refinery_faster_uptake_of_solid_state_e1b0455c" FLOAT,
"demand_nickel_refinery_faster_uptake_of_solid_state_ba_e749ba15" UINTEGER,
"demand_nickel_refinery_faster_uptake_of_solid_state_ba_09af09f2" UINTEGER,
"demand_nickel_refinery_faster_uptake_of_solid_state_ba_27f7630f" UINTEGER,
"demand_silicon_refinery_faster_uptake_of_solid_state_b_91833a8a" UINTEGER,
"demand_silicon_refinery_faster_uptake_of_solid_state_b_9844b13a" UINTEGER,
"demand_silicon_refinery_faster_uptake_of_solid_state_b_5c230ea2" UINTEGER,
"demand_graphite_battery_grade_refinery_high_material_p_64a22774" UINTEGER,
"demand_graphite_battery_grade_refinery_high_material_p_811a9fa3" UINTEGER,
"demand_graphite_battery_grade_refinery_high_material_p_78b108fd" UINTEGER,
"demand_cobalt_refinery_high_material_prices_announced_pledges" FLOAT,
"demand_cobalt_refinery_high_material_prices_net_zero_by_2050" FLOAT,
"demand_cobalt_refinery_high_material_prices_stated_policies" FLOAT,
"demand_copper_refinery_high_material_prices_announced_pledges" UINTEGER,
"demand_copper_refinery_high_material_prices_net_zero_by_2050" UINTEGER,
"demand_copper_refinery_high_material_prices_stated_policies" UINTEGER,
"demand_lithium_refinery_high_material_prices_announced_pledges" UINTEGER,
"demand_lithium_refinery_high_material_prices_net_zero_by_2050" UINTEGER,
"demand_lithium_refinery_high_material_prices_stated_policies" UINTEGER,
"demand_manganese_refinery_high_material_prices_announc_dd3dbc17" FLOAT,
"demand_manganese_refinery_high_material_prices_net_zero_by_2050" FLOAT,
"demand_manganese_refinery_high_material_prices_stated_policies" FLOAT,
"demand_nickel_refinery_high_material_prices_announced_pledges" UINTEGER,
"demand_nickel_refinery_high_material_prices_net_zero_by_2050" UINTEGER,
"demand_nickel_refinery_high_material_prices_stated_policies" UINTEGER,
"demand_silicon_refinery_high_material_prices_announced_pledges" UINTEGER,
"demand_silicon_refinery_high_material_prices_net_zero_by_2050" UINTEGER,
"demand_silicon_refinery_high_material_prices_stated_policies" UINTEGER,
"demand_graphite_battery_grade_refinery_limited_battery_885a5554" UINTEGER,
"demand_cobalt_refinery_limited_battery_size_reduction__561d1554" FLOAT,
"demand_copper_refinery_limited_battery_size_reduction__d186f1df" UINTEGER,
"demand_lithium_refinery_limited_battery_size_reduction_3edbbfd8" UINTEGER,
"demand_manganese_refinery_limited_battery_size_reducti_f33576a4" FLOAT,
"demand_nickel_refinery_limited_battery_size_reduction__d1e7cf84" UINTEGER,
"demand_silicon_refinery_limited_battery_size_reduction_4d4e5501" UINTEGER,
"demand_graphite_battery_grade_refinery_lower_battery_s_9dcb0127" UINTEGER,
"demand_graphite_battery_grade_refinery_lower_battery_s_de734a17" UINTEGER,
"demand_cobalt_refinery_lower_battery_sizes_announced_pledges" FLOAT,
"demand_cobalt_refinery_lower_battery_sizes_stated_policies" FLOAT,
"demand_copper_refinery_lower_battery_sizes_announced_pledges" UINTEGER,
"demand_copper_refinery_lower_battery_sizes_stated_policies" UINTEGER,
"demand_lithium_refinery_lower_battery_sizes_announced_pledges" UINTEGER,
"demand_lithium_refinery_lower_battery_sizes_stated_policies" UINTEGER,
"demand_manganese_refinery_lower_battery_sizes_announced_pledges" UINTEGER,
"demand_manganese_refinery_lower_battery_sizes_stated_policies" UINTEGER,
"demand_nickel_refinery_lower_battery_sizes_announced_pledges" UINTEGER,
"demand_nickel_refinery_lower_battery_sizes_stated_policies" UINTEGER,
"demand_silicon_refinery_lower_battery_sizes_announced_pledges" UINTEGER,
"demand_silicon_refinery_lower_battery_sizes_stated_policies" UINTEGER,
"demand_graphite_battery_grade_refinery_wider_use_of_si_8474d49c" UINTEGER,
"demand_graphite_battery_grade_refinery_wider_use_of_si_0ca5dfea" UINTEGER,
"demand_graphite_battery_grade_refinery_wider_use_of_si_cf54ea86" UINTEGER,
"demand_cobalt_refinery_wider_use_of_silicon_rich_anode_9e70f827" FLOAT,
"demand_cobalt_refinery_wider_use_of_silicon_rich_anode_11b9a840" FLOAT,
"demand_cobalt_refinery_wider_use_of_silicon_rich_anode_c62ae8b4" FLOAT,
"demand_copper_refinery_wider_use_of_silicon_rich_anode_22ded85f" UINTEGER,
"demand_copper_refinery_wider_use_of_silicon_rich_anode_59849e94" UINTEGER
);
CREATE TABLE owid_demand_for_key_minerals (
"case" VARCHAR,
"year" INTEGER,
"mineral" VARCHAR,
"process" VARCHAR,
"scenario" VARCHAR,
"technology" VARCHAR,
"demand" FLOAT,
"demand_as_a_share_of_global_demand" FLOAT,
"demand_as_a_share_of_global_supply" FLOAT
);
CREATE TABLE owid_supply_by_country (
"country" VARCHAR,
"year" INTEGER,
"supply_lithium_refinery_base_case_all_scenarios" UINTEGER,
"supply_lithium_mine_base_case_all_scenarios" FLOAT,
"supply_cobalt_mine_base_case_all_scenarios" UINTEGER,
"supply_magnet_rare_earth_elements_mine_base_case_all_scenarios" UINTEGER,
"supply_magnet_rare_earth_elements_refinery_base_case_a_0c3a31fd" UINTEGER,
"supply_nickel_mine_base_case_all_scenarios" UINTEGER,
"supply_nickel_refinery_base_case_all_scenarios" UINTEGER,
"supply_graphite_mine_base_case_all_scenarios" UINTEGER,
"supply_cobalt_refinery_base_case_all_scenarios" FLOAT,
"supply_graphite_refinery_base_case_all_scenarios" UINTEGER,
"supply_copper_mine_base_case_all_scenarios" UINTEGER,
"supply_copper_refinery_base_case_all_scenarios" UINTEGER,
"supply_as_a_share_of_global_demand_lithium_refinery_ba_bfd02016" FLOAT,
"supply_as_a_share_of_global_demand_lithium_refinery_ba_edb50079" FLOAT,
"supply_as_a_share_of_global_demand_lithium_refinery_ba_af56a131" FLOAT,
"supply_as_a_share_of_global_demand_magnet_rare_earth_e_bfcd2c26" FLOAT,
"supply_as_a_share_of_global_demand_magnet_rare_earth_e_28d93a48" FLOAT,
"supply_as_a_share_of_global_demand_magnet_rare_earth_e_53d7a631" FLOAT,
"supply_as_a_share_of_global_demand_nickel_refinery_bas_e6bcafc2" FLOAT,
"supply_as_a_share_of_global_demand_nickel_refinery_bas_0503ab81" FLOAT,
"supply_as_a_share_of_global_demand_nickel_refinery_bas_2256da7d" FLOAT,
"supply_as_a_share_of_global_demand_cobalt_refinery_bas_a623a3e4" FLOAT,
"supply_as_a_share_of_global_demand_cobalt_refinery_bas_22db210c" FLOAT,
"supply_as_a_share_of_global_demand_cobalt_refinery_bas_f8899c21" FLOAT,
"supply_as_a_share_of_global_demand_copper_refinery_bas_d6da7ff6" FLOAT,
"supply_as_a_share_of_global_demand_copper_refinery_bas_fe6eb9dd" FLOAT,
"supply_as_a_share_of_global_demand_copper_refinery_bas_dfd38f2e" FLOAT,
"supply_as_a_share_of_global_supply_lithium_refinery_ba_3eae8cea" FLOAT,
"supply_as_a_share_of_global_supply_lithium_mine_base_c_c3e8b5c3" FLOAT,
"supply_as_a_share_of_global_supply_cobalt_mine_base_ca_787496fa" FLOAT,
"supply_as_a_share_of_global_supply_magnet_rare_earth_e_fc1e8c39" FLOAT,
"supply_as_a_share_of_global_supply_magnet_rare_earth_e_7f4ee8a3" FLOAT,
"supply_as_a_share_of_global_supply_nickel_mine_base_ca_ac502578" FLOAT,
"supply_as_a_share_of_global_supply_nickel_refinery_bas_f9a3459d" FLOAT,
"supply_as_a_share_of_global_supply_graphite_mine_base__f46ba933" FLOAT,
"supply_as_a_share_of_global_supply_cobalt_refinery_bas_094054b2" FLOAT,
"supply_as_a_share_of_global_supply_graphite_refinery_b_b0b58e4b" FLOAT,
"supply_as_a_share_of_global_supply_copper_mine_base_ca_3df2b540" FLOAT,
"supply_as_a_share_of_global_supply_copper_refinery_bas_957f98d3" FLOAT
);
CREATE TABLE owid_supply_for_key_minerals (
"case" VARCHAR,
"country" VARCHAR,
"year" INTEGER,
"mineral" VARCHAR,
"process" VARCHAR,
"scenario" VARCHAR,
"supply" FLOAT,
"supply_as_a_share_of_global_demand" FLOAT,
"supply_as_a_share_of_global_supply" FLOAT
);
Anyone who has the link will be able to view this.