Name: Additional Kiva Snapshot
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Additional Kiva Snapshot

Context

This dataset contains additional data snapshot provided by kiva.org. It could be used in the Data Science for Good: Kiva Crowdfunding challenge. The snapshot provides information about 1.4M loans and 2.3M lenders.

Country level statistics and detailed economic grid data are provided as well.

Inspiration

These additional files could be used for

NLP
Demography (age, marital status, family size)
Explore lenders statistics
Map poverty indices, economic data to countries/regions
Merge GPS coords to loans

Content

This dataset has seven main files.

loans.csv
lenders.csv
loans_lenders.csv
country_stats.csv
GEconV4.csv
locations.csv
loan_coords.csv

Acknowledgements

Thanks for kiva for providing these snapshots. http://build.kiva.org/docs/data/snapshots
Human Development Index http://hdr.undp.org/en/composite/HDI
CIA World Factbook https://www.cia.gov/library/publications/resources/the-world-factbook/fields/print_2046.html
Global Gridded Geographically Based Economic Data http://sedac.ciesin.columbia.edu/data/set/spatialecon-gecon-v4

Photo by Doug Linstedt on Unsplash.

Tables

Country Stats

@kaggle.gaborfodor_additional_kiva_snapshot.country_stats

25.22 kB
174 rows
13 columns

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

Geconv4

@kaggle.gaborfodor_additional_kiva_snapshot.geconv4

2.58 MB
27,445 rows
22 columns

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

Lenders

@kaggle.gaborfodor_additional_kiva_snapshot.lenders

77.32 MB
2,349,174 rows
11 columns

CREATE TABLE lenders (
  "permanent_name" VARCHAR,
  "display_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "country_code" VARCHAR,
  "member_since" BIGINT,
  "occupation" VARCHAR,
  "loan_because" VARCHAR,
  "loan_purchase_num" DOUBLE,
  "invited_by" VARCHAR,
  "num_invited" BIGINT
);

Loan Coords

@kaggle.gaborfodor_additional_kiva_snapshot.loan_coords

6.21 MB
1,216,487 rows
3 columns

CREATE TABLE loan_coords (
  "loan_id" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Loans

@kaggle.gaborfodor_additional_kiva_snapshot.loans

1.15 GB
1,419,607 rows
31 columns

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

Loans Lenders

@kaggle.gaborfodor_additional_kiva_snapshot.loans_lenders

262.01 MB
1,387,432 rows
2 columns

CREATE TABLE loans_lenders (
  "loan_id" BIGINT,
  "lenders" VARCHAR
);

Locations

@kaggle.gaborfodor_additional_kiva_snapshot.locations

3.5 MB
18,365 rows
17 columns

CREATE TABLE locations (
  "address_components" VARCHAR,
  "formatted_address" VARCHAR,
  "geometry_bounds_northeast_lat" DOUBLE,
  "geometry_bounds_northeast_lng" DOUBLE,
  "geometry_bounds_southwest_lat" DOUBLE,
  "geometry_bounds_southwest_lng" DOUBLE,
  "geometry_location_lat" DOUBLE,
  "geometry_location_lng" DOUBLE,
  "geometry_location_type" VARCHAR,
  "geometry_viewport_northeast_lat" DOUBLE,
  "geometry_viewport_northeast_lng" DOUBLE,
  "geometry_viewport_southwest_lat" DOUBLE,
  "geometry_viewport_southwest_lng" DOUBLE,
  "location_name" VARCHAR,
  "partial_match" VARCHAR,
  "place_id" VARCHAR,
  "types" VARCHAR
);