Average Residential Retail Kerosene Prices by Region: Beginning 2000

The Average Residential Retail Kerosene Prices dataset provides New York residents and businesses with objective information on average residential retail kerosene pricing in New York State and by region beginning September 4, 2000. Pricing data is obtained via surveys conducted by New York State Energy Research and Development Authority (NYSERDA) staff on a weekly basis during heating season (September to March) and bi-weekly during the rest of the year. All prices are listed in dollars per gallon.

The Average Home Heating Oil Prices dataset, Average Residential Retail Kerosene Prices dataset, and Average Residential Retail Propane Prices dataset are collectively referred to as the Heating Fuel Prices dataset.

For current and historical residential retail price data, regional comparisons, and fuel type comparisons, please visit the Kerosene Prices Dashboard: https://www.nyserda.ny.gov/researchers-and-policymakers/energy-prices/kerosene/average-kerosene-prices

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 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/average-residential-retail-kerosene-prices-by-akrs-38uc\".\"average_residential_retail_kerosene_prices_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.