Baselight
Sign In

Historical Statistics For Mineral And Material Commodities

@owid.historical_statistics_for_mineral_and_material_commodities

Loading...
Loading...

About this Dataset

Historical Statistics For Mineral And Material Commodities

Information on mineral commodities, including production and unit value (the real and nominal price in U.S. dollars of a metric ton of apparent consumption). For many of the commodities, data are reported as far back as 1900.
The data was compiled primarily from publications of the United States Geological Survey (USGS) and the U.S. Bureau of Mines (USBM). The principal references are the annual Minerals Yearbook (MYB) publication and its predecessor, Mineral Resources of the United States (MR). Other USGS and USBM publications used as references included: Statistical Compendium (SC), Metal Prices in the United States Through 1991 (MP91), Metal Prices in the United States Through 1998 (MP98), Metal Prices in the United States Through 2010, MCS and its predecessor Commodity Data Summaries (CDS), Minerals Facts and Problems (MFP), and various USBM Information Circulars. In some cases, USGS mineral commodity specialists added previously unpublished or recently revised data to the historical statistics series.

Tables

Historical Statistics For Mineral And Material Commodities

@owid.historical_statistics_for_mineral_and_material_commodities.owid_historical_statistics_for_mineral_and_material_co_2cbfb7f0
  • 198.39 KB
  • 246 rows
  • 136 columns
Loading... 

