distribution_substations: 66

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
66 ancoats north primary 0 enw 
[
    "ecc5fa8f-0f8f-4b0d-a89e-c6078a37d720"
]
 
[
    6.6,
    33.0
]
 
[
    {
        "node_1": [
            "ancnor_33_bancnor_6.6_bfrom_icn",
            "ancnor_33_t11",
            "ancnor_33_t14"
        ],
        "node_id_1": [
            "b3b55c53-f3e8-4101-a694-70b5ab91618b",
            "46f75f59-59a9-470c-8cb9-60f4cec46b7d",
            "0987f7d5-b9eb-4ad0-b416-299033d4d1af"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ancnor_33_bancnor_6.6_bto_icn",
            "ancnor_33_aancnor_6.6_ato_icn",
            "ancnor_33_t14ancnor_6.6_cto_icn"
        ],
        "node_id_2": [
            "5caa8ce7-b457-4e36-a8c5-04bd686432ea",
            "5b1b4020-0e16-4d30-a95f-db21927c7dbd",
            "c95f1135-8e5d-4332-a6c2-5d1ef0d25813"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 25.941353167236546,
        "firm_capacity": 36.113,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 36.113,
        "local_dem_headroom": 10.171646832763454
    }
]
 enw_primary_ancoats_north 53.48608 -2.2274 100601 enw_bsp_red_bank 100503 0 0 
[]
 36.113 10.171646832763454