Greenhouse Gas Emissions By Sector
@owid.emissions_by_sector
@owid.emissions_by_sector
CREATE TABLE owid_carbon_dioxide_emissions_by_sector_1 (
"country" VARCHAR,
"year" INTEGER,
"aviation_and_shipping_co2_emissions" FLOAT,
"aviation_and_shipping_co2_emissions_per_capita" FLOAT,
"buildings_co2_emissions" FLOAT,
"buildings_co2_emissions_per_capita" FLOAT,
"electricity_and_heat_co2_emissions" FLOAT,
"electricity_and_heat_co2_emissions_per_capita" FLOAT,
"energy_co2_emissions" FLOAT,
"energy_co2_emissions_per_capita" FLOAT,
"fugitive_co2_emissions" FLOAT,
"fugitive_co2_emissions_per_capita" FLOAT,
"industry_co2_emissions" FLOAT,
"industry_co2_emissions_per_capita" FLOAT,
"land_use_change_and_forestry_co2_emissions" FLOAT,
"land_use_change_and_forestry_co2_emissions_per_capita" FLOAT,
"manufacturing_and_construction_co2_emissions" FLOAT,
"manufacturing_and_construction_co2_emissions_per_capita" FLOAT,
"other_fuel_combustion_co2_emissions" FLOAT,
"other_fuel_combustion_co2_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_co2_emissions_excluding_lucf" FLOAT,
"total_co2_emissions_excluding_lucf_per_capita" FLOAT,
"total_co2_emissions_including_lucf" FLOAT,
"total_co2_emissions_including_lucf_per_capita" FLOAT,
"transport_co2_emissions" FLOAT,
"transport_co2_emissions_per_capita" FLOAT
);
CREATE TABLE owid_carbon_dioxide_emissions_by_sector_2 (
"country" VARCHAR,
"year" INTEGER,
"aviation_and_shipping_co2_emissions" FLOAT,
"aviation_and_shipping_co2_emissions_per_capita" FLOAT,
"buildings_co2_emissions" FLOAT,
"buildings_co2_emissions_per_capita" FLOAT,
"electricity_and_heat_co2_emissions" FLOAT,
"electricity_and_heat_co2_emissions_per_capita" FLOAT,
"energy_co2_emissions" FLOAT,
"energy_co2_emissions_per_capita" FLOAT,
"fugitive_co2_emissions" FLOAT,
"fugitive_co2_emissions_per_capita" FLOAT,
"industry_co2_emissions" FLOAT,
"industry_co2_emissions_per_capita" FLOAT,
"land_use_change_and_forestry_co2_emissions" FLOAT,
"land_use_change_and_forestry_co2_emissions_per_capita" FLOAT,
"manufacturing_and_construction_co2_emissions" FLOAT,
"manufacturing_and_construction_co2_emissions_per_capita" FLOAT,
"other_fuel_combustion_co2_emissions" FLOAT,
"other_fuel_combustion_co2_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_co2_emissions_excluding_lucf" FLOAT,
"total_co2_emissions_excluding_lucf_per_capita" FLOAT,
"total_co2_emissions_including_lucf" FLOAT,
"total_co2_emissions_including_lucf_per_capita" FLOAT,
"transport_co2_emissions" FLOAT,
"transport_co2_emissions_per_capita" FLOAT
);
CREATE TABLE owid_fluorinated_gas_emissions_by_sector_1 (
"country" VARCHAR,
"year" INTEGER,
"industry_fgas_emissions" FLOAT,
"industry_fgas_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_fgas_emissions_excluding_lucf" FLOAT,
"total_fgas_emissions_excluding_lucf_per_capita" FLOAT,
"total_fgas_emissions_including_lucf" FLOAT,
"total_fgas_emissions_including_lucf_per_capita" FLOAT
);
CREATE TABLE owid_fluorinated_gas_emissions_by_sector_2 (
"country" VARCHAR,
"year" INTEGER,
"industry_fgas_emissions" FLOAT,
"industry_fgas_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_fgas_emissions_excluding_lucf" FLOAT,
"total_fgas_emissions_excluding_lucf_per_capita" FLOAT,
"total_fgas_emissions_including_lucf" FLOAT,
"total_fgas_emissions_including_lucf_per_capita" FLOAT
);
CREATE TABLE owid_greenhouse_gas_emissions_by_sector_1 (
"country" VARCHAR,
"year" INTEGER,
"agriculture_ghg_emissions" FLOAT,
"agriculture_ghg_emissions_per_capita" FLOAT,
"aviation_and_shipping_ghg_emissions" FLOAT,
"aviation_and_shipping_ghg_emissions_per_capita" FLOAT,
"buildings_ghg_emissions" FLOAT,
"buildings_ghg_emissions_per_capita" FLOAT,
"electricity_and_heat_ghg_emissions" FLOAT,
"electricity_and_heat_ghg_emissions_per_capita" FLOAT,
"energy_ghg_emissions" FLOAT,
"energy_ghg_emissions_per_capita" FLOAT,
"fugitive_ghg_emissions" FLOAT,
"fugitive_ghg_emissions_per_capita" FLOAT,
"industry_ghg_emissions" FLOAT,
"industry_ghg_emissions_per_capita" FLOAT,
"land_use_change_and_forestry_ghg_emissions" FLOAT,
"land_use_change_and_forestry_ghg_emissions_per_capita" FLOAT,
"manufacturing_and_construction_ghg_emissions" FLOAT,
"manufacturing_and_construction_ghg_emissions_per_capita" FLOAT,
"other_fuel_combustion_ghg_emissions" FLOAT,
"other_fuel_combustion_ghg_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_ghg_emissions_excluding_lucf" FLOAT,
"total_ghg_emissions_excluding_lucf_per_capita" FLOAT,
"total_ghg_emissions_including_lucf" FLOAT,
"total_ghg_emissions_including_lucf_per_capita" FLOAT,
"transport_ghg_emissions" FLOAT,
"transport_ghg_emissions_per_capita" FLOAT,
"waste_ghg_emissions" FLOAT,
"waste_ghg_emissions_per_capita" FLOAT
);
CREATE TABLE owid_greenhouse_gas_emissions_by_sector_2 (
"country" VARCHAR,
"year" INTEGER,
"agriculture_ghg_emissions" FLOAT,
"agriculture_ghg_emissions_per_capita" FLOAT,
"aviation_and_shipping_ghg_emissions" FLOAT,
"aviation_and_shipping_ghg_emissions_per_capita" FLOAT,
"buildings_ghg_emissions" FLOAT,
"buildings_ghg_emissions_per_capita" FLOAT,
"electricity_and_heat_ghg_emissions" FLOAT,
"electricity_and_heat_ghg_emissions_per_capita" FLOAT,
"energy_ghg_emissions" FLOAT,
"energy_ghg_emissions_per_capita" FLOAT,
"fugitive_ghg_emissions" FLOAT,
"fugitive_ghg_emissions_per_capita" FLOAT,
"industry_ghg_emissions" FLOAT,
"industry_ghg_emissions_per_capita" FLOAT,
"land_use_change_and_forestry_ghg_emissions" FLOAT,
"land_use_change_and_forestry_ghg_emissions_per_capita" FLOAT,
"manufacturing_and_construction_ghg_emissions" FLOAT,
"manufacturing_and_construction_ghg_emissions_per_capita" FLOAT,
"other_fuel_combustion_ghg_emissions" FLOAT,
"other_fuel_combustion_ghg_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_ghg_emissions_excluding_lucf" FLOAT,
"total_ghg_emissions_excluding_lucf_per_capita" FLOAT,
"total_ghg_emissions_including_lucf" FLOAT,
"total_ghg_emissions_including_lucf_per_capita" FLOAT,
"transport_ghg_emissions" FLOAT,
"transport_ghg_emissions_per_capita" FLOAT,
"waste_ghg_emissions" FLOAT,
"waste_ghg_emissions_per_capita" FLOAT
);
CREATE TABLE owid_methane_emissions_by_sector_1 (
"country" VARCHAR,
"year" INTEGER,
"agriculture_ch4_emissions" FLOAT,
"agriculture_ch4_emissions_per_capita" FLOAT,
"aviation_and_shipping_ch4_emissions" FLOAT,
"aviation_and_shipping_ch4_emissions_per_capita" FLOAT,
"buildings_ch4_emissions" FLOAT,
"buildings_ch4_emissions_per_capita" FLOAT,
"electricity_and_heat_ch4_emissions" FLOAT,
"electricity_and_heat_ch4_emissions_per_capita" FLOAT,
"energy_ch4_emissions" FLOAT,
"energy_ch4_emissions_per_capita" FLOAT,
"fugitive_ch4_emissions" FLOAT,
"fugitive_ch4_emissions_per_capita" FLOAT,
"industry_ch4_emissions" FLOAT,
"industry_ch4_emissions_per_capita" FLOAT,
"land_use_change_and_forestry_ch4_emissions" FLOAT,
"land_use_change_and_forestry_ch4_emissions_per_capita" FLOAT,
"manufacturing_and_construction_ch4_emissions" FLOAT,
"manufacturing_and_construction_ch4_emissions_per_capita" FLOAT,
"other_fuel_combustion_ch4_emissions" FLOAT,
"other_fuel_combustion_ch4_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_ch4_emissions_excluding_lucf" FLOAT,
"total_ch4_emissions_excluding_lucf_per_capita" FLOAT,
"total_ch4_emissions_including_lucf" FLOAT,
"total_ch4_emissions_including_lucf_per_capita" FLOAT,
"transport_ch4_emissions" FLOAT,
"transport_ch4_emissions_per_capita" FLOAT,
"waste_ch4_emissions" FLOAT,
"waste_ch4_emissions_per_capita" FLOAT
);
CREATE TABLE owid_methane_emissions_by_sector_2 (
"country" VARCHAR,
"year" INTEGER,
"agriculture_ch4_emissions" FLOAT,
"agriculture_ch4_emissions_per_capita" FLOAT,
"aviation_and_shipping_ch4_emissions" FLOAT,
"aviation_and_shipping_ch4_emissions_per_capita" FLOAT,
"buildings_ch4_emissions" FLOAT,
"buildings_ch4_emissions_per_capita" FLOAT,
"electricity_and_heat_ch4_emissions" FLOAT,
"electricity_and_heat_ch4_emissions_per_capita" FLOAT,
"energy_ch4_emissions" FLOAT,
"energy_ch4_emissions_per_capita" FLOAT,
"fugitive_ch4_emissions" FLOAT,
"fugitive_ch4_emissions_per_capita" FLOAT,
"industry_ch4_emissions" FLOAT,
"industry_ch4_emissions_per_capita" FLOAT,
"land_use_change_and_forestry_ch4_emissions" FLOAT,
"land_use_change_and_forestry_ch4_emissions_per_capita" FLOAT,
"manufacturing_and_construction_ch4_emissions" FLOAT,
"manufacturing_and_construction_ch4_emissions_per_capita" FLOAT,
"other_fuel_combustion_ch4_emissions" FLOAT,
"other_fuel_combustion_ch4_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_ch4_emissions_excluding_lucf" FLOAT,
"total_ch4_emissions_excluding_lucf_per_capita" FLOAT,
"total_ch4_emissions_including_lucf" FLOAT,
"total_ch4_emissions_including_lucf_per_capita" FLOAT,
"transport_ch4_emissions" FLOAT,
"transport_ch4_emissions_per_capita" FLOAT,
"waste_ch4_emissions" FLOAT,
"waste_ch4_emissions_per_capita" FLOAT
);
CREATE TABLE owid_nitrous_oxide_emissions_by_sector_1 (
"country" VARCHAR,
"year" INTEGER,
"agriculture_n2o_emissions" FLOAT,
"agriculture_n2o_emissions_per_capita" FLOAT,
"aviation_and_shipping_n2o_emissions" FLOAT,
"aviation_and_shipping_n2o_emissions_per_capita" FLOAT,
"buildings_n2o_emissions" FLOAT,
"buildings_n2o_emissions_per_capita" FLOAT,
"electricity_and_heat_n2o_emissions" FLOAT,
"electricity_and_heat_n2o_emissions_per_capita" FLOAT,
"energy_n2o_emissions" FLOAT,
"energy_n2o_emissions_per_capita" FLOAT,
"fugitive_n2o_emissions" FLOAT,
"fugitive_n2o_emissions_per_capita" FLOAT,
"industry_n2o_emissions" FLOAT,
"industry_n2o_emissions_per_capita" FLOAT,
"land_use_change_and_forestry_n2o_emissions" FLOAT,
"land_use_change_and_forestry_n2o_emissions_per_capita" FLOAT,
"manufacturing_and_construction_n2o_emissions" FLOAT,
"manufacturing_and_construction_n2o_emissions_per_capita" FLOAT,
"other_fuel_combustion_n2o_emissions" FLOAT,
"other_fuel_combustion_n2o_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_n2o_emissions_excluding_lucf" FLOAT,
"total_n2o_emissions_excluding_lucf_per_capita" FLOAT,
"total_n2o_emissions_including_lucf" FLOAT,
"total_n2o_emissions_including_lucf_per_capita" FLOAT,
"transport_n2o_emissions" FLOAT,
"transport_n2o_emissions_per_capita" FLOAT,
"waste_n2o_emissions" FLOAT,
"waste_n2o_emissions_per_capita" FLOAT
);
CREATE TABLE owid_nitrous_oxide_emissions_by_sector_2 (
"country" VARCHAR,
"year" INTEGER,
"agriculture_n2o_emissions" FLOAT,
"agriculture_n2o_emissions_per_capita" FLOAT,
"aviation_and_shipping_n2o_emissions" FLOAT,
"aviation_and_shipping_n2o_emissions_per_capita" FLOAT,
"buildings_n2o_emissions" FLOAT,
"buildings_n2o_emissions_per_capita" FLOAT,
"electricity_and_heat_n2o_emissions" FLOAT,
"electricity_and_heat_n2o_emissions_per_capita" FLOAT,
"energy_n2o_emissions" FLOAT,
"energy_n2o_emissions_per_capita" FLOAT,
"fugitive_n2o_emissions" FLOAT,
"fugitive_n2o_emissions_per_capita" FLOAT,
"industry_n2o_emissions" FLOAT,
"industry_n2o_emissions_per_capita" FLOAT,
"land_use_change_and_forestry_n2o_emissions" FLOAT,
"land_use_change_and_forestry_n2o_emissions_per_capita" FLOAT,
"manufacturing_and_construction_n2o_emissions" FLOAT,
"manufacturing_and_construction_n2o_emissions_per_capita" FLOAT,
"other_fuel_combustion_n2o_emissions" FLOAT,
"other_fuel_combustion_n2o_emissions_per_capita" FLOAT,
"population" BIGINT,
"total_n2o_emissions_excluding_lucf" FLOAT,
"total_n2o_emissions_excluding_lucf_per_capita" FLOAT,
"total_n2o_emissions_including_lucf" FLOAT,
"total_n2o_emissions_including_lucf_per_capita" FLOAT,
"transport_n2o_emissions" FLOAT,
"transport_n2o_emissions_per_capita" FLOAT,
"waste_n2o_emissions" FLOAT,
"waste_n2o_emissions_per_capita" FLOAT
);
Anyone who has the link will be able to view this.