The Utility Energy Registry (UER) is a database platform that provides streamlined public access to aggregated community-scale 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 and CCA administrators 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. Other UER datasets include energy use data reported at the city, town, village, and county level. 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 reduce reliance on fossil fuels. To learn more about NYSERDA’s programs, visit nyserda.ny.gov or follow us on X, Facebook, YouTube, or Instagram.

New York Electric Generation By Fuel Type, GWh dataset provides data on total electricity requirements and in-state generation for New York State in giga-watt hours. Sources of electricity include coal, natural gas, petroleum products, hydro, nuclear, waste, landfill gas, wood, wind, solar, and net imports of electricity. How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

This dataset provides a time-series view into electricity consumption (in kWh) and cost (in USD) for the City of New York and/or its boroughs and developments. It covers multiple temporal resolutions (daily, monthly) and spans several years, capturing patterns of energy use, seasonal fluctuations, and cost dynamics. It is ideal for forecasting tasks, trend analysis, anomaly detection, energy management insights, and sustainability research.

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 county level level collected under a data protocol in effect between 2016 and 2021. Other UER datasets include energy use data reported at the city, town, and village, and ZIP code 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-County-Energy-Use-/46pe-aat9. 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 X, Facebook, YouTube, or Instagram.

The "Energy Consumption in New York City" dataset provides comprehensive information on the energy usage patterns and trends in City over the past five years. The dataset includes data on electricity consumption, gas consumption, and water consumption in various sectors, such as residential, commercial, and industrial. Attributes: 2020: The year for which the data was recorded. August: The month for which the data was recorded. Sector: The sector (residential, commercial, industrial) of energy consumption. Electricity Consumption (kWh): Total electricity consumption 200,000 kWh for the specific sector. Gas Consumption (m³): Total gas consumption 500 m³ for the residential sector. Water Consumption (m³): Total water consumption 300 m³ for both residential and commercial sector. Data Sources: The data has been collected from industry reports, ensuring its reliability and accuracy. Use Cases: This dataset is valuable for researchers, urban planners, and policymakers to analyze energy consumption patterns, identify trends, and make informed decisions regarding energy efficiency and sustainability initiatives in New York City. Update Frequency: The dataset is updated annually to include the latest available data. License: The dataset is made available under the Creative Commons Attribution License, allowing users to share and adapt the data for non-commercial purposes with appropriate attribution.

Context

This dataset contains energy usage information for every building owned and managed by NYC DCAS. DCAS, or the Department of Citywide Administrative Services, is the arm of the New York City municipal government which handles ownership and management of the city's office facilities and real estate inventory. The organization voluntarily publicly discloses self-measured information about the energy use of its buildings.

Content

This data contains information on the name, address, location, and 2015 financial cycle energy usage of every building managed at that time by DCAS.

Acknowledgements

This dataset is published as-is by of the City of New York (here).

Inspiration

• By combining this dataset with the New York City Buildings Database, what can you learn about the energy usage of buildings in New York City?
• Can you use this data to model the energy consumption for city's office space at large?

There are three United States cities' daily electricity consumption data and weather data. The cities are: New York, Los Angeles and Sacramento There are total six CSV files to work with. I found it while working on my thesis.

Data was collected from the GitHub repository

If you use this dataset, please cite the paper:

Wang, Z., Hong, T., Li, H. and Piette, M.A., 2021. Predicting City-Scale Daily Electricity Consumption Using Data-Driven Models. Advances in Applied Energy, p.100025. Paper link

Content

City Building Energy Usage Data.

Context

This is a dataset hosted by the City of New York. The city has an open data platform found here and they update their information according the amount of data that is brought in. Explore New York City using Kaggle and all of the data sources available through the City of New York organization page!

• Update Frequency: This dataset is updated annually.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Johny Goerend on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

New York Energy Prices presents retail energy price data. Energy prices are provided by fuel type in nominal dollars per specified physical unit for the residential, commercial, industrial, and transportation sectors. This section includes a column in the price table displaying gross domestic product (GDP) price deflators for converting nominal (current year) dollars to constant (real) dollars. To convert nominal to constant dollars, divide the nominal energy price by the GDP price deflator for that particular year. Historical petroleum, electricity, coal, and natural gas prices were compiled primarily from the Energy Information Administration. How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

