distribution_substations: 75
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |