distribution_substations: 25

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id bsp_group_id bsp_group_name gsp_group_id gsp_group_name other_substation_ids global_gen_headroom global_dem_headroom
25 hazel grove bsp 0 enw 
[
    "1415bf4b-9112-47a2-a3ef-7a91f6055884"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "hazelg_132_gt2",
            "hazelg_132_gt1"
        ],
        "node_id_1": [
            "76aa0505-88bb-4b27-b325-b53223b5611e",
            "68b09545-e5c1-4689-acf1-0e3dabd354df"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "hazelg_33_gt2",
            "hazelg_33_gt1"
        ],
        "node_id_2": [
            "3910b774-7716-419b-a692-d40aa4b6387f",
            "f240b280-b837-40a9-9435-d49139e3f711"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 30.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_452",
            "enw__ecr_project_345"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 64.2111138577469,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 87.0,
        "local_dem_headroom": 52.788886142253105
    }
]
 enw_bsp_hazel_grove 53.37854 -2.1319 303188 0 0 enw_gsp_bredbury 305953 
[]
 87.0 52.788886142253105