distribution_substations: 97

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
97 blackpool primary 0 enw 
[
    "d9fa6c43-c518-40b6-b807-00b1c69c473b"
]
 
[
    6.6,
    33.0
]
 
[
    {
        "node_1": [
            "blackp_33_bblackp_6.6_bfrom_icn",
            "blackp_33_ablackp_6.6_afrom_icn"
        ],
        "node_id_1": [
            "ac8f568e-971a-4b31-acc4-4a6e54ed479b",
            "97c8cbb3-29a4-4f44-83ac-85a7b10a444a"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "blackp_33_bblackp_6.6_bto_icn",
            "blackp_33_ablackp_6.6_ato_icn"
        ],
        "node_id_2": [
            "c7bcecea-14e8-417b-b46f-ed0e61193798",
            "2f491f25-67b5-4be5-8d14-299ff74e8355"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            32.0,
            26.46
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 11.040925924903547,
        "firm_capacity": 23.75,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 23.75,
        "local_dem_headroom": 12.709074075096453
    }
]
 enw_primary_blackpool 53.80944 -3.05179 400113 enw_bsp_blackpool 400113 enw_gsp_penwortham_east_rochdale 400240 
[]
 23.75 12.709074075096453