distribution_substations: 48

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
48 sandgate bsp 0 enw 
[
    "926bba6e-65fc-411a-868e-499f01b002f9"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "barrow_132_gt1",
            "barrow_132_gt2",
            "sandga_132_gt2"
        ],
        "node_id_1": [
            "5f66a4aa-653c-4ee3-8bbd-cabdb6a3b475",
            "576e6e6a-0d42-47d0-a6e0-a7cb871de997",
            "71e7255b-ce97-4677-a033-1389554b9a28"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "barrow_33_gt1",
            "barrow_33_gt2",
            "sandga_33_gt2"
        ],
        "node_id_2": [
            "5d3651b7-8624-4649-8c4b-baaa94a2df2d",
            "f5940b56-1491-457b-b774-66fc1d2cb1a2",
            "5796ccab-ec44-4c6c-925d-e61e3e41579f"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0,
            75.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 38.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_207"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 60.71551000728844,
        "firm_capacity": 126.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 88.0,
        "local_dem_headroom": 65.28448999271157
    }
]
 enw_bsp_sandgate 54.12391 -3.23018 609001 0 0 enw_gsp_harker_hutton 609600 
[]
 88.0 65.28448999271157