distribution_substations: 55

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
55 thornton bsp 0 enw 
[
    "4d8adac7-e7a5-4d0f-a6ee-71968dca9e39"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "thornt_132_gt1",
            "thornt_132_gt2"
        ],
        "node_id_1": [
            "7d20e353-10a7-4f0a-ae73-ca0188fee7a1",
            "2033a27b-246c-4202-a9e1-8c2dd18d94d4"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "thornt_33_gt1",
            "thornt_33_gt2"
        ],
        "node_id_2": [
            "a377bc2b-fd34-4cca-acb9-de53ada987f2",
            "eeede2d9-329a-4bbe-85d9-d4b366618d8c"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            75.0,
            75.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 24.682000000000002,
        "accepted_import": 5.0,
        "project_id": [
            "enw__ecr_project_509",
            "enw__ecr_project_377",
            "enw__ecr_project_150"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 47.48527684962197,
        "firm_capacity": 75.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 50.318,
        "local_dem_headroom": 22.514723150378032
    }
]
 enw_bsp_thornton 53.8709 -3.00229 0 0 0 enw_gsp_penwortham_east_rochdale 400240 
[]
 50.318 22.514723150378032