Monthly ZIP Code Energy Use for New York State Utilities

ZIP code-level electricity and natural gas usage data reported by utilities under New York State regulation. The dataset includes metrics such as number_of_accounts and value for each month and utility_display_name, beginning in 2021. It is published by data.ny.gov and sourced from the state-mandated Utility Energy Registry.

Use Cases

• Forecast monthly energy value for a specific zip_code based on historical month and utility_display_name patterns.
• Analyze the correlation between number_of_accounts and total energy consumption value across different zip_code areas.
• Compare electricity (data_stream) versus natural gas (data_stream) usage trends by year and zip_city.
• Identify utilities (utility_display_name) with the highest per-account consumption using value and number_of_accounts columns.

Strengths

• Data is reported at the ZIP Code level (zip_code), providing granular spatial detail.
• Includes distinct data streams for electricity and natural gas consumption (data_stream).

Limitations

• Row count and total data volume are unknown, limiting assessment of statistical power.
• Data fields that fail privacy screening are withheld, potentially creating gaps in coverage.
• Temporal coverage is limited to records beginning in 2021, offering a short historical baseline.

Provenance

Source

New York State utilities and Community Choice Aggregation administrators, compiled into the state-mandated Utility Energy Registry.

Collection Method

Aggregated community-scale energy data reported by regulated entities under PSC Order CASE 17-M-0315.

Time Range

Beginning 2021 onward.

Freshness

Updated monthly, with last update in September 2025.

Geography

New York State, United States.