Issa Rice

I just checked this and the message is still there.

This is completed and is available at https://github.com/riceissa/ralph-c-wilson-jr-foundation I already ran `scrape.py` so you can just run `proc.py`.

I'm wondering if it's best to create a `dlw_common` repo like https://github.com/riceissa/devec_sql_common that includes a "master donor/donee map" that canonicalizes all the names.

There is a grant made to Farm Africa USA of $0 https://www.barrfoundation.org/grantmaking/grants?query=%22Farm+Africa+USA%22#Grants

There is one more similar grant, to George Washington University: https://www.barrfoundation.org/grantmaking/grants?query=%22George+Washington+University%22#Grants

This is now basically done at https://github.com/riceissa/barr-foundation Some notes: - There are some fields in the CSV that we don't currently use: - `grantee_url` - `Term`, e.g. "36 months" -...

For aggregate funding and funding sources, I'm planning to do this eventually on AI Watch. See: * https://github.com/riceissa/project-ideas/issues/33 * https://github.com/riceissa/aiwatch/issues/1 I'm still deciding between: * doing the individual giving on...

Some queries I've been playing around with: ```mysql select donations.donee, donations.donor, donations.amount, money_moved.amount, donations.influencer, start_date,end_date from donations left join money_moved on donations.donor=money_moved.identified_donors and donations.donee=money_moved.identified_donees where donations.influencer = 'GiveWell' and donation_date...

I think it's working now. saving some of the experimental mess that I don't want to commit: https://gist.github.com/riceissa/a67e91aa73728803a7a4340df42d3cc2

I pushed and forgot to mention the issue number in the commit messages. But the relevant commits are: * b2b4e838ee9228c43d521f30df110a7068e4c060 * 20f3e7765133f83b8a3a23f7ce3eb3fdac288c6b * 48282a2e21d9b85bd3c001c6231abfd998c759c0 * 02da4ad59ca8ea5977a7daa98558353b465c0912