Environment, Social And Governance Data

@kaggle.tunguz_environment_social_and_governance_data

Table List

6 tables(3.62 MB)

Esgcountry Series

Esgdata

Esgcountry

@kaggle.tunguz_environment_social_and_governance_data.esgcountry

49.22 KB
239 rows
31 columns

country_code Country Code	short_name Short Name	table_name Table Name	long_name Long Name	n_2_alpha_code 2-alpha Code	currency_unit Currency Unit	special_notes Special Notes	region Region	income_group Income Group	wb_2_code WB-2 Code	national_accounts_base_year National Accounts Base Year	national_accounts_reference_year National Accounts Reference Year	sna_price_valuation SNA Price Valuation	lending_category Lending Category	other_groups Other Groups	system_of_national_accounts System Of National Accounts	alternative_conversion_factor Alternative Conversion Factor	balance_of_payments_manual_in_use Balance Of Payments Manual In Use	external_debt_reporting_status External Debt Reporting Status	system_of_trade System Of Trade	government_accounting_concept Government Accounting Concept	imf_data_dissemination_standard IMF Data Dissemination Standard	latest_population_census Latest Population Census	latest_household_survey Latest Household Survey	source_of_most_recent_income_and_expenditure_data Source Of Most Recent Income And Expenditure Data	vital_registration_complete Vital Registration Complete	latest_agricultural_census Latest Agricultural Census	latest_industrial_data Latest Industrial Data	latest_trade_data Latest Trade Data
AFG	Afghanistan	Afghanistan	Islamic State of Afghanistan	AF	Afghan afghani	nan	South Asia	Low income	AF	2016		Value added at basic prices (VAB)	IDA	HIPC	Country uses the 1993 System of National Accounts methodology	nan	BPM6	Actual	General trade system	Consolidated central government	Enhanced General Data Dissemination System (e-GDDS)	1979	Demographic and Health Survey, 2015	Integrated household survey (IHS), 2016/17	nan	nan		2017
AGO	Angola	Angola	People's Republic of Angola	AO	Angolan kwanza	nan	Sub-Saharan Africa	Lower middle income	AO	2002		Value added at producer prices (VAP)	IBRD	nan	Country uses the 1993 System of National Accounts methodology	1991–96	BPM6	Actual	Special trade system	Budgetary central government	Enhanced General Data Dissemination System (e-GDDS)	2014	Demographic and Health Survey, 2015/16	Integrated household survey (IHS), 2008/09	nan	nan		2017
ALB	Albania	Albania	Republic of Albania	AL	Albanian lek	nan	Europe & Central Asia	Upper middle income	AL	Original chained constant price data are rescaled.	2010	Value added at basic prices (VAB)	IBRD	nan	Country uses the 2008 System of National Accounts methodology	nan	BPM6	Actual	Special trade system	Consolidated central government	Enhanced General Data Dissemination System (e-GDDS)	2011	Demographic and Health Survey, 2017/18	Living Standards Measurement Study Survey (LSMS), 2012	Yes	2012	2013	2017
AND	Andorra	Andorra	Principality of Andorra	AD	Euro	nan	Europe & Central Asia	High income	AD	2010		Value added at basic prices (VAB)	nan	nan	Country uses the 1993 System of National Accounts methodology	nan	BPM6	nan	General trade system	nan	nan	2011. Population data compiled from administrative registers.	nan	nan	Yes	nan
ARB	Arab World	Arab World	Arab World	1A	nan	Arab World aggregate. Arab World is composed of members of the League of Arab States.	nan	nan	1A	nan		nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan		2016
ARE	United Arab Emirates	United Arab Emirates	United Arab Emirates	AE	U.A.E. dirham	nan	Middle East & North Africa	High income	AE	2010		Value added at producer prices (VAP)	nan	nan	Country uses the 1993 System of National Accounts methodology	nan	nan	nan	Special trade system	Consolidated central government	Enhanced General Data Dissemination System (e-GDDS)	2010	World Health Survey, 2003	nan	Yes	2012	1985	2017
ARG	Argentina	Argentina	Argentine Republic	AR	Argentine peso	nan	Latin America & Caribbean	Upper middle income	AR	2004		Value added at basic prices (VAB)	IBRD	nan	Country uses the 2008 System of National Accounts methodology	1971–84; 2012-15	BPM6	Actual	Special trade system	Consolidated central government	Special Data Dissemination Standard (SDDS)	2010	Multiple Indicator Cluster Survey, 2011/12	Integrated household survey (IHS), 2016	Yes	2008	2002	2017
ARM	Armenia	Armenia	Republic of Armenia	AM	Armenian dram	nan	Europe & Central Asia	Upper middle income	AM	Original chained constant price data are rescaled.	2012	Value added at basic prices (VAB)	IBRD	nan	Country uses the 2008 System of National Accounts methodology	1990–95	BPM6	Actual	General trade system	Consolidated central government	Special Data Dissemination Standard (SDDS)	2011	Demographic and Health Survey, 2015/16	Integrated household survey (IHS), 2016	Yes	2014		2017
ATG	Antigua and Barbuda	Antigua and Barbuda	Antigua and Barbuda	AG	East Caribbean dollar	nan	Latin America & Caribbean	High income	AG	2006		Value added at basic prices (VAB)	IBRD	nan	Country uses the 2008 System of National Accounts methodology	nan	BPM6	nan	General trade system	Budgetary central government	Enhanced General Data Dissemination System (e-GDDS)	2011	nan	nan	Yes	2007		2017
AUS	Australia	Australia	Commonwealth of Australia	AU	Australian dollar	Fiscal year end: June 30; reporting period for national accounts data: FY.	East Asia & Pacific	High income	AU	Original chained constant price data are rescaled.	2019	Value added at basic prices (VAB)	nan	nan	Country uses the 2008 System of National Accounts methodology	nan	BPM6	nan	General trade system	Consolidated central government	Special Data Dissemination Standard (SDDS)	2016	nan	Expenditure survey/budget survey (ES/BS), 2010	Yes	2015-2016	2013	2017


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
);