DER Hosting Capacity by County

NYSERDA Integrated Energy Data Resource (IEDR) per-county DER hosting-capacity rollup for New York State's 62 counties.

NYSERDA IEDRInfrastructure data

Download data Open on map

Native record

event_time x county_id

daily snapshot publication cadence

Evidence

Observed market data

Published observations from the named source

In Ask the Grid

DER hosting capacity on the NYISO map

Values for the live grid surface

Overview

Each snapshot row carries DER counts by status, feeder count, and min/max/total hosting capacity for generic DER, ESS charging, ESS discharging, and EV load, plus county population and centroid. `county_id` is an IEDR-internal identifier, NOT a FIPS code — join to county geometry by normalized county name. Bitemporal snapshot: use ROW_NUMBER() OVER (PARTITION BY county_id ORDER BY event_time DESC) = 1 (or an equivalent argMax(..., event_time) per county_id) to get the current snapshot. ESS charging and discharging hosting capacity are asymmetric: a battery can only charge into a wire's spare import capacity, but can discharge more than the wire's rating when serving co-located load.

Query contract

Preserve one canonical row per (event_time, county_id) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, county_id.

Schema30

Column

Type

event_timeDateTime64(6, 'UTC')

county_idLowCardinality(String)

county_nameNullable(String)

population_2020Nullable(Int64)

county_typeNullable(String)

centroid_lonNullable(Float64)

centroid_latNullable(Float64)

der_countNullable(Int64)

installed_der_countNullable(Int64)

planned_der_countNullable(Int64)

cancelled_der_countNullable(Int64)

application_reviewed_der_countNullable(Int64)

min_der_nameplate_kwNullable(Float64)

max_der_nameplate_kwNullable(Float64)

total_der_nameplate_kwNullable(Float64)

feeder_countNullable(Int64)

min_hosting_capacity_mwNullable(Float64)

max_hosting_capacity_mwNullable(Float64)

total_hosting_capacity_mwNullable(Float64)

min_ess_charging_hosting_capacity_mwNullable(Float64)

max_ess_charging_hosting_capacity_mwNullable(Float64)

total_ess_charging_hosting_capacity_mwNullable(Float64)

min_ess_discharging_hosting_capacity_mwNullable(Float64)

max_ess_discharging_hosting_capacity_mwNullable(Float64)

total_ess_discharging_hosting_capacity_mwNullable(Float64)

min_ev_load_capacity_mwNullable(Float64)

max_ev_load_capacity_mwNullable(Float64)

total_ev_load_capacity_mwNullable(Float64)

