distribution_substations: 69

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
69 ansdell primary 0 enw 
[
    "63bc21aa-3fd7-4806-a4cc-f71f1f834c29"
]
 
[
    6.6,
    33.0
]
 
[
    {
        "node_1": [
            "ansdel_33_aansdel_6.6_afrom_icn",
            "ansdel_33_bansdel_6.6_bfrom_icn"
        ],
        "node_id_1": [
            "46fd2d42-4d30-4b66-9bcf-8e79d1efca23",
            "533aaa11-c9b4-4770-a82a-5ce278a63829"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ansdel_33_aansdel_6.6_ato_icn",
            "ansdel_33_bansdel_6.6_bto_icn"
        ],
        "node_id_2": [
            "6688a481-bd57-429f-ac65-e82911b40f13",
            "3bbeb145-75dd-440c-a9b3-9fc44c215f6b"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 8.055048110156784,
        "firm_capacity": 16.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 16.0,
        "local_dem_headroom": 7.944951889843216
    }
]
 enw_primary_ansdell 53.7465 -2.99588 400101 enw_bsp_lytham 400107 enw_gsp_penwortham_east_rochdale 400240 
[]
 16.0 7.944951889843216