distribution_substations: 19
This data as json
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |