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

Roa

@kaggle.giuliofabbri_environment_data.roa

17.53 KB
63 rows
17 columns

company Company	country Country	economic_sector Economic Sector	sub_industry Sub Industry	pollution Pollution	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
ACCENTURE PLC	Ireland	Technology	IT Consulting & Other Services	non-polluter	RETURN ON ASSETS	15.04	16.77	16.63	20.76	18.1	18.14	23.8	17.72	19.02	20.07	17.59
AIRBUS SE	Netherlands	Industrials	Aerospace & Defense	polluter	RETURN ON ASSETS	1.08	1.6	1.88	2.07	3.03	3.3	1.38	2.99	3.12	-0.93	-0.67
AKZO NOBEL N.V.	Netherlands	Basic Materials	Speciality Chemicals	polluter	RETURN ON ASSETS	5.14	3.39	-10.31	5.73	4.51	7.19	7.12	5.87	39.9	3.93	5.46
ALSTOM SA	France	Industrials	Construction Machinery & Heavy Transportation Equipment	polluter	RETURN ON ASSETS	5.23	2.12	3.02		2.46	-1.72	14.06	2.52	3.73	5.56	3.94
AP MOELLER MAERSK	Denmark	Industrials	Marine Transportation	polluter	RETURN ON ASSETS	8.32	4.31	5.9	5.21	7.11	1.62	-2.29	-1.02	6.53	0.74	6.52
ARCELORMITTAL SA	Luxembourg	Basic Materials	Steel	polluter	RETURN ON ASSETS	3.81	2.8	-1.54	-0.69	0.47	-8.49	3.51	7.2	7.2	-2.2	-0.34
BASF SE	Germany	Basic Materials	Diversified Chemicals	polluter	RETURN ON ASSETS	9.3	11.3	8.61	8.49	8.43	6.32	6.3	8.57	6.3	10.57	-0.69
CAPGEMINI SE	France	Technology	IT Consulting & Other Services	non-polluter	RETURN ON ASSETS	3.77	4.97	4.23	5.13	6.2	9.48	6.75	5.77	5.1	5.57	5.55
CARGOTEC CORP	Finland	Industrials	Industrial Machinery & Supplies & Components	polluter	RETURN ON ASSETS	3.53	5.67	3.36	2.24	2.86	4.63	4.28	4.29	3.45	2.75	0.36
CORBION NV	Netherlands	Basic Materials	Speciality Chemicals	polluter	RETURN ON ASSETS	5.46	-5.83	-1.69	0.58	-1.79	10.85	13.68	11.16	6.92	3.13	7.8


CREATE TABLE roa (
  "company" VARCHAR,
  "country" VARCHAR,
  "economic_sector" VARCHAR,
  "sub_industry" VARCHAR,
  "pollution" 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
);