distribution_substations: 86

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
86 barrow devonshire rd primary 0 enw 
[
    "8e608534-ede1-4562-a08b-effa241561c5"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "node_1": [
            "barrow_33_bbarrow_11_bfrom_icn",
            "barrow_33_abarrow_11_afrom_icn"
        ],
        "node_id_1": [
            "64488b9d-177a-43c2-b295-1751e0d44727",
            "32232cd9-ee2b-4fbd-85fa-1457165c4f3c"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "barrow_33_bbarrow_11_bto_icn",
            "barrow_33_abarrow_11_ato_icn"
        ],
        "node_id_2": [
            "077a9c4d-bf37-4eba-af47-6ab96d4b3a56",
            "059b827f-80a0-448f-b513-aa654b660b8d"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 12.5,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_530"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 9.35412810545146,
        "firm_capacity": 23.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 10.5,
        "local_dem_headroom": 13.64587189454854
    }
]
 enw_primary_barrow_devonshire_rd 54.12391 -3.23018 609001 enw_bsp_sandgate 609001 enw_gsp_harker_hutton 609600 
[]
 10.5 13.64587189454854