distribution_substations: 36

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
36 new mills bsp 0 enw 
[
    "9c9edc39-43ee-47be-8a0d-7975d12be6d3"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "newmil_132_gt1",
            "newmil_132_gt2"
        ],
        "node_id_1": [
            "5ccd16d6-e260-49bc-ac78-c98751c0cfe6",
            "e18e45d1-0333-451d-987c-2690a042316b"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "newmil_33_gt1",
            "newmil_33_gt2"
        ],
        "node_id_2": [
            "c47d1c8a-7974-4598-b5d6-336adb6c4e85",
            "95e52698-c0be-425a-8490-75e6cbfcd297"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            58.5,
            58.5
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 39.0,
        "accepted_import": 39.0,
        "project_id": [
            "enw__ecr_project_374",
            "enw__ecr_project_65"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 20.771983088219564,
        "firm_capacity": 58.5,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 19.5,
        "local_dem_headroom": -1.2719830882195637
    }
]
 enw_bsp_new_mills 53.35237 -1.9844 301672 0 0 0 0 
[]
 19.5 -1.2719830882195637