distribution_substations: 52

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
52 stainburn bsp 0 enw 
[
    "d6ce8d2c-531b-4af6-8eb7-20ea7c88c440"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "siddic_132_gt1",
            "stainb_132_gt1",
            "stainb_132_gt2"
        ],
        "node_id_1": [
            "609c8539-af5a-4675-9605-c2c1d75a01d9",
            "0d87e5bf-0ba6-4977-b6f4-6b34d4157993",
            "5a4408e8-e7cf-4166-bd73-d3a990a45ac8"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "siddic_33_gt1",
            "stainb_33_gt1",
            "stainb_33_gt2"
        ],
        "node_id_2": [
            "d4961ee9-8eeb-4189-9e9a-1bf7c76efd43",
            "9edbb027-c03c-4e47-945b-202f1a32e842",
            "9249ed2a-13c6-46be-a097-3bb7bf551d51"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 19.775,
        "accepted_import": 7.26,
        "project_id": [
            "enw__ecr_project_495",
            "enw__ecr_project_335",
            "enw__ecr_project_379"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 97.39743751941866,
        "firm_capacity": 131.9,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 112.125,
        "local_dem_headroom": 27.24256248058135
    }
]
 enw_bsp_stainburn 54.64948 -3.51144 609311 0 0 enw_gsp_harker_hutton 609600 
[]
 112.125 27.24256248058135