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

203.15 kB
246 rows
136 columns

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 Sand And Gravel Mine, Construction Tonnes,
  "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 Sand And Gravel Mine, Industrial Tonnes,
  "production_iodine_mine_tonnes" FLOAT,
  "production_iron_ore_mine_crude_ore_tonnes" UINTEGER  -- Production Iron Ore Mine, Crude Ore Tonnes,
  "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, Scrap And Flake Tonnes,
  "production_mica_mine_sheet_tonnes" FLOAT  -- Production Mica Mine, Sheet Tonnes,
  "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 Diamond Mine And Synthetic, Industrial Tonnes,
  "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 Iron Smelter, Pig Iron Tonnes,
  "production_selenium_refinery_tonnes" INTEGER,
  "production_silver_mine_tonnes" INTEGER,
  "production_steel_processing_crude_tonnes" UINTEGER  -- Production Steel Processing, Crude Tonnes,
  "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 Sand And Gravel Mine, Construction Constant 1998 Usd Per Tonne,
  "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 Diamond Mine And Synthetic, Industrial Constant 1998 Usd Per Tonne,
  "unit_value_garnet_mine_constant_1998_usd_per_tonne" FLOAT,
  "unit_value_sand_and_gravel_mine_industrial_constant_19_cd89ce57" FLOAT  -- Unit Value Sand And Gravel Mine, Industrial Constant 1998 Usd Per Tonne
);

Historical Statistics For Mineral And Material Commodities

@owid.historical_statistics_for_mineral_and_material_commodities.owid_historical_unit_value

36.56 kB
7,188 rows
7 columns

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