Name: Global Corporate ESG And Financial Dataset
Creator: Kaggle
License: https://opensource.org/licenses/MIT

About this Dataset

Global Corporate ESG And Financial Dataset

This dataset offers a comprehensive overview of over 50,000 companies, detailing essential information such as website domain, company name, and stock ticker. It also includes variables indicating companies' involvement in specific controversial activities. This rich dataset is ideal for a variety of analyses, including ESG (Environmental, Social, and Governance) assessments, allowing users to explore corporate practices concerning these significant metrics. Whether you're a financial analyst, academic researcher, or data enthusiast, this dataset provides fertile ground for in-depth analysis of the global corporate landscape.

Dataset Contents

-domain: The official web domain of the company.

-name: The name of the company.

-ticker : The stock ticker symbol used for the company in stock exchanges.

-involvement: Indicators of the company's involvement in various controversial sectors:

Alcoholic Beverages: Involvement in alcoholic beverages.
Adult Entertainment: Involvement in adult entertainment.
Gambling: Involvement in gambling.
Tobacco Products: Involvement in tobacco products.
Animal Testing: Involvement in animal testing.
Fur and Specialty Leather: Involvement in fur and specialty leather.
Controversial Weapons: Involvement in controversial weapons.
Small Arms: Involvement in small arms.
Catholic Values: Involvement in activities contrary to Catholic values.
GMO: Involvement in genetically modified organisms.
Military Contracting: Involvement in military contracting.
Pesticides: Involvement in pesticides.
Thermal Coal: Involvement in thermal coal.
Palm Oil: Involvement in palm oil.

-employees: The number of employees in the company.

-industry: The industrial sector to which the company belongs.

-sector: The market sector to which the company belongs.

-altman_score: The company's Altman Z-score, used to predict bankruptcy risk.

-piotroski_score: The company's Piotroski F-score, used to assess the financial health of the company.

-Controversies: Indicators of the company's ESG controversies:

Environment: Environmental controversies.
Social: Social controversies.
Customers: Customer-related controversies.
Human Rights & Community: Human rights and community-related controversies.
Labor Rights & Supply Chain: Labor rights and supply chain-related controversies.
Governance: Governance-related controversies.

-Decarbonization Target: The company's decarbonization targets:

Target Year: The target year for the decarbonization goal.
Comprehensiveness: The percentage comprehensiveness of the decarbonization target.
Ambition p.a.: The annual percentage ambition of the decarbonization target.
Decarbonization Target: Whether the company has a decarbonization target.
Decarbonization Target on Temperature Rise: Whether the decarbonization target addresses temperature rise.
Temperature Goal: The company's temperature goal in degrees Celsius.

-sdg: The company's alignment with the United Nations Sustainable Development Goals:

No Poverty: No poverty.
No Hunger: Zero hunger.
Good Health and Well-Being: Good health and well-being.
Quality Education: Quality education.
Gender Equality: Gender equality.
Clean Water and Sanitation: Clean water and sanitation.
Affordable and Clean Energy: Affordable and clean energy.
Decent Work and Economic Growth: Decent work and economic growth.
Industry, Innovation and Infrastructure: Industry, innovation and infrastructure.
Reduced Inequalities: Reduced inequalities.
Sustainable Cities and Communities: Sustainable cities and communities.
Responsible Consumption and Production: Responsible consumption and production.
Climate Action: Climate action.
Life under Water: Life under water.
Life on Land: Life on land.
Peace, Justice and Strong Institutions: Peace, justice and strong institutions.
Partnerships for the Goals: Partnerships for the goals.

-esg: The company's overall Environmental, Social, and Governance (ESG) score.

-involvement_msci: The company's involvement in controversial sectors according to MSCI:

Controversial Weapons: Involvement in controversial weapons.
Gambling: Involvement in gambling.
Tobacco Products: Involvement in tobacco products.
Alcoholic Beverages: Involvement in alcoholic beverages.

The data may be incorrect, being scraped from YahooFinance.com, Investing.com, StockAnalysis.com, MSCI

Tables

Companies

@kaggle.tonylm00_business_companies_dataset.companies

421.07 kB
7,610 rows
3 columns

