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

Roe

@kaggle.giuliofabbri_environment_data.roe

17.82 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 EQUITY - TOTAL (%)	62.8	67.84	63.64	72.08	55.02	51.47	60.08	41.75	42.04	38.58	32.52
AIRBUS SE	Netherlands	Industrials	Aerospace & Defense	polluter	RETURN ON EQUITY - TOTAL (%)	5.71	11.68	12.75	13.68	26.14	41.39	20.68	33.79	29.85	-17.35	-18.24
AKZO NOBEL N.V.	Netherlands	Basic Materials	Speciality Chemicals	polluter	RETURN ON EQUITY - TOTAL (%)	9	5.24	-26.94	11.6	9.59	15.95	14.88	13.4	75.42	5.93	10.42
ALSTOM SA	France	Industrials	Construction Machinery & Heavy Transportation Equipment	polluter	RETURN ON EQUITY - TOTAL (%)	35.06	11.34	17.46		11.08	-15.67	80.97	8.33	12.46	18.24	12.69
AP MOELLER MAERSK	Denmark	Industrials	Marine Transportation	polluter	RETURN ON EQUITY - TOTAL (%)	16.02	8.09	10.76	9.13	12	2.15	-5.67	-3.84	9.97	-0.28	10.03
ARCELORMITTAL SA	Luxembourg	Basic Materials	Steel	polluter	RETURN ON EQUITY - TOTAL (%)	4.95	3.58	-6.96	-5.55	-2.44	-26.24	6.42	13.17	12.66	-6.18	-1.97
BASF SE	Germany	Basic Materials	Diversified Chemicals	polluter	RETURN ON EQUITY - TOTAL (%)	23.44	27.17	20.03	18.72	18.86	13.62	12.93	18.52	13.67	22	-2.82
CAPGEMINI SE	France	Technology	IT Consulting & Other Services	non-polluter	RETURN ON EQUITY - TOTAL (%)	6.57	9.43	8.46	9.89	12.19	18.82	13.01	11.53	10.11	10.76	13.18
CARGOTEC CORP	Finland	Industrials	Industrial Machinery & Supplies & Components	polluter	RETURN ON EQUITY - TOTAL (%)	7.66	13.28	7.4	4.48	5.85	11.22	9.22	9.65	7.51	6.27	0.59
CORBION NV	Netherlands	Basic Materials	Speciality Chemicals	polluter	RETURN ON EQUITY - TOTAL (%)	8.98	-17.29	-7.46	0.22	-4.08	15.65	20.58	17.13	10.76	4.92	13.99


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