Content

How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

Solar Electric Programs Reported by NYSERDA; Beginning 2000 dataset includes the following data points for projects completed and in the pipeline (not yet installed) in the Incentive Program beginning December 2000: Project number, city, county, state, zip code, sector, program type, solicitation, electric utility, purchase type, date application received, date completed, project status, contractor, primary inverter manufacturer, total inverter quantity, primary inverter model number, primary PV module manufacturer, total PV module quantity, primary PV module model number, project cost, incentive amount, total nameplate capacity, expected annual kilowatt-hour production, remote net metering, affordable solar, community distributed generation project and Green Jobs-Green New York participant. Blank cells represent data that were not required or are not currently available. Contractor data is provided for completed projects only, except for Community Distributed Generation projects. Pipeline projects are subject to change. The interactive map at https://www.nyserda.ny.gov/All-Programs/Programs/NY-Sun/Data-and-Trends provides information on solar photovoltaic (PV) installations supported by NYSERDA throughout New York State since 2000 by county, region, or statewide. Updated monthly, the graphs show the number of projects, expected production, total capacity, and annual trends.

Context

This is a dataset hosted by the State of New York. The state has an open data platform found here and they update their information according the amount of data that is brought in. Explore New York State using Kaggle and all of the data sources available through the State of New York organization page!

• Update Frequency: This dataset is updated monthly.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by American Public Power Association on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

IMPORTANT! PLEASE READ DISCLAIMER BEFORE USING DATA. This dataset backcasts estimated modeled savings for a subset of 2007-2012 completed projects in the Home Performance with ENERGY STAR® Program against normalized savings calculated by an open source energy efficiency meter available at https://www.openee.io/. Open source code uses utility-grade metered consumption to weather-normalize the pre- and post-consumption data using standard methods with no discretionary independent variables. The open source energy efficiency meter allows private companies, utilities, and regulators to calculate energy savings from energy efficiency retrofits with increased confidence and replicability of results. This dataset is intended to lay a foundation for future innovation and deployment of the open source energy efficiency meter across the residential energy sector, and to help inform stakeholders interested in pay for performance programs, where providers are paid for realizing measurable weather-normalized results. To download the open source code, please visit the website at https://github.com/openeemeter/eemeter/releases

D I S C L A I M E R: Normalized Savings using open source OEE meter. Several data elements, including, Evaluated Annual Elecric Savings (kWh), Evaluated Annual Gas Savings (MMBtu), Pre-retrofit Baseline Electric (kWh), Pre-retrofit Baseline Gas (MMBtu), Post-retrofit Usage Electric (kWh), and Post-retrofit Usage Gas (MMBtu) are direct outputs from the open source OEE meter.

Home Performance with ENERGY STAR® Estimated Savings. Several data elements, including, Estimated Annual kWh Savings, Estimated Annual MMBtu Savings, and Estimated First Year Energy Savings represent contractor-reported savings derived from energy modeling software calculations and not actual realized energy savings. The accuracy of the Estimated Annual kWh Savings and Estimated Annual MMBtu Savings for projects has been evaluated by an independent third party. The results of the Home Performance with ENERGY STAR impact analysis indicate that, on average, actual savings amount to 35 percent of the Estimated Annual kWh Savings and 65 percent of the Estimated Annual MMBtu Savings. For more information, please refer to the Evaluation Report published on NYSERDA’s website at: http://www.nyserda.ny.gov/-/media/Files/Publications/PPSER/Program-Evaluation/2012ContractorReports/2012-HPwES-Impact-Report-with-Appendices.pdf.

