Environment, Social And Governance Data
Environment, Social And Governance Data
@kaggle.tunguz_environment_social_and_governance_data
Environment, Social And Governance Data
@kaggle.tunguz_environment_social_and_governance_data
The World Bank’s ESG Data Draft dataset provides information on 17 key sustainability themes spanning environmental, social, and governance categories.
In order to shift financial flows so that they are better aligned with global goals, the World Bank Group (WBG) is working to provide financial markets with improved data and analytics that shed light on countries’ sustainability performance. Along with new information and tools, the World Bank will also develop research on the correlation between countries’ sustainability performance and the risk and return profiles of relevant investments.
CREATE TABLE esgcountry (
"country_code" VARCHAR,
"short_name" VARCHAR,
"table_name" VARCHAR,
"long_name" VARCHAR,
"n_2_alpha_code" VARCHAR -- 2-alpha Code,
"currency_unit" VARCHAR,
"special_notes" VARCHAR,
"region" VARCHAR,
"income_group" VARCHAR,
"wb_2_code" VARCHAR,
"national_accounts_base_year" VARCHAR,
"national_accounts_reference_year" DOUBLE,
"sna_price_valuation" VARCHAR,
"lending_category" VARCHAR,
"other_groups" VARCHAR,
"system_of_national_accounts" VARCHAR,
"alternative_conversion_factor" VARCHAR,
"ppp_survey_year" VARCHAR,
"balance_of_payments_manual_in_use" VARCHAR,
"external_debt_reporting_status" VARCHAR,
"system_of_trade" VARCHAR,
"government_accounting_concept" VARCHAR,
"imf_data_dissemination_standard" VARCHAR,
"latest_population_census" VARCHAR,
"latest_household_survey" VARCHAR,
"source_of_most_recent_income_and_expenditure_data" VARCHAR,
"vital_registration_complete" VARCHAR,
"latest_agricultural_census" VARCHAR,
"latest_industrial_data" DOUBLE,
"latest_trade_data" DOUBLE,
"unnamed_30" VARCHAR -- Unnamed: 30
);CREATE TABLE esgcountry_series (
"countrycode" VARCHAR,
"seriescode" VARCHAR,
"description" VARCHAR,
"unnamed_3" VARCHAR -- Unnamed: 3
);CREATE TABLE esgdata (
"country_name" VARCHAR,
"country_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_code" VARCHAR,
"n_1960" DOUBLE -- 1960,
"n_1961" DOUBLE -- 1961,
"n_1962" DOUBLE -- 1962,
"n_1963" DOUBLE -- 1963,
"n_1964" DOUBLE -- 1964,
"n_1965" DOUBLE -- 1965,
"n_1966" DOUBLE -- 1966,
"n_1967" DOUBLE -- 1967,
"n_1968" DOUBLE -- 1968,
"n_1969" DOUBLE -- 1969,
"n_1970" DOUBLE -- 1970,
"n_1971" DOUBLE -- 1971,
"n_1972" DOUBLE -- 1972,
"n_1973" DOUBLE -- 1973,
"n_1974" DOUBLE -- 1974,
"n_1975" DOUBLE -- 1975,
"n_1976" DOUBLE -- 1976,
"n_1977" DOUBLE -- 1977,
"n_1978" DOUBLE -- 1978,
"n_1979" DOUBLE -- 1979,
"n_1980" DOUBLE -- 1980,
"n_1981" DOUBLE -- 1981,
"n_1982" DOUBLE -- 1982,
"n_1983" DOUBLE -- 1983,
"n_1984" DOUBLE -- 1984,
"n_1985" DOUBLE -- 1985,
"n_1986" DOUBLE -- 1986,
"n_1987" DOUBLE -- 1987,
"n_1988" DOUBLE -- 1988,
"n_1989" DOUBLE -- 1989,
"n_1990" DOUBLE -- 1990,
"n_1991" DOUBLE -- 1991,
"n_1992" DOUBLE -- 1992,
"n_1993" DOUBLE -- 1993,
"n_1994" DOUBLE -- 1994,
"n_1995" DOUBLE -- 1995,
"n_1996" DOUBLE -- 1996,
"n_1997" DOUBLE -- 1997,
"n_1998" DOUBLE -- 1998,
"n_1999" DOUBLE -- 1999,
"n_2000" DOUBLE -- 2000,
"n_2001" DOUBLE -- 2001,
"n_2002" DOUBLE -- 2002,
"n_2003" DOUBLE -- 2003,
"n_2004" DOUBLE -- 2004,
"n_2005" DOUBLE -- 2005,
"n_2006" DOUBLE -- 2006,
"n_2007" DOUBLE -- 2007,
"n_2008" DOUBLE -- 2008,
"n_2009" DOUBLE -- 2009,
"n_2010" DOUBLE -- 2010,
"n_2011" DOUBLE -- 2011,
"n_2012" DOUBLE -- 2012,
"n_2013" DOUBLE -- 2013,
"n_2014" DOUBLE -- 2014,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2050" DOUBLE -- 2050,
"unnamed_66" VARCHAR -- Unnamed: 66
);CREATE TABLE esgfootnote (
"countrycode" VARCHAR,
"seriescode" VARCHAR,
"year" VARCHAR,
"description" VARCHAR,
"unnamed_4" VARCHAR -- Unnamed: 4
);CREATE TABLE esgseries (
"series_code" VARCHAR,
"topic" VARCHAR,
"indicator_name" VARCHAR,
"short_definition" VARCHAR,
"long_definition" VARCHAR,
"unit_of_measure" VARCHAR,
"periodicity" VARCHAR,
"base_period" VARCHAR,
"other_notes" VARCHAR,
"aggregation_method" VARCHAR,
"limitations_and_exceptions" VARCHAR,
"notes_from_original_source" VARCHAR,
"general_comments" VARCHAR,
"source" VARCHAR,
"statistical_concept_and_methodology" VARCHAR,
"development_relevance" VARCHAR,
"related_source_links" VARCHAR,
"other_web_links" VARCHAR,
"related_indicators" VARCHAR,
"license_type" VARCHAR,
"unnamed_20" VARCHAR -- Unnamed: 20
);CREATE TABLE esgseries_time (
"seriescode" VARCHAR,
"year" VARCHAR,
"description" VARCHAR,
"unnamed_3" VARCHAR -- Unnamed: 3
);Anyone who has the link will be able to view this.