National Contributions To Climate Change
@owid.national_contributions
@owid.national_contributions
CREATE TABLE owid_national_contributions_1 (
"country" VARCHAR,
"year" INTEGER,
"annual_emissions_ch4_fossil" FLOAT,
"annual_emissions_ch4_land" FLOAT,
"annual_emissions_ch4_total" FLOAT,
"annual_emissions_co2_fossil" FLOAT,
"annual_emissions_co2_total" FLOAT,
"annual_emissions_n2o_fossil" FLOAT,
"annual_emissions_n2o_land" FLOAT,
"annual_emissions_n2o_total" FLOAT,
"annual_emissions_co2_land" FLOAT,
"cumulative_emissions_ghg_fossil" FLOAT,
"cumulative_emissions_ghg_land" FLOAT,
"cumulative_emissions_ghg_total" FLOAT,
"cumulative_emissions_ch4_fossil" FLOAT,
"cumulative_emissions_ch4_land" FLOAT,
"cumulative_emissions_ch4_total" FLOAT,
"cumulative_emissions_co2_fossil" FLOAT,
"cumulative_emissions_co2_land" FLOAT,
"cumulative_emissions_co2_total" FLOAT,
"cumulative_emissions_n2o_fossil" FLOAT,
"cumulative_emissions_n2o_land" FLOAT,
"cumulative_emissions_n2o_total" FLOAT,
"temperature_response_ghg_fossil" FLOAT,
"temperature_response_ghg_land" FLOAT,
"temperature_response_ghg_total" FLOAT,
"temperature_response_ch4_fossil" FLOAT,
"temperature_response_ch4_land" FLOAT,
"temperature_response_ch4_total" FLOAT,
"temperature_response_co2_fossil" FLOAT,
"temperature_response_co2_land" FLOAT,
"temperature_response_co2_total" FLOAT,
"temperature_response_n2o_fossil" FLOAT,
"temperature_response_n2o_land" FLOAT,
"temperature_response_n2o_total" FLOAT,
"annual_emissions_ch4_fossil_co2eq" FLOAT,
"annual_emissions_ch4_land_co2eq" FLOAT,
"annual_emissions_ch4_total_co2eq" FLOAT,
"annual_emissions_n2o_fossil_co2eq" FLOAT,
"annual_emissions_n2o_land_co2eq" FLOAT,
"annual_emissions_n2o_total_co2eq" FLOAT,
"annual_emissions_ghg_fossil_co2eq" FLOAT,
"annual_emissions_ghg_land_co2eq" FLOAT,
"annual_emissions_ghg_total_co2eq" FLOAT,
"share_of_annual_emissions_ch4_total" FLOAT,
"share_of_annual_emissions_co2_total" FLOAT,
"share_of_annual_emissions_n2o_total" FLOAT,
"share_of_annual_emissions_ghg_total" FLOAT,
"share_of_temperature_response_ghg_total" FLOAT,
"annual_emissions_ch4_total_co2eq_per_capita" FLOAT,
"annual_emissions_co2_total_per_capita" FLOAT,
"annual_emissions_n2o_total_co2eq_per_capita" FLOAT,
"annual_emissions_ghg_total_co2eq_per_capita" FLOAT
);
CREATE TABLE owid_national_contributions_2 (
"country" VARCHAR,
"year" INTEGER,
"annual_emissions_ch4_fossil" FLOAT,
"annual_emissions_ch4_land" FLOAT,
"annual_emissions_ch4_total" FLOAT,
"annual_emissions_co2_fossil" FLOAT,
"annual_emissions_co2_total" FLOAT,
"annual_emissions_n2o_fossil" FLOAT,
"annual_emissions_n2o_land" FLOAT,
"annual_emissions_n2o_total" FLOAT,
"annual_emissions_co2_land" FLOAT,
"cumulative_emissions_ghg_fossil" FLOAT,
"cumulative_emissions_ghg_land" FLOAT,
"cumulative_emissions_ghg_total" FLOAT,
"cumulative_emissions_ch4_fossil" FLOAT,
"cumulative_emissions_ch4_land" FLOAT,
"cumulative_emissions_ch4_total" FLOAT,
"cumulative_emissions_co2_fossil" FLOAT,
"cumulative_emissions_co2_land" FLOAT,
"cumulative_emissions_co2_total" FLOAT,
"cumulative_emissions_n2o_fossil" FLOAT,
"cumulative_emissions_n2o_land" FLOAT,
"cumulative_emissions_n2o_total" FLOAT,
"temperature_response_ghg_fossil" FLOAT,
"temperature_response_ghg_land" FLOAT,
"temperature_response_ghg_total" FLOAT,
"temperature_response_ch4_fossil" FLOAT,
"temperature_response_ch4_land" FLOAT,
"temperature_response_ch4_total" FLOAT,
"temperature_response_co2_fossil" FLOAT,
"temperature_response_co2_land" FLOAT,
"temperature_response_co2_total" FLOAT,
"temperature_response_n2o_fossil" FLOAT,
"temperature_response_n2o_land" FLOAT,
"temperature_response_n2o_total" FLOAT,
"annual_emissions_ch4_fossil_co2eq" FLOAT,
"annual_emissions_ch4_land_co2eq" FLOAT,
"annual_emissions_ch4_total_co2eq" FLOAT,
"annual_emissions_n2o_fossil_co2eq" FLOAT,
"annual_emissions_n2o_land_co2eq" FLOAT,
"annual_emissions_n2o_total_co2eq" FLOAT,
"annual_emissions_ghg_fossil_co2eq" FLOAT,
"annual_emissions_ghg_land_co2eq" FLOAT,
"annual_emissions_ghg_total_co2eq" FLOAT,
"share_of_annual_emissions_ch4_total" FLOAT,
"share_of_annual_emissions_co2_total" FLOAT,
"share_of_annual_emissions_n2o_total" FLOAT,
"share_of_annual_emissions_ghg_total" FLOAT,
"share_of_temperature_response_ghg_total" FLOAT,
"annual_emissions_ch4_total_co2eq_per_capita" FLOAT,
"annual_emissions_co2_total_per_capita" FLOAT,
"annual_emissions_n2o_total_co2eq_per_capita" FLOAT,
"annual_emissions_ghg_total_co2eq_per_capita" FLOAT
);
CREATE TABLE owid_national_contributions_3 (
"country" VARCHAR,
"year" INTEGER,
"annual_emissions_ch4_fossil" FLOAT,
"annual_emissions_ch4_land" FLOAT,
"annual_emissions_ch4_total" FLOAT,
"annual_emissions_co2_fossil" FLOAT,
"annual_emissions_co2_total" FLOAT,
"annual_emissions_n2o_fossil" FLOAT,
"annual_emissions_n2o_land" FLOAT,
"annual_emissions_n2o_total" FLOAT,
"annual_emissions_co2_land" FLOAT,
"cumulative_emissions_ghg_fossil" FLOAT,
"cumulative_emissions_ghg_land" FLOAT,
"cumulative_emissions_ghg_total" FLOAT,
"cumulative_emissions_ch4_fossil" FLOAT,
"cumulative_emissions_ch4_land" FLOAT,
"cumulative_emissions_ch4_total" FLOAT,
"cumulative_emissions_co2_fossil" FLOAT,
"cumulative_emissions_co2_land" FLOAT,
"cumulative_emissions_co2_total" FLOAT,
"cumulative_emissions_n2o_fossil" FLOAT,
"cumulative_emissions_n2o_land" FLOAT,
"cumulative_emissions_n2o_total" FLOAT,
"temperature_response_ghg_fossil" FLOAT,
"temperature_response_ghg_land" FLOAT,
"temperature_response_ghg_total" FLOAT,
"temperature_response_ch4_fossil" FLOAT,
"temperature_response_ch4_land" FLOAT,
"temperature_response_ch4_total" FLOAT,
"temperature_response_co2_fossil" FLOAT,
"temperature_response_co2_land" FLOAT,
"temperature_response_co2_total" FLOAT,
"temperature_response_n2o_fossil" FLOAT,
"temperature_response_n2o_land" FLOAT,
"temperature_response_n2o_total" FLOAT,
"annual_emissions_ch4_fossil_co2eq" FLOAT,
"annual_emissions_ch4_land_co2eq" FLOAT,
"annual_emissions_ch4_total_co2eq" FLOAT,
"annual_emissions_n2o_fossil_co2eq" FLOAT,
"annual_emissions_n2o_land_co2eq" FLOAT,
"annual_emissions_n2o_total_co2eq" FLOAT,
"annual_emissions_ghg_fossil_co2eq" FLOAT,
"annual_emissions_ghg_land_co2eq" FLOAT,
"annual_emissions_ghg_total_co2eq" FLOAT,
"share_of_annual_emissions_ch4_total" FLOAT,
"share_of_annual_emissions_co2_total" FLOAT,
"share_of_annual_emissions_n2o_total" FLOAT,
"share_of_annual_emissions_ghg_total" FLOAT,
"share_of_temperature_response_ghg_total" FLOAT,
"annual_emissions_ch4_total_co2eq_per_capita" FLOAT,
"annual_emissions_co2_total_per_capita" FLOAT,
"annual_emissions_co2_fossil_per_capita" FLOAT,
"annual_emissions_n2o_total_co2eq_per_capita" FLOAT,
"annual_emissions_ghg_total_co2eq_per_capita" FLOAT,
"annual_emissions_ghg_fossil_co2eq_per_capita" FLOAT
);
Anyone who has the link will be able to view this.