Message from discussion
data dump
Received: by 10.68.236.170 with SMTP id uv10mr13900772pbc.4.1332893726633;
Tue, 27 Mar 2012 17:15:26 -0700 (PDT)
X-BeenThere: build-kiva@googlegroups.com
Received: by 10.68.226.102 with SMTP id rr6ls2276656pbc.8.gmail; Tue, 27 Mar
2012 17:15:25 -0700 (PDT)
Received: by 10.68.235.4 with SMTP id ui4mr24474464pbc.3.1332893725923;
Tue, 27 Mar 2012 17:15:25 -0700 (PDT)
Received: by 10.68.235.4 with SMTP id ui4mr24474461pbc.3.1332893725901;
Tue, 27 Mar 2012 17:15:25 -0700 (PDT)
Return-Path: <n...@kiva.org>
Received: from na3sys010aog112.obsmtp.com ([74.125.245.92])
by gmr-mx.google.com with SMTP id a5si2010599pbd.0.2012.03.27.17.15.25;
Tue, 27 Mar 2012 17:15:25 -0700 (PDT)
Received-SPF: pass (google.com: domain of n...@kiva.org designates 74.125.245.92 as permitted sender) client-ip=74.125.245.92;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of n...@kiva.org designates 74.125.245.92 as permitted sender) smtp.mail=n...@kiva.org
Received: from mail-iy0-f176.google.com ([209.85.210.176]) (using TLSv1) by na3sys010aob112.postini.com ([74.125.244.12]) with SMTP
ID DSNKT3JYHIUxR/dR1X9GYIb63xTR1e95j...@postini.com; Tue, 27 Mar 2012 17:15:25 PDT
Received: by mail-iy0-f176.google.com with SMTP id w33so836621iag.35
for <build-kiva@googlegroups.com>; Tue, 27 Mar 2012 17:15:24 -0700 (PDT)
d=google.com; s=20120113;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:x-gm-message-state:content-type;
bh=NyUK+dHxGZpJ2/sUAUoqWWgaDGHPDAv7wfoiZVpQILE=;
b=LmmnYUXJNiP8IplUbKrN8P0/vqWJHXbTHJFHIx5F4zWoMh2N95EAJ5ZHpdByI3A4dN
mVnVq/QRZvZy8awyxvjc4d9H7Yqt4v0G42LLq1vDdRg0SPcm4dqyWWW3QCA9WGM7PjAO
jr64JzKYdLW9EMEPl32qe0vmAZE8fo949MzRCwo2EfQLpEojeIWCJXkJge64sTB3dSru
jzhEkD91rhaigX8qBHPCr3VxVJa5JYHAXrXDONmMttUMPtgxHqWRRgBz9meSonbwTLWg
JRyglJ4RhvVccSFrQfCdgshg2IRWo1pUlbmEHRs+fWushor0kQAr5Xn+a1d1XOwYLEp+
ehWA==
MIME-Version: 1.0
Received: by 10.50.154.169 with SMTP id vp9mr633781igb.53.1332893724067; Tue,
27 Mar 2012 17:15:24 -0700 (PDT)
Received: by 10.231.46.19 with HTTP; Tue, 27 Mar 2012 17:15:24 -0700 (PDT)
In-Reply-To: <3242365.649.1332630777580.JavaMail.geo-discussion-forums@yneo2>
References: <1778c27c-a066-405f-8685-138d05205...@1g2000vbu.googlegroups.com>
<CAA7u5n7C_7TH-RAFMFt=hp1wps_uanXA4Hdd2Os72B1m2QQ...@mail.gmail.com>
<CAHQS_ex0tNDA+UrxBWHw+t6Vq4tA=K9BUSN3CO3Qj4fY3cr...@mail.gmail.com>
<CAOEcmSJ9h-EL2Gn4Ogufk-j_aJXqTjZJcZUY0eBuu-3XpHh...@mail.gmail.com>
<3242365.649.1332630777580.JavaMail.geo-discussion-forums@yneo2>
Date: Tue, 27 Mar 2012 17:15:24 -0700
Message-ID: <CAOEcmSL_T1MrJ4wmBCWrP4zb_Jsi+T50gABO3atu98LtHBy...@mail.gmail.com>
Subject: Re: data dump
From: Noah Balmer <n...@kiva.org>
To: build-kiva@googlegroups.com
X-Gm-Message-State: ALoCoQkoMny1jqpMIHwlayYST61nsRnP6lVVg6J4kVXit8/hq64yf18/nEHTZIZFO8Z6JNjRVvtl
Content-Type: multipart/alternative; boundary=14dae9340e3ff2466904bc4280bb
--14dae9340e3ff2466904bc4280bb
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
We have our own data analysis group in-house who answer questions of the
type you describe. There are a variety of reasons, such as user privacy,
that we don't expose all of their tools for public consumption.
We are actively working on getting the data dumps, as they existed before,
working again. Stay tuned for updates.
-Noah
On Sat, Mar 24, 2012 at 4:12 PM, Paul Lam <pty...@gmail.com> wrote:
> Speaking as a data scientist, a data dump would be useful to do
> exploratory analysis. For example, wouldn't you like to know why some loa=
ns
> get funded and others don't? So that you can do something about it?
>
> Instead of taking snapshots of the database, why not push your data at th=
e
> generation point on the web app into a message queue which then pushes in=
to
> Amazon S3 directly? This will probably take a few weeks to do, so
> unfortunately, I doubt you guys have the time.
>
>
>
> On Friday, 12 August 2011 07:25:19 UTC+1, Noah Balmer wrote:
>
>> Thanks for the offer, Matthew.
>>
>> Getting the data dumps working again is an expensive undertaking. The
>> simplest approach we've discussed so far starts with buying and maintain=
ing
>> more hardware, revisiting some aspects of our architecture, going throug=
h
>> some legal and privacy policy review, and then, when all that's ironed o=
ut,
>> rewriting the scripts. There's no way to do it that doesn't take
>> considerable investment on our part, and at this point it's not on the t=
op
>> of anyone's priority list.
>>
>> It's also unlikely that we can disclose everything you're looking for...
>> for example, we've never published the exact amount a given lender has
>> lent, and we're unlikely to start.
>>
>> I'd like to see some version of the data dumps working again, but I don'=
t
>> see it happening in the near future.
>>
>> There is a lot of repayment data available via the API. Is there
>> something particular you're trying to figure out that you can't learn fr=
om
>> the API?
>>
>> -Noah
>>
>> On Wed, Aug 10, 2011 at 12:44 PM, Matthew Pocock <
>> turingatemyhams...@gmail.com> wrote:
>>
>>> Hi Paul,
>>>
>>> We'd like to know about the borrowers, lenders, and the details of loan=
s
>>> - their amounts, if they where repaid or not and so on. We'd ideally al=
so
>>> like to know how much particular lenders contributed and when they
>>> contributed it. The API at
>>> http://api.kivaws.org/v1/=E2=80=8Blending_actions/recent.json<http://ap=
i.kivaws.org/v1/lending_actions/recent.json> =E2=80=8Bcovers
>>> part of what we need, but is limited to the most recent 50 transactions=
.
>>>
>>> You say there's not a plan to fix the data dumps. Is this something
>>> where the donation of some time and expertise could help you? A complet=
e
>>> data dump would be the ideal solution for me, and I'd be happy to work =
with
>>> you with any server-side stuff needed to make this work.
>>>
>>> Thanks,
>>>
>>> Matthew
>>>
>>>
>>> On 10 August 2011 20:26, Paul Ericksen <liquidmon...@gmail.com> wrote:
>>>
>>>> Yes, the data dumps are currently broken and there is currently not a
>>>> plan to fix them, so you should use the API. What type of historical
>>>> data are you looking for?
>>>>
>>>> On Tue, Aug 9, 2011 at 12:20 PM, Matthew Pocock
>>>> <turingatemyhams...@gmail.com> wrote:
>>>> > Hi,
>>>> >
>>>> > Is there a way to get a data dump for the kiva info? I ideally need
>>>> > historical as well as current data. Are there data dumps, or should =
I
>>>> > go through the APIs, or something else?
>>>> >
>>>> > Thanks,
>>>> >
>>>> > Matthew
>>>> >
>>>> > --
>>>> > You received this message because you are subscribed to the Google
>>>> Groups "build-kiva" group.
>>>> > To post to this group, send email to build-kiva@googlegroups.com.
>>>> > To unsubscribe from this group, send email to
>>>> build-kiva+unsubscribe@=E2=80=8Bgooglegroups.com<build-kiva%2Bunsubscr=
ibe@googlegroups.com>
>>>> .
>>>> > For more options, visit this group at
>>>> http://groups.google.com/=E2=80=8Bgroup/build-kiva?hl=3Den<http://grou=
ps.google.com/group/build-kiva?hl=3Den>
>>>> .
>>>> >
>>>> >
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "build-kiva" group.
>>>> To post to this group, send email to build-kiva@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> build-kiva+unsubscribe@=E2=80=8Bgooglegroups.com<build-kiva%2Bunsubscr=
ibe@googlegroups.com>
>>>> .
>>>> For more options, visit this group at
>>>> http://groups.google.com/=E2=80=8Bgroup/build-kiva?hl=3Den<http://grou=
ps.google.com/group/build-kiva?hl=3Den>
>>>> .
>>>>
>>>>
>>>
>>>
>>> --
>>> Dr Matthew Pocock
>>> Visitor, School of Computing Science, Newcastle University
>>> mailto: turingatemyhamster@=E2=80=8Bgmail.com <turingatemyhamster@gmail=
.com>
>>> gchat: turingatemyhamster@=E2=80=8Bgmail.com <turingatemyhamster@gmail.=
com>
>>> msn: matthew_poc...@yahoo.co.uk
>>> irc.freenode.net: drdozer
>>> tel: (0191) 2566550
>>> mob: +447535664143
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "build-kiva" group.
>>> To post to this group, send email to build-kiva@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> build-kiva+unsubscribe@=E2=80=8Bgooglegroups.com<build-kiva%2Bunsubscri=
be@googlegroups.com>
>>> .
>>> For more options, visit this group at
>>> http://groups.google.com/=E2=80=8Bgroup/build-kiva?hl=3Den<http://group=
s.google.com/group/build-kiva?hl=3Den>
>>> .
>>>
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "build-kiva" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/build-kiva/-/AjufSulHoioJ.
>
> To post to this group, send email to build-kiva@googlegroups.com.
> To unsubscribe from this group, send email to
> build-kiva+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/build-kiva?hl=3Den.
>
--14dae9340e3ff2466904bc4280bb
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
We have our own data analysis group in-house who answer questions of the ty=
pe you describe. =C2=A0There are a variety of reasons, such as user privacy=
, that we don't expose all of their tools for public consumption.=C2=A0=
<div><br>
</div><div>We are actively working on getting the data dumps, as they exist=
ed before, working again. Stay tuned for updates.</div><div><br></div><div>=
-Noah</div><div><br></div><div><br></div><div><br><div class=3D"gmail_quote=
">
On Sat, Mar 24, 2012 at 4:12 PM, Paul Lam <span dir=3D"ltr"><<a href=3D"=
mailto:pty...@gmail.com">pty...@gmail.com</a>></span> wrote:<br><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex">
Speaking as a data scientist, a data dump would be useful to do exploratory=
analysis. For example, wouldn't you like to know why some loans get fu=
nded and others don't? So that you can do something about it?<div><br>
</div><div>Instead of taking snapshots of the database, why not push your d=
ata at the generation point on the web app into a message queue which then =
pushes into Amazon S3 directly? This will probably take a few weeks to do, =
so unfortunately, I doubt you guys have the time.<div class=3D"im">
<div style=3D"border-style:initial;border-color:initial"><br></div><br><br>=
On Friday, 12 August 2011 07:25:19 UTC+1, Noah Balmer wrote:</div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0;margin-left:0.8ex;border-left:1=
px #ccc solid;padding-left:1ex">
<div class=3D"im">Thanks for the offer, Matthew.=C2=A0 <br>
<br>
Getting the data dumps working again is an expensive undertaking.=C2=A0 The=
=20
simplest approach we've discussed so far starts with buying and=20
maintaining more hardware, revisiting some aspects of our architecture,=20
going through some legal and privacy policy review, and then, when all=20
that's ironed out, rewriting the scripts.=C2=A0 There's no way to d=
o it that=20
doesn't take considerable investment on our part, and at this point it&=
#39;s
not on the top of anyone's priority list.=C2=A0 <br>
<br>
It's also unlikely that we can disclose everything you're looking f=
or...
for example, we've never published the exact amount a given lender has=
=20
lent, and we're unlikely to start.=C2=A0 <br>
<br>
I'd like to see some version of the data dumps working again, but I don=
't see it happening in the near future.<br>
<br>
There is a lot of repayment data available via the API.=C2=A0 Is there=20
something particular you're trying to figure out that you can't lea=
rn=20
from the API?<br>
<br>
-Noah<br><br></div><div class=3D"gmail_quote"><div class=3D"im">On Wed, Aug=
10, 2011 at 12:44 PM, Matthew Pocock <span dir=3D"ltr"><<a href=3D"mail=
to:turingatemyhams...@gmail.com" target=3D"_blank">turingatemyhamster@gmail=
.com</a>></span> wrote:<br>
</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-l=
eft:1px #ccc solid;padding-left:1ex">
Hi Paul,<div><br></div><div>We'd like to know about the borrowers, lend=
ers, and the details of loans - their amounts, if they where repaid or not =
and so on. We'd ideally also like to know how much particular lenders c=
ontributed and when they contributed it. The API at=C2=A0<a href=3D"http://=
api.kivaws.org/v1/lending_actions/recent.json" target=3D"_blank">http://api=
.kivaws.org/v1/=E2=80=8Blending_actions/recent.json</a>=C2=A0=E2=80=8Bcover=
s part of what we need, but is limited to the most recent 50 transactions.<=
/div>
<div><div class=3D"h5">
<div><br></div><div>You say there's not a plan to fix the data dumps. I=
s this something where the donation of some time and=C2=A0expertise=C2=A0co=
uld help you? A complete data dump would be the ideal solution for me, and =
I'd be happy to work with you with any server-side stuff needed to make=
this work.</div>
<div><br></div><div>Thanks,</div><div><br></div></div></div><div><div><div =
class=3D"h5">Matthew<div><div></div><div><br><br><div class=3D"gmail_quote"=
>On 10 August 2011 20:26, Paul Ericksen <span dir=3D"ltr"><<a href=3D"ma=
ilto:liquidmon...@gmail.com" target=3D"_blank">liquidmon...@gmail.com</a>&g=
t;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Yes, the data dumps are currently broken and=
there is currently not a<br>
plan to fix them, so you should use the API. What type of historical<br>
data are you looking for?<br>
<div><div></div><div><br>
On Tue, Aug 9, 2011 at 12:20 PM, Matthew Pocock<br>
<<a href=3D"mailto:turingatemyhams...@gmail.com" target=3D"_blank">turin=
gatemyhams...@gmail.com</a>> wrote:<br>
> Hi,<br>
><br>
> Is there a way to get a data dump for the kiva info? I ideally need<br=
>
> historical as well as current data. Are there data dumps, or should I<=
br>
> go through the APIs, or something else?<br>
><br>
> Thanks,<br>
><br>
> Matthew<br>
><br>
</div></div><div><div></div><div>> --<br>
> You received this message because you are subscribed to the Google Gro=
ups "build-kiva" group.<br>
> To post to this group, send email to <a href=3D"mailto:build-kiva@goog=
legroups.com" target=3D"_blank">build-kiva@googlegroups.com</a>.<br>
> To unsubscribe from this group, send email to <a href=3D"mailto:build-=
kiva%2Bunsubscribe@googlegroups.com" target=3D"_blank">build-kiva+unsubscri=
be@=E2=80=8Bgooglegroups.com</a>.<br>
> For more options, visit this group at <a href=3D"http://groups.google.=
com/group/build-kiva?hl=3Den" target=3D"_blank">http://groups.google.com/=
=E2=80=8Bgroup/build-kiva?hl=3Den</a>.<br>
><br>
><br>
<br>
--<br>
You received this message because you are subscribed to the Google Groups &=
quot;build-kiva" group.<br>
To post to this group, send email to <a href=3D"mailto:build-kiva@googlegro=
ups.com" target=3D"_blank">build-kiva@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to <a href=3D"mailto:build-kiva%=
2Bunsubscribe@googlegroups.com" target=3D"_blank">build-kiva+unsubscribe@=
=E2=80=8Bgooglegroups.com</a>.<br>
For more options, visit this group at <a href=3D"http://groups.google.com/g=
roup/build-kiva?hl=3Den" target=3D"_blank">http://groups.google.com/=E2=80=
=8Bgroup/build-kiva?hl=3Den</a>.<br>
<br>
</div></div></blockquote></div><br><br clear=3D"all"><br></div></div></div>=
</div><div class=3D"im">-- <br><div>Dr Matthew Pocock</div><div>Visitor, Sc=
hool of Computing Science, Newcastle University</div><div>mailto:=C2=A0<a h=
ref=3D"mailto:turingatemyhams...@gmail.com" target=3D"_blank">turingatemyha=
mster@=E2=80=8Bgmail.com</a></div>
<div>gchat:=C2=A0<a href=3D"mailto:turingatemyhams...@gmail.com" target=3D"=
_blank">turingatemyhamster@=E2=80=8Bgmail.com</a></div><div>msn: <a href=3D=
"mailto:matthew_poc...@yahoo.co.uk" target=3D"_blank">matthew_pocock@yahoo.=
co.uk</a></div><div>
<a href=3D"http://irc.freenode.net" target=3D"_blank">irc.freenode.net</a>:=
drdozer</div><div>tel: (0191) 2566550</div><div>mob:=C2=A0<span style=3D"b=
order-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><a val=
ue=3D"+447535664143">+447535664143</a></span></div>
<br>
</div></div><font color=3D"#888888">
<p></p>
-- <br></font><div><div></div><div><div class=3D"im">
You received this message because you are subscribed to the Google Groups &=
quot;build-kiva" group.<br>
To post to this group, send email to <a href=3D"mailto:build-kiva@googlegro=
ups.com" target=3D"_blank">build-kiva@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to <a href=3D"mailto:build-kiva%=
2Bunsubscribe@googlegroups.com" target=3D"_blank">build-kiva+unsubscribe@=
=E2=80=8Bgooglegroups.com</a>.<br></div><div class=3D"im">
For more options, visit this group at <a href=3D"http://groups.google.com/g=
roup/build-kiva?hl=3Den" target=3D"_blank">http://groups.google.com/=E2=80=
=8Bgroup/build-kiva?hl=3Den</a>.<br>
</div></div></div></blockquote></div><br>
</blockquote></div><div class=3D"im">
<p></p>
-- <br>
You received this message because you are subscribed to the Google Groups &=
quot;build-kiva" group.<br></div>
To view this discussion on the web visit <a href=3D"https://groups.google.c=
om/d/msg/build-kiva/-/AjufSulHoioJ" target=3D"_blank">https://groups.google=
.com/d/msg/build-kiva/-/AjufSulHoioJ</a>.<div class=3D"HOEnZb"><div class=
=3D"h5">
<br>=20
To post to this group, send email to <a href=3D"mailto:build-kiva@googlegro=
ups.com" target=3D"_blank">build-kiva@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to <a href=3D"mailto:build-kiva%=
2Bunsubscribe@googlegroups.com" target=3D"_blank">build-kiva+unsubscribe@go=
oglegroups.com</a>.<br>
For more options, visit this group at <a href=3D"http://groups.google.com/g=
roup/build-kiva?hl=3Den" target=3D"_blank">http://groups.google.com/group/b=
uild-kiva?hl=3Den</a>.<br>
</div></div></blockquote></div><br></div>
--14dae9340e3ff2466904bc4280bb--