Green Businesses in Berkeley - Totals per year

Total number of Berkeley businesses since 2000 that are green-certified as of Dec. 31st of each year

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofberkeley-info/green-businesses-in-berkeley-totals-per-year-cyim-hufj\".\"green_businesses_in_berkeley_totals_per_year\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.