Transportation Fuels Inventory: Beginning 2004

The Transportation Fuels Inventory dataset contains weekly stock amounts of Central Atlantic diesel as well as gasoline from the Central Atlantic region (PADD 1B), East Coast (PADD 1) and the total U.S. The dataset also contains fuel ethanol stocks for the East Coast and U.S. crude oil stocks. Additionally, East Coast jet fuel stocks are included. The data is collected on a weekly basis and measured in terms of thousands of barrels beginning in April 2004.

How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

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 \"ny-gov/transportation-fuels-inventory-beginning-2004-7rev-x3j5\".\"transportation_fuels_inventory_beginning_2004\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.