Baselight
Sign In

Additional Kiva Snapshot

Additional 3GB uncompressed snapshot from kiva

@kaggle.gaborfodor_additional_kiva_snapshot

Country Stats
@kaggle.gaborfodor_additional_kiva_snapshot.country_stats

  • 24.63 KB
  • 174 rows
  • 13 columns
country_name

Country Name

country_code

Country Code

country_code3

Country Code3

continent

Continent

region

Region

population

Population

population_below_poverty_line

Population Below Poverty Line

hdi

Hdi

life_expectancy

Life Expectancy

expected_years_of_schooling

Expected Years Of Schooling

mean_years_of_schooling

Mean Years Of Schooling

gni

Gni

kiva_country_name

Kiva Country Name

IndiaININDAsiaSouthern Asia133918012721.90.62355879468.32211.696596.2988335615663.4747990000005India
NigeriaNGNGAAfricaWestern Africa190886311700.52710453953.0579.97048265442.901264Nigeria
MexicoMXMEXAmericasCentral America12916327646.20.76168289776.97213.299098.55498483299999916383.10668Mexico
PakistanPKPAKAsiaSouthern Asia19701595529.50.55035416566.3658.1069100000000015.089465031.173074Pakistan
BangladeshBDBGDAsiaSouthern Asia16466975131.50.57882402871.98510.1787065.2415765373341.490722Bangladesh
Democratic Republic of the CongoCDCODAfricaMiddle Africa81339988630.4354646759.0579.756.117152596679.6312234000001The Democratic Republic of the Congo
United StatesUSUSAAmericasNorthern America32445946315.10.91955305679.22216.5381513.2178903353245.076960000006United States
ChinaCNCHNAsiaEastern Asia14095173973.30.7376805975.9630000000000113.535757.64183995899999913345.47746China
EthiopiaETETHAfricaEastern Africa10495743829.60.44775045964.6028.3515199999999992.5807800191522.954782Ethiopia
IndonesiaIDIDNAsiaSouth-eastern Asia26399137910.90.6888470369.0519999999999912.867667.93481694110053.3377Indonesia

CREATE TABLE country_stats (
  "country_name" VARCHAR,
  "country_code" VARCHAR,
  "country_code3" VARCHAR,
  "continent" VARCHAR,
  "region" VARCHAR,
  "population" BIGINT,
  "population_below_poverty_line" DOUBLE,
  "hdi" DOUBLE,
  "life_expectancy" DOUBLE,
  "expected_years_of_schooling" DOUBLE,
  "mean_years_of_schooling" DOUBLE,
  "gni" DOUBLE,
  "kiva_country_name" VARCHAR
);