CREATE TABLE companies (
  "domain_name_ticker_involvement_alcoholic_beverages_inv_93c99a78" VARCHAR  -- Domain;name;ticker;involvement.Alcoholic Beverages;involvement.Adult Entertainment;involvement.Gambling;involvement.Tobacco Products;involvement.Animal Testing;involvement.Fur And Specialty Leather;involvement.Controversial Weapons;involvement.Small Arms;involvement.Catholic Values;involvement.GMO;involvement.Military Contracting;involvement.Pesticides;involvement.Thermal Coal;involvement.Palm Oil;employees;industry;sector;altman Score;piotroski Score;Controversies.Environment;Controversies.Social;Controversies.Customers;Controversies.Human Rights \u0026 Community;Controversies.Labor Rights \u0026 Supply Chain;Controversies.Governance;Decarbonization Target.Target Year;Decarbonization Target.Comprehensiveness;Decarbonization Target.Ambition P.a.;Decarbonization Target.Decarbonization Target;Decarbonization Target.Decarbonization Target On Temperature Rise;Temperature Goal;sdg.No Poverty;sdg.No Hunger;sdg.Good Health And Well-Being;sdg.Quality Education;sdg.Gender Equality;sdg.Clean Water And Sanitation;sdg.Affordable And Clean Energy;sdg.Decent Work And Economic Growth;sdg.Industry,
  "n__innovation_and_infrastructure_sdg_reduced_inequalit_bbce770c" VARCHAR  -- Innovation And Infrastructure;sdg.Reduced Inequalities;sdg.Sustainable Cities And Communities;sdg.Responsible Consumption And Production;sdg.Climate Action;sdg.Life Under Water;sdg.Life On Land;sdg.Peace,
  "n__justice_and_strong_institutions_sdg_partnerships_fo_c1621499" VARCHAR  -- Justice And Strong Institutions;sdg.Partnerships For The Goals;esg;involvement Msci.Controversial Weapons;involvement Msci.Gambling;involvement Msci.Tobacco Products;involvement Msci.Alcoholic Beverages;Controversies.Supply Chain Labor Standards;Controversies;Decarbonization Target;sdg;Controversies.Collective Bargaining \u0026 Union;Controversies.Health \u0026 Safety;Controversies.Discrimination \u0026 Workforce Diversity;Controversies.Labor Management Relations;involvement;involvement Msci;Controversies.Anticompetitive Practices;Controversies.Privacy \u0026 Data Security;Controversies.Bribery \u0026 Fraud;Controversies.Governance Structures;Controversies.Customer Relations;Controversies.Product Safety \u0026 Quality;Controversies.Human Rights Concerns;Controversies.Energy \u0026 Climate Change;Controversies.Toxic Emissions \u0026 Waste;Controversies.Impact On Local Communities;Controversies.Biodiversity \u0026 Land Use;Controversies.Other;Controversies.Marketing \u0026 Advertising;Controversies.Civil Liberties;Controversies.Operational Waste (Non-Hazardous);Controversies.Supply Chain Management;Controversies.Water Stress;Controversies.Child Labor;Controversies.Controversial Investments
);

Raw

@kaggle.tonylm00_business_companies_dataset.raw

1.76 MB
51,181 rows
3 columns

CREATE TABLE raw (
  "domain_name_ticker_involvement_alcoholic_beverages_inv_93c99a78" VARCHAR  -- Domain;name;ticker;involvement.Alcoholic Beverages;involvement.Adult Entertainment;involvement.Gambling;involvement.Tobacco Products;involvement.Animal Testing;involvement.Fur And Specialty Leather;involvement.Controversial Weapons;involvement.Small Arms;involvement.Catholic Values;involvement.GMO;involvement.Military Contracting;involvement.Pesticides;involvement.Thermal Coal;involvement.Palm Oil;employees;industry;sector;altman Score;piotroski Score;Controversies.Environment;Controversies.Social;Controversies.Customers;Controversies.Human Rights \u0026 Community;Controversies.Labor Rights \u0026 Supply Chain;Controversies.Governance;Decarbonization Target.Target Year;Decarbonization Target.Comprehensiveness;Decarbonization Target.Ambition P.a.;Decarbonization Target.Decarbonization Target;Decarbonization Target.Decarbonization Target On Temperature Rise;Temperature Goal;sdg.No Poverty;sdg.No Hunger;sdg.Good Health And Well-Being;sdg.Quality Education;sdg.Gender Equality;sdg.Clean Water And Sanitation;sdg.Affordable And Clean Energy;sdg.Decent Work And Economic Growth;sdg.Industry,
  "n__innovation_and_infrastructure_sdg_reduced_inequalit_bbce770c" VARCHAR  -- Innovation And Infrastructure;sdg.Reduced Inequalities;sdg.Sustainable Cities And Communities;sdg.Responsible Consumption And Production;sdg.Climate Action;sdg.Life Under Water;sdg.Life On Land;sdg.Peace,
  "n__justice_and_strong_institutions_sdg_partnerships_fo_c1621499" VARCHAR  -- Justice And Strong Institutions;sdg.Partnerships For The Goals;esg;involvement Msci.Controversial Weapons;involvement Msci.Gambling;involvement Msci.Tobacco Products;involvement Msci.Alcoholic Beverages;Controversies.Supply Chain Labor Standards;Controversies;Decarbonization Target;sdg;Controversies.Collective Bargaining \u0026 Union;Controversies.Health \u0026 Safety;Controversies.Discrimination \u0026 Workforce Diversity;Controversies.Labor Management Relations;involvement;involvement Msci;Controversies.Anticompetitive Practices;Controversies.Privacy \u0026 Data Security;Controversies.Bribery \u0026 Fraud;Controversies.Governance Structures;Controversies.Customer Relations;Controversies.Product Safety \u0026 Quality;Controversies.Human Rights Concerns;Controversies.Energy \u0026 Climate Change;Controversies.Toxic Emissions \u0026 Waste;Controversies.Impact On Local Communities;Controversies.Biodiversity \u0026 Land Use;Controversies.Other;Controversies.Marketing \u0026 Advertising;Controversies.Civil Liberties;Controversies.Operational Waste (Non-Hazardous);Controversies.Supply Chain Management;Controversies.Water Stress;Controversies.Child Labor;Controversies.Controversial Investments
);