Diesel Retail Price Weekly Average by Region: Beginning 2007

Diesel retail prices weekly average by region dataset provides the weekly average retail diesel prices for New York State and eight New York metropolitan regions in U.S. dollars per gallon. Data is a weekly average from October 2007 through current. Some metropolitan regions begin in 2017.

Average daily retail diesel prices are collected from the American Automobile Association (AAA) Daily Fuel Gauge Report. The AAA Daily Fuel Gauge Report prices are averaged to produce a weekly average retail price for New York State and each metropolitan region.

The New York State metropolitan regions in the dataset are Albany (Albany-Schenectady-Troy), Batavia, Binghamton, Buffalo (Buffalo-Niagara Falls), Dutchess (Dutchess-Putnam), Elmira, Glens Falls, Ithaca, Kingston, Nassau (Nassau-Suffolk), New York City, Rochester, Syracuse, Utica (Utica-Rome), Watertown (Watertown-Fort Drum), and White Plains.

The New York State Energy Research and Development Authority (NYSERDA) offers objective information and analysis, innovative programs, technical expertise, and support to help New Yorkers increase energy efficiency, save money, use renewable energy, and reduce reliance on fossil fuels. To learn more about NYSERDA’s programs, visit https://nyserda.ny.gov or follow us on Twitter, Facebook, YouTube, or Instagram.

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/diesel-retail-price-weekly-average-by-region-dtfv-pchi\".\"diesel_retail_price_weekly_average_by_region\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.