ny-gov/utility-energy-registry-monthly-zip-code-energy-tzb9-c2c6
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 6 months ago
Indexed 1 month ago

Utility Energy Registry Monthly ZIP Code Energy Use: 2016-2021

The Utility Energy Registry (UER) is a database platform that provides streamlined public access to aggregated community-scale utility-reported energy data. The UER is intended to promote and facilitate community-based energy planning and energy use awareness and engagement. On April 19, 2018, the New York State Public Service Commission (PSC) issued the Order Adopting the Utility Energy Registry under regulatory CASE 17-M-0315. The order requires utilities under its regulation to develop and report community energy use data to the UER.

This dataset includes electricity and natural gas usage data reported at the ZIP Code level collected under a data protocol in effect between 2016 and 2021. Other UER datasets include energy use data reported at the city, town, village, and county level. Data collected after 2021 were collected according to a modified protocol. Those data may be found at https://data.ny.gov/Energy-Environment/Utility-Energy-Registry-Monthly-ZIP-Code-Energy-Us/g2x3-izm4.

Data in the UER can be used for several important purposes such as planning community energy programs, developing community greenhouse gas emissions inventories, and relating how certain energy projects and policies may affect a particular community. It is important to note that the data are subject to privacy screening and fields that fail the privacy screen are withheld.

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 accelerate economic growth. 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/utility-energy-registry-monthly-zip-code-energy-tzb9-c2c6\".\"utility_energy_registry_monthly_zip_code_energy\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • utility_energy_registry_monthly_zip_code_energy
     
     
     
     
     
Upstream Metadata