source_timeDateTime64(6, 'UTC')

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	county_id	county_name	population_2020	county_type	centroid_lon	centroid_lat	der_count	installed_der_count	planned_der_count	cancelled_der_count	application_reviewed_der_count	min_der_nameplate_kw	max_der_nameplate_kw	total_der_nameplate_kw	feeder_count	min_hosting_capacity_mw	max_hosting_capacity_mw	total_hosting_capacity_mw	min_ess_charging_hosting_capacity_mw	max_ess_charging_hosting_capacity_mw	total_ess_charging_hosting_capacity_mw	min_ess_discharging_hosting_capacity_mw	max_ess_discharging_hosting_capacity_mw	total_ess_discharging_hosting_capacity_mw	min_ev_load_capacity_mw	max_ev_load_capacity_mw	total_ev_load_capacity_mw	source_time	ingested_at
2026-09-08 07:25:13.064597	977309	St Lawrence	108505	counties_shoreline	-75.06282579	44.49126466	0	0	0	0	0	0	0	0	16383	0	10	16793.310000000027	0	9.4	2993.4599999999973	0	10	11308.119999999879	0.21	12.26	198.13	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974159	Yates	24774	counties_shoreline	-77.10547142	42.63345319	316	215	15	70	1	1.18	200000	797433.0079999999	3276	0	10	4820.699999999989	0	10	4488.699999999997	0.1	10	4881.699999999968	-0.5892	33.397	77.1762	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974158	Wyoming	40531	counties_shoreline	-78.22436756	42.70241225	321	183	25	101	1	0	126000	709802.7119999997	8164	0	10	7126.009999999989	0	8	7324.700000000001	0	10	6501.900000000005	-15.218	7.729	37.5101	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974157	Westchester	1004457	counties_shoreline	-73.75521231	41.16427426	19494	14785	1421	3276	0	0	505000	2369250.216000007	47666	0	12.35	121466.78000000058	0	10	32358.71022572802	0	18.069625	53539.393164381196	-0.2606	12.447	16833.38646765313	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974156	Wayne	91283	counties_shoreline	-77.02937609	43.15655009	1026	643	68	269	3	0	614000	1748043.825	17023	0	10	18410.90000000011	0	10	19956.300000000047	0	10	19877.000000000102	-0.983	32.5368	151.05040000000002	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974155	Washington	61302	counties_shoreline	-73.43092083	43.311667	210	144	22	39	0	0	5000	157033.43200000012	10080	0	10	8873.289999999992	0	7.2	3892.819999999994	0	10	3622.229999999995	0.69	15.8099	117.73509999999999	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974154	Warren	65737	counties_shoreline	-73.84590039	43.56107921	1	0	0	1	0	2000	2000	2000	10906	0	10	7347.2199999999575	0	7.8	4821.430000000002	0	10	5192.269999999951	0.51	12.52	214.7	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974153	Ulster	181851	counties_shoreline	-74.25852788	41.888039	81	63	4	12	0	0	6720	28424.289	61809	0	10	90136.52999999996	0	9.2	86810.90000000008	0	10	2683.600000000003	3.394	28.6568	48.6223	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974152	Tompkins	105740	counties_shoreline	-76.47372897	42.45192433	2129	1801	41	268	1	0	144000	973778.7259999984	9679	0	10	26503.690000000068	0	10	22420.900000000092	0	10	18269.799999999996	-1.3023	19.1628	233.8254	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974151	Tioga	48455	counties_shoreline	-76.30624377	42.17017194	588	376	36	154	0	0	20000	703970.2089999994	4407	0	10	9257.299999999994	0	10	4594.30000000001	0	10	6769.400000000005	-2.8992	11.781	98.49959999999999	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974150	Sullivan	78624	counties_shoreline	-74.76820748	41.71633262	1356	786	62	484	3	0	8000	1187618.2960000006	18552	0	10	17699.379999999932	0	10	16141.400000000012	0	10	14240.000000000004	-0.3134	8.98	1807.7491	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974149	Suffolk	1525920	counties_shoreline	-72.86141034	40.87718684	0	0	0	0	0	0	0	0	177979	0	12.9	189627.63999997816	3.1172	6.23226	31.165580000000002	7.793	15.58065	77.91395	3.44	3.580149019	34.960596075999995	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974148	Steuben	93584	counties_shoreline	-77.38387856	42.2678154	647	292	56	262	0	0	300000	2019358.195999999	13330	0	10	19037.099999999962	0	10	17566.899999999972	0	10	18203.100000000035	-0.7696	18.5112	302.4588	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974147	Seneca	33814	counties_shoreline	-76.82377521	42.78106734	341	201	21	113	0	0	24000	495963.66699999996	5031	0	10	5317.309999999974	0	10	6295.999999999977	0	10	5788.99999999998	-0.3443	22.05	79.1762	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974146	Schuyler	17898	counties_shoreline	-76.87541028	42.3938133	296	190	24	74	0	0	20000	379276.3479999998	3506	0	10	6452.580000000001	0	10	5276.299999999994	0	10	3164.5999999999976	0.42	29.8476	75.1843	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974145	Schoharie	29714	counties_shoreline	-74.44211154	42.5882401	80	41	7	31	0	0	5000	85435.776	5231	0	10	3065.949999999999	0	10	2165.299999999997	0	10	2613.5300000000007	0.88	21.092	80.1635	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974144	Schenectady	158061	counties_shoreline	-74.05861596	42.81810425	0	0	0	0	0	0	0	0	13724	0	10	27626.630000000034	0	10	8835.839999999997	0	10	13089.64999999998	0	10.99	172.76	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974143	Saratoga	235509	counties_shoreline	-73.86404141	43.10753262	477	378	21	72	0	0	20000	191086.67100000038	25072	0	10	39390.71999999997	0	10	20435.780000000068	0	10	23512.159999999978	-0.63	23.542	370.515	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974142	Rockland	338329	counties_shoreline	-74.02402527	41.15236173	6583	5477	539	567	0	0	20000	206651.7670000002	38434	0.01	10	155860.7699999896	0	7.2	359.04999999999995	0	3.1	401.24999999999994	0	5.92	36803.91	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974141	Richmond	495747	counties_shoreline	-74.15304839	40.580807	17814	14704	757	2353	0	0	5000	1594040	22960	0.32	19.32	111800.76999999888	0	6.45093	17850.371440619114	0	16.127325	44563.889167077796	0	14.07	21054.60939432698	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974140	Rensselaer	161130	counties_shoreline	-73.50974901	42.71097125	533	429	12	84	3	0	20000	182328.70100000023	17603	0	10	14971.860000000008	0	10	11632.28999999996	0	10	11876.089999999944	-0.3474	19.64	255.24739999999997	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974139	Queens	2405464	counties_shoreline	-73.8186443	40.70766467	33019	26598	2273	4148	0	0	5000	965541	74095	0	9101.865	79020.49300000028	0	6.65795	3321.9545970330137	0	16.644875	8302.940862240008	0	7.529224861	7331.901556950856	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974138	Putnam	97668	counties_shoreline	-73.74950321	41.42649933	1258	960	63	222	0	0	150000	256708.06300000046	13355	0	10	30565.64000000016	0	10	27575.100000000006	0	10	28425.60000000014	-0.3106	12.447	169.13660000000002	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974137	Otsego	58524	counties_shoreline	-75.0325916	42.63376237	509	362	22	113	1	0	200600	502861.91099999944	8610	0	10	7296.66999999994	0	10	7709.699999999988	0	10	8082.69999999992	-0.47	9.6191	87.9154	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872
2026-09-08 07:25:13.064597	974136	Oswego	117525	counties_shoreline	-76.14125349	43.42695147	5	0	0	5	0	2000	5000	13000	17763	0	10	18569.85000000002	0	9.4	9178.700000000039	0	10	17953.910000000116	0	12.2	144.82	2026-09-08 07:25:13.064597	2026-09-08 07:25:14.654872

