Gasoline Retail Prices Weekly Average By Region: Beginning January 2017
State of New York
@usgov.state_of_new_york_gasoline_retail_prices_weekly_averag_c6b7480b
State of New York
@usgov.state_of_new_york_gasoline_retail_prices_weekly_averag_c6b7480b
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 January 2017 through current.
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 X, Facebook, YouTube, or Instagram.
Organization: State of New York
Last updated: 2020-11-12T04:00:15.375340
Tags: energy-prices, gasoline, transportation-fuels
CREATE TABLE table_1 (
"date" TIMESTAMP,
"new_york_state_average_gal" DOUBLE -- New York State Average ($/gal),
"albany_average_gal" DOUBLE -- Albany Average ($/gal),
"batavia_average_gal" DOUBLE -- Batavia Average ($/gal),
"binghamton_average_gal" DOUBLE -- Binghamton Average ($/gal),
"buffalo_average_gal" DOUBLE -- Buffalo Average ($/gal),
"dutchess_average_gal" DOUBLE -- Dutchess Average ($/gal),
"elmira_average_gal" DOUBLE -- Elmira Average ($/gal),
"glens_falls_average_gal" DOUBLE -- Glens Falls Average ($/gal),
"ithaca_average_gal" DOUBLE -- Ithaca Average ($/gal),
"kingston_average_gal" DOUBLE -- Kingston Average ($/gal),
"nassau_average_gal" DOUBLE -- Nassau Average ($/gal),
"new_york_city_average_gal" DOUBLE -- New York City Average ($/gal),
"rochester_average_gal" DOUBLE -- Rochester Average ($/gal),
"syracuse_average_gal" DOUBLE -- Syracuse Average ($/gal),
"utica_average_gal" DOUBLE -- Utica Average ($/gal),
"watertown_average_gal" DOUBLE -- Watertown Average ($/gal),
"white_plains_average_gal" DOUBLE -- White Plains Average ($/gal)
);Anyone who has the link will be able to view this.