distribution_substations

6,655 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_published, licence, type, all_voltage, connected_export, other_substation_ids (array)

Link rowid ▼ name date_published source licence latitude longitude type location substation_id transformers all_voltage source_id connected_export other_substation_ids comments detailed_global_headroom global_gen_headroom global_dem_headroom
1 1 wem 30/05/2024 spen southern 52.85742736419944 -2.7384256901316206 primary wem spen_southern_primary_wem [{"node_1": ["wem"], "voltage_node_1": 33.0, "node_2": ["wem"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.18, "max_transformer_flow": 4.71, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.68, "local_dem_headroom": 2.79}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.68, -9.0]}] 8.68 -9.0
2 2 ykk 30/05/2024 spen southern 53.31064166170123 -2.6575678790742194 primary ykk spen_southern_primary_ykk [{"node_1": ["ykk"], "voltage_node_1": 33.0, "node_2": ["ykk"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 3.95, "max_transformer_flow": 15.81, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 33.95, "local_dem_headroom": 14.19}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, 4.31]}] 20.12 4.31
3 3 rtz 30/05/2024 spen southern 53.36109957706429 -2.7744514702450234 primary rtz spen_southern_primary_rtz [{"node_1": ["rtz"], "voltage_node_1": 33.0, "node_2": ["rtz"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 4.28, "max_transformer_flow": 17.13, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 34.28, "local_dem_headroom": 12.870000000000001}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, 2.99]}] 20.12 2.99
4 4 ince 30/05/2024 spen southern 53.27706643543043 -2.81309528275764 bsp ince spen_southern_bsp_ince [{"node_1": ["ince c3", "incl c2", "incl c1"], "voltage_node_1": 132.0, "node_2": ["ince e3", "ince e2", "ince e1"], "voltage_node_2": 33.0, "nom_rating": [60.0, 45.0, 45.0], "eme_rating": [], "transformer_count": 3, "min_transformer_flow": 11.5, "max_transformer_flow": 46.2, "firm_capacity": 100.6, "accepted_export": 31.57894736842105, "accepted_import": 0.0, "project_id": ["spen_project_419_subid_1"], "local_gen_headroom": 80.52105263157894, "local_dem_headroom": 54.39999999999999}] [33.0, 132.0] NaN 0.0 []   [{"t13": [80.52, 54.4]}] 80.52 54.4
5 5 duns 17/06/2024 spen scottish 55.776947148605814 -2.3316810871668388 primary duns spen_scottish_primary_duns [{"node_1": ["dunst2", "dunst1"], "voltage_node_1": 33.0, "node_2": ["duns5-", "duns5-"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.36, "max_transformer_flow": 5.44, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 11.36, "local_dem_headroom": 4.56}] [33.0, 11.0] NaN 0.0 []   [{"t31": [11.36, 4.56]}] 11.36 4.56
6 6 mbna 30/05/2024 spen southern 53.15989872062274 -2.894922119993866 primary mbna spen_southern_primary_mbna [{"node_1": ["mbna"], "voltage_node_1": 33.0, "node_2": ["mbna"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 2.65, "max_transformer_flow": 10.58, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 32.65, "local_dem_headroom": 19.42}] [33.0, 11.0] NaN 0.0 []   [{"t31": [-4860.66, -4462.78]}] -4860.66 -4462.78
7 7 usac 30/05/2024 spen southern 53.36710545354615 -2.7115086291429784 primary usac spen_southern_primary_usac [{"node_1": ["usac"], "voltage_node_1": 33.0, "node_2": ["usac"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 2.35, "max_transformer_flow": 9.41, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 32.35, "local_dem_headroom": 20.59}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, 10.71]}] 20.12 10.71
8 8 mere 30/05/2024 spen southern 53.329256141483185 -2.4089117064380887 primary mere spen_southern_primary_mere [{"node_1": ["mere"], "voltage_node_1": 33.0, "node_2": ["mere"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.16, "max_transformer_flow": 4.64, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.66, "local_dem_headroom": 2.8600000000000003}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.66, 2.86]}] 8.66 2.86
9 9 mona 30/05/2024 spen southern 53.25098566366285 -4.371946112898453 primary mona spen_southern_primary_mona [{"node_1": ["mona"], "voltage_node_1": 33.0, "node_2": ["mona"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.43, "max_transformer_flow": 1.73, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 7.93, "local_dem_headroom": 5.77}] [33.0, 11.0] NaN 0.0 []   [{"t31": [-1.81, 5.77]}] -1.81 5.77
10 10 over 30/05/2024 spen southern 53.19128221238841 -2.53735067573302 primary over spen_southern_primary_over [{"node_1": ["over"], "voltage_node_1": 33.0, "node_2": ["over"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 4.46, "max_transformer_flow": 17.83, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 34.46, "local_dem_headroom": 12.170000000000002}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, 2.29]}] 20.12 2.29
11 11 bala 30/05/2024 spen southern 52.92020337239161 -3.586523905413076 primary bala spen_southern_primary_bala [{"node_1": ["bala"], "voltage_node_1": 33.0, "node_2": ["bala"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.85, "max_transformer_flow": 3.41, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.35, "local_dem_headroom": 4.09}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.35, 4.09]}] 8.35 4.09
12 12 irby 30/05/2024 spen southern 53.35224026648969 -3.1173104356222527 primary irby spen_southern_primary_irby [{"node_1": ["irby"], "voltage_node_1": 33.0, "node_2": ["irby"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 4.37, "max_transformer_flow": 17.49, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 34.37, "local_dem_headroom": 12.510000000000002}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, 2.63]}] 20.12 2.63
13 13 bold 30/05/2024 spen southern 53.43386042863474 -2.6938193619510167 bsp bold spen_southern_bsp_bold [{"node_1": ["bold c4"], "voltage_node_1": 132.0, "node_2": ["bold e5"], "voltage_node_2": 33.0, "nom_rating": [60.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 6.5, "max_transformer_flow": 26.0, "firm_capacity": 64.6, "accepted_export": 34.68736842105263, "accepted_import": 16.178947368421053, "project_id": ["spen_project_259_subid_0", "spen_project_752_subid_0", "spen_project_102_subid_0", "spen_project_258_subid_0", "spen_project_170_subid_0"], "local_gen_headroom": 36.41263157894736, "local_dem_headroom": 22.42105263157894}] [33.0, 132.0] NaN 0.0 []   [{"t13": [36.41, 22.42]}] 36.41 22.42
14 14 llay 30/05/2024 spen southern 53.10004941124803 -3.0065297515710867 primary llay spen_southern_primary_llay [{"node_1": ["llay"], "voltage_node_1": 33.0, "node_2": ["llay"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.96, "max_transformer_flow": 7.83, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 11.96, "local_dem_headroom": 2.17}] [33.0, 11.0] NaN 0.0 []   [{"t31": [11.96, -39.7]}] 11.96 -39.7
15 15 lymm 30/05/2024 spen southern 53.38033765119692 -2.4925878958515164 primary lymm spen_southern_primary_lymm [{"node_1": ["lymm"], "voltage_node_1": 33.0, "node_2": ["lymm"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 2.22, "max_transformer_flow": 8.87, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 12.22, "local_dem_headroom": 1.1300000000000008}] [33.0, 11.0] NaN 0.0 []   [{"t31": [12.22, 1.13]}] 12.22 1.13
16 16 rhyl 30/05/2024 spen southern 53.30971678286146 -3.484944737489202 bsp rhyl spen_southern_bsp_rhyl [{"node_1": ["rhyl c1", "rhyl c2"], "voltage_node_1": 132.0, "node_2": ["rhyl e1", "nhoyle"], "voltage_node_2": 33.0, "nom_rating": [90.0, 90.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 22.4, "max_transformer_flow": 89.4, "firm_capacity": 112.9, "accepted_export": 66.3157894736842, "accepted_import": 0.0, "project_id": ["spen_project_616_subid_1", "spen_project_203_subid_1", "spen_project_392_subid_1"], "local_gen_headroom": 68.9842105263158, "local_dem_headroom": 23.5}] [33.0, 132.0] NaN 0.0 []   [{"t13": [68.98, 23.5]}] 68.98 23.5
17 17 ford 30/05/2024 spen southern 53.386161033198135 -3.0847463320503308 primary ford spen_southern_primary_ford [{"node_1": ["hapsford services station", "hartford", "hartford", "ford", "knutsford grid", "hapsford services station", "knutsford grid"], "voltage_node_1": 33.0, "node_2": ["hapsford services station t1", "hartford t1", "hartford t2", "ford", "knutsford grid t1", "hapsford services station t2", "knutsford grid t2"], "voltage_node_2": 11.0, "nom_rating": [10.0, 7.5, 7.5, 7.5, 7.5, 10.0, 7.5], "eme_rating": [], "transformer_count": 7, "min_transformer_flow": 4.4, "max_transformer_flow": 17.62, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 34.4, "local_dem_headroom": 12.379999999999999}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.46, 2.84]}] 20.46 2.84
18 18 annan 17/06/2024 spen scottish 54.9942149448268 -3.2528154187781526 primary annan spen_scottish_primary_annan [{"node_1": ["anant2", "anant1"], "voltage_node_1": 33.0, "node_2": ["anan5-", "anan5-"], "voltage_node_2": 11.0, "nom_rating": [12.0, 12.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 2.87, "max_transformer_flow": 11.48, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 26.87, "local_dem_headroom": 12.52}] [33.0, 11.0] NaN 0.0 []   [{"t31": [19.71, 8.23]}] 19.71 8.23
19 19 troon 17/06/2024 spen scottish 55.547757982742425 -4.647330516936993 primary troon spen_scottish_primary_troon [{"node_1": ["troot1", "troot2"], "voltage_node_1": 33.0, "node_2": ["troo5-", "troo5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 3.61, "max_transformer_flow": 14.45, "firm_capacity": 17.43, "accepted_export": 0.2105263157894737, "accepted_import": 0.0, "project_id": ["spen_project_538"], "local_gen_headroom": 20.829473684210527, "local_dem_headroom": 2.9800000000000004}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.83, 2.98]}] 20.83 2.98
20 20 tywyn 30/05/2024 spen southern 52.58756399266039 -4.080256444893464 primary tywyn spen_southern_primary_tywyn [{"node_1": ["tywyn"], "voltage_node_1": 33.0, "node_2": ["tywyn"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.05, "max_transformer_flow": 4.21, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.55, "local_dem_headroom": 3.29}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.55, 3.29]}] 8.55 3.29
21 21 edern 30/05/2024 spen southern 52.920672666280005 -4.560214066427661 primary edern spen_southern_primary_edern [{"node_1": ["edern"], "voltage_node_1": 33.0, "node_2": ["edern"], "voltage_node_2": 11.0, "nom_rating": [4.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.77, "max_transformer_flow": 3.09, "firm_capacity": 4.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 4.77, "local_dem_headroom": 0.9100000000000001}] [33.0, 11.0] NaN 0.0 []   [{"t31": [4.77, 0.91]}] 4.77 0.91
22 22 leven 17/06/2024 spen scottish 56.19766268951904 -3.0386875834450717 primary leven spen_scottish_primary_leven [{"node_1": ["levet1", "levet2"], "voltage_node_1": 33.0, "node_2": ["leve5-", "leve5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 3.14, "max_transformer_flow": 12.58, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 27.14, "local_dem_headroom": 11.42}] [33.0, 11.0] NaN 0.0 []   [{"t31": [21.6, 9.02]}] 21.6 9.02
23 23 prees 30/05/2024 spen southern 52.89746656084515 -2.6738885948236226 primary prees spen_southern_primary_prees [{"node_1": ["prees"], "voltage_node_1": 33.0, "node_2": ["prees"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.31, "max_transformer_flow": 5.23, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.81, "local_dem_headroom": 2.2699999999999996}] [33.0, 11.0] NaN 0.0 []   [{"t31": [-127.01, -321.48]}] -127.01 -321.48
24 24 speke 30/05/2024 spen southern 53.35305319970272 -2.848639021709814 bsp speke spen_southern_bsp_speke [{"node_1": ["spek c1", "spek c3"], "voltage_node_1": 132.0, "node_2": ["spek e1", "spek e2"], "voltage_node_2": 33.0, "nom_rating": [60.0, 60.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 13.8, "max_transformer_flow": 55.3, "firm_capacity": 108.3, "accepted_export": 28.947368421052634, "accepted_import": 21.05263157894737, "project_id": ["spen_project_444_subid_1", "spen_project_716_subid_1", "spen_project_717_subid_1"], "local_gen_headroom": 93.15263157894736, "local_dem_headroom": 31.94736842105263}] [33.0, 132.0] NaN 0.0 []   [{"t13": [93.15, 31.95]}] 93.15 31.95
25 25 kelco 30/05/2024 spen southern 53.46468110063253 -2.859040673019658 primary kelco spen_southern_primary_kelco [{"node_1": ["kelco"], "voltage_node_1": 33.0, "node_2": ["kelco"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 4.3, "max_transformer_flow": 17.22, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 34.3, "local_dem_headroom": 12.780000000000001}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.1, 2.88]}] 20.1 2.88
26 26 kodak 30/05/2024 spen southern 53.48433921300886 -2.8489862849242846 primary kodak spen_southern_primary_kodak [{"node_1": ["kodak"], "voltage_node_1": 33.0, "node_2": ["kodak"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 3.68, "max_transformer_flow": 14.71, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 33.68, "local_dem_headroom": 15.29}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, 5.41]}] 20.12 5.41
27 27 caldy 30/05/2024 spen southern 53.357864993900456 -3.1631556427290692 primary caldy spen_southern_primary_caldy [{"node_1": ["caldy"], "voltage_node_1": 33.0, "node_2": ["caldy"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 3.76, "max_transformer_flow": 15.04, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 33.76, "local_dem_headroom": 14.96}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.46, 5.08]}] 20.46 5.08
28 28 tulip 30/05/2024 spen southern 53.335967336324565 -2.9624348496105575 primary tulip spen_southern_primary_tulip [{"node_1": ["tulip"], "voltage_node_1": 33.0, "node_2": ["tulip"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.65, "max_transformer_flow": 6.61, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 11.65, "local_dem_headroom": 3.3899999999999997}] [33.0, 11.0] NaN 0.0 []   [{"t31": [-2416.27, -2558.72]}] -2416.27 -2558.72
29 29 acton 30/05/2024 spen southern 53.07692847968798 -2.5525271103629295 primary acton spen_southern_primary_acton [{"node_1": ["acton"], "voltage_node_1": 33.0, "node_2": ["acton"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.25, "max_transformer_flow": 4.99, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.75, "local_dem_headroom": 2.51}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.75, 2.51]}] 8.75 2.51
30 30 lache 30/05/2024 spen southern 53.16927193792324 -2.9251137128370566 primary lache spen_southern_primary_lache [{"node_1": ["lache"], "voltage_node_1": 33.0, "node_2": ["lache"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 2.65, "max_transformer_flow": 10.58, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 32.65, "local_dem_headroom": 19.42}] [33.0, 11.0] NaN 0.0 []   [{"t31": [-4860.66, -4462.78]}] -4860.66 -4462.78
31 31 conwy 30/05/2024 spen southern 53.28383335910783 -3.8383836038741226 primary conwy spen_southern_primary_conwy [{"node_1": ["conwy"], "voltage_node_1": 33.0, "node_2": ["conwy"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 3.03, "max_transformer_flow": 12.1, "firm_capacity": 27.32, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 30.35, "local_dem_headroom": 15.22}] [33.0, 11.0] NaN 0.0 []   [{"t31": [-1125.64, -1069.72]}] -1125.64 -1069.72
32 32 forth 17/06/2024 spen scottish 55.76312701449095 -3.7049029441675194 primary forth spen_scottish_primary_forth [{"node_1": ["frtht1"], "voltage_node_1": 33.0, "node_2": ["frth5-"], "voltage_node_2": 11.0, "nom_rating": [12.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.23, "max_transformer_flow": 4.94, "firm_capacity": 20.3, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 21.53, "local_dem_headroom": 15.36}] [33.0, 11.0] NaN 0.0 []   [{"t31": [21.53, 15.36]}] 21.53 15.36
33 33 pandy 30/05/2024 spen southern 53.07369969679359 -2.9909753238914325 primary pandy spen_southern_primary_pandy [{"node_1": ["pandy", "pandy"], "voltage_node_1": 33.0, "node_2": ["pandy t1", "pandy t2"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 2.03, "max_transformer_flow": 8.12, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 12.03, "local_dem_headroom": 1.8800000000000008}] [33.0, 11.0] NaN 0.0 []   [{"t31": [12.03, 1.88]}] 12.03 1.88
34 34 conix 30/05/2024 spen southern 53.35025102910953 -2.8417711830534587 primary conix spen_southern_primary_conix [{"node_1": ["conix", "conix"], "voltage_node_1": 33.0, "node_2": ["conix t2", "conix t1"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.79, "max_transformer_flow": 7.16, "firm_capacity": 20.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 21.79, "local_dem_headroom": 12.84}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.6, 12.84]}] 20.6 12.84
35 35 ayton 17/06/2024 spen scottish 55.838344376061656 -2.12830969340173 primary ayton spen_scottish_primary_ayton [{"node_1": ["aytot1", "aytot2"], "voltage_node_1": 33.0, "node_2": ["ayto5-", "ayto5-"], "voltage_node_2": 11.0, "nom_rating": [5.0, 5.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.15, "max_transformer_flow": 4.58, "firm_capacity": 5.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 6.15, "local_dem_headroom": 0.41999999999999993}] [33.0, 11.0] NaN 0.0 []   [{"t31": [6.15, 0.42]}] 6.15 0.42
36 36 palco 30/05/2024 spen southern 53.46246851790726 -2.870989076653031 primary palco spen_southern_primary_palco [{"node_1": ["palco"], "voltage_node_1": 33.0, "node_2": ["palco"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 4.3, "max_transformer_flow": 17.22, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 34.3, "local_dem_headroom": 12.780000000000001}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.46, 3.24]}] 20.46 3.24
37 37 omega 30/05/2024 spen southern 53.40875459117517 -2.6450406752424476 primary omega spen_southern_primary_omega [{"node_1": ["omega", "omega"], "voltage_node_1": 33.0, "node_2": ["omega t2", "omega t1"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 3.7, "max_transformer_flow": 14.82, "firm_capacity": 40.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 43.7, "local_dem_headroom": 25.18}] [33.0, 11.0] NaN 0.0 []   [{"t31": [21.6, 6.78]}] 21.6 6.78
38 38 morda 30/05/2024 spen southern 52.847873783210346 -3.0546649613466 primary morda spen_southern_primary_morda [{"node_1": ["morda"], "voltage_node_1": 33.0, "node_2": ["morda"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.83, "max_transformer_flow": 3.33, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.33, "local_dem_headroom": 4.17}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.33, -9.0]}] 8.33 -9.0
39 39 kelty 17/06/2024 spen scottish 56.13795306108347 -3.3621142641911854 primary kelty spen_scottish_primary_kelty [{"node_1": ["keltt2", "keltt1"], "voltage_node_1": 33.0, "node_2": ["kelt5-", "kelt5-"], "voltage_node_2": 11.0, "nom_rating": [10.0, 10.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.8, "max_transformer_flow": 7.2, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 11.8, "local_dem_headroom": 2.8}] [33.0, 11.0] NaN 0.0 []   [{"t31": [11.8, 2.8]}] 11.8 2.8
40 40 raith 17/06/2024 spen scottish 56.1034354314203 -3.160891804429212 primary raith spen_scottish_primary_raith [{"node_1": ["raitt1", "raitt2"], "voltage_node_1": 33.0, "node_2": ["rait5-", "rait5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.96, "max_transformer_flow": 7.85, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 25.96, "local_dem_headroom": 16.15}] [33.0, 11.0] NaN 0.0 []   [{"t31": [17.6, 9.75]}] 17.6 9.75
41 41 moore 30/05/2024 spen southern 53.344065890511445 -2.6655980007371176 bsp moore spen_southern_bsp_moore [{"node_1": ["moor c1"], "voltage_node_1": 132.0, "node_2": ["moor e1"], "voltage_node_2": 33.0, "nom_rating": [60.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 16.8, "max_transformer_flow": 67.1, "firm_capacity": 106.2, "accepted_export": 42.10526315789474, "accepted_import": 12.631578947368421, "project_id": ["spen_project_93_subid_1", "spen_project_92_subid_1"], "local_gen_headroom": 80.89473684210526, "local_dem_headroom": 26.468421052631587}] [33.0, 132.0] NaN 0.0 []   [{"t13": [63.69, 9.27]}] 63.69 9.27
42 42 cupar 17/06/2024 spen scottish 56.31395917152902 -3.034899752218677 primary cupar spen_scottish_primary_cupar [{"node_1": ["cupat1", "cupat2"], "voltage_node_1": 33.0, "node_2": ["cupa5-", "cupa5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 3.98, "max_transformer_flow": 15.9, "firm_capacity": 21.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 24.98, "local_dem_headroom": 5.1}] [33.0, 11.0] NaN 0.0 []   [{"t31": [24.98, 5.1]}] 24.98 5.1
43 43 crewe 30/05/2024 spen southern 53.10344833920535 -2.484795208423832 bsp crewe spen_southern_bsp_crewe [{"node_1": ["crew c1", "crew c4", "crew c2"], "voltage_node_1": 132.0, "node_2": ["crew e1", "crew e4", "crew e2"], "voltage_node_2": 33.0, "nom_rating": [60.0, 60.0, 60.0], "eme_rating": [], "transformer_count": 3, "min_transformer_flow": 29.8, "max_transformer_flow": 119.1, "firm_capacity": 197.4, "accepted_export": 234.92631578947368, "accepted_import": 43.578947368421055, "project_id": ["spen_project_121_subid_1", "spen_project_121_subid_2", "spen_project_224_subid_1", "spen_project_224_subid_2", "spen_project_276_subid_1", "spen_project_276_subid_2", "spen_project_490_subid_1", "spen_project_490_subid_2", "spen_project_535_subid_1", "spen_project_535_subid_2", "spen_project_781_subid_1", "spen_project_781_subid_2", "spen_project_209_subid_1", "spen_project_209_subid_2"], "local_gen_headroom": -7.726315789473659, "local_dem_headroom": 34.72105263157896}] [33.0, 132.0] NaN 0.0 []   [{"t13": [-7.73, 34.72]}] -7.73 34.72
44 44 upton 30/05/2024 spen southern 53.38447641600384 -3.0985992668839186 primary upton spen_southern_primary_upton [{"node_1": ["upton"], "voltage_node_1": 33.0, "node_2": ["upton"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 3.13, "max_transformer_flow": 12.51, "firm_capacity": 20.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 23.13, "local_dem_headroom": 7.49}] [33.0, 11.0] NaN 0.0 []   [{"t31": [18.46, 5.95]}] 18.46 5.95
45 45 deans 17/06/2024 spen scottish 55.90337993344813 -3.5719610036867184 primary deans spen_scottish_primary_deans [{"node_1": ["deast1", "deast2"], "voltage_node_1": 33.0, "node_2": ["deas5-", "deas5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 3.61, "max_transformer_flow": 14.44, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 27.61, "local_dem_headroom": 9.56}] [33.0, 11.0] NaN 0.0 []   [{"t31": [27.61, 9.56]}] 27.61 9.56
46 46 b r d 30/05/2024 spen southern 52.51673221607967 -3.2981169585817525 primary b r d spen_southern_primary_brd [{"node_1": ["b r d"], "voltage_node_1": 33.0, "node_2": ["b r d"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.31, "max_transformer_flow": 5.26, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.81, "local_dem_headroom": 2.24}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.81, 2.24]}] 8.81 2.24
47 47 largs 17/06/2024 spen scottish 55.79878398267906 -4.8560499586042924 primary largs spen_scottish_primary_largs [{"node_1": ["largt2"], "voltage_node_1": 33.0, "node_2": ["larg5-"], "voltage_node_2": 11.0, "nom_rating": [24.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.96, "max_transformer_flow": 7.83, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 25.96, "local_dem_headroom": 16.17}] [33.0, 11.0] NaN 0.0 []   [{"t31": [25.96, 16.17]}] 25.96 16.17
48 48 flint 30/05/2024 spen southern 53.25224135180582 -3.142028941991487 primary flint spen_southern_primary_flint [{"node_1": ["flint", "flint"], "voltage_node_1": 33.0, "node_2": ["flint t2", "flint t1"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.48, "max_transformer_flow": 5.93, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 11.48, "local_dem_headroom": 4.07}] [33.0, 11.0] NaN 0.0 []   [{"t31": [11.48, 4.07]}] 11.48 4.07
49 49 oxton 30/05/2024 spen southern 53.38235749970853 -3.052941955914349 primary oxton spen_southern_primary_oxton [{"node_1": ["oxton"], "voltage_node_1": 33.0, "node_2": ["oxton"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 4.4, "max_transformer_flow": 17.62, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 34.4, "local_dem_headroom": 12.379999999999999}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.46, 2.84]}] 20.46 2.84
50 50 manod 30/05/2024 spen southern 52.968984328932066 -3.9303281328453306 primary manod spen_southern_primary_manod [{"node_1": ["manod"], "voltage_node_1": 33.0, "node_2": ["manod"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.28, "max_transformer_flow": 1.12, "firm_capacity": 4.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 4.28, "local_dem_headroom": 2.88}] [33.0, 11.0] NaN 0.0 []   [{"t31": [4.28, 2.88]}] 4.28 2.88
51 51 elton 30/05/2024 spen southern 53.27304647686608 -2.812687257058121 primary elton spen_southern_primary_elton [{"node_1": ["elton"], "voltage_node_1": 33.0, "node_2": ["elton"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.67, "max_transformer_flow": 2.67, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.17, "local_dem_headroom": 4.83}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.17, 4.83]}] 8.17 4.83
52 52 meols 30/05/2024 spen southern 53.39882712942903 -3.1553751399520578 primary meols spen_southern_primary_meols [{"node_1": ["meols"], "voltage_node_1": 33.0, "node_2": ["meols"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 3.76, "max_transformer_flow": 15.04, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 33.76, "local_dem_headroom": 14.96}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, -77.5]}] 20.12 -77.5
53 53 alpoco 30/05/2024 spen southern 53.29411580506211 -4.596197938500489 primary alpoco spen_southern_primary_alpoco [{"node_1": ["alpoco"], "voltage_node_1": 33.0, "node_2": ["alpoco"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.55, "max_transformer_flow": 2.18, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.05, "local_dem_headroom": 5.32}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.05, 5.32]}] 8.05 5.32
54 54 forgan 17/06/2024 spen scottish 56.41220667958264 -2.9148164481238976 primary forgan spen_scottish_primary_forgan [{"node_1": ["forgt1", "forgt2"], "voltage_node_1": 33.0, "node_2": ["forg5-", "forg5-"], "voltage_node_2": 11.0, "nom_rating": [12.0, 12.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.86, "max_transformer_flow": 7.45, "firm_capacity": 14.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 15.86, "local_dem_headroom": 6.55}] [33.0, 11.0] NaN 0.0 []   [{"t31": [15.86, 6.55]}] 15.86 6.55
55 55 biggar 17/06/2024 spen scottish 55.6220121980282 -3.524225442971981 primary biggar spen_scottish_primary_biggar [{"node_1": ["bgart1"], "voltage_node_1": 33.0, "node_2": ["bgar5-"], "voltage_node_2": 11.0, "nom_rating": [10.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.44, "max_transformer_flow": 5.78, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 11.44, "local_dem_headroom": 4.22}] [33.0, 11.0] NaN 0.0 []   [{"t31": [11.44, 4.22]}] 11.44 4.22
56 56 audlem 30/05/2024 spen southern 52.995926665325726 -2.488867305156926 primary audlem spen_southern_primary_audlem [{"node_1": ["audlem"], "voltage_node_1": 33.0, "node_2": ["audlem"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.89, "max_transformer_flow": 3.56, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.39, "local_dem_headroom": 3.94}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.39, 3.94]}] 8.39 3.94
57 57 dutton 30/05/2024 spen southern 53.311684547825095 -2.6647472021497123 bsp dutton spen_southern_bsp_dutton [{"node_1": ["dutn c1"], "voltage_node_1": 132.0, "node_2": ["dutn e1"], "voltage_node_2": 33.0, "nom_rating": [60.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 16.8, "max_transformer_flow": 67.1, "firm_capacity": 106.2, "accepted_export": 42.10526315789474, "accepted_import": 12.631578947368421, "project_id": ["spen_project_93_subid_0", "spen_project_92_subid_0"], "local_gen_headroom": 80.89473684210526, "local_dem_headroom": 26.468421052631587}] [33.0, 132.0] NaN 0.0 []   [{"t13": [80.89, 26.47]}] 80.89 26.47
58 58 sorbie 17/06/2024 spen scottish 54.781884082298156 -4.459736400562703 primary sorbie spen_scottish_primary_sorbie [{"node_1": ["sorbt2", "sorbt1"], "voltage_node_1": 33.0, "node_2": ["sorb5-", "sorb5-"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.25, "max_transformer_flow": 5.0, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 11.25, "local_dem_headroom": 5.0}] [33.0, 11.0] NaN 0.0 []   [{"t31": [0.0, -5.0]}] 0.0 -5.0
59 59 orford 30/05/2024 spen southern 53.411151491716986 -2.573308853456878 primary orford spen_southern_primary_orford [{"node_1": ["orford"], "voltage_node_1": 33.0, "node_2": ["orford"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 2.19, "max_transformer_flow": 8.77, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 12.19, "local_dem_headroom": 1.2300000000000004}] [33.0, 11.0] NaN 0.0 []   [{"t31": [12.19, 1.23]}] 12.19 1.23
60 60 duddon 30/05/2024 spen southern 53.18054566576525 -2.7233772932457345 primary duddon spen_southern_primary_duddon [{"node_1": ["duddon"], "voltage_node_1": 33.0, "node_2": ["duddon"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.54, "max_transformer_flow": 2.15, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.04, "local_dem_headroom": 5.35}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.04, 5.35]}] 8.04 5.35
61 61 shotts 17/06/2024 spen scottish 55.82162660062597 -3.7900130247631565 primary shotts spen_scottish_primary_shotts [{"node_1": ["shttt1", "shttt2"], "voltage_node_1": 33.0, "node_2": ["shtt5-", "shtt5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 2.5, "max_transformer_flow": 9.98, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 26.5, "local_dem_headroom": 14.02}] [33.0, 11.0] NaN 0.0 []   [{"t31": [26.5, 14.02]}] 26.5 14.02
62 62 ditton 30/05/2024 spen southern 53.37139937864823 -2.7564448192689426 primary ditton spen_southern_primary_ditton [{"node_1": ["ditton"], "voltage_node_1": 33.0, "node_2": ["ditton"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 4.28, "max_transformer_flow": 17.13, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 34.28, "local_dem_headroom": 12.870000000000001}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, 2.99]}] 20.12 2.99
63 63 dingle 30/05/2024 spen southern 53.38434811882617 -2.957751747030431 primary dingle spen_southern_primary_dingle [{"node_1": ["dingle"], "voltage_node_1": 33.0, "node_2": ["dingle"], "voltage_node_2": 6.3, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.35, "max_transformer_flow": 5.4, "firm_capacity": 17.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 18.85, "local_dem_headroom": 12.1}] [33.0, 6.3] NaN 0.0 []   [{"t36": [18.85, 10.34]}] 18.85 10.34
64 64 neston main 30/05/2024 spen southern 53.28757197974981 -3.0550842420851954 primary neston spen_southern_primary_neston [{"node_1": ["neston main"], "voltage_node_1": 33.0, "node_2": ["neston main"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 2.16, "max_transformer_flow": 8.65, "firm_capacity": 20.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 22.16, "local_dem_headroom": 11.35}] [33.0, 11.0] NaN 0.0 []   [{"t31": [17.66, 9.01]}] 17.66 9.01
65 65 darvel 17/06/2024 spen scottish 55.61117728865924 -4.270260854104357 primary darvel spen_scottish_primary_darvel [{"node_1": ["darvt1"], "voltage_node_1": 33.0, "node_2": ["darv5-"], "voltage_node_2": 11.0, "nom_rating": [10.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.33, "max_transformer_flow": 1.3, "firm_capacity": 10.0, "accepted_export": 2.631578947368421, "accepted_import": 0.0, "project_id": ["spen_project_571"], "local_gen_headroom": 7.698421052631579, "local_dem_headroom": 8.7}] [33.0, 11.0] NaN 0.0 []   [{"t31": [7.7, 8.7]}] 7.7 8.7
66 66 amlwch 30/05/2024 spen southern 53.41088364940866 -4.336888561322224 bsp amlwch spen_southern_bsp_amlwch [{"node_1": ["amlc c1"], "voltage_node_1": 132.0, "node_2": ["amlc e2"], "voltage_node_2": 33.0, "nom_rating": [45.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 12.1, "max_transformer_flow": 48.5, "firm_capacity": 72.5, "accepted_export": 57.05263157894738, "accepted_import": 0.0, "project_id": ["spen_project_200_subid_0", "spen_project_173_subid_0"], "local_gen_headroom": 27.547368421052617, "local_dem_headroom": 24.0}] [33.0, 132.0] NaN 0.0 []   [{"t13": [27.55, 24.0]}] 27.55 24.0
67 67 granby 30/05/2024 spen southern 53.394984310763114 -2.9681809485261317 primary granby spen_southern_primary_granby [{"node_1": ["granby"], "voltage_node_1": 33.0, "node_2": ["granby"], "voltage_node_2": 6.3, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.35, "max_transformer_flow": 5.4, "firm_capacity": 17.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 18.85, "local_dem_headroom": 12.1}] [33.0, 6.3] NaN 0.0 []   [{"t36": [18.85, 12.1]}] 18.85 12.1
68 68 tarvin 30/05/2024 spen southern 53.19990825922652 -2.7618432740970578 primary tarvin spen_southern_primary_tarvin [{"node_1": ["tarvin"], "voltage_node_1": 33.0, "node_2": ["tarvin"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.46, "max_transformer_flow": 5.86, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.96, "local_dem_headroom": 1.6399999999999997}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.96, 1.64]}] 8.96 1.64
69 69 fodens 30/05/2024 spen southern 53.145399273913625 -2.3912821358752248 primary fodens spen_southern_primary_fodens [{"node_1": ["fodens"], "voltage_node_1": 33.0, "node_2": ["fodens"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.22, "max_transformer_flow": 4.9, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.72, "local_dem_headroom": 2.5999999999999996}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.72, 2.6]}] 8.72 2.6
70 70 widnes 30/05/2024 spen southern 53.360618468455534 -2.739156686981453 bsp widnes spen_southern_bsp_widnes [{"node_1": ["widn c2", "widn c1"], "voltage_node_1": 132.0, "node_2": ["widn e2", "widn e1"], "voltage_node_2": 33.0, "nom_rating": [60.0, 45.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 20.3, "max_transformer_flow": 81.1, "firm_capacity": 110.6, "accepted_export": 23.10842105263158, "accepted_import": 16.178947368421053, "project_id": ["spen_project_259_subid_2", "spen_project_752_subid_2", "spen_project_102_subid_2", "spen_project_258_subid_2"], "local_gen_headroom": 107.79157894736842, "local_dem_headroom": 13.321052631578947}] [33.0, 132.0] NaN 0.0 []   [{"t13": [107.79, 13.32]}] 107.79 13.32
71 71 rivals 30/05/2024 spen southern 52.9838474407591 -4.4089010181383115 primary rivals spen_southern_primary_rivals [{"node_1": ["rivals"], "voltage_node_1": 33.0, "node_2": ["rivals"], "voltage_node_2": 11.0, "nom_rating": [4.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.34, "max_transformer_flow": 1.35, "firm_capacity": 4.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 4.34, "local_dem_headroom": 2.65}] [33.0, 11.0] NaN 0.0 []   [{"t31": [4.34, 2.65]}] 4.34 2.65
72 72 castle 17/06/2024 spen scottish 55.776715370523604 -4.30634512255554 primary castle spen_scottish_primary_castle [{"node_1": ["calet2", "calet1"], "voltage_node_1": 33.0, "node_2": ["cale5-", "cale5-"], "voltage_node_2": 11.0, "nom_rating": [21.0, 21.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 4.99, "max_transformer_flow": 19.95, "firm_capacity": 21.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 25.990000000000002, "local_dem_headroom": 1.0500000000000007}] [33.0, 11.0] NaN 0.0 []   [{"t31": [25.99, 1.05]}] 25.99 1.05
73 73 carmel 30/05/2024 spen southern 53.075695500899585 -4.249547654408851 primary carmel spen_southern_primary_carmel [{"node_1": ["carmel"], "voltage_node_1": 33.0, "node_2": ["carmel"], "voltage_node_2": 11.0, "nom_rating": [4.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.72, "max_transformer_flow": 2.89, "firm_capacity": 4.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 4.72, "local_dem_headroom": 1.1099999999999999}] [33.0, 11.0] NaN 0.0 []   [{"t31": [4.72, 1.11]}] 4.72 1.11
74 74 lanark 17/06/2024 spen scottish 55.6699682718226 -3.7588724124398505 primary lanark spen_scottish_primary_lanark [{"node_1": ["lankt1", "lankt2"], "voltage_node_1": 33.0, "node_2": ["lank5-", "lank5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.78, "max_transformer_flow": 7.11, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 25.78, "local_dem_headroom": 16.89}] [33.0, 11.0] NaN 0.0 []   [{"t31": [16.9, 9.79]}] 16.9 9.79
75 75 foxbar 17/06/2024 spen scottish 55.82638482260717 -4.460800462079585 primary foxbar spen_scottish_primary_foxbar [{"node_1": ["foxbt1", "foxbt2"], "voltage_node_1": 33.0, "node_2": ["foxb5-", "foxb5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.85, "max_transformer_flow": 7.39, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 25.85, "local_dem_headroom": 16.61}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.86, 13.47]}] 20.86 13.47
76 76 hunter 17/06/2024 spen scottish 55.77047229337794 -4.148718542274194 primary hunter spen_scottish_primary_hunter [{"node_1": ["huntt2", "huntt1"], "voltage_node_1": 33.0, "node_2": ["hunt5-", "hunt5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.15, "max_transformer_flow": 4.61, "firm_capacity": 20.86, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 22.009999999999998, "local_dem_headroom": 16.25}] [33.0, 11.0] NaN 0.0 []   [{"t31": [22.01, 16.25]}] 22.01 16.25
77 77 bangor 30/05/2024 spen southern 53.20950661691218 -4.180753392778038 bsp bangor spen_southern_bsp_bangor [{"node_1": ["bang c1"], "voltage_node_1": 132.0, "node_2": ["bang e2"], "voltage_node_2": 33.0, "nom_rating": [60.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 11.9, "max_transformer_flow": 47.6, "firm_capacity": 82.1, "accepted_export": 21.05263157894737, "accepted_import": 1.0526315789473684, "project_id": ["spen_project_691_subid_0"], "local_gen_headroom": 72.94736842105263, "local_dem_headroom": 33.44736842105262}] [33.0, 132.0] NaN 0.0 []   [{"t13": [-1530.2, -1069.72]}] -1530.2 -1069.72
78 78 irvine 17/06/2024 spen scottish 55.60599340500473 -4.667003199149166 primary irvine spen_scottish_primary_irvine [{"node_1": ["irvit1", "irvit2"], "voltage_node_1": 33.0, "node_2": ["irvi5-", "irvi5-"], "voltage_node_2": 11.0, "nom_rating": [21.0, 21.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 4.7, "max_transformer_flow": 18.8, "firm_capacity": 21.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 25.7, "local_dem_headroom": 2.1999999999999993}] [33.0, 11.0] NaN 0.0 []   [{"t31": [25.7, 2.2]}] 25.7 2.2
79 79 east mains 17/06/2024 spen scottish 55.93691615162071 -3.4502794038654807 primary east s spen_scottish_primary_easts [{"node_1": ["eamat1", "eamat2"], "voltage_node_1": 33.0, "node_2": ["eama5-", "eama5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.79, "max_transformer_flow": 7.17, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 25.79, "local_dem_headroom": 16.83}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.86, 13.69]}] 20.86 13.69
80 80 bewsey 30/05/2024 spen southern 53.39690749870157 -2.6135964784360275 primary bewsey spen_southern_primary_bewsey [{"node_1": ["bewsey"], "voltage_node_1": 33.0, "node_2": ["bewsey"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 3.97, "max_transformer_flow": 15.87, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 33.97, "local_dem_headroom": 14.13}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, 4.25]}] 20.12 4.25
81 81 spital 30/05/2024 spen southern 53.34122612550317 -3.007039480926014 primary spital spen_southern_primary_spital [{"node_1": ["royal liverpool hospital", "spital", "royal liverpool hospital"], "voltage_node_1": 33.0, "node_2": ["royal liverpool hospital t2", "spital", "royal liverpool hospital t1"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5, 7.5], "eme_rating": [], "transformer_count": 3, "min_transformer_flow": 3.62, "max_transformer_flow": 14.48, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 33.62, "local_dem_headroom": 15.52}] [33.0, 11.0] NaN 0.0 []   [{"t31": [-2416.27, -2558.72]}] -2416.27 -2558.72
82 82 wervin 30/05/2024 spen southern 53.230533445939244 -2.8667777713026994 primary wervin spen_southern_primary_wervin [{"node_1": ["wervin"], "voltage_node_1": 33.0, "node_2": ["wervin"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.79, "max_transformer_flow": 3.15, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.29, "local_dem_headroom": 4.35}] [33.0, 11.0] NaN 0.0 []   [{"t31": [-4860.66, -4462.78]}] -4860.66 -4462.78
83 83 amlwch 30/05/2024 spen southern 53.410926797127125 -4.337666657334883 primary amlwch spen_southern_primary_amlwch [{"node_1": ["amlwch", "amlwch"], "voltage_node_1": 33.0, "node_2": ["amlwch t1", "amlwch t2"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 0.77, "max_transformer_flow": 3.09, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 10.77, "local_dem_headroom": 6.91}] [33.0, 11.0] NaN 0.0 []   [{"t31": [10.77, 6.91]}] 10.77 6.91
84 84 carfin 17/06/2024 spen scottish 55.80366733657182 -3.959508107870995 primary carfin spen_scottish_primary_carfin [{"node_1": ["carft1", "carft2"], "voltage_node_1": 33.0, "node_2": ["carf5-", "carf5-"], "voltage_node_2": 11.0, "nom_rating": [21.0, 21.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 2.59, "max_transformer_flow": 10.37, "firm_capacity": 21.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 23.59, "local_dem_headroom": 10.63}] [33.0, 11.0] NaN 0.0 []   [{"t31": [23.59, 10.63]}] 23.59 10.63
85 85 lugton 17/06/2024 spen scottish 55.89621279940717 -3.0719636968829036 primary lugton spen_scottish_primary_lugton [{"node_1": ["lugtt1", "lugtt2"], "voltage_node_1": 33.0, "node_2": ["lugt5-", "lugt5-"], "voltage_node_2": 11.0, "nom_rating": [23.0, 23.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 3.94, "max_transformer_flow": 15.74, "firm_capacity": 23.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 26.94, "local_dem_headroom": 7.26}] [33.0, 11.0] NaN 0.0 []   [{"t31": [26.94, 7.26]}] 26.94 7.26
86 86 airbus 30/05/2024 spen southern 53.171888071871344 -2.9722361445561303 primary airbus spen_southern_primary_airbus [{"node_1": ["airbus"], "voltage_node_1": 33.0, "node_2": ["airbus"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.75, "max_transformer_flow": 7.01, "firm_capacity": 20.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 21.75, "local_dem_headroom": 12.99}] [33.0, 11.0] NaN 0.0 []   [{"t31": [21.6, 12.99]}] 21.6 12.99
87 87 huyton 30/05/2024 spen southern 53.423312380674524 -2.8604242807762144 bsp huyton spen_southern_bsp_huyton [{"node_1": ["huyt c1"], "voltage_node_1": 132.0, "node_2": ["huyt e1"], "voltage_node_2": 33.0, "nom_rating": [60.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 21.8, "max_transformer_flow": 87.2, "firm_capacity": 114.8, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 136.6, "local_dem_headroom": 27.599999999999994}] [33.0, 132.0] NaN 0.0 []   [{"t13": [136.6, 27.6]}] 136.6 27.6
88 88 bootle 30/05/2024 spen southern 53.45628909069473 -2.9857123060679074 primary bootle spen_southern_primary_bootle [{"node_1": ["bootle", "bootle"], "voltage_node_1": 33.0, "node_2": ["bootle t1", "bootle t2"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 3.82, "max_transformer_flow": 15.28, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 33.82, "local_dem_headroom": 14.72}] [33.0, 11.0] NaN 0.0 []   [{"t31": [20.12, -27.59]}] 20.12 -27.59
89 89 gordon 17/06/2024 spen scottish 55.684490137101506 -2.5564732560965586 primary gordon spen_scottish_primary_gordon [{"node_1": ["gordt1"], "voltage_node_1": 33.0, "node_2": ["gord5-"], "voltage_node_2": 11.0, "nom_rating": [5.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.46, "max_transformer_flow": 1.84, "firm_capacity": 5.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 5.46, "local_dem_headroom": 3.16}] [33.0, 11.0] NaN 0.0 []   [{"t31": [5.46, 3.16]}] 5.46 3.16
90 90 blacon 30/05/2024 spen southern 53.21064480257859 -2.9313054730561436 primary blacon spen_southern_primary_blacon [{"node_1": ["blacon"], "voltage_node_1": 33.0, "node_2": ["blacon"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 5.21, "max_transformer_flow": 20.85, "firm_capacity": 37.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 42.71, "local_dem_headroom": 16.65}] [33.0, 11.0] NaN 0.0 []   [{"t31": [-4860.66, -4462.78]}] -4860.66 -4462.78
91 91 gretna 17/06/2024 spen scottish 54.98983748676222 -3.0691754581599273 primary gretna spen_scottish_primary_gretna [{"node_1": ["grnat1", "grnat2"], "voltage_node_1": 33.0, "node_2": ["grna5-", "grna5-"], "voltage_node_2": 11.0, "nom_rating": [24.0, 24.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 2.14, "max_transformer_flow": 8.55, "firm_capacity": 24.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 26.14, "local_dem_headroom": 15.45}] [33.0, 11.0] NaN 0.0 []   [{"t31": [26.14, 15.45]}] 26.14 15.45
92 92 brymbo 30/05/2024 spen southern 53.07130958646131 -3.0597320906889105 bsp brymbo spen_southern_bsp_brymbo [{"node_1": ["brym c2", "brym c1"], "voltage_node_1": 132.0, "node_2": ["brym e2", "brym e1"], "voltage_node_2": 33.0, "nom_rating": [60.0, 60.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 29.9, "max_transformer_flow": 119.7, "firm_capacity": 154.7, "accepted_export": 46.421052631578945, "accepted_import": 11.052631578947368, "project_id": ["spen_project_810_subid_0", "spen_project_553_subid_0", "spen_project_809_subid_0", "spen_project_333"], "local_gen_headroom": 138.17894736842106, "local_dem_headroom": 23.947368421052616}] [33.0, 132.0] NaN 0.0 []   [{"t13": [138.18, 23.95]}] 138.18 23.95
93 93 weston 30/05/2024 spen southern 53.073215388453725 -2.3962125041495863 primary weston spen_southern_primary_weston [{"node_1": ["weston"], "voltage_node_1": 33.0, "node_2": ["weston"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 1.75, "max_transformer_flow": 6.99, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 11.75, "local_dem_headroom": 3.01}] [33.0, 11.0] NaN 0.0 []   [{"t31": [11.75, 3.01]}] 11.75 3.01
94 94 bootle 30/05/2024 spen southern 53.45660294980903 -2.9858214800409484 bsp bootle spen_southern_bsp_bootle [{"node_1": ["boot c1", "boot c2"], "voltage_node_1": 132.0, "node_2": ["boot e1", "boot e2"], "voltage_node_2": 33.0, "nom_rating": [60.0, 60.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 11.4, "max_transformer_flow": 45.6, "firm_capacity": 68.6, "accepted_export": 21.05263157894737, "accepted_import": 8.421052631578947, "project_id": ["spen_project_410_subid_0"], "local_gen_headroom": 58.94736842105263, "local_dem_headroom": 14.578947368421046}] [33.0, 132.0] NaN 0.0 []   [{"t13": [44.39, -518.41]}] 44.39 -518.41
95 95 whitby main 30/05/2024 spen southern 53.27343861796266 -2.909368507896691 primary whitby spen_southern_primary_whitby [{"node_1": ["whitby main", "whitby main"], "voltage_node_1": 33.0, "node_2": ["whitby main t2", "whitby main t1"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 4.56, "max_transformer_flow": 18.22, "firm_capacity": 25.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 30.06, "local_dem_headroom": 7.280000000000001}] [33.0, 11.0] NaN 0.0 []   [{"t31": [21.6, 2.28]}] 21.6 2.28
96 96 legacy 30/05/2024 spen southern 53.02400862110089 -3.058297368343994 bsp legacy spen_southern_bsp_legacy [{"node_1": ["lega c7", "lega c6"], "voltage_node_1": 132.0, "node_2": ["lega e1", "lega e2"], "voltage_node_2": 33.0, "nom_rating": [60.0, 45.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 29.9, "max_transformer_flow": 119.7, "firm_capacity": 154.7, "accepted_export": 59.47368421052632, "accepted_import": 10.526315789473685, "project_id": ["spen_project_168_subid_0", "spen_project_810_subid_1", "spen_project_553_subid_1", "spen_project_809_subid_1", "spen_project_155_subid_0"], "local_gen_headroom": 125.12631578947367, "local_dem_headroom": 24.4736842105263}] [33.0, 132.0] NaN 0.0 []   [{"t13": [125.13, 24.47]}] 125.13 24.47
97 97 bibbys 30/05/2024 spen southern 53.44219502579466 -3.0014751567364266 primary bibbys spen_southern_primary_bibbys [{"node_1": ["bibbys"], "voltage_node_1": 33.0, "node_2": ["bibbys"], "voltage_node_2": 6.3, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 2.91, "max_transformer_flow": 11.64, "firm_capacity": 17.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 20.41, "local_dem_headroom": 5.859999999999999}] [33.0, 6.3] NaN 0.0 []   [{"t36": [18.88, -925.73]}] 18.88 -925.73
98 98 dallam 30/05/2024 spen southern 53.41171287465039 -2.6008934513587687 bsp dallam spen_southern_bsp_dallam [{"node_1": ["dala c1"], "voltage_node_1": 132.0, "node_2": ["dala e5"], "voltage_node_2": 33.0, "nom_rating": [60.0], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 15.0, "max_transformer_flow": 59.8, "firm_capacity": 75.4, "accepted_export": 4.265263157894736, "accepted_import": 0.0, "project_id": ["spen_project_454_subid_0"], "local_gen_headroom": 86.13473684210527, "local_dem_headroom": 15.600000000000009}] [33.0, 132.0] NaN 0.0 []   [{"t13": [86.13, 15.6]}] 86.13 15.6
99 99 lauder 17/06/2024 spen scottish 55.71849117687025 -2.7634160394901897 primary lauder spen_scottish_primary_lauder [{"node_1": ["laudt1"], "voltage_node_1": 33.0, "node_2": ["laud5-"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 0.66, "max_transformer_flow": 2.63, "firm_capacity": 7.5, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 8.16, "local_dem_headroom": 4.87}] [33.0, 11.0] NaN 0.0 []   [{"t31": [8.16, 4.87]}] 8.16 4.87
100 100 chapel 17/06/2024 spen scottish 56.135240259327894 -3.1857627335596 primary chapel spen_scottish_primary_chapel [{"node_1": ["chelt1", "chelt2"], "voltage_node_1": 33.0, "node_2": ["chel5-", "chel5-"], "voltage_node_2": 11.0, "nom_rating": [10.0, 10.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 1.64, "max_transformer_flow": 6.57, "firm_capacity": 10.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 11.64, "local_dem_headroom": 3.4299999999999997}] [33.0, 11.0] NaN 0.0 []   [{"t31": [11.64, 3.43]}] 11.64 3.43

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "distribution_substations" (
"name" TEXT,
  "date_published" TEXT,
  "source" TEXT,
  "licence" TEXT,
  "latitude" REAL,
  "longitude" REAL,
  "type" TEXT,
  "location" TEXT,
  "substation_id" TEXT,
  "transformers" TEXT,
  "all_voltage" TEXT,
  "source_id" TEXT,
  "connected_export" REAL,
  "other_substation_ids" TEXT,
  "comments" TEXT,
  "detailed_global_headroom" TEXT,
  "global_gen_headroom" REAL,
  "global_dem_headroom" REAL
);