Air Transport CO2 Emissions
@owid.co2_air_transport
@owid.co2_air_transport
The OECD Air Transport CO₂ Emissions database includes annual, quarterly, and monthly information on CO₂ emissions related to commercial passenger, freight, and general aviation flights, on both a territory and a residence basis, for 186 countries. These CO₂ emissions are estimated by the OECD, based on a consistent methodology across countries.
OECD database is updated by the end of the first month of each quarter with new data from the previous quarter.
CREATE TABLE owid_co2_air_transport_1 (
"country" VARCHAR,
"year" INTEGER,
"ter_dom_a" FLOAT,
"ter_int_a" FLOAT,
"per_capita_ter_dom_a" FLOAT,
"per_capita_ter_int_a" FLOAT,
"int_inb_out_per_capita" FLOAT,
"int_inb_out_tot" FLOAT,
"ter_dom_m" FLOAT,
"ter_int_m" FLOAT,
"total_monthly_emissions" FLOAT
);CREATE TABLE owid_co2_air_transport_2 (
"country" VARCHAR,
"year" INTEGER,
"ter_dom_a" FLOAT,
"ter_int_a" FLOAT,
"per_capita_ter_dom_a" FLOAT,
"per_capita_ter_int_a" FLOAT,
"int_inb_out_per_capita" FLOAT,
"int_inb_out_tot" FLOAT,
"ter_dom_m" FLOAT,
"ter_int_m" FLOAT,
"per_capita_ter_dom_m" FLOAT,
"per_capita_ter_int_m" FLOAT,
"total_monthly_emissions" FLOAT
);CREATE TABLE owid_co2_air_transport_3 (
"country" VARCHAR,
"year" INTEGER,
"ter_dom_a" FLOAT,
"ter_int_a" FLOAT,
"per_capita_ter_dom_a" FLOAT,
"per_capita_ter_int_a" FLOAT,
"int_inb_out_per_capita" FLOAT,
"int_inb_out_tot" FLOAT,
"ter_dom_m" FLOAT,
"ter_int_m" FLOAT,
"per_capita_ter_dom_m" FLOAT,
"per_capita_ter_int_m" FLOAT,
"total_monthly_emissions" FLOAT
);CREATE TABLE owid_co2_air_transport_4 (
"country" VARCHAR,
"year" INTEGER,
"ter_dom_a" FLOAT,
"ter_int_a" FLOAT,
"total_annual_emissions" FLOAT,
"per_capita_ter_dom_a" FLOAT,
"per_capita_ter_int_a" FLOAT,
"per_capita_total_annual_emissions" FLOAT,
"int_inb_out_per_capita" FLOAT,
"int_inb_out_tot" FLOAT,
"ter_dom_m" FLOAT,
"ter_int_m" FLOAT,
"n__2019_total_emissions" FLOAT -- 2019 Total Emissions,
"n__2020_total_emissions" FLOAT -- 2020 Total Emissions,
"n__2021_total_emissions" FLOAT -- 2021 Total Emissions,
"n__2022_total_emissions" FLOAT -- 2022 Total Emissions,
"n__2023_total_emissions" FLOAT -- 2023 Total Emissions,
"n__2024_total_emissions" FLOAT -- 2024 Total Emissions,
"per_capita_ter_dom_m" FLOAT,
"per_capita_ter_int_m" FLOAT,
"total_monthly_emissions" FLOAT
);Anyone who has the link will be able to view this.