CREATE TABLE owid_historical_statistics_for_mineral_and_material_co_2cbfb7f0 (
  "country" VARCHAR,
  "year" INTEGER,
  "production_alumina_refinery_tonnes" UINTEGER,
  "production_arsenic_processing_tonnes" UINTEGER,
  "production_asbestos_mine_tonnes" UINTEGER,
  "production_bauxite_mine_tonnes" UINTEGER,
  "production_bismuth_mine_tonnes" INTEGER,
  "production_boron_mine_tonnes" UINTEGER,
  "production_cadmium_refinery_tonnes" FLOAT,
  "production_cement_processing_tonnes" BIGINT,
  "production_sand_and_gravel_mine_construction_tonnes" BIGINT,
  "production_diatomite_mine_tonnes" UINTEGER,
  "production_feldspar_mine_tonnes" UINTEGER,
  "production_fluorspar_mine_tonnes" UINTEGER,
  "production_gallium_refinery_tonnes" FLOAT,
  "production_germanium_refinery_tonnes" FLOAT,
  "production_graphite_mine_tonnes" UINTEGER,
  "production_gypsum_mine_tonnes" UINTEGER,
  "production_helium_mine_tonnes" FLOAT,
  "production_indium_refinery_tonnes" FLOAT,
  "production_garnet_mine_tonnes" UINTEGER,
  "production_sand_and_gravel_mine_industrial_tonnes" UINTEGER,
  "production_iodine_mine_tonnes" FLOAT,
  "production_iron_ore_mine_crude_ore_tonnes" UINTEGER,
  "production_lithium_mine_tonnes" UINTEGER,
  "production_magnesium_compounds_mine_tonnes" UINTEGER,
  "production_manganese_mine_tonnes" FLOAT,
  "production_mica_mine_scrap_and_flake_tonnes" UINTEGER,
  "production_mica_mine_sheet_tonnes" FLOAT,
  "production_molybdenum_mine_tonnes" FLOAT,
  "production_nitrogen_fixed_ammonia_tonnes" UINTEGER,
  "production_perlite_mine_tonnes" UINTEGER,
  "production_phosphate_rock_mine_tonnes" UINTEGER,
  "production_potash_mine_tonnes" UINTEGER,
  "production_pumice_and_pumicite_mine_tonnes" UINTEGER,
  "production_rare_earths_mine_tonnes" FLOAT,
  "production_rhenium_mine_tonnes" FLOAT,
  "production_salt_mine_tonnes" UINTEGER,
  "production_silicon_processing_tonnes" UINTEGER,
  "production_soda_ash_natural_and_synthetic_tonnes" UINTEGER,
  "production_strontium_mine_tonnes" UINTEGER,
  "production_sulfur_processing_tonnes" UINTEGER,
  "production_talc_and_pyrophyllite_mine_tonnes" UINTEGER,
  "production_vanadium_mine_tonnes" FLOAT,
  "production_aluminum_smelter_tonnes" UINTEGER,
  "production_antimony_mine_tonnes" UINTEGER,
  "production_barite_mine_tonnes" UINTEGER,
  "production_chromium_mine_tonnes" UINTEGER,
  "production_copper_mine_tonnes" UINTEGER,
  "production_gemstones_mine_tonnes" FLOAT,
  "production_gold_mine_tonnes" INTEGER,
  "production_diamond_mine_and_synthetic_industrial_tonnes" FLOAT,
  "production_lead_mine_tonnes" UINTEGER,
  "production_lime_processing_tonnes" UINTEGER,
  "production_magnesium_metal_smelter_tonnes" UINTEGER,
  "production_mercury_mine_tonnes" INTEGER,
  "production_nickel_mine_tonnes" UINTEGER,
  "production_iron_smelter_pig_iron_tonnes" UINTEGER,
  "production_selenium_refinery_tonnes" INTEGER,
  "production_silver_mine_tonnes" INTEGER,
  "production_steel_processing_crude_tonnes" UINTEGER,
  "production_tantalum_mine_tonnes" INTEGER,
  "production_tin_mine_tonnes" UINTEGER,
  "production_tungsten_mine_tonnes" UINTEGER,
  "production_zinc_mine_tonnes" UINTEGER,
  "production_beryllium_mine_tonnes" INTEGER,
  "production_cobalt_mine_tonnes" UINTEGER,
  "production_niobium_mine_tonnes" UINTEGER,
  "production_bismuth_refinery_tonnes" INTEGER,
  "production_cobalt_refinery_tonnes" UINTEGER,
  "unit_value_alumina_refinery_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_aluminum_smelter_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_antimony_mine_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_arsenic_processing_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_asbestos_mine_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_barite_mine_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_bauxite_mine_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_beryllium_mine_constant_1998_usd_per_tonne" UINTEGER,
  "unit_value_bismuth_mine_constant_1998_usd_per_tonne" UINTEGER,
  "unit_value_boron_mine_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_cadmium_refinery_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_cement_processing_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_chromium_mine_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_cobalt_value_constant_1998_usd_per_tonne" UINTEGER,
  "unit_value_sand_and_gravel_mine_construction_constant__a8256989" FLOAT,
  "unit_value_copper_mine_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_diatomite_mine_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_feldspar_mine_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_fluorspar_mine_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_gallium_refinery_constant_1998_usd_per_tonne" UINTEGER,
  "unit_value_gemstones_mine_constant_1998_usd_per_tonne" BIGINT,
  "unit_value_germanium_refinery_constant_1998_usd_per_tonne" UINTEGER,
  "unit_value_gold_mine_constant_1998_usd_per_tonne" UINTEGER,
  "unit_value_graphite_mine_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_gypsum_mine_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_helium_mine_constant_1998_usd_per_tonne" INTEGER,
  "unit_value_indium_refinery_constant_1998_usd_per_tonne" UINTEGER,
  "unit_value_diamond_mine_and_synthetic_industrial_const_b92425a2" UINTEGER,
  "unit_value_garnet_mine_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_sand_and_gravel_mine_industrial_constant_19_cd89ce57" FLOAT
);

Historical Statistics For Mineral And Material Commodities

@owid.historical_statistics_for_mineral_and_material_commodities.owid_historical_unit_value
  • 35.7 KB
  • 7188 rows
  • 7 columns
Loading... 

CREATE TABLE owid_historical_unit_value (
  "country" VARCHAR,
  "year" INTEGER,
  "commodity" VARCHAR,
  "sub_commodity" VARCHAR,
  "unit" VARCHAR,
  "unit_value" FLOAT,
  "notes_unit_value" VARCHAR
);

Share link

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