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

Scope2

@kaggle.giuliofabbri_environment_data.scope2

27.22 KB
63 rows
24 columns

company Company	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	CO2 Equivalents Emission Indirect	182328	222168	224615	232988	228030	237239	263050	243773	282026	281489	162983	1242.72803513489	1770.9860500152	1884.60535838756	2022.10936719377	2027.99106051691	2072.34992571816	2377.2030793812	2500.04954568865	3062.03672861722	3320.02688719509	2579.76117104498
AIRBUS SE	CO2 Equivalents Emission Indirect	428531	455370.7	431164	423814	405077	401734	377955	422099	424000	395000	350000	18740.1203869784	20401.4593999117	19981.9327924255	20765.4337413976	19407.0187001582	20636.2706932856	19090.2728005549	23328.2791401618	22719.2818088741	20034.3082433847	17847.3736660534
AKZO NOBEL N.V.	CO2 Equivalents Emission Indirect	3200000	3200000	3200000	2800000	2800000	2300000	2000000	1900000	226000	183100	168200	34215.0203364225	32459.0665892573	29010.3934617477	22987.9911682843	22480.6846629068	17624.6483990267	14804.2380925986	14849.1312472329	1999.77539553609	1057.27518768834	1025.29953287769
ALSTOM SA	CO2 Equivalents Emission Indirect	280000	267000	344000	326000	324000	70000	69000	62000	65000	65000	70000	3877.37729164801	4028.62968538348	5383.35998148909	5338.1003010857	4942.83105640276	1169.57014196716	450.213080303341	440.110945540793	438.602303814278	395.098279124703	429.863396957098
AP MOELLER MAERSK	CO2 Equivalents Emission Indirect	653000	685000	683000	382000	402000	415000	252000	402000	338000	287000	324000	133703.178977981	145779.466260933	150675.130160684	83825.0283303624	89587.8565888326	90188.7185376053	52433.5910097337	78619.6487517211	60228.1187784037	48905.1784510545	53021.4933251252
ARCELORMITTAL SA	CO2 Equivalents Emission Indirect	19599000	17902000	17256000	21000000	17000000	16000000	14000000	15100000	13900000	12100000	9500000	1008181.3339797	851879.106128986	736710.177962363	865423.346650072	679759.197877705	531958.964103181	448553.082324663	493539.910036906	488220.198509392	396446.768005487	277482.102645544
BASF SE	CO2 Equivalents Emission Indirect	4389000	4879000	3977000	3987000	3911000	3795000	3884000	3796000	4067000	3519000	3279000	142943.292577632	157450.497666511	133352.963246632	138404.561641164	143385.539037158	134702.458766458	140127.722557136	145739.642334003	166289.073247242	137145.043233612	121229.176428156
CAPGEMINI SE	CO2 Equivalents Emission Indirect	121984.26	119557.85	175428	144936	145772	230527	186822	174804	153837	188200	116229	613.41677238878	636.021425779575	890.293144127083	726.479143099103	803.122331307872	1756.19285338989	1365.29547173288	1291.99058611251	1147.99478214303	1495.150934571	1171.76131525339
CARGOTEC CORP	CO2 Equivalents Emission Indirect	29375	9588	18028.61	18200	24600	25500	26300	23500	28600	29700	23700	45.7682681967017	15.3023247528931	30.2225671660037	31.8617973641951	45.3030352785251	44.4030221550171	45.5466053895464	40.1102905815909	49.2474204570007	56.4018782317058	42.8893658823454
CORBION NV	CO2 Equivalents Emission Indirect	174000	186000	144000	94000	91000	88000	90000	86000	101000	96000	96000	247.554425328986	234.726523847228	165.398864701669	38.5869851753343	37.2377618137144	35.8339096519195	35.8836239477493	34.8099095193046	46.2519886521805	48.0852382949932	48.9841787055239


CREATE TABLE scope2 (
  "company" 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
);