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