Climate Change Indicators: Atmospheric Concentrations Of Greenhouse Gases
@owid.ghg_concentration
@owid.ghg_concentration
This indicator describes how the levels of major greenhouse gases in the atmosphere have changed over time.
The data contains concentrations of carbon dioxide in the atmosphere from hundreds of thousands of years ago through 2021, measured in parts per million (ppm). The data come from a variety of historical ice core studies and recent air monitoring sites around the world.
CREATE TABLE owid_ghg_concentration_1 (
"year" INTEGER,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT
);CREATE TABLE owid_ghg_concentration_10 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_11 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_12 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_13 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_14 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_2 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_3 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_4 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_5 (
"year" INTEGER,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT
);CREATE TABLE owid_ghg_concentration_6 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_7 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_8 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);CREATE TABLE owid_ghg_concentration_9 (
"location" VARCHAR,
"date" TIMESTAMP,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT
);Anyone who has the link will be able to view this.