Global Carbon Budget
@owid.global_carbon_budget
@owid.global_carbon_budget
CREATE TABLE owid_global_carbon_budget_1 (
"country" VARCHAR,
"year" INTEGER,
"consumption_emissions" FLOAT,
"consumption_emissions_as_share_of_global" FLOAT,
"consumption_emissions_per_capita" FLOAT,
"consumption_emissions_per_gdp" FLOAT,
"cumulative_consumption_emissions" FLOAT,
"cumulative_consumption_emissions_as_share_of_global" FLOAT,
"cumulative_emissions_from_cement" FLOAT,
"cumulative_emissions_from_cement_as_share_of_global" FLOAT,
"cumulative_emissions_from_coal" FLOAT,
"cumulative_emissions_from_coal_as_share_of_global" FLOAT,
"cumulative_emissions_from_flaring" FLOAT,
"cumulative_emissions_from_flaring_as_share_of_global" FLOAT,
"cumulative_emissions_from_gas" FLOAT,
"cumulative_emissions_from_gas_as_share_of_global" FLOAT,
"cumulative_emissions_from_land_use_change" FLOAT,
"cumulative_emissions_from_land_use_change_as_share_of_global" FLOAT,
"cumulative_emissions_from_oil" FLOAT,
"cumulative_emissions_from_oil_as_share_of_global" FLOAT,
"cumulative_emissions_from_other_industry" FLOAT,
"cumulative_emissions_from_other_industry_as_share_of_global" FLOAT,
"cumulative_emissions_total" FLOAT,
"cumulative_emissions_total_as_share_of_global" FLOAT,
"cumulative_emissions_total_including_land_use_change" FLOAT,
"cumulative_emissions_total_including_land_use_change_a_02c01dc9" FLOAT,
"emissions_from_cement" FLOAT,
"emissions_from_cement_as_share_of_global" FLOAT,
"emissions_from_cement_per_capita" FLOAT,
"emissions_from_coal" FLOAT,
"emissions_from_coal_as_share_of_global" FLOAT,
"emissions_from_coal_per_capita" FLOAT,
"emissions_from_flaring" FLOAT,
"emissions_from_flaring_as_share_of_global" FLOAT,
"emissions_from_flaring_per_capita" FLOAT,
"emissions_from_gas" FLOAT,
"emissions_from_gas_as_share_of_global" FLOAT,
"emissions_from_gas_per_capita" FLOAT,
"emissions_from_land_use_change" FLOAT,
"emissions_from_land_use_change_as_share_of_global" FLOAT,
"emissions_from_land_use_change_per_capita" FLOAT,
"emissions_from_oil" FLOAT,
"emissions_from_oil_as_share_of_global" FLOAT,
"emissions_from_oil_per_capita" FLOAT,
"emissions_from_other_industry" FLOAT,
"emissions_from_other_industry_as_share_of_global" FLOAT,
"emissions_from_other_industry_per_capita" FLOAT,
"emissions_total" FLOAT,
"emissions_total_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change" FLOAT,
"emissions_total_including_land_use_change_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change_per_capita" FLOAT,
"emissions_total_including_land_use_change_per_gdp" FLOAT,
"emissions_total_including_land_use_change_per_unit_energy" FLOAT,
"emissions_total_per_capita" FLOAT,
"emissions_total_per_gdp" FLOAT,
"emissions_total_per_unit_energy" FLOAT,
"gdp" FLOAT,
"global_cumulative_emissions_from_cement" FLOAT,
"global_cumulative_emissions_from_coal" FLOAT,
"global_cumulative_emissions_from_flaring" FLOAT,
"global_cumulative_emissions_from_gas" FLOAT,
"global_cumulative_emissions_from_land_use_change" FLOAT,
"global_cumulative_emissions_from_oil" FLOAT,
"global_cumulative_emissions_from_other_industry" FLOAT,
"global_cumulative_emissions_total" FLOAT,
"global_cumulative_emissions_total_including_land_use_change" FLOAT,
"global_emissions_from_cement" FLOAT,
"global_emissions_from_coal" FLOAT,
"global_emissions_from_flaring" FLOAT,
"global_emissions_from_gas" FLOAT,
"global_emissions_from_international_transport" FLOAT,
"global_emissions_from_land_use_change" FLOAT,
"global_emissions_from_oil" FLOAT,
"global_emissions_from_other_industry" FLOAT,
"global_emissions_total" FLOAT,
"global_emissions_total_including_land_use_change" FLOAT,
"global_population" BIGINT,
"growth_emissions_total" FLOAT,
"growth_emissions_total_including_land_use_change" FLOAT,
"land_use_change_quality_flag" INTEGER,
"pct_growth_emissions_total" FLOAT,
"pct_growth_emissions_total_including_land_use_change" FLOAT,
"pct_traded_emissions" FLOAT,
"population" BIGINT,
"population_as_share_of_global" FLOAT,
"primary_energy_consumption" FLOAT,
"traded_emissions" FLOAT,
"traded_emissions_per_capita" FLOAT
);
CREATE TABLE owid_global_carbon_budget_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_emissions" FLOAT,
"consumption_emissions_as_share_of_global" FLOAT,
"consumption_emissions_per_capita" FLOAT,
"consumption_emissions_per_gdp" FLOAT,
"cumulative_consumption_emissions" FLOAT,
"cumulative_consumption_emissions_as_share_of_global" FLOAT,
"cumulative_emissions_from_cement" FLOAT,
"cumulative_emissions_from_cement_as_share_of_global" FLOAT,
"cumulative_emissions_from_coal" FLOAT,
"cumulative_emissions_from_coal_as_share_of_global" FLOAT,
"cumulative_emissions_from_flaring" FLOAT,
"cumulative_emissions_from_flaring_as_share_of_global" FLOAT,
"cumulative_emissions_from_gas" FLOAT,
"cumulative_emissions_from_gas_as_share_of_global" FLOAT,
"cumulative_emissions_from_land_use_change" FLOAT,
"cumulative_emissions_from_land_use_change_as_share_of_global" FLOAT,
"cumulative_emissions_from_oil" FLOAT,
"cumulative_emissions_from_oil_as_share_of_global" FLOAT,
"cumulative_emissions_from_other_industry" FLOAT,
"cumulative_emissions_from_other_industry_as_share_of_global" FLOAT,
"cumulative_emissions_total" FLOAT,
"cumulative_emissions_total_as_share_of_global" FLOAT,
"cumulative_emissions_total_including_land_use_change" FLOAT,
"cumulative_emissions_total_including_land_use_change_a_02c01dc9" FLOAT,
"emissions_from_cement" FLOAT,
"emissions_from_cement_as_share_of_global" FLOAT,
"emissions_from_cement_per_capita" FLOAT,
"emissions_from_coal" FLOAT,
"emissions_from_coal_as_share_of_global" FLOAT,
"emissions_from_coal_per_capita" FLOAT,
"emissions_from_flaring" FLOAT,
"emissions_from_flaring_as_share_of_global" FLOAT,
"emissions_from_flaring_per_capita" FLOAT,
"emissions_from_gas" FLOAT,
"emissions_from_gas_as_share_of_global" FLOAT,
"emissions_from_gas_per_capita" FLOAT,
"emissions_from_land_use_change" FLOAT,
"emissions_from_land_use_change_as_share_of_global" FLOAT,
"emissions_from_land_use_change_per_capita" FLOAT,
"emissions_from_oil" FLOAT,
"emissions_from_oil_as_share_of_global" FLOAT,
"emissions_from_oil_per_capita" FLOAT,
"emissions_from_other_industry" FLOAT,
"emissions_from_other_industry_as_share_of_global" FLOAT,
"emissions_from_other_industry_per_capita" FLOAT,
"emissions_total" FLOAT,
"emissions_total_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change" FLOAT,
"emissions_total_including_land_use_change_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change_per_capita" FLOAT,
"emissions_total_including_land_use_change_per_gdp" FLOAT,
"emissions_total_including_land_use_change_per_unit_energy" FLOAT,
"emissions_total_per_capita" FLOAT,
"emissions_total_per_gdp" FLOAT,
"emissions_total_per_unit_energy" FLOAT,
"gdp" FLOAT,
"growth_emissions_total" FLOAT,
"growth_emissions_total_including_land_use_change" FLOAT,
"land_use_change_quality_flag" INTEGER,
"pct_growth_emissions_total" FLOAT,
"pct_growth_emissions_total_including_land_use_change" FLOAT,
"pct_traded_emissions" FLOAT,
"population" BIGINT,
"population_as_share_of_global" FLOAT,
"primary_energy_consumption" FLOAT,
"traded_emissions" FLOAT,
"traded_emissions_per_capita" FLOAT
);
CREATE TABLE owid_global_carbon_budget_3 (
"country" VARCHAR,
"year" INTEGER,
"consumption_emissions" FLOAT,
"consumption_emissions_as_share_of_global" FLOAT,
"consumption_emissions_per_capita" FLOAT,
"consumption_emissions_per_gdp" FLOAT,
"cumulative_consumption_emissions" FLOAT,
"cumulative_consumption_emissions_as_share_of_global" FLOAT,
"cumulative_emissions_from_cement" FLOAT,
"cumulative_emissions_from_cement_as_share_of_global" FLOAT,
"cumulative_emissions_from_coal" FLOAT,
"cumulative_emissions_from_coal_as_share_of_global" FLOAT,
"cumulative_emissions_from_flaring" FLOAT,
"cumulative_emissions_from_flaring_as_share_of_global" FLOAT,
"cumulative_emissions_from_gas" FLOAT,
"cumulative_emissions_from_gas_as_share_of_global" FLOAT,
"cumulative_emissions_from_land_use_change" FLOAT,
"cumulative_emissions_from_land_use_change_as_share_of_global" FLOAT,
"cumulative_emissions_from_oil" FLOAT,
"cumulative_emissions_from_oil_as_share_of_global" FLOAT,
"cumulative_emissions_from_other_industry" FLOAT,
"cumulative_emissions_from_other_industry_as_share_of_global" FLOAT,
"cumulative_emissions_total" FLOAT,
"cumulative_emissions_total_as_share_of_global" FLOAT,
"cumulative_emissions_total_including_land_use_change" FLOAT,
"cumulative_emissions_total_including_land_use_change_a_02c01dc9" FLOAT,
"emissions_from_cement" FLOAT,
"emissions_from_cement_as_share_of_global" FLOAT,
"emissions_from_cement_per_capita" FLOAT,
"emissions_from_coal" FLOAT,
"emissions_from_coal_as_share_of_global" FLOAT,
"emissions_from_coal_per_capita" FLOAT,
"emissions_from_flaring" FLOAT,
"emissions_from_flaring_as_share_of_global" FLOAT,
"emissions_from_flaring_per_capita" FLOAT,
"emissions_from_gas" FLOAT,
"emissions_from_gas_as_share_of_global" FLOAT,
"emissions_from_gas_per_capita" FLOAT,
"emissions_from_land_use_change" FLOAT,
"emissions_from_land_use_change_as_share_of_global" FLOAT,
"emissions_from_land_use_change_per_capita" FLOAT,
"emissions_from_oil" FLOAT,
"emissions_from_oil_as_share_of_global" FLOAT,
"emissions_from_oil_per_capita" FLOAT,
"emissions_from_other_industry" FLOAT,
"emissions_from_other_industry_as_share_of_global" FLOAT,
"emissions_from_other_industry_per_capita" FLOAT,
"emissions_total" FLOAT,
"emissions_total_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change" FLOAT,
"emissions_total_including_land_use_change_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change_per_capita" FLOAT,
"emissions_total_including_land_use_change_per_gdp" FLOAT,
"emissions_total_including_land_use_change_per_unit_energy" FLOAT,
"emissions_total_per_capita" FLOAT,
"emissions_total_per_gdp" FLOAT,
"emissions_total_per_unit_energy" FLOAT,
"gdp" FLOAT,
"growth_emissions_total" FLOAT,
"growth_emissions_total_including_land_use_change" FLOAT,
"land_use_change_quality_flag" INTEGER,
"pct_growth_emissions_total" FLOAT,
"pct_growth_emissions_total_including_land_use_change" FLOAT,
"pct_traded_emissions" FLOAT,
"population" BIGINT,
"population_as_share_of_global" FLOAT,
"primary_energy_consumption" FLOAT,
"traded_emissions" FLOAT,
"traded_emissions_per_capita" FLOAT
);
CREATE TABLE owid_global_carbon_budget_4 (
"country" VARCHAR,
"year" INTEGER,
"consumption_emissions" FLOAT,
"consumption_emissions_as_share_of_global" FLOAT,
"consumption_emissions_per_capita" FLOAT,
"consumption_emissions_per_gdp" FLOAT,
"cumulative_consumption_emissions" FLOAT,
"cumulative_consumption_emissions_as_share_of_global" FLOAT,
"cumulative_emissions_from_cement" FLOAT,
"cumulative_emissions_from_cement_as_share_of_global" FLOAT,
"cumulative_emissions_from_coal" FLOAT,
"cumulative_emissions_from_coal_as_share_of_global" FLOAT,
"cumulative_emissions_from_flaring" FLOAT,
"cumulative_emissions_from_flaring_as_share_of_global" FLOAT,
"cumulative_emissions_from_gas" FLOAT,
"cumulative_emissions_from_gas_as_share_of_global" FLOAT,
"cumulative_emissions_from_land_use_change" FLOAT,
"cumulative_emissions_from_land_use_change_as_share_of_global" FLOAT,
"cumulative_emissions_from_oil" FLOAT,
"cumulative_emissions_from_oil_as_share_of_global" FLOAT,
"cumulative_emissions_from_other_industry" FLOAT,
"cumulative_emissions_from_other_industry_as_share_of_global" FLOAT,
"cumulative_emissions_total" FLOAT,
"cumulative_emissions_total_as_share_of_global" FLOAT,
"cumulative_emissions_total_including_land_use_change" FLOAT,
"cumulative_emissions_total_including_land_use_change_a_02c01dc9" FLOAT,
"emissions_from_cement" FLOAT,
"emissions_from_cement_as_share_of_global" FLOAT,
"emissions_from_cement_per_capita" FLOAT,
"emissions_from_coal" FLOAT,
"emissions_from_coal_as_share_of_global" FLOAT,
"emissions_from_coal_per_capita" FLOAT,
"emissions_from_flaring" FLOAT,
"emissions_from_flaring_as_share_of_global" FLOAT,
"emissions_from_flaring_per_capita" FLOAT,
"emissions_from_gas" FLOAT,
"emissions_from_gas_as_share_of_global" FLOAT,
"emissions_from_gas_per_capita" FLOAT,
"emissions_from_land_use_change" FLOAT,
"emissions_from_land_use_change_as_share_of_global" FLOAT,
"emissions_from_land_use_change_per_capita" FLOAT,
"emissions_from_oil" FLOAT,
"emissions_from_oil_as_share_of_global" FLOAT,
"emissions_from_oil_per_capita" FLOAT,
"emissions_from_other_industry" FLOAT,
"emissions_from_other_industry_as_share_of_global" FLOAT,
"emissions_from_other_industry_per_capita" FLOAT,
"emissions_total" FLOAT,
"emissions_total_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change" FLOAT,
"emissions_total_including_land_use_change_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change_per_capita" FLOAT,
"emissions_total_including_land_use_change_per_gdp" FLOAT,
"emissions_total_including_land_use_change_per_unit_energy" FLOAT,
"emissions_total_per_capita" FLOAT,
"emissions_total_per_gdp" FLOAT,
"emissions_total_per_unit_energy" FLOAT,
"gdp" FLOAT,
"growth_emissions_total" FLOAT,
"growth_emissions_total_including_land_use_change" FLOAT,
"land_use_change_quality_flag" INTEGER,
"pct_growth_emissions_total" FLOAT,
"pct_growth_emissions_total_including_land_use_change" FLOAT,
"pct_traded_emissions" FLOAT,
"population" BIGINT,
"population_as_share_of_global" FLOAT,
"primary_energy_consumption" FLOAT,
"traded_emissions" FLOAT,
"traded_emissions_per_capita" FLOAT
);
CREATE TABLE owid_global_carbon_budget_5 (
"country" VARCHAR,
"year" INTEGER,
"consumption_emissions" FLOAT,
"consumption_emissions_as_share_of_global" FLOAT,
"consumption_emissions_per_capita" FLOAT,
"consumption_emissions_per_gdp" FLOAT,
"cumulative_consumption_emissions" FLOAT,
"cumulative_consumption_emissions_as_share_of_global" FLOAT,
"cumulative_emissions_from_cement" FLOAT,
"cumulative_emissions_from_cement_as_share_of_global" FLOAT,
"cumulative_emissions_from_coal" FLOAT,
"cumulative_emissions_from_coal_as_share_of_global" FLOAT,
"cumulative_emissions_from_flaring" FLOAT,
"cumulative_emissions_from_flaring_as_share_of_global" FLOAT,
"cumulative_emissions_from_gas" FLOAT,
"cumulative_emissions_from_gas_as_share_of_global" FLOAT,
"cumulative_emissions_from_land_use_change" FLOAT,
"cumulative_emissions_from_land_use_change_as_share_of_global" FLOAT,
"cumulative_emissions_from_oil" FLOAT,
"cumulative_emissions_from_oil_as_share_of_global" FLOAT,
"cumulative_emissions_from_other_industry" FLOAT,
"cumulative_emissions_from_other_industry_as_share_of_global" FLOAT,
"cumulative_emissions_total" FLOAT,
"cumulative_emissions_total_as_share_of_global" FLOAT,
"cumulative_emissions_total_including_land_use_change" FLOAT,
"cumulative_emissions_total_including_land_use_change_a_02c01dc9" FLOAT,
"emissions_from_cement" FLOAT,
"emissions_from_cement_as_share_of_global" FLOAT,
"emissions_from_cement_per_capita" FLOAT,
"emissions_from_coal" FLOAT,
"emissions_from_coal_as_share_of_global" FLOAT,
"emissions_from_coal_per_capita" FLOAT,
"emissions_from_flaring" FLOAT,
"emissions_from_flaring_as_share_of_global" FLOAT,
"emissions_from_flaring_per_capita" FLOAT,
"emissions_from_gas" FLOAT,
"emissions_from_gas_as_share_of_global" FLOAT,
"emissions_from_gas_per_capita" FLOAT,
"emissions_from_land_use_change" FLOAT,
"emissions_from_land_use_change_as_share_of_global" FLOAT,
"emissions_from_land_use_change_per_capita" FLOAT,
"emissions_from_oil" FLOAT,
"emissions_from_oil_as_share_of_global" FLOAT,
"emissions_from_oil_per_capita" FLOAT,
"emissions_from_other_industry" FLOAT,
"emissions_from_other_industry_as_share_of_global" FLOAT,
"emissions_from_other_industry_per_capita" FLOAT,
"emissions_total" FLOAT,
"emissions_total_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change" FLOAT,
"emissions_total_including_land_use_change_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change_per_capita" FLOAT,
"emissions_total_including_land_use_change_per_gdp" FLOAT,
"emissions_total_including_land_use_change_per_unit_energy" FLOAT,
"emissions_total_per_capita" FLOAT,
"emissions_total_per_gdp" FLOAT,
"emissions_total_per_unit_energy" FLOAT,
"gdp" FLOAT,
"growth_emissions_total" FLOAT,
"growth_emissions_total_including_land_use_change" FLOAT,
"pct_growth_emissions_total" FLOAT,
"pct_growth_emissions_total_including_land_use_change" FLOAT,
"pct_traded_emissions" FLOAT,
"population" BIGINT,
"population_as_share_of_global" FLOAT,
"primary_energy_consumption" FLOAT,
"traded_emissions" FLOAT,
"traded_emissions_per_capita" FLOAT
);
CREATE TABLE owid_global_carbon_budget_6 (
"country" VARCHAR,
"year" INTEGER,
"consumption_emissions" FLOAT,
"consumption_emissions_as_share_of_global" FLOAT,
"consumption_emissions_per_capita" FLOAT,
"consumption_emissions_per_gdp" FLOAT,
"cumulative_consumption_emissions" FLOAT,
"cumulative_consumption_emissions_as_share_of_global" FLOAT,
"cumulative_emissions_from_cement" FLOAT,
"cumulative_emissions_from_cement_as_share_of_global" FLOAT,
"cumulative_emissions_from_coal" FLOAT,
"cumulative_emissions_from_coal_as_share_of_global" FLOAT,
"cumulative_emissions_from_flaring" FLOAT,
"cumulative_emissions_from_flaring_as_share_of_global" FLOAT,
"cumulative_emissions_from_gas" FLOAT,
"cumulative_emissions_from_gas_as_share_of_global" FLOAT,
"cumulative_emissions_from_land_use_change" FLOAT,
"cumulative_emissions_from_land_use_change_as_share_of_global" FLOAT,
"cumulative_emissions_from_oil" FLOAT,
"cumulative_emissions_from_oil_as_share_of_global" FLOAT,
"cumulative_emissions_from_other_industry" FLOAT,
"cumulative_emissions_from_other_industry_as_share_of_global" FLOAT,
"cumulative_emissions_total" FLOAT,
"cumulative_emissions_total_as_share_of_global" FLOAT,
"cumulative_emissions_total_including_land_use_change" FLOAT,
"cumulative_emissions_total_including_land_use_change_a_02c01dc9" FLOAT,
"emissions_from_cement" FLOAT,
"emissions_from_cement_as_share_of_global" FLOAT,
"emissions_from_cement_per_capita" FLOAT,
"emissions_from_coal" FLOAT,
"emissions_from_coal_as_share_of_global" FLOAT,
"emissions_from_coal_per_capita" FLOAT,
"emissions_from_flaring" FLOAT,
"emissions_from_flaring_as_share_of_global" FLOAT,
"emissions_from_flaring_per_capita" FLOAT,
"emissions_from_gas" FLOAT,
"emissions_from_gas_as_share_of_global" FLOAT,
"emissions_from_gas_per_capita" FLOAT,
"emissions_from_land_use_change" FLOAT,
"emissions_from_land_use_change_as_share_of_global" FLOAT,
"emissions_from_land_use_change_per_capita" FLOAT,
"emissions_from_oil" FLOAT,
"emissions_from_oil_as_share_of_global" FLOAT,
"emissions_from_oil_per_capita" FLOAT,
"emissions_from_other_industry" FLOAT,
"emissions_from_other_industry_as_share_of_global" FLOAT,
"emissions_from_other_industry_per_capita" FLOAT,
"emissions_total" FLOAT,
"emissions_total_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change" FLOAT,
"emissions_total_including_land_use_change_as_share_of_global" FLOAT,
"emissions_total_including_land_use_change_per_capita" FLOAT,
"emissions_total_including_land_use_change_per_gdp" FLOAT,
"emissions_total_including_land_use_change_per_unit_energy" FLOAT,
"emissions_total_per_capita" FLOAT,
"emissions_total_per_gdp" FLOAT,
"emissions_total_per_unit_energy" FLOAT,
"gdp" FLOAT,
"growth_emissions_total" FLOAT,
"growth_emissions_total_including_land_use_change" FLOAT,
"pct_growth_emissions_total" FLOAT,
"pct_growth_emissions_total_including_land_use_change" FLOAT,
"pct_traded_emissions" FLOAT,
"population" BIGINT,
"population_as_share_of_global" FLOAT,
"primary_energy_consumption" FLOAT,
"traded_emissions" FLOAT,
"traded_emissions_per_capita" FLOAT
);
Anyone who has the link will be able to view this.