Good Food Purchasing Data

This dataset includes an item-by-item list of food items purchased by the City, whenever available, including whenever possible item description, weight, quantity, price, City agency making the purchase and other variables. The data is collected as part of the City's Good Food Purchasing program.

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 \"cityofnewyork-us/good-food-purchasing-data-usrf-za7k\".\"good_food_purchasing_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.