Monthly Community Electricity and Natural Gas Usage in New York

Community-scale electricity and natural gas consumption data aggregated for cities, towns, and villages in New York State. The New York State Energy Research and Development Authority (NYSERDA) manages this data, which utilities and Community Choice Aggregation administrators are required to report. Records begin in 2021 and are updated monthly.

Use Cases

• Forecast monthly community energy demand using `value`, `month`, `year`, and `com_type`.
• Analyze the adoption of Community Choice Aggregation programs by comparing `value` across `com_type` and `utility_display_name`.
• Model the relationship between the number of accounts (`number_of_accounts`) and total energy consumption (`value`) for different `data_stream` types.
• Assess geographic disparities in energy use by aggregating `value` by `county_name` or `full_fips`.
• Track seasonal energy consumption patterns for specific `com_name` entities using the `month` and `year` columns.

Strengths

• Data is reported at a granular community level (`city`, `town`, `village`) via `com_type` and `com_name`.
• Includes both electricity and natural gas consumption data via the `data_stream` column.
• Provides temporal granularity with `month` and `year` columns for time-series analysis.
• Contains utility source information (`utility_display_name`) and account counts (`number_of_accounts`).

Limitations

• Specific row count and total data volume are unknown.
• Data is limited to New York State communities, limiting broader geographic analysis.
• Privacy screening may result in withheld data points, potentially creating gaps.

Provenance

Source

New York State Energy Research and Development Authority (NYSERDA) via data.ny.gov.

Collection Method

Mandatory reporting by utilities and Community Choice Aggregation administrators under New York State Public Service Commission order.

Time Range

Beginning 2021 onward.

Freshness

Updated monthly, with last update in February 2026.

Geography

Cities, towns, and villages within New York State.