Coverage

100.0% complete0 gap days46 days with data

Show coverage history ▾

Coverage: 100.0%Days with data: 46Gaps: 0

2026

gaplessmore

Related infrastructure data

Related infrastructure data
Dataset	Description
CAISO Interconnection QueueCAISO · monthly snapshot	CAISO's public generation interconnection queue, combining active, completed, and withdrawn projects with the proposed point of interconnection, technology, requested capacity, status, and completion dates. Each posting is a snapshot: current totals must use one latest snapshot, and requested queue MW is not operating capacity, available transmission headroom, or evidence that a project will be built.
CAISO Price LocationsCAISO · slow-moving dimension, refreshed every 6 hours	Every CAISO location that carries a price, as three columns: location_id, name, and kind. 26,632 rows — node (26,048), interface (578), zone (6). This is the dimension the CAISO price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For CAISO, name equals location_id (the pnode name). The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.
ERCOT Interconnection QueueERCOT · monthly snapshot	ERCOT's public large-generation interconnection queue, with project identity, developer, proposed point of interconnection, transmission owner, technology, requested MW, queue status, and proposed or actual completion dates. Each posting is a snapshot, so current project claims must use the latest snapshot rather than count every vintage. Queue inclusion and proposed dates do not establish available transmission headroom, study outcome, approval, construction probability, or an operating asset. The official source is ERCOT's GIS Report.
ERCOT Price LocationsERCOT · slow-moving dimension, refreshed every 6 hours	Every ERCOT location that carries a price, as three columns: location_id, name, and kind. 20,456 rows — bus (19,329), node (1,100), weather_zone (8), zone (8), hub (7), interface (4). This is the dimension the ERCOT price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For ERCOT, name equals location_id — the settlement-point name is the identifier. The key is (location_id, kind), not location_id alone: 161 ERCOT names exist as both a settlement point and an electrical bus, and those are separately priced objects. Filter on kind when a name could be either. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.