distribution_substations: 45

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
45 rossendale bsp 0 enw 
[
    "7f6ab1b2-af02-4ed6-a3d0-86703a978401"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "rossen_132_gt2",
            "rossen_132_gt1"
        ],
        "node_id_1": [
            "ddcb4925-0dd7-485f-86c5-d342ac18c179",
            "605de971-2238-4f65-822b-559328427095"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "rossen_33_gt2",
            "rossen_33_gt1"
        ],
        "node_id_2": [
            "c6ac8ce6-0818-4903-8327-632de8bee5b2",
            "5aeddbe5-537f-4970-b6f1-8bac7d3423a9"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 68.36842105263158,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_306",
            "enw__ecr_project_337",
            "enw__ecr_project_349",
            "enw__ecr_project_526",
            "enw__ecr_project_562"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 62.28977057859426,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 48.631578947368425,
        "local_dem_headroom": 54.71022942140574
    }
]
 enw_bsp_rossendale 53.69402 -2.30041 400094 0 0 0 0 
[]
 48.631578947368425 54.71022942140574