Greenhouse Gas Giants

Historical production data from largest fossil fuel producers

@kaggle.konradb_greenhouse_gas_giants

Table List

3 tables(1.4 MB)

Emissions High Granularity

Emissions Low Granularity

Emissions Medium Granularity

Emissions High Granularity

@kaggle.konradb_greenhouse_gas_giants.emissions_high_granularity

1.1 MB
15797 rows
16 columns

year Year	parent_entity Parent Entity	parent_type Parent Type	reporting_entity Reporting Entity	commodity Commodity	production_value Production Value	production_unit Production Unit	product_emissions_mtco2 Product Emissions MtCO2	flaring_emissions_mtco2 Flaring Emissions MtCO2	venting_emissions_mtco2 Venting Emissions MtCO2	fugitive_methane_emissions_mtco2e Fugitive Methane Emissions MtCO2e	fugitive_methane_emissions_mtch4 Fugitive Methane Emissions MtCH4	total_operational_emissions_mtco2e Total Operational Emissions MtCO2e	total_emissions_mtco2e Total Emissions MtCO2e	source Source
1962	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	0.9125	Million bbl/yr	0.3389276996	0.0054040774447285	0.001298971928993	0.0182540819247638	0.0006519314973129	0.0249571312984854	0.3638848308984855	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-37
1963	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	1.825	Million bbl/yr	0.6778553992	0.010808154889457	0.0025979438579861	0.0365081638495277	0.0013038629946259	0.0499142625969709	0.727769661796971	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-38
1964	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	7.300000000000002	Million bbl/yr	2.7114215968	0.0432326195578283	0.0103917754319445	0.1460326553981109	0.0052154519785039	0.1996570503878838	2.911078647187884	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-39
1965	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	10.95	Million bbl/yr	4.067132395200001	0.0648489293367425	0.0155876631479167	0.2190489830971664	0.0078231779677559	0.2994855755818257	4.366617970781825	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-40
1966	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	13.505	Million bbl/yr	5.01612995408	0.0799803461819825	0.0192247845490973	0.2701604124865052	0.0096485861602323	0.369365543217585	5.385495497297585	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-41
1967	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	14.6	Million bbl/yr	5.4228431936	0.0864652391156567	0.020783550863889	0.2920653107962219	0.0104309039570079	0.3993141007757676	5.822157294375768	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-42
1968	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	18.25	Million bbl/yr	6.778553992	0.1080815488945709	0.0259794385798612	0.3650816384952773	0.0130386299462599	0.4991426259697094	7.277696617969709	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-43
1969	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	22.265	Million bbl/yr	8.269835870240001	0.1318594896513766	0.0316949150674307	0.4453995989642384	0.015907128534437	0.6089540036830458	8.878789873923047	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-44
1970	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	25.7325	Million bbl/yr	9.55776112872	0.152394983941345	0.0366310083976043	0.514765110278341	0.0183844682242264	0.7037911026172904	10.261552231337292	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-45
1971	Abu Dhabi National Oil Company	State-owned Entity	Abu Dhabi	Oil & NGL	34.309999999999995	Million bbl/yr	12.74368150496	0.2031933119217933	0.0488413445301391	0.6863534803711213	0.0245126242989686	0.9383881368230538	13.682069641783054	Abu Dhabi National Oil Company Annual Report 1975, pp. 35-46


CREATE TABLE emissions_high_granularity (
  "year" BIGINT,
  "parent_entity" VARCHAR,
  "parent_type" VARCHAR,
  "reporting_entity" VARCHAR,
  "commodity" VARCHAR,
  "production_value" DOUBLE,
  "production_unit" VARCHAR,
  "product_emissions_mtco2" DOUBLE,
  "flaring_emissions_mtco2" DOUBLE,
  "venting_emissions_mtco2" DOUBLE,
  "own_fuel_use_emissions_mtco2" DOUBLE,
  "fugitive_methane_emissions_mtco2e" DOUBLE,
  "fugitive_methane_emissions_mtch4" DOUBLE,
  "total_operational_emissions_mtco2e" DOUBLE,
  "total_emissions_mtco2e" DOUBLE,
  "source" VARCHAR
);