Countries Financial Summary

Check out the financial summaries of few countries in the world

@kaggle.dhronacharya_all_countries_financial_summary

Table List

1 table(39.18 KB)

Country Summary

@kaggle.dhronacharya_all_countries_financial_summary.country_summary

39.18 KB
135 rows
31 columns

country_code Country Code	short_name Short Name	table_name Table Name	long_name Long Name	two_alpha_code Two 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	ppp_survey_year Ppp Survey Year	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
EAP	East Asia & Pacific (excluding high income)	East Asia & Pacific (excluding high income)	East Asia & Pacific (excluding high income)	4E	nan	East Asia and Pacific regional aggregate (does not include high-income economies).	nan	nan	4E	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
ECA	Europe & Central Asia (excluding high income)	Europe & Central Asia (excluding high income)	Europe & Central Asia (excluding high income)	7E	nan	Europe and Central Asia regional aggregate (does not include high-income economies).	nan	nan	7E	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
IDX	IDA only	IDA only	IDA only	XI	nan	IDA only group aggregate.	nan	nan	XI	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
LAC	Latin America & Caribbean (excluding high income)	Latin America & Caribbean (excluding high income)	Latin America & Caribbean (excluding high income)	XJ	nan	Latin America and Caribbean regional aggregate (does not include high-income economies).	nan	nan	XJ	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
LDC	Least developed countries: UN classification	Least developed countries: UN classification	Least developed countries: UN classification	XL	nan	Least developed countries (UN classification) aggregate.	nan	nan	XL	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
LIC	Low income	Low income	Low income	XM	nan	Low income group aggregate. Low-income economies are those in which 2015 GNI per capita was $1,025 or less.	nan	nan	XM	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
LMC	Lower middle income	Lower middle income	Lower middle income	XN	nan	Lower middle income group aggregate. Lower-middle-income economies are those in which 2015 GNI per capita was between $1,026 and $4,035.	nan	nan	XN	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
LMY	Low & middle income	Low & middle income	Low & middle income	XO	nan	Low and middle income group aggregate (all developing economies). Low- and middle-income economies are those in which 2015 GNI per capita was $12,475 or less.	nan	nan	XO	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
MIC	Middle income	Middle income	Middle income	XP	nan	Middle income group aggregate. Middle-income economies are those in which 2015 GNI per capita was between $1,026 and $12,475.	nan	nan	XP	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
MNA	Middle East & North Africa (excluding high income)	Middle East & North Africa (excluding high income)	Middle East & North Africa (excluding high income)	XQ	nan	Middle East and North Africa regional aggregate (does not include high-income economies).	nan	nan	XQ	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan


CREATE TABLE country_summary (
  "country_code" VARCHAR,
  "short_name" VARCHAR,
  "table_name" VARCHAR,
  "long_name" VARCHAR,
  "two_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" VARCHAR,
  "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,
  "latest_water_withdrawal_data" DOUBLE
);