Open vipulnaik opened 6 years ago
The CSV link above has FiscalYearStart=2016
, but it is possible to broaden that to start from 2006:
https://data.fordfoundation.org/v1/grants/search-csv?&MinAmount=0&MaxAmount=30000000&FiscalYearStart=2006&FiscalYearEnd=2017&Search&SortBy=1&SortDirection=0&IsBuild=
I've started on this at https://github.com/riceissa/ford-foundation
Some observations:
donation_date
column.affected_regions
or affected_countries
columns. Also "benefiting populations" and "benefiting locations" contain some encoded information and appear like 1258###Children (0-19)###75@@@8595###No target###100
or 655###Moscow###100
.notes
column).Thanks. For the donation_date column, using the start date is fine. It looks like that is what you are doing :).
However, I noticed one problem: it is not formatted YYYY-mm-dd so the insertion commands do not work. Is that possible to fix?
I will review the other points you raised as well, plus anything . I see after the data is inserted.
I fixed the date format issue.
The data still won't insert though, because the location string is too long. (But dealing with the location string is one of the points I raised earlier.)
Inserted, cleanup remains though.
Grants page has downloadable CSV, see http://www.fordfoundation.org/work/our-grants/grants-database/grants-all CSV link: https://data.fordfoundation.org/v1/grants/search-csv?&MinAmount=0&MaxAmount=30000000&FiscalYearStart=2016&FiscalYearEnd=2017&Search&SortBy=1&SortDirection=0&IsBuild=