search

vipulnaik / donations

Donations list website (DLW): a repository for keeping track of public donations by some people I (arbitrarily) decide to track
https://donations.vipulnaik.com
Creative Commons Zero v1.0 Universal
20 stars 2 forks source link

Import grants data for Unbound Philanthropy into Donations List Website #25

Open vipulnaik opened 6 years ago

vipulnaik commented 6 years ago

See https://www.unboundphilanthropy.org/who-we-fund Note that it does not appear to include amounts, but that is fine.

riceissa commented 6 years ago

It looks like there is an xlsx file at the bottom of the page giving amounts for each grant: https://www.unboundphilanthropy.org/sites/default/files/Full_Grants_List_December-2017.xlsx

riceissa commented 6 years ago

This is basically done at https://github.com/riceissa/unbound-philanthropy

As usual, there are some FIXMEs in the script where you might want to make changes.

vipulnaik commented 6 years ago

Currently the FIXME on the currency conversion date is blocking SQL insertion. Can you put some actual date there (which could just be the donation date for simplicity) or even NULL? We can figure out the exact right date later. You can put FIXME in a comment so we remember to review this.

riceissa commented 6 years ago

Done. (I used Fixer.io again for conversions, which I actually didn't know about when I was first working on Unbound Philanthropy.)

vipulnaik commented 6 years ago

Reinserted. Now reassigning to myself for further data quality and field value checks.