donations icon indicating copy to clipboard operation
donations copied to clipboard
verified publisher icon vipulnaik

Import Wellcome Trust grants data into Donations List Website (XLSX available)

Open vipulnaik opened this issue 8 years ago • 6 comments

See https://wellcome.ac.uk/funding/managing-grant/grants-awarded

XLSX file at https://wellcome.ac.uk/sites/default/files/wellcome-grants-awarded-2000-2016.xlsx

vipulnaik avatar Nov 25 '17 07:11 vipulnaik

I have started this at https://github.com/riceissa/wellcome-trust

riceissa avatar Dec 15 '17 01:12 riceissa

I think this is done (with the usual FIXMEs needing to be filled). Some notes I made in chat (this was over a month ago so I don't have a good memory):

  • wellcome trust amounts are in pounds
  • also not sure about cause area here
  • there is a "grant type" column with the following values https://gist.github.com/riceissa/0b4108e3599d714dd9459725831566cd
  • there is also a "panel" column with the following values https://gist.github.com/riceissa/95f8e23680c2da4de7cb723b42f703c6 so if you want to somehow use those to map to cause areas, that is one idea

riceissa avatar Jan 16 '18 18:01 riceissa

Can we use fixer.io to do currency conversion for this one, like you did for #6?

vipulnaik avatar Jan 28 '18 15:01 vipulnaik

Yes, I'll use Fixer.io. I think you meant #25 (Unbound Philanthropy) rather than #6 (Ford).

riceissa avatar Jan 31 '18 23:01 riceissa

Okay, currency conversion is done.

riceissa avatar Jan 31 '18 23:01 riceissa

Inserted, next step is cleanup.

vipulnaik avatar Feb 11 '18 05:02 vipulnaik