Additional Kiva Snapshot

Additional 3GB uncompressed snapshot from kiva

@kaggle.gaborfodor_additional_kiva_snapshot

Table List

7 tables(1.4 GB)

Country Stats

Geconv4

Lenders

Loans

Loans Lenders

Loan Coords

Locations

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
India	IN	IND	Asia	Southern Asia	1339180127	21.9	0.623558794	68.322	11.69659	6.298833561	5663.4747990000005	India
Nigeria	NG	NGA	Africa	Western Africa	190886311	70	0.527104539	53.057	9.970482	6	5442.901264	Nigeria
Mexico	MX	MEX	Americas	Central America	129163276	46.2	0.761682897	76.972	13.29909	8.554984832999999	16383.10668	Mexico
Pakistan	PK	PAK	Asia	Southern Asia	197015955	29.5	0.550354165	66.365	8.106910000000001	5.08946	5031.173074	Pakistan
Bangladesh	BD	BGD	Asia	Southern Asia	164669751	31.5	0.578824028	71.985	10.178706	5.241576537	3341.490722	Bangladesh
Democratic Republic of the Congo	CD	COD	Africa	Middle Africa	81339988	63	0.43546467	59.057	9.75	6.117152596	679.6312234000001	The Democratic Republic of the Congo
United States	US	USA	Americas	Northern America	324459463	15.1	0.919553056	79.222	16.53815	13.21789033	53245.076960000006	United States
China	CN	CHN	Asia	Eastern Asia	1409517397	3.3	0.73768059	75.96300000000001	13.53575	7.641839958999999	13345.47746	China
Ethiopia	ET	ETH	Africa	Eastern Africa	104957438	29.6	0.447750459	64.602	8.351519999999999	2.580780019	1522.954782	Ethiopia
Indonesia	ID	IDN	Asia	South-eastern Asia	263991379	10.9	0.68884703	69.05199999999999	12.86766	7.934816941	10053.3377	Indonesia


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