Additional Resources For Kiva Crowdfunding

Region inclusion for Kiva locations with poverty decomposition

@kaggle.lucian18_mpi_on_regions

Table List

2 tables(106.26 MB)

All Kiva Loans

@kaggle.lucian18_mpi_on_regions.all_kiva_loans

106.24 MB
1419607 rows
21 columns

loan_id Loan Id	funded_amount Funded Amount	loan_amount Loan Amount	status Status	activity_name Activity Name	sector_name Sector Name	loan_use Loan Use	country_code Country Code	country_name Country Name	town_name Town Name	currency_policy Currency Policy	currency Currency	partner_id Partner Id	posted_time Posted Time	planned_expiration_time Planned Expiration Time	disburse_time Disburse Time	raised_time Raised Time	lender_term Lender Term	num_lenders_total Num Lenders Total	borrower_genders Borrower Genders	repayment_interval Repayment Interval
657307	125	125	funded	General Store	Retail	to buy additional inventories for her sari-sari store business	PH	Philippines	Ozamiz - Ozamiz City	shared	PHP	126	2014-01-15 02:23:45.000 +0000	2014-02-14 03:30:06.000 +0000	2013-12-22 08:00:00.000 +0000	2014-01-15 04:48:22.000 +0000	7	3	female	irregular
657259	400	400	funded	Used Clothing	Clothing	To buy American clothing such as blouses, shirts, pants, children's clothing, etc. to meet customer demand.	HN	Honduras	La Lopez, Choloma	shared	HNL	201	2014-01-14 20:23:20.000 +0000	2014-03-26 22:25:07.000 +0000	2013-12-20 08:00:00.000 +0000	2014-02-25 06:42:06.000 +0000	8	11	female	monthly
658010	400	400	funded	General Store	Retail	to buy stock of rice, sugar and flour	PK	Pakistan	Lala Musa	shared	PKR	245	2014-01-16 11:32:58.000 +0000	2014-02-15 21:10:05.000 +0000	2014-01-09 08:00:00.000 +0000	2014-01-24 23:06:18.000 +0000	14	16	female	monthly
659347	625	625	funded	Farming	Agriculture	to buy cucumber and tomato seeds, as well as fertilizers and pesticides.	KG	Kyrgyzstan	Aravan village, Osh region	shared	KGS	171	2014-01-20 09:59:48.000 +0000	2014-02-21 03:10:02.000 +0000	2014-01-17 08:00:00.000 +0000	2014-01-22 05:29:28.000 +0000	14	21	female	monthly
656933	425	425	funded	Farming	Agriculture	to buy organic fertilizer and agrochemical products for his farming business	PH	Philippines	Baleleng, Sto. Thomas, Isabela	shared	PHP	123	2014-01-14 05:46:21.000 +0000	2014-02-13 06:10:02.000 +0000	2013-12-17 08:00:00.000 +0000	2014-01-14 17:29:27.000 +0000	7	15	male	bullet
659605	350	350	funded	Farming	Agriculture	to buy organic pesticides and a new variety of seeds	PH	Philippines	Bonifacio, Misamis Occidental	shared	PHP	136	2014-01-21 01:09:34.000 +0000	2014-02-20 02:30:07.000 +0000	2014-01-15 08:00:00.000 +0000	2014-01-21 03:12:06.000 +0000	8	13	female	monthly
660240	125	125	funded	Agriculture	Agriculture	to finance farm maintenance and fertilization costs.	PH	Philippines	Baliangao, Misamis Occidental	shared	PHP	136	2014-01-22 03:43:12.000 +0000	2014-02-21 07:50:11.000 +0000	2014-01-20 08:00:00.000 +0000	2014-01-22 10:35:41.000 +0000	8	4	female	irregular
661601	1600	1600	funded	Agriculture	Agriculture	to improve the infrastructure of his fishponds and buy cattle.	SV	El Salvador	nan	shared	USD	167	2014-01-24 16:29:55.000 +0000	2014-02-25 09:50:03.000 +0000	2014-01-10 08:00:00.000 +0000	2014-02-22 17:52:56.000 +0000	26	49	male	irregular
661960	350	350	funded	Farming	Agriculture	to buy fertilizer for her farm	PH	Philippines	Pagadian - Navalan, Tukuran, Zamboanga del Sur	shared	PHP	126	2014-01-26 23:05:52.000 +0000	2014-02-26 00:10:03.000 +0000	2014-01-23 08:00:00.000 +0000	2014-01-27 02:24:03.000 +0000	10	13	female	irregular
662117	1825	1825	funded	Clothing	Clothing	to buy lots of clothes to resell	BI	Burundi	Gitega	shared	BIF	162	2014-01-27 07:22:38.000 +0000	2014-03-19 13:40:02.000 +0000	2014-01-10 08:00:00.000 +0000	2014-02-17 16:39:04.000 +0000	10	46	female, female, female, female	monthly


CREATE TABLE all_kiva_loans (
  "loan_id" BIGINT,
  "funded_amount" DOUBLE,
  "loan_amount" DOUBLE,
  "status" VARCHAR,
  "activity_name" VARCHAR,
  "sector_name" VARCHAR,
  "loan_use" VARCHAR,
  "country_code" VARCHAR,
  "country_name" VARCHAR,
  "town_name" VARCHAR,
  "currency_policy" VARCHAR,
  "currency" VARCHAR,
  "partner_id" DOUBLE,
  "posted_time" VARCHAR,
  "planned_expiration_time" VARCHAR,
  "disburse_time" VARCHAR,
  "raised_time" VARCHAR,
  "lender_term" DOUBLE,
  "num_lenders_total" BIGINT,
  "borrower_genders" VARCHAR,
  "repayment_interval" VARCHAR
);