distribution_substations: 94

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
94 blackburn primary 0 enw 
[
    "ccaff536-eba3-4316-bdd4-066d1e83e16e"
]
 
[
    6.6,
    33.0
]
 
[
    {
        "node_1": [
            "blackb_33_ablackb_6.6_afrom_icn",
            "samlzo_33_te2"
        ],
        "node_id_1": [
            "169641ef-4644-452b-af1f-cfd00ee5708c",
            "4d358162-e130-4df1-899b-31392de81462"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "blackb_33_ablackb_6.6_ato_icn",
            "samlzo_33_te2blackb_6.6_bto_icn"
        ],
        "node_id_2": [
            "90cb7897-5231-4dfd-a873-eea49350e329",
            "052e58f6-7506-4e48-94da-b57e95c4dbff"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            32.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 20.525160324014774,
        "firm_capacity": 42.183,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 42.183,
        "local_dem_headroom": 21.657839675985226
    }
]
 enw_primary_blackburn 53.7592 -2.44764 400001 enw_bsp_blackburn 400001 0 0 
[]
 42.183 21.657839675985226