Financial-environmental Multi Time Series

Relation between emissions and Financial performance

@kaggle.giuliofabbri_environment_data

Table List

6 tables(184.18 KB)

Div

Roa

Roe

Scope1

Scope2

Tot Ass

Scope1

@kaggle.giuliofabbri_environment_data.scope1

30.15 KB
63 rows
27 columns

company Company	country Country	economic_sector Economic Sector	sub_industry Sub Industry	metric Metric	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	wa_10 Wa 10	wa_11 Wa 11	wa_12 Wa 12	wa_13 Wa 13	wa_14 Wa 14	wa_15 Wa 15	wa_16 Wa 16	wa_17 Wa 17	wa_18 Wa 18	wa_19 Wa 19	wa_20 Wa 20
ACCENTURE PLC	Ireland	Technology	IT Consulting & Other Services	CO2 Equivalents Emission Direct	14270	12098	9383	32155	29767	26290	27203	24095	22183	18923	13945	97.2627849884539	96.4377823677755	78.7269420018719	279.074144171011	264.733631094185	229.650603598609	245.835602997175	247.10978575711	240.847158598554	223.187651334129	220.727128168105
AIRBUS SE	Netherlands	Industrials	Aerospace & Defense	CO2 Equivalents Emission Direct	594422	593529.5	580243	585911	545613	525883	557447	591002	739000	744000	585000	25994.7117960392	26591.2321475666	26890.8736102164	28707.631293105	26140.0220058147	27013.5560868563	28156.302474768	32663.0947441096	39597.9935300895	37735.5071723498	29830.6102704036
AKZO NOBEL N.V.	Netherlands	Basic Materials	Speciality Chemicals	CO2 Equivalents Emission Direct	2000000	1600000	1500000	1100000	1100000	1500000	1600000	1500000	70160	58290	57160	21384.3877102641	16229.5332946286	13598.6219351942	9030.99653039739	8831.69754614196	11494.3359124087	11843.3904740788	11722.9983530786	620.815228985894	336.584220045621	348.431161113488
ALSTOM SA	France	Industrials	Construction Machinery & Heavy Transportation Equipment	CO2 Equivalents Emission Direct	153000	187000	175000	183000	163000	54000	55000	51000	53000	55000	58000	2118.7097343648	2821.54962983787	2738.62789755986	2996.54096656038	2486.67117961003	902.239823803238	358.865498792519	362.026745525491	357.629570802411	334.313928490134	356.17252890731
AP MOELLER MAERSK	Denmark	Industrials	Marine Transportation	CO2 Equivalents Emission Direct	37020000	40284000	37948000	33494000	32406000	33044000	35917000	35579000	38749000	36204000	33973000	7579926.01189104	8573109.51657725	8371624.9477857	7349831.14894544	7221850.94681022	7181195.21772682	7473243.20752621	6958230.05705842	6904672.70575256	6169209.34021595	5559565.40967431
ARCELORMITTAL SA	Luxembourg	Basic Materials	Steel	CO2 Equivalents Emission Direct	165226000	162028000	158192000	169000000	174000000	176000000	176000000	179700000	174900000	173700000	140400000	8499299.40752742	7710214.93731803	6753688.94716169	6964597.40875534	6957535.31945416	5851548.60513499	5638953.03493862	5873451.77706172	6143144.79994911	5691140.79359942	4100893.3906773
BASF SE	Germany	Basic Materials	Diversified Chemicals	CO2 Equivalents Emission Direct	21312000	20920000	18808000	18842000	18450000	18375000	18094000	18775000	18593000	17323000	18395000	694100.581320231	675110.557733839	630651.881504315	654080.44907018	676416.05605614	652215.462406762	652798.921716997	720827.656696759	760219.507963111	675124.633116188	680088.655198515
CAPGEMINI SE	France	Technology	IT Consulting & Other Services	CO2 Equivalents Emission Direct	26531.11	3062.48	10203	11343	8251	9621	6225	6330	7470	12425	8479	133.415801875518	16.2917189964643	51.7799949240066	56.855804770196	45.4584032298469	73.2943709086749	45.4923098539634	46.7855450109389	55.7442034270588	98.7101507016192	85.4809401443141
CARGOTEC CORP	Finland	Industrials	Industrial Machinery & Supplies & Components	CO2 Equivalents Emission Direct	9375	29513	8671.39	7100	8800	8900	9800	8400	20100	22000	21300	14.6068941053303	47.1023686308024	14.536432187374	12.4296022684497	16.2059638394724	15.4975253795942	16.9717388904013	14.337295356824	34.6109493421578	41.7791690605228	38.5461389575509
CORBION NV	Netherlands	Basic Materials	Speciality Chemicals	CO2 Equivalents Emission Direct	135000	122000	155000	99000	92000	91000	94000	92000	94000	101000	100000	192.068088617317	153.960408114848	178.033500199714	40.6394843867883	37.6469679874915	37.0555202082349	37.4784516787603	37.2385078578608	43.0464052802472	50.5896777895241	51.0251861515874


CREATE TABLE scope1 (
  "company" VARCHAR,
  "country" VARCHAR,
  "economic_sector" VARCHAR,
  "sub_industry" VARCHAR,
  "metric" VARCHAR,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "wa_10" DOUBLE,
  "wa_11" DOUBLE,
  "wa_12" DOUBLE,
  "wa_13" DOUBLE,
  "wa_14" DOUBLE,
  "wa_15" DOUBLE,
  "wa_16" DOUBLE,
  "wa_17" DOUBLE,
  "wa_18" DOUBLE,
  "wa_19" DOUBLE,
  "wa_20" DOUBLE
);