This dataset includes the following data points for a subset of projects completed in 2007-2012: Contractor ID, Project County, Project City, Project ZIP, Climate Zone, Weather Station, Weather Station-Normalization, Project Completion Date, Customer Type, Size of Home, Volume of Home, Number of Units, Year Home Built, Total Project Cost, Contractor Incentive, Total Incentives, Amount Financed through Program, Estimated Annual kWh Savings, Estimated Annual MMBtu Savings, Estimated First Year Energy Savings, Evaluated Annual Electric Savings (kWh), Evaluated Annual Gas Savings (MMBtu), Pre-retrofit Baseline Electric (kWh), Pre-retrofit Baseline Gas (MMBtu), Post-retrofit Usage Electric (kWh), Post-retrofit Usage Gas (MMBtu), Central Hudson, Consolidated Edison, LIPA, National Grid, National Fuel Gas, New York State Electric and Gas, Orange and Rockland, Rochester Gas and Electric.

How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

New York Electricity Sales dataset provides data on total electricity requirements for New York State. Electricity sales to ultimate consumers are provided and are broken down by sector (Residential/Commercial/Industrial/Transportation) in GWh.

How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

This dataset includes all Statewide Commercial Baseline Study summary statistics related to the estimation of population penetration and saturation estimates. These include summaries of the number of survey respondents asked each equation, the number of survey respondents who provided a valid answer, the unweighted penetration, weighted penetration, and adjusted and weighted penetration. All supporting summary statistics are also provided. Penetration refers to the proportion of businesses that have one or more of a particular piece of equipment. Saturation is a number representing how many of a particular piece of equipment are present, on average, among all businesses. The overall objective of the Statewide Commercial Baseline research was to understand the existing commercial building stock in New York State and associated energy use, including the penetration and saturation of energy consuming equipment (electric, natural gas, and other fuels). For more information, see the Final Report at https://www.nyserda.ny.gov/About/Publications/Building-Stock-and-Potential-Studies/Commercial-Statewide-Baseline-Study. 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.

Go to https://afdc.energy.gov/stations/#/find/nearest to access the full database of alternative fuel station locations nationwide, collected and maintained by the U.S. Department of Energy National Renewable Energy Laboratory. A station appears as one point in the data and on the map, regardless of the number of fuel dispensers or charging outlets at that location. For EV charging stations for example, the data includes the number of number of charging ports available at the specific station.

How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

IMPORTANT! PLEASE READ DISCLAIMER BEFORE USING DATA. To reduce the energy burden on income-qualified households within New York State, NYSERDA offers the EmPower New York (EmPower) program, a retrofit program that provides cost-effective electric reduction measures (i.e., primarily lighting and refrigerator replacements), and cost-effective home performance measures (i.e., insulation air sealing, heating system repair and replacments, and health and safety measures) to income qualified homeowners and renters. Home assessments and implementation services are provided by Building Performance Institute (BPI) Goldstar contractors to reduce energy use for low income households. This data set includes energy efficiency projects completed since January 2018 for households with income up to 60% area (county) median income.

D I S C L A I M E R: Estimated Annual kWh Savings, Estimated Annual MMBtu Savings, and First Year Energy Savings $ Estimate represent contractor reported savings derived from energy modeling software calculations and not actual realized energy savings. The accuracy of the Estimated Annual kWh Savings and Estimated Annual MMBtu Savings for projects has been evaluated by an independent third party. The results of the impact analysis indicate that, on average, actual savings amount to 54 percent of the Estimated Annual kWh Savings and 70 percent of the Estimated Annual MMBtu Savings. The analysis did not evaluate every single project, but rather a sample of projects from 2007 and 2008, so the results are applicable to the population on average but not necessarily to any individual project which could have over or under achieved in comparison to the evaluated savings. The results from the impact analysis will be updated when more recent information is available. Some reasons individual households may realize savings different from those projected include, but are not limited to, changes in the number or needs of household members, changes in occupancy schedules, changes in energy usage behaviors, changes to appliances and electronics installed in the home, and beginning or ending a home business. For more information, please refer to the Evaluation Report published on NYSERDA’s website at: https://www.nyserda.ny.gov/-/media/Files/Publications/PPSER/Program-Evaluation/2012ContractorReports/2012-EmPower-New-York-Impact-Report.pdf.

