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

Geconv4

@kaggle.gaborfodor_additional_kiva_snapshot.geconv4

2.46 MB
27445 rows
22 columns

area AREA	country COUNTRY	lat LAT	longitude LONGITUDE	long_name LONG NAME	mer1990_40 MER1990–40	newcountryid NEWCOUNTRYID	popgpw_1990_40 POPGPW 1990–40	popgpw_1995_40 POPGPW 1995–40	popgpw_2000_40 POPGPW 2000–40	popgpw_2005_40 POPGPW 2005–40	ppp1990_40 PPP1990–40	quality QUALITY	rig RIG	quality_revision QUALITY REVISION	date_of_last DATE OF LAST
130	Afghanistan	29	60	Transitional Islamic State of Afghanista	0.000115697	4	238.0923	304.6392	351.7668	414.288	0.000175731	-1	0.011988012	1	2006.12.30
3405	Afghanistan	29	61	Transitional Islamic State of Afghanista	0.001797333	4	3699.9729	5104.5383	5824.0374	6981.7556	0.002731126	1	0.315	1	2006.12.30
5935	Afghanistan	29	62	Transitional Islamic State of Afghanista	0.003150575	4	6486.0063	8973.1834	10237.9252	12282.0186	0.00478748	1	0.549	1	2006.12.30
5686	Afghanistan	29	63	Transitional Islamic State of Afghanista	0.00518999	4	11060.2205	15373.7582	17541.8312	21069.386	0.007886403	1	0.525474525	1	2006.12.30
4994	Afghanistan	29	64	Transitional Islamic State of Afghanista	0.004703665	4	8784.0449	12198.8081	13918.9429	16713.7719	0.007147398	1	0.462	1	2006.12.30
3665	Afghanistan	29	65	Transitional Islamic State of Afghanista	0.000861778	4	1227.0183	1656.6346	1888.9191	2251.9803	0.001309512	1	0.339	1	2006.12.30
595	Afghanistan	29	66	Transitional Islamic State of Afghanista	0.000951272	4	1354.378	1749.1128	1992.4811	2347.2657	0.001445499	1	0.055	1	2006.12.30
5672	Afghanistan	30	61	Transitional Islamic State of Afghanista	0.010019776	4	20627.1194	28363.7457	32472.3701	38915.6764	0.015225493	1	0.53	1	2006.12.30
10702	Afghanistan	30	62	Transitional Islamic State of Afghanista	0.01173594	4	24179.2264	33724.2198	38484.6779	46261.9287	0.017833282	1	1	1	2006.12.30
10702	Afghanistan	30	63	Transitional Islamic State of Afghanista	0.009374171	4	20003.0514	27899.3145	31836.8276	38271.2135	0.014244468	1	1	1	2006.12.30


CREATE TABLE geconv4 (
  "area" BIGINT,
  "country" VARCHAR,
  "lat" BIGINT,
  "longitude" BIGINT,
  "long_name" VARCHAR,
  "mer1990_40" VARCHAR,
  "mer1995_40" VARCHAR,
  "mer2000_40" VARCHAR,
  "mer2005_40" VARCHAR,
  "newcountryid" BIGINT,
  "popgpw_1990_40" DOUBLE,
  "popgpw_1995_40" DOUBLE,
  "popgpw_2000_40" DOUBLE,
  "popgpw_2005_40" DOUBLE,
  "ppp1990_40" VARCHAR,
  "ppp1995_40" VARCHAR,
  "ppp2000_40" VARCHAR,
  "ppp2005_40" VARCHAR,
  "quality" DOUBLE,
  "rig" DOUBLE,
  "quality_revision" VARCHAR,
  "date_of_last" VARCHAR
);