distribution_substations: 100

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
100 bolton le sands primary 0 enw 
[
    "7efef9aa-96c5-4639-b3a7-0b1ea72bc6c4"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "node_1": [
            "bolesa_33_bbolesa_11_bfrom_icn",
            "bolesa_33_abolesa_11_afrom_icn"
        ],
        "node_id_1": [
            "cb79e3ca-812a-4b03-a757-89e1ae13768c",
            "9603aa21-9c28-47cd-8327-53c1efae8e43"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "bolesa_33_bbolesa_11_bto_icn",
            "bolesa_33_abolesa_11_ato_icn"
        ],
        "node_id_2": [
            "85328c44-0afb-4b46-bd8e-b846e5ea1148",
            "3dabf162-f538-48e7-a40d-3c6aa99320d2"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            17.5,
            17.5
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 10.476888547811116,
        "firm_capacity": 17.5,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 17.5,
        "local_dem_headroom": 7.023111452188884
    }
]
 enw_primary_bolton_le_sands 53.59102 -2.42059 200114 enw_bsp_bolton 200111 enw_gsp_kearsley 200220 
[]
 17.5 7.023111452188884