Dataset: S&P 500 Firms' ESG Ratings And CEO Info | Nov 2023

About this Dataset

S&P 500 Firms' ESG Ratings And CEO Info | Nov 2023

This dataset was created so I can explore any relationships between female CEOs and ESG rating scores among S&P 500 firms. Do firms with female CEOs perform better or worse in ESG ratings than the average or those with male CEOs?

I used the latest available data, and any firms without ESG Ratings or ratings before 2022 were discarded. This led to a total of 426 firms being analysed and 77 firms being discarded.

I used Yahoo Finance as they provide the CEO info and also the latest ESG rating data from Sustainalytics.

This dataset may be useful for further expanding on research relating ESG rating to firm characteristics. For example industry, number of employees, diversity, assets or profitability.

Tables

Sp500 Esg Ceo Info Filtered

@kaggle.flamingmasamune_s_and_p_500_firms_esg_ratings.sp500_esg_ceo_info_filtered

26.45 KB
426 rows
11 columns


CREATE TABLE sp500_esg_ceo_info_filtered (
  "ticker" VARCHAR,
  "esg_score" DOUBLE,
  "governance_score" DOUBLE,
  "environment_score" DOUBLE,
  "social_score" DOUBLE,
  "esg_score_date" TIMESTAMP,
  "esg_status" VARCHAR,
  "ceo_full_name" VARCHAR,
  "ceo_gender" VARCHAR,
  "ceo_status" VARCHAR,
  "year" BIGINT
);

Sp500 Esg Ceo Info

@kaggle.flamingmasamune_s_and_p_500_firms_esg_ratings.sp500_esg_ceo_info

28.74 KB
503 rows
10 columns


CREATE TABLE sp500_esg_ceo_info (
  "ticker" VARCHAR,
  "esg_score" DOUBLE,
  "governance_score" DOUBLE,
  "environment_score" DOUBLE,
  "social_score" DOUBLE,
  "esg_score_date" TIMESTAMP,
  "esg_status" VARCHAR,
  "ceo_full_name" VARCHAR,
  "ceo_gender" VARCHAR,
  "ceo_status" VARCHAR
);