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

Loans

@kaggle.gaborfodor_additional_kiva_snapshot.loans

1.07 GB
1419607 rows
31 columns

loan_id Loan Id	loan_name Loan Name	original_language Original Language	description Description	description_translated Description Translated	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_exchange_coverage_rate Currency Exchange Coverage Rate	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	num_journal_entries Num Journal Entries	num_bulk_entries Num Bulk Entries	tags Tags	borrower_genders Borrower Genders	borrower_pictured Borrower Pictured	repayment_interval Repayment Interval	distribution_model Distribution Model
657307	Aivy	English	Aivy, 21 years of age, is single and lives in Ozamiz City, Misamis Occidental, Philippines. To help her parents meet their financial needs, she invests in a small sari-sari business (variety store). Her parents are thankful to her because of the things she has done for the family.\r\n\r\nIn the year…	nan	125	125	funded	General Store	Retail	to buy additional inventories for her sari-sari store business	PH	Philippines	Ozamiz - Ozamiz City	shared	0.1	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	2	1	nan	female	true	irregular	field_partner
657259	Idalia Marizza	Spanish	Doña Idalia, esta casada, tiene 57 años de edad, vive con su esposo y sus 3 nietos en el municipio de Choloma, Cortes. Hace 7 años que se dedica a la venta de mercadería en general como ropa usada americana, lociones, calzado y otra achinería. Las ventas las realiza en forma ambulante. Ha solicitado…	Idalia, 57, is married and lives with her husband and three grandchildren in the town of Choloma, Cortes. For seven years she has been selling merchandise in general such as used American clothing, lotions, shoes and trinkets, working as a street vendor. Idalia is requesting a loan in the amount o…	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	0.1	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	2	1	nan	female	true	monthly	field_partner
658010	Aasia	English	Aasia is a 45-year-old married lady and she has been running a small general store in her community for many years. She offers a variety of grocery items at a reasonable price and has retained many customers who regularly shop at her store. Aasia makes enough to provide for her family.\r\n\r\nTo ma…	nan	400	400	funded	General Store	Retail	to buy stock of rice, sugar and flour	PK	Pakistan	Lala Musa	shared	0.1	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	2	1	#Woman Owned Biz, #Supporting Family, user_favorite	female	true	monthly	field_partner
659347	Gulmira	Russian	Гулмире 36 лет, замужем, вместе с супругом воспитывают 2 детей. У Гулмиры -среднее образование. В качестве основного дохода для своей семьи Гулмира занимается полеводством, а точнее выращиванием овощей, стартовав 16 лет назад, с 5,000 сом KGS. Благодаря упорному труду Гулмиры, на сегодняшний день у …	Gulmira is 36 years old and married. She and her husband are raising two children. She has a secondary education and is involved in agriculture, an activity which constitutes her family\'s main source of income. She essentially grows vegetables, which she started doing 16 years ago with an initia…	625	625	funded	Farming	Agriculture	to buy cucumber and tomato seeds, as well as fertilizers and pesticides.	KG	Kyrgyzstan	Aravan village, Osh region	shared	0.1	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	2	1	user_favorite	female	true	monthly	field_partner
656933	Ricky\t	English	Ricky is a farmer who currently cultivates his parent's farmland. He is 43 years old and lives with his partner. He has three children who are attending school. \r\n\r\nRicky's primary source of income comes from his farming business. Aside from farming, he also raises cattle. Ricky aims to have a v…	nan	425	425	funded	Farming	Agriculture	to buy organic fertilizer and agrochemical products for his farming business	PH	Philippines	Baleleng, Sto. Thomas, Isabela	shared	0.1	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	2	1	#Animals, #Eco-friendly, #Sustainable Ag	male	true	bullet	field_partner
659605	Gloria	English	To make a living, Gloria helps her husband working on their farm. They have been growing and harvesting rice for many years. She earns enough from this to provide for her family and had successfully repaid her previous loan, which she used to buy fertilizer. Currently, she is requesting a new loan f…	nan	350	350	funded	Farming	Agriculture	to buy organic pesticides and a new variety of seeds	PH	Philippines	Bonifacio, Misamis Occidental	shared	0.1	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	1	1	nan	female	true	monthly	field_partner
660240	Elsie	English	Elsie and her husband earn well from their banana farm. They have been growing and harvesting bananas for more than two years to make a living. To finance farm maintenance and fertilization costs, she borrowed a new loan from GDMPC micro credit. She is hopeful to gain more return from the farm and w…	nan	125	125	funded	Agriculture	Agriculture	to finance farm maintenance and fertilization costs.	PH	Philippines	Baliangao, Misamis Occidental	shared	0.1	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	1	1	nan	female	true	irregular	field_partner
661601	Francisco	Spanish	Francisco, es jefe de su hogar, vive con su familia integrada por su esposa y sus hijos, no posee ayuda del extranjero, aprendió de su familia a comercializar ganado y tener crianza de peces, además para obtener mejores ingresos instalo una tienda en su casa de habitación, lo apoyan su esposa y sus …	Francisco is the head of his household, living with his family made up of his wife and children. He doesn’t have help from abroad. He learned to market cattle and breed fish from his family. Also to get a better income, he set up a shop in a room of his house. His wife and children help him carry ou…	1600	1600	funded	Agriculture	Agriculture	to improve the infrastructure of his fishponds and buy cattle.	SV	El Salvador	nan	shared	0.1	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	1	1	user_favorite, #Biz Durable Asset, #Animals, #Sustainable Ag, user_favorite	male	true	irregular	field_partner
661960	Juanita	English	Juanita is married with six children. Juanita is 58-years-old and lives in the Philippines.\r\n\r\nJuanita is a farmer and grows vegetables and crops to earn a living. She has been doing this for 20 years. She has requested a loan to buy fertilizer for her farm.\r\n\r\nJuanita has been a member of P…	nan	350	350	funded	Farming	Agriculture	to buy fertilizer for her farm	PH	Philippines	Pagadian - Navalan, Tukuran, Zamboanga del Sur	shared	0.1	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	2	1	nan	female	true	irregular	field_partner
662117	Dukure Group	French	Samia fait partie du groupe Dukure et habite à Gitega. C’est un célibataire de 26 ans responsable de ses 2 sœurs et son frère âgés de 16 à 20 ans, tous étudient.\n\nElle fait le commerce des habits depuis 3 ans. \n\nElle est à son dixième crédit à Turame. Avec le crédit KIVA qu’elle obtient, …	Samia, age 26, is a member of Dukure Group. She's single and lives in Gitega. She's responsible for her two sisters and her brother, aged 16 to 20, who are all students.\r\n\r\nShe's been selling clothes for the past three years. She's seeking her tenth loan from Kiva's partner, Turame. With this Ki…	1825	1825	funded	Clothing	Clothing	to buy lots of clothes to resell	BI	Burundi	Gitega	shared	0.1	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	1	1	user_favorite	female, female, female, female	true, true, true, true	monthly	field_partner


CREATE TABLE loans (
  "loan_id" BIGINT,
  "loan_name" VARCHAR,
  "original_language" VARCHAR,
  "description" VARCHAR,
  "description_translated" VARCHAR,
  "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_exchange_coverage_rate" DOUBLE,
  "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,
  "num_journal_entries" BIGINT,
  "num_bulk_entries" BIGINT,
  "tags" VARCHAR,
  "borrower_genders" VARCHAR,
  "borrower_pictured" VARCHAR,
  "repayment_interval" VARCHAR,
  "distribution_model" VARCHAR
);