Office of Climate and Sustainability: 2019 Fuel Oil Sales

NYC Fuel Oil Deliveries - Companies that deliver heating oil and biodiesel to buildings in New York City are required by Local Law 43 of 2010 to disclose the amount in gallons of each fuel oil grade delivered to buildings by zip code (non-wholesale only) on an annual basis. The Local Law also requires minimum biodiesel content and limits sulfur levels in fuel oil. This dataset details the amount of fuel oil delivered to each NYC Zip Code and offers a breakdown of the biodiesel blend.

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/office-of-climate-and-sustainability-2019-fuel-oil-psr5-vz6y\".\"office_of_climate_and_sustainability_2019_fuel_oil\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.