Data Catalog
Overview
NYSERDA Integrated Energy Data Resource (IEDR) per-county DER hosting-capacity rollup for New York State's 62 counties. 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.
Schema32
Column
Type
event_timeDateTime64(6, 'UTC')county_idLowCardinality(String)county_nameNullable(String)population_2020Nullable(Int64)county_typeNullable(String)local_law_idNullable(String)local_law_dateNullable(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 rows
| event_time | county_id | county_name | population_2020 | county_type | local_law_id | local_law_date | 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-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
| 2026-07-25 01:26:11.020247 | 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-07-25 01:26:11.020247 | 2026-07-25 01:26:11.450666 |
Coverage
100.0% complete0 gap days1 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 1Gaps: 0
2026
gaplessmore