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
CREATE TABLE esgcountry_series (
"countrycode" VARCHAR,
"seriescode" VARCHAR,
"description" VARCHAR,
"unnamed_3" VARCHAR
);
CREATE TABLE esgcountry (
"country_code" VARCHAR,
"short_name" VARCHAR,
"table_name" VARCHAR,
"long_name" VARCHAR,
"n_2_alpha_code" VARCHAR,
"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
);
CREATE TABLE esgdata (
"country_name" VARCHAR,
"country_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_code" VARCHAR,
"n_1960" DOUBLE,
"n_1961" DOUBLE,
"n_1962" DOUBLE,
"n_1963" DOUBLE,
"n_1964" DOUBLE,
"n_1965" DOUBLE,
"n_1966" DOUBLE,
"n_1967" DOUBLE,
"n_1968" DOUBLE,
"n_1969" DOUBLE,
"n_1970" DOUBLE,
"n_1971" DOUBLE,
"n_1972" DOUBLE,
"n_1973" DOUBLE,
"n_1974" DOUBLE,
"n_1975" DOUBLE,
"n_1976" DOUBLE,
"n_1977" DOUBLE,
"n_1978" DOUBLE,
"n_1979" DOUBLE,
"n_1980" DOUBLE,
"n_1981" DOUBLE,
"n_1982" DOUBLE,
"n_1983" DOUBLE,
"n_1984" DOUBLE,
"n_1985" DOUBLE,
"n_1986" DOUBLE,
"n_1987" DOUBLE,
"n_1988" DOUBLE,
"n_1989" DOUBLE,
"n_1990" DOUBLE,
"n_1991" DOUBLE,
"n_1992" DOUBLE,
"n_1993" DOUBLE,
"n_1994" DOUBLE,
"n_1995" DOUBLE,
"n_1996" DOUBLE,
"n_1997" DOUBLE,
"n_1998" DOUBLE,
"n_1999" DOUBLE,
"n_2000" DOUBLE,
"n_2001" DOUBLE,
"n_2002" DOUBLE,
"n_2003" DOUBLE,
"n_2004" DOUBLE,
"n_2005" DOUBLE,
"n_2006" DOUBLE,
"n_2007" DOUBLE,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"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,
"n_2050" DOUBLE,
"unnamed_66" VARCHAR
);
CREATE TABLE esgfootnote (
"countrycode" VARCHAR,
"seriescode" VARCHAR,
"year" VARCHAR,
"description" VARCHAR,
"unnamed_4" VARCHAR
);
CREATE TABLE esgseries_time (
"seriescode" VARCHAR,
"year" VARCHAR,
"description" VARCHAR,
"unnamed_3" VARCHAR
);
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
);
Anyone who has the link will be able to view this.