ny-gov/gasoline-retail-prices-weekly-average-by-region-nqur-w4p7
Icon for Socrata external plugin
 
Readme
Updated 1 day ago
Indexed 4 hours ago

Gasoline Retail Prices Weekly Average by Region: Beginning 2007

Gasoline retail prices weekly average by region dataset provides the weekly average retail gasoline prices for New York State and sixteen 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 gasoline 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/gasoline-retail-prices-weekly-average-by-region-nqur-w4p7\".\"gasoline_retail_prices_weekly_average_by_region\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • gasoline_retail_prices_weekly_average_by_region
     
Upstream Metadata