No description or website provided.
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
LICENSE
README.md
data-2018-11-23.csv
data.csv
out.sql
proc.py
proc_legacy.py
scrape.py

README.md

Hewlett Foundation

This repo is for work on Vipul Naik's Donations List Website.

The issue that started this repo is: https://github.com/vipulnaik/donations/issues/7

For the data source, see https://www.hewlett.org/grants/

How to use the scripts

# Get today's date
today=$(date -Idate)

# Get new data; this takes maybe 30 minutes
./scrape.py data-$today.csv

# Convert CSV to SQL
./proc.py data-$today.csv > out-$today.sql

There is also proc_legacy.py; for that, you need to run it like:

./proc.py > out.sql  # input CSV in data.csv

License

CC0 for the scripts, not sure about data.