distribution_substations: 35

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
35 moss nook bsp 0 enw 
[
    "6dce090d-8d94-444e-8251-79ad0561c9e9"
]
 
[
    11.0,
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "mosnok_132_gt3",
            "mosnok_132_gt2",
            "mosnok_132_gt1"
        ],
        "node_id_1": [
            "e1db3b5f-b194-47cc-87c9-9dce14d8343a",
            "227f9c20-952f-4d6d-8ee0-3a12da6b7fb7",
            "6df425a3-e028-47d4-bf38-3541e02c0b4c"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "mosnok_33_gt3",
            "mosnok_33_gt2",
            "mosnok_33_gt1"
        ],
        "node_id_2": [
            "0a084627-1ae0-44b6-bb7a-09db30c92a84",
            "ff1e7bd6-3237-4f03-8fcb-06af59103f17",
            "e8b8cb43-3820-424f-8ea1-182a08a6a9fe"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            75.0,
            75.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 1.25,
        "accepted_import": 1.25,
        "project_id": [
            "enw__ecr_project_363",
            "enw__ecr_project_518"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 113.61114335737093,
        "firm_capacity": 178.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 176.75,
        "local_dem_headroom": 63.138856642629065
    },
    {
        "node_1": [
            "mosnok_132_gt1a"
        ],
        "node_id_1": [
            "746f2e04-2cd9-47fc-92b2-5f123d346414"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "mosnok_11_gt1a"
        ],
        "node_id_2": [
            "38283367-c032-4bc9-a4ba-c0168c3b849e"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            37.5
        ],
        "eme_rating": [],
        "transformer_count": 1,
        "accepted_export": 1.25,
        "accepted_import": 1.25,
        "project_id": [
            "enw__ecr_project_429",
            "enw__ecr_project_363",
            "enw__ecr_project_518"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 113.61114335737093,
        "firm_capacity": 178.0,
        "spare": [
            false
        ],
        "local_gen_headroom": 176.75,
        "local_dem_headroom": 63.138856642629065
    }
]
 enw_bsp_moss_nook 53.36201 -2.2408 100005 0 0 enw_gsp_south_manchester 100091 
[]
 353.5 126.27771328525813