distribution_substations: 70

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
70 ardwick primary 0 enw 
[
    "bdc84ded-daa7-4351-86b8-7bc2af26c5d9"
]
 
[
    6.6,
    33.0
]
 
[
    {
        "node_1": [
            "ardwic_33_t12",
            "ardwic_33_t11"
        ],
        "node_id_1": [
            "cd855d0e-6fdd-4408-950f-50fdef4f8b23",
            "25fad8fd-51b6-4574-b983-53c74f3ac04d"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ardwic_33_t12ardwic_6.6_bto_icn",
            "ardwic_33_t11ardwic_6.6_ato_icn"
        ],
        "node_id_2": [
            "3d134200-8949-4fa1-bd82-60d156dfced9",
            "65246fd1-b3e9-4961-bbc3-f2ddf8a63801"
        ],
        "voltage_node_2": 6.6,
        "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": 14.989548881372727,
        "firm_capacity": 16.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 16.0,
        "local_dem_headroom": 1.010451118627273
    }
]
 enw_primary_ardwick 53.47324 -2.23127 100101 0 0 0 0 
[]
 16.0 1.010451118627273