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