distribution_substations: 8

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
8 blackburn bsp 0 enw 
[
    "ccaff536-eba3-4316-bdd4-066d1e83e16e"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "blackb_132_gt2blackb_33_gt2from_icn",
            "blackb_132_gt1blackb_33_gt1from_icn"
        ],
        "node_id_1": [
            "aec8f7a1-47f9-4e54-adcf-f5662203f1bc",
            "ae309dab-f161-4d58-a17d-2e26eea097cf"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "blackb_33_gt2",
            "blackb_33_gt1"
        ],
        "node_id_2": [
            "72914741-e368-4ad2-8da7-65bb84c53165",
            "a9e1a790-d2a4-43dc-9808-88eb7cd8f1e5"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 64.83157894736843,
        "accepted_import": 49.2,
        "project_id": [
            "enw__ecr_project_415",
            "enw__ecr_project_141",
            "enw__ecr_project_155",
            "enw__ecr_project_258"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 52.181505761348674,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 52.16842105263157,
        "local_dem_headroom": 15.618494238651323
    }
]
 enw_bsp_blackburn 53.7592 -2.44764 400001 0 0 0 0 
[]
 52.16842105263157 15.618494238651323