This dataset includes the following data points for projects completed after January 1, 2018: Reporting Period, Project ID, Project County, Project City, Project ZIP, Gas Utility, Electric Utility, Project Completion Date, Total Project Cost (USD), Pre-Retrofit Home Heating Fuel Type, Year Home Built, Size of Home, Number of Units, Job Type, Type of Dwelling, Measure Type, Estimated Annual kWh Savings, Estimated Annual MMBtu Savings, First Year Modeled Energy Savings $ Estimate (USD).

How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

The Build Smart NY Program aims to increase energy efficiency of New York State government buildings. Build Smart NY was established by Executive Order 88 and mandates a reduction in energy consumption by 20% in government owned and operated buildings by 2020. Site utility data has been collected for all government buildings larger than 20,000 square feet and this has been converted to Source Energy Use Intensity (EUI) which is a ratio of Source Energy Use to gross square footage. The Source EUI will be used as a performance metric to achieve the 20% reduction targets. The dataset represents a baseline of Source EUI for New York State government buildings at the baseline year of SFI 2010/2011; subsequent reports will demonstrate a progression to achieving a 20% energy reduction target.

Content

Recharge New York Power is available to businesses and not-for-profit corporations for job retention and business expansion and attraction purposes. This dataset contains Recharge New York Customers, including their location, amount of allocation, and amount of jobs committed.

Context

This is a dataset hosted by the State of New York. The state has an open data platform found here and they update their information according the amount of data that is brought in. Explore New York State using Kaggle and all of the data sources available through the State of New York organization page!

• Update Frequency: This dataset is updated monthly.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Hiep Nguyen on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

The NYSERDA-funded Integrated Energy Data Resource (IEDR) provides a single statewide platform to securely collect, integrate, analyze, and make accessible a large and diverse set of energy-related information from New York's electric, gas, and steam utilities and other sources. Useful access to useful energy data provided by the IEDR enables analyses that informs investment decisions, identifies operational inefficiencies, monitors the effectiveness of policy objectives, promotes innovation, and encourages new business models.The IEDR includes analytic tools to enable energy stakeholders to design and run useful queries and calculations that can operate across all data types in the IEDR. Those tools' number and functionality should increase over time to align with, and support the use cases, that become operational as part of the IEDR. Additionally, relational information that describes the relationships among the various data elements in the IEDR materially affects the depth potential of users' ability to find, analyze, and generate useful information. User access to the IEDR data and analytic tools will be governed by the access controls that reflect and align with each type of user's legitimate needs while preventing unwarranted access to information that does not serve those legitimate needs.Public, utility-managed, and commercial datasets processed by the platform and made available or planned to be made available to approved users in various forms include: • Feeder and sub-feeder hosting capacity • Installed and queued DER projects • Utility Rates and Tariffs • Customer billing and usage • Aggregated building usage • Disadvantaged Community Characteristics • Land, Parcel, and Terrain attributesThe 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, accelerate economic growth, and reduce reliance on fossil fuels.

Energy storage is critical to New York’s clean energy future. As renewable power sources like wind and solar provide a larger portion of New York’s electricity, storage will allow clean energy to be available when and where it is most needed. The 2019 Climate Act set a statewide goal of 3,000 MW of Energy Storage by 2030, further increased to 6,000 MW of Energy Storage by 2030 by Governor Kathy Hochul. This dataset tracks progress towards these statewide goals by compiling data on installed energy storage projects. Projects that received funding support from NYSERDA, as well as unincentivized projects, are included in this dataset The New York State Energy Research and Development Authority (NYSERDA) offers objective information and analysis, innovative programs, technical expertise, and support to help develop energy storage projects. Please see https://www.nyserda.ny.gov/All-Programs/Energy-Storage-Program.

New York Energy Prices presents retail energy price data. Energy prices are provided by fuel type in nominal dollars per million Btu for the residential, commercial, industrial, and transportation sectors. This section includes a column in the price table displaying gross domestic product (GDP) price deflators for converting nominal (current year) dollars to constant (real) dollars. To convert nominal to constant dollars, divide the nominal energy price by the GDP price deflator for that particular year. Historical petroleum, electricity, coal, and natural gas prices were compiled primarily from the Energy Information Administration.

How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.