Baselight

CO2 Emissions Complete Dataset 1750-2020

Complete Data set of CO2 emissions per country and related variables ( RAW )

@kaggle.kvnxls_co2_emissions_dataset_1750_2020

Owid Co2 Data
@kaggle.kvnxls_co2_emissions_dataset_1750_2020.owid_co2_data

  • 2.46 MB
  • 25989 rows
  • 60 columns
iso_code

Iso Code

country

Country

year

Year

co2

Co2

co2_per_capita

Co2 Per Capita

trade_co2

Trade Co2

cement_co2

Cement Co2

cement_co2_per_capita

Cement Co2 Per Capita

coal_co2

Coal Co2

coal_co2_per_capita

Coal Co2 Per Capita

flaring_co2

Flaring Co2

flaring_co2_per_capita

Flaring Co2 Per Capita

gas_co2

Gas Co2

gas_co2_per_capita

Gas Co2 Per Capita

oil_co2

Oil Co2

oil_co2_per_capita

Oil Co2 Per Capita

other_industry_co2

Other Industry Co2

other_co2_per_capita

Other Co2 Per Capita

co2_growth_prct

Co2 Growth Prct

co2_growth_abs

Co2 Growth Abs

co2_per_gdp

Co2 Per Gdp

co2_per_unit_energy

Co2 Per Unit Energy

consumption_co2

Consumption Co2

consumption_co2_per_capita

Consumption Co2 Per Capita

consumption_co2_per_gdp

Consumption Co2 Per Gdp

cumulative_co2

Cumulative Co2

cumulative_cement_co2

Cumulative Cement Co2

cumulative_coal_co2

Cumulative Coal Co2

cumulative_flaring_co2

Cumulative Flaring Co2

cumulative_gas_co2

Cumulative Gas Co2

cumulative_oil_co2

Cumulative Oil Co2

cumulative_other_co2

Cumulative Other Co2

trade_co2_share

Trade Co2 Share

share_global_co2

Share Global Co2

share_global_cement_co2

Share Global Cement Co2

share_global_coal_co2

Share Global Coal Co2

share_global_flaring_co2

Share Global Flaring Co2

share_global_gas_co2

Share Global Gas Co2

share_global_oil_co2

Share Global Oil Co2

share_global_other_co2

Share Global Other Co2

share_global_cumulative_co2

Share Global Cumulative Co2

share_global_cumulative_cement_co2

Share Global Cumulative Cement Co2

share_global_cumulative_coal_co2

Share Global Cumulative Coal Co2

share_global_cumulative_flaring_co2

Share Global Cumulative Flaring Co2

share_global_cumulative_gas_co2

Share Global Cumulative Gas Co2

share_global_cumulative_oil_co2

Share Global Cumulative Oil Co2

share_global_cumulative_other_co2

Share Global Cumulative Other Co2

total_ghg

Total Ghg

ghg_per_capita

Ghg Per Capita

total_ghg_excluding_lucf

Total Ghg Excluding Lucf

ghg_excluding_lucf_per_capita

Ghg Excluding Lucf Per Capita

methane

Methane

methane_per_capita

Methane Per Capita

nitrous_oxide

Nitrous Oxide

nitrous_oxide_per_capita

Nitrous Oxide Per Capita

population

Population

gdp

Gdp

primary_energy_consumption

Primary Energy Consumption

energy_per_capita

Energy Per Capita

energy_per_gdp

Energy Per Gdp

AFGAfghanistan19490.0150.0020.0150.0020.0150.0157624058
AFGAfghanistan19500.0840.0110.0210.0030.0630.0084750.070.0090.0990.0360.06377521179421400064
AFGAfghanistan19510.0920.0120.0260.0030.0660.0088.70.0070.010.1910.0610.12978401519692279808
AFGAfghanistan19520.0920.0120.0320.0040.060.0080.0090.2820.0930.189793599610017325056
AFGAfghanistan19530.1060.0130.0380.0050.0680.008160.0150.010.3880.1310.257803968410630519808
AFGAfghanistan19540.1060.0130.0430.0050.0640.0080.010.4950.1740.321815131610866360320
AFGAfghanistan19550.1540.0190.0620.0080.0920.01144.830.0480.0140.6490.2360.413827099211078185984
AFGAfghanistan19560.1830.0220.0620.0070.1210.01419.050.0290.0160.8320.2980.534839887311581236224
AFGAfghanistan19570.2930.0340.0770.0090.2160.025600.110.0251.1250.3750.750.01853515711578973184
AFGAfghanistan19580.330.0380.0920.0110.2380.02712.50.0370.0271.4550.4670.9880.01868009712238841856

CREATE TABLE owid_co2_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "co2" DOUBLE,
  "co2_per_capita" DOUBLE,
  "trade_co2" DOUBLE,
  "cement_co2" DOUBLE,
  "cement_co2_per_capita" DOUBLE,
  "coal_co2" DOUBLE,
  "coal_co2_per_capita" DOUBLE,
  "flaring_co2" DOUBLE,
  "flaring_co2_per_capita" DOUBLE,
  "gas_co2" DOUBLE,
  "gas_co2_per_capita" DOUBLE,
  "oil_co2" DOUBLE,
  "oil_co2_per_capita" DOUBLE,
  "other_industry_co2" DOUBLE,
  "other_co2_per_capita" DOUBLE,
  "co2_growth_prct" DOUBLE,
  "co2_growth_abs" DOUBLE,
  "co2_per_gdp" DOUBLE,
  "co2_per_unit_energy" DOUBLE,
  "consumption_co2" DOUBLE,
  "consumption_co2_per_capita" DOUBLE,
  "consumption_co2_per_gdp" DOUBLE,
  "cumulative_co2" DOUBLE,
  "cumulative_cement_co2" DOUBLE,
  "cumulative_coal_co2" DOUBLE,
  "cumulative_flaring_co2" DOUBLE,
  "cumulative_gas_co2" DOUBLE,
  "cumulative_oil_co2" DOUBLE,
  "cumulative_other_co2" DOUBLE,
  "trade_co2_share" DOUBLE,
  "share_global_co2" DOUBLE,
  "share_global_cement_co2" DOUBLE,
  "share_global_coal_co2" DOUBLE,
  "share_global_flaring_co2" DOUBLE,
  "share_global_gas_co2" DOUBLE,
  "share_global_oil_co2" DOUBLE,
  "share_global_other_co2" DOUBLE,
  "share_global_cumulative_co2" DOUBLE,
  "share_global_cumulative_cement_co2" DOUBLE,
  "share_global_cumulative_coal_co2" DOUBLE,
  "share_global_cumulative_flaring_co2" DOUBLE,
  "share_global_cumulative_gas_co2" DOUBLE,
  "share_global_cumulative_oil_co2" DOUBLE,
  "share_global_cumulative_other_co2" DOUBLE,
  "total_ghg" DOUBLE,
  "ghg_per_capita" DOUBLE,
  "total_ghg_excluding_lucf" DOUBLE,
  "ghg_excluding_lucf_per_capita" DOUBLE,
  "methane" DOUBLE,
  "methane_per_capita" DOUBLE,
  "nitrous_oxide" DOUBLE,
  "nitrous_oxide_per_capita" DOUBLE,
  "population" DOUBLE,
  "gdp" DOUBLE,
  "primary_energy_consumption" DOUBLE,
  "energy_per_capita" DOUBLE,
  "energy_per_gdp" DOUBLE
);

Share link

Anyone who has the link will be able to view this.