Skip to content
master
Go to file
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.

README.md

New instructions

Get new grants data:

./scrape.py > grants-YYYY-MM-DD.csv

Use CSV file to generate SQL (the older grants-with-multiyear.tsv file is required for figuring out the cause areas of grants):

./proc.py grants-YYYY-MM-DD.csv grants-with-multiyear.tsv > out.sql

Old instructions

Run the following commands to update out.sql:

curl http://www.arnoldfoundation.org/grants/ > index.html
python3.5 fetch_page.py index.html > grants-with-multiyear.tsv
python3.5 loop.py grants-with-multiyear.tsv > out.sql

The following commands are to insert into donations list website and git repository:

mysql donations -p < out.sql # Enter password on being prompted
cp out.sql ../donations/sql/donations/private-foundations/arnold-foundation-grants.sql
cd ../donations
# Then git diff, commit, push, etc.

About

No description or website provided.

Topics

Resources

License

Releases

No releases published

Packages

No packages published
You can’t perform that action at this time.