Climate Change Indicators: Atmospheric Concentrations Of Greenhouse Gases
@owid.ghg_concentration
@owid.ghg_concentration
CREATE TABLE owid_ghg_concentration_1 (
"year" INTEGER,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" 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
);
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
);
Anyone who has the link will be able to view this.