Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
vipulnaik opened this issue Dec 21, 2017 · 5 comments
Open

Comments

@vipulnaik
Copy link
Owner

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

@riceissa
Copy link
Collaborator

riceissa commented Dec 31, 2017

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
Copy link
Collaborator

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
Copy link
Owner Author

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
Copy link
Collaborator

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

@vipulnaik
Copy link
Owner Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants