Air Transport CO2 Emissions
@owid.co2_air_transport
@owid.co2_air_transport
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,
"n__2020_total_emissions" FLOAT,
"n__2021_total_emissions" FLOAT,
"n__2022_total_emissions" FLOAT,
"n__2023_total_emissions" FLOAT,
"n__2024_total_emissions" FLOAT,
"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.