home / master_data / distribution_substations

distribution_substations

4,615 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, licence, source, voltages, gsp_group_id, gsp_group_name, other_substation_ids, substation_ids (array), other_substation_ids (array)

Link 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
1 1 adswood bsp 0 enw
[
    "feeb617c-4441-41fe-abf1-f53563bbe4c9"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "adswod_132_gt2",
            "adswod_132_gt1"
        ],
        "node_id_1": [
            "2a7c0d30-6c8b-4531-af38-749e55f72d36",
            "751dc58c-dca1-46d1-9663-cf08931121bf"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "adswod_33_gt2",
            "adswod_33_gt1"
        ],
        "node_id_2": [
            "c1910b97-66bd-40fe-b36f-667eb53fe449",
            "66510755-3798-4730-88dc-1371eab97dcf"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 51.97050660780038,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 117.0,
        "local_dem_headroom": 65.02949339219961
    }
]
enw_bsp_adswood 53.39156 -2.16403 301290 0 0 enw_gsp_bredbury 305953
[]
117.0 65.02949339219961
2 2 agecroft bsp 0 enw
[
    "1c027c12-0b68-4751-836a-b13d48ec7f52"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "agecro_132_gt2",
            "agecro_132_gt1"
        ],
        "node_id_1": [
            "8ddd2989-d169-4096-8ea6-9304f027ae4b",
            "d74678fc-8944-4314-89c7-94aab6bd80c4"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "agecro_33_gt2",
            "agecro_33_gt1"
        ],
        "node_id_2": [
            "e9f41ee2-9c87-4163-a6c0-e250950471e4",
            "53a6ddbb-1f7a-49d5-9b94-67baa9bd8a8a"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            75.0,
            78.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 8.5,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_396",
            "enw__ecr_project_168"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 59.992811207623426,
        "firm_capacity": 78.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 69.5,
        "local_dem_headroom": 18.007188792376574
    }
]
enw_bsp_agecroft 53.51279 -2.29754 100506 0 0 enw_gsp_kearsley 200220
[]
69.5 18.007188792376574
3 3 altrincham bsp 0 enw
[
    "eeacadc3-9582-4192-8472-0a27bba26c83"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "altrin_132_gt2",
            "altrin_132_gt1"
        ],
        "node_id_1": [
            "c5455a0e-8e44-4292-b9de-b672c210ae0a",
            "3e90ea19-5c12-4698-92bf-db4e62c60cd9"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "altrin_33_gt2",
            "altrin_33_gt1"
        ],
        "node_id_2": [
            "e8569b04-bf43-4ea2-9694-8de4d765ec2d",
            "27ee63e5-979a-4887-aa58-8482d6992fa5"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 55.47384709488014,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 117.0,
        "local_dem_headroom": 61.52615290511986
    }
]
enw_bsp_altrincham 53.39778 -2.35667 100001 0 0 0 100092
[]
117.0 61.52615290511986
4 4 atherton bsp 0 enw
[
    "23970efd-da72-48f7-859a-0a8c742af0f7"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "athert_132_gt1",
            "athert_132_gt2"
        ],
        "node_id_1": [
            "892c1a4b-49bf-4ea6-8a11-5b59544f67d2",
            "f843fd8d-4a5a-4376-9e90-87b8628f1220"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "athert_33_gt1",
            "athert_33_gt2"
        ],
        "node_id_2": [
            "0441ee9d-8fc0-444d-9eff-343265780848",
            "50565f6b-2935-44d7-90bf-82fba763095c"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_318"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 80.10416455576268,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 117.0,
        "local_dem_headroom": 36.89583544423732
    }
]
enw_bsp_atherton 53.51405 -2.51233 205317 0 0 enw_gsp_kearsley 200220
[]
117.0 36.89583544423732
5 5 barton bsp 0 enw
[
    "6b2cff5f-a126-44f6-8478-f2d63883b8aa"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "barton_132_gt1",
            "barton_132_gt2",
            "barton_132_gt3"
        ],
        "node_id_1": [
            "a26eae10-bdf2-452e-935e-1bab94888f65",
            "f336ecf1-a945-457e-a3a5-15d24599ff2e",
            "0e18b75b-d755-4fef-ae29-47b66ec2a86d"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "barton_33_gt1",
            "barton_33_gt2",
            "barton_33_gt3"
        ],
        "node_id_2": [
            "f24f26bf-3e67-453e-9800-b7e75e63a103",
            "fed2844f-7173-47ef-8e62-a7a22a855702",
            "0ae4c55f-432c-4fdb-b0ba-1b4bf5fa9a60"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            60.0,
            78.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 8.0,
        "accepted_import": 8.0,
        "project_id": [
            "enw__ecr_project_553"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 75.00260039159166,
        "firm_capacity": 150.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 142.0,
        "local_dem_headroom": 66.99739960840834
    }
]
enw_bsp_barton 53.47087 -2.35076 100501 0 0 0 100092
[]
142.0 66.99739960840834
6 6 belfield bsp 0 enw
[
    "ce6421a5-de26-4078-8b6d-efe028c276e4"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "belfie_132_gt1",
            "belfie_132_gt2"
        ],
        "node_id_1": [
            "44fc8322-7486-4d01-a32c-0e9af2a0c9ec",
            "71ac7a77-9eb6-4838-8b65-a30bd1dced63"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "belfie_33_gt1",
            "belfie_33_gt2"
        ],
        "node_id_2": [
            "cee9474e-817d-4240-a0bd-af28576a9686",
            "c41a5b2e-f2cc-40b1-bcce-855909dfe2a3"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 31.0,
        "accepted_import": 30.0,
        "project_id": [
            "enw__ecr_project_435",
            "enw__ecr_project_147"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 43.76247580300212,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 86.0,
        "local_dem_headroom": 43.23752419699788
    }
]
enw_bsp_belfield 53.62216 -2.13727 304899 0 0 0 0
[]
86.0 43.23752419699788
7 7 bispham bsp 0 enw
[
    "ec0e01ec-4a16-4d81-b6c9-6108d7764151"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "bispha_132_gt2",
            "bispha_132_gt1"
        ],
        "node_id_1": [
            "570c7913-9e91-42ef-9e4c-b7df91abd66e",
            "8170e8be-e7d5-4cde-8932-24221bd5a143"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "bispha_33_gt2",
            "bispha_33_gt1"
        ],
        "node_id_2": [
            "e3ac3289-e6bf-42f0-9e2e-ecd060a551ac",
            "48b92204-ebe8-4289-b983-904b79b1801c"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 7.587,
        "accepted_import": 7.587,
        "project_id": [
            "enw__ecr_project_324"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 63.61280297290262,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 109.413,
        "local_dem_headroom": 45.80019702709738
    }
]
enw_bsp_bispham 53.84897 -3.04054 400102 0 0 enw_gsp_penwortham_east_rochdale 400240
[]
109.413 45.80019702709738
8 8 blackburn bsp 0 enw
[
    "ccaff536-eba3-4316-bdd4-066d1e83e16e"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "blackb_132_gt2blackb_33_gt2from_icn",
            "blackb_132_gt1blackb_33_gt1from_icn"
        ],
        "node_id_1": [
            "aec8f7a1-47f9-4e54-adcf-f5662203f1bc",
            "ae309dab-f161-4d58-a17d-2e26eea097cf"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "blackb_33_gt2",
            "blackb_33_gt1"
        ],
        "node_id_2": [
            "72914741-e368-4ad2-8da7-65bb84c53165",
            "a9e1a790-d2a4-43dc-9808-88eb7cd8f1e5"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 64.83157894736843,
        "accepted_import": 49.2,
        "project_id": [
            "enw__ecr_project_415",
            "enw__ecr_project_141",
            "enw__ecr_project_155",
            "enw__ecr_project_258"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 52.181505761348674,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 52.16842105263157,
        "local_dem_headroom": 15.618494238651323
    }
]
enw_bsp_blackburn 53.7592 -2.44764 400001 0 0 0 0
[]
52.16842105263157 15.618494238651323
9 9 blackpool bsp 0 enw
[
    "d9fa6c43-c518-40b6-b807-00b1c69c473b"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "blackp_132_gt1",
            "blackp_132_gt2"
        ],
        "node_id_1": [
            "28e36806-f0ee-4941-8bb1-80b8d2cd5868",
            "421c5366-3611-41ec-a88f-52b78632b564"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "blackp_33_gt1",
            "blackp_33_gt2"
        ],
        "node_id_2": [
            "55daceed-8ec2-4e7e-b673-c2ee1ec5542a",
            "5feaff9b-f366-4577-9829-d85590573c58"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 67.49934345196115,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 117.0,
        "local_dem_headroom": 49.50065654803885
    }
]
enw_bsp_blackpool 53.80944 -3.05179 400113 0 0 enw_gsp_penwortham_east_rochdale 400240
[]
117.0 49.50065654803885
10 10 bloom street bsp 0 enw
[
    "239fc344-25a0-4da1-a70c-4ae3e135c2b5"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "bloost_132_gt1",
            "bloost_132_gt2"
        ],
        "node_id_1": [
            "056a3f27-493d-498d-8077-8fd786912824",
            "17433942-7e59-41ac-91a7-86d78bb0437c"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "bloost_33_gt1",
            "bloost_33_gt2"
        ],
        "node_id_2": [
            "eace72dc-d43e-4886-959a-603be6648ff6",
            "6e6d8cbe-ee87-4680-a237-18e797398afd"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 53.51080713956605,
        "firm_capacity": 93.2,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 93.2,
        "local_dem_headroom": 39.689192860433955
    }
]
enw_bsp_bloom_street 53.47593 -2.23943 100507 0 0 enw_gsp_bredbury 305953
[]
93.2 39.689192860433955
11 11 bolton bsp 0 enw
[
    "559d8135-7a7b-4aef-bf3f-69a26ebfbeff"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "bolton_132_gt1bolton_33_gt1from_icn",
            "bolton_132_gt3bolton_33_gt3from_icn",
            "bolton_132_gt4bolton_33_gt4from_icn"
        ],
        "node_id_1": [
            "5041c9ca-4fc7-4d55-947d-d6e005e90fd7",
            "708bab53-576f-4ef2-a67d-e74523fce7d9",
            "552fcdf8-3a1d-41c6-9251-a26f3fc9ae6b"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "bolton_33_gt1",
            "bolton_33_gt3",
            "bolton_33_gt4"
        ],
        "node_id_2": [
            "1f066130-f97d-46bf-86db-b7f5601942a3",
            "bfb5f62b-5532-4830-a19a-7c4b8017fea4",
            "098050e3-f4a9-4b80-ae0f-3f7f43f57ebc"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            75.0,
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 6.0,
        "accepted_import": 6.0,
        "project_id": [
            "enw__ecr_project_315"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 101.87117273350606,
        "firm_capacity": 124.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 118.0,
        "local_dem_headroom": 16.128827266493943
    }
]
enw_bsp_bolton 53.59102 -2.42059 200111 0 0 enw_gsp_kearsley 200220
[]
118.0 16.128827266493943
12 12 burnley bsp 0 enw
[
    "79eb0d12-2662-4431-9051-21bc2f02ebb5"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "burnle_132_gt2",
            "burnle_132_gt1"
        ],
        "node_id_1": [
            "e649ce7d-359c-46b7-95f2-ddcc2c0342f1",
            "82ca6b5b-342d-4605-bf42-4edd74248c83"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "burnle_33_gt2",
            "burnle_33_gt1"
        ],
        "node_id_2": [
            "ad180707-06df-4fa7-9c3c-a39c157548bb",
            "7ea149a0-b99d-4727-8d73-d0a8e24abe06"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 77.89473684210526,
        "accepted_import": 20.0,
        "project_id": [
            "enw__ecr_project_76",
            "enw__ecr_project_206",
            "enw__ecr_project_331"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 45.37114965756178,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 39.10526315789474,
        "local_dem_headroom": 51.62885034243823
    }
]
enw_bsp_burnley 53.80624 -2.22125 401053 0 0 0 0
[]
39.10526315789474 51.62885034243823
13 13 bury bsp 0 enw
[
    "1adb6fd5-0438-40b1-b508-1b49cb11cafb"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "bury_132_gt1",
            "bury_132_gt2"
        ],
        "node_id_1": [
            "06796655-1c3a-4549-83f5-ab01792a7ba9",
            "c589e5ab-28ea-4d4a-9898-8d72581ccce7"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "bury_33_gt1",
            "bury_33_gt2"
        ],
        "node_id_2": [
            "7022a9da-3dbc-4cdc-ba97-640d1d1aa927",
            "50346e7d-8bdc-4a1e-945c-0f90e3c8058c"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 74.08735472688821,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 117.0,
        "local_dem_headroom": 42.91264527311179
    }
]
enw_bsp_bury 53.5967 -2.29975 200206 0 0 enw_gsp_kearsley 200220
[]
117.0 42.91264527311179
14 14 buxton bsp 0 enw
[
    "ea37d373-0ef0-49e7-9abc-5c10b624b986"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "buxton_132_gt2",
            "buxton_132_gt1"
        ],
        "node_id_1": [
            "eaf0e532-bf5d-4e2f-bcc5-3cbc218662ef",
            "f7c38b59-71c6-4c81-90d7-a518c5190b37"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "buxton_33_gt2",
            "buxton_33_gt1"
        ],
        "node_id_2": [
            "930649d1-879a-4c77-8408-32aaa39d2c65",
            "773953c0-1adc-43c2-8f07-5ecc3c5b935d"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            130.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 102.10526315789474,
        "accepted_import": 60.0,
        "project_id": [
            "enw__ecr_project_172",
            "enw__ecr_project_351",
            "enw__ecr_project_356",
            "enw__ecr_project_388",
            "enw__ecr_project_493"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 65.1115955442326,
        "firm_capacity": 103.5,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 1.3947368421052602,
        "local_dem_headroom": -21.6115955442326
    }
]
enw_bsp_buxton 53.27596 -1.885 303846 0 0 0 0
[]
1.3947368421052602 -21.6115955442326
15 15 carlisle bsp 0 enw
[
    "fb2410d4-9591-48d5-82f8-490942b0f19b"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "carlis_132_gt1",
            "carlis_132_gt2",
            "carlis_132_gt3"
        ],
        "node_id_1": [
            "a018c591-24de-42bb-8d13-8a34bf7a7e68",
            "acf72f55-4e43-46bd-b8cf-a62ee3255f5d",
            "38c8207e-2527-4810-8884-c0103c605508"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "carlis_33_gt1",
            "carlis_33_gt2",
            "carlis_33_gt3"
        ],
        "node_id_2": [
            "72458558-ba66-4ce8-8fd3-61cbf0ab2b00",
            "d6cf43fc-9e4f-4723-a03f-6feb9735656e",
            "9a20cda6-3082-474f-82c9-05f7b5f523cf"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            60.0,
            78.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 99.00526315789475,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_144",
            "enw__ecr_project_252",
            "enw__ecr_project_307",
            "enw__ecr_project_333"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 128.8930402981027,
        "firm_capacity": 174.5,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 75.49473684210525,
        "local_dem_headroom": 45.606959701897296
    }
]
enw_bsp_carlisle 54.8993 -2.9589 609609 0 0 enw_gsp_harker_hutton 609600
[]
75.49473684210525 45.606959701897296
16 16 carrington bsp 0 enw
[
    "01690bc3-44e8-4ff9-9730-a5bee0b8e8a7"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "carrin_132_gt1",
            "carrin_132_gt2"
        ],
        "node_id_1": [
            "348a4275-8a04-4170-9d18-e524e30d6bb3",
            "a486d794-41de-4592-8ed5-3a4a8507cc51"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "carrin_33_gt1",
            "carrin_33_gt2"
        ],
        "node_id_2": [
            "9d580e3e-23cc-4080-a90e-9baba598f167",
            "dc21856d-2664-4a2e-b50d-beceddc8cfe0"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            75.0,
            75.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 36.257321766349044,
        "firm_capacity": 69.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 69.0,
        "local_dem_headroom": 32.742678233650956
    }
]
enw_bsp_carrington 53.43349 -2.40648 100009 0 0 0 100092
[]
69.0 32.742678233650956
17 17 castleton bsp 0 enw
[
    "c9697d5b-c272-492d-81df-29db4c00bf94"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "castle_132_bcastle_33_gt2from_icn",
            "castle_132_acastle_33_gt1from_icn"
        ],
        "node_id_1": [
            "545dec48-6b96-408d-b4fa-a5cbc30c4f43",
            "333bd0d9-555d-4c0c-84e9-04310f88f8e5"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "castle_33_gt2",
            "castle_33_gt1"
        ],
        "node_id_2": [
            "4a99e915-8ab3-49a7-a6b4-dbd596ba3bd4",
            "52e8d8b1-65ad-425d-9a5a-fd97c78fd9a8"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 69.05263157894737,
        "accepted_import": 35.0,
        "project_id": [
            "enw__ecr_project_122",
            "enw__ecr_project_434",
            "enw__ecr_project_417",
            "enw__ecr_project_327",
            "enw__ecr_project_489"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 46.83476755168031,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 47.94736842105263,
        "local_dem_headroom": 35.1652324483197
    }
]
enw_bsp_castleton 53.59783 -2.17663 304881 0 0 0 0
[]
47.94736842105263 35.1652324483197
18 18 catterall waterworks bsp 0 enw
[
    "8f11e3ba-d0b7-458c-bf9c-e09c56e56b12"
]
[
    11.0,
    132.0
]
[
    {
        "node_1": [
            "132/11kv from_breaker at catter_132_gt2_icn",
            "132/11kv from_breaker at catter_132_gt1_icn"
        ],
        "node_id_1": [
            "80743bfe-8634-4a29-aa74-aa853a4bdf50",
            "52cc48b3-7453-46ee-889c-11bf397c6d13"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "catter_25_bcatter_132_gt2from_icn",
            "catter_25_acatter_132_gt1from_icn"
        ],
        "node_id_2": [
            "b445977d-d042-4189-acf9-225fc0a0ca68",
            "b0ac14c3-4d3a-4146-99ca-706a8f0b6cf7"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            18.0,
            18.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0,
        "max_transformer_flow": 0,
        "firm_capacity": 0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 36.0,
        "local_dem_headroom": 36.0
    }
]
enw_bsp_catterall_waterworks 53.87323 -2.77181 0 0 0 enw_gsp_penwortham_east_rochdale 400240
[]
36.0 36.0
19 19 chadderton bsp 0 enw
[
    "c4864c47-5900-4ba4-a034-d6b0ba6eb8cc"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "chadde_132_gt1",
            "chadde_132_gt2"
        ],
        "node_id_1": [
            "0b787cad-4fa6-478a-a555-b203946ec75d",
            "fd8eb3a5-9263-4bf7-b015-7594a63220a8"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "chadde_33_gt1",
            "chadde_33_gt2"
        ],
        "node_id_2": [
            "fc882464-3148-4959-b629-732adb81c34f",
            "5a073252-7719-4325-adcd-349e802ce7bb"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 16.35363157894737,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_320",
            "enw__ecr_project_378",
            "enw__ecr_project_425"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 82.06167073884706,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 100.64636842105263,
        "local_dem_headroom": 34.938329261152944
    }
]
enw_bsp_chadderton 53.53127 -2.16481 301101 0 0 0 0
[]
100.64636842105263 34.938329261152944
20 20 droylsden bsp 0 enw
[
    "a9efe2b8-380f-4926-84c3-490b5176e607"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "droyls_132_gt2",
            "droyls_132_gt1"
        ],
        "node_id_1": [
            "2ddfe8a6-846c-4ec6-b1b6-14ae212572ea",
            "16475591-e1af-46d3-a20e-05f355876694"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "droyls_33_gt2",
            "droyls_33_gt1"
        ],
        "node_id_2": [
            "87adc87a-776b-4981-bc54-eadb1c19df11",
            "a0fb2587-69de-4506-a465-9526565a4d08"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 1.456,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_336"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 65.69879889718855,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 115.544,
        "local_dem_headroom": 51.30120110281145
    }
]
enw_bsp_droylsden 53.4802 -2.14954 100003 0 0 0 0
[]
115.544 51.30120110281145
21 21 egremont bsp 0 enw
[
    "7ac63675-01e5-4d96-be6c-6a0b536910ec"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "egremo_132_gt2",
            "egremo_132_gt1"
        ],
        "node_id_1": [
            "c3cd2bb6-16c8-4e41-8f28-f4028dea5ec5",
            "004a4974-ae85-43fe-9294-f3e123a89677"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "egremo_33_gt2",
            "egremo_33_gt1"
        ],
        "node_id_2": [
            "c510ae11-4b7f-4fbe-a9ca-531d8b2a4ce6",
            "c63a972b-296c-45cd-9dea-378c59c54318"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 127.53157894736842,
        "accepted_import": 45.0,
        "project_id": [
            "enw__ecr_project_159",
            "enw__ecr_project_387",
            "enw__ecr_project_524",
            "enw__ecr_project_552"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 51.39327183998001,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": -10.531578947368416,
        "local_dem_headroom": 20.606728160019998
    }
]
enw_bsp_egremont 54.50354 -3.52919 609351 0 0 enw_gsp_harker_hutton 609600
[]
-10.531578947368416 20.606728160019998
22 22 frederick road bsp 0 enw
[
    "31f50da3-2b0c-42b0-85ec-9878c7491797"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "freder_132_gt3",
            "freder_132_gt1",
            "freder_132_gt2"
        ],
        "node_id_1": [
            "65fc2d71-3a53-4421-a2ce-a52dd3e5f71f",
            "a101c421-4e2a-426d-b05d-1459e777028f",
            "bc1a18ad-3bd7-4a1a-90bb-66cf313e6dc4"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "freder_33_gt3",
            "freder_33_gt1",
            "freder_33_gt2"
        ],
        "node_id_2": [
            "648f8fad-0141-4e3e-96a3-c7f6eeeed9fa",
            "ab78d64e-7191-41ce-b5a8-0efe0d689f46",
            "de313fd5-9be3-45c1-89a5-5c5c47f09da3"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0,
            78.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 113.27670311141894,
        "firm_capacity": 138.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 138.0,
        "local_dem_headroom": 24.72329688858106
    }
]
enw_bsp_frederick_road 53.49066 -2.27698 0 0 0 enw_gsp_kearsley 200220
[]
138.0 24.72329688858106
23 23 golborne bsp 0 enw
[
    "95b06cd0-7c27-444f-8695-e665ba31c70a"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "golbor_132_gt2",
            "golbor_132_gt1"
        ],
        "node_id_1": [
            "efa9a914-6241-462d-9723-4085d2f947dc",
            "83b2d0f1-54a8-4cca-8a94-9ef3ad6fd215"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "golbor_33_gt2",
            "golbor_33_gt1"
        ],
        "node_id_2": [
            "cec67d14-fb47-4816-9c1c-ee947e3c16d4",
            "96dc1c69-b95f-4bad-8c1c-49e5eaa609f3"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 20.922842105263157,
        "accepted_import": 3.0,
        "project_id": [
            "enw__ecr_project_253",
            "enw__ecr_project_81",
            "enw__ecr_project_268",
            "enw__ecr_project_163",
            "enw__ecr_project_220"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 68.21696739491503,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 96.07715789473684,
        "local_dem_headroom": 45.78303260508497
    }
]
enw_bsp_golborne 53.47498 -2.59493 205308 0 0 0 0
[]
96.07715789473684 45.78303260508497
24 24 greenhill bsp 0 enw
[
    "f64f0c87-a45a-4686-8ec0-fd919899856c"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "greenh_132_gt3",
            "greenh_132_gt2"
        ],
        "node_id_1": [
            "91961f8f-d2b4-42dd-9ed4-30e68d15b9dd",
            "801c4a98-a612-4469-984e-39e7f582092f"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "greenh_33_gt3",
            "greenh_33_gt2"
        ],
        "node_id_2": [
            "1dbf3aff-b8a0-4e1b-9508-28228cc9c5df",
            "940f10d4-80d0-4e5e-b9f1-727e539912c0"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 89.05263157894737,
        "accepted_import": 63.0,
        "project_id": [
            "enw__ecr_project_25",
            "enw__ecr_project_380",
            "enw__ecr_project_480",
            "enw__ecr_project_162",
            "enw__ecr_project_330",
            "enw__ecr_project_483"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 70.2141728856293,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 27.94736842105263,
        "local_dem_headroom": -16.214172885629296
    }
]
enw_bsp_greenhill 53.53936 -2.10308 300024 0 0 0 0
[]
27.94736842105263 -16.214172885629296
25 25 hazel grove bsp 0 enw
[
    "1415bf4b-9112-47a2-a3ef-7a91f6055884"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "hazelg_132_gt2",
            "hazelg_132_gt1"
        ],
        "node_id_1": [
            "76aa0505-88bb-4b27-b325-b53223b5611e",
            "68b09545-e5c1-4689-acf1-0e3dabd354df"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "hazelg_33_gt2",
            "hazelg_33_gt1"
        ],
        "node_id_2": [
            "3910b774-7716-419b-a692-d40aa4b6387f",
            "f240b280-b837-40a9-9435-d49139e3f711"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 30.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_452",
            "enw__ecr_project_345"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 64.2111138577469,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 87.0,
        "local_dem_headroom": 52.788886142253105
    }
]
enw_bsp_hazel_grove 53.37854 -2.1319 303188 0 0 enw_gsp_bredbury 305953
[]
87.0 52.788886142253105
26 26 heyrod bsp 0 enw
[
    "42d68d8a-5577-44b9-81b4-817a1d6f2365"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "heyrod_132_gt3",
            "heyrod_132_gt1",
            "heyrod_132_gt2"
        ],
        "node_id_1": [
            "90469c87-801f-40c1-b20e-1a8bf8d30ad2",
            "79e715ee-8c7d-4dc2-889c-e14286656f7f",
            "ce59d528-c693-4846-b079-bbba6a0f1df0"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "heyrod_33_gt3",
            "heyrod_33_gt1",
            "heyrod_33_gt2"
        ],
        "node_id_2": [
            "4c353417-9b20-44be-a37b-f083825f30a2",
            "1832aab6-509a-4aab-ad9b-35b980b46d49",
            "c93649b0-1ff5-43ae-bd98-fd474cde3a4d"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            75.0,
            75.0,
            75.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 28.15263157894737,
        "accepted_import": 4.6,
        "project_id": [
            "enw__ecr_project_151",
            "enw__ecr_project_251",
            "enw__ecr_project_231"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 82.24481854324732,
        "firm_capacity": 118.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 89.84736842105264,
        "local_dem_headroom": 31.15518145675268
    }
]
enw_bsp_heyrod 53.49638 -2.04169 304200 0 0 0 0
[]
89.84736842105264 31.15518145675268
27 27 huncoat bsp 0 enw
[
    "cdb5a1a4-a09a-4851-a1d1-34e54ae6ba79"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "huncoa_132_gt1",
            "huncoa_132_gt2"
        ],
        "node_id_1": [
            "6a0e2544-1488-4eba-896d-311a486983ce",
            "573f5be4-d3c4-41e0-969a-8b4288758ac6"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "huncoa_33_gt1",
            "huncoa_33_gt2"
        ],
        "node_id_2": [
            "e9cb2843-4480-4552-8c03-f32fee0cda16",
            "99a80b65-f5a5-4a7f-984b-12a0540034c4"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 32.05263157894737,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_139",
            "enw__ecr_project_484"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 60.154902699631805,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 84.94736842105263,
        "local_dem_headroom": 56.845097300368195
    }
]
enw_bsp_huncoat 53.77521 -2.33688 401010 0 0 0 0
[]
84.94736842105263 56.845097300368195
28 28 hyde bsp 0 enw
[
    "57979f42-c4af-409b-a011-3472e32dd0f0"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "hyde_132_gt2",
            "hyde_132_gt1"
        ],
        "node_id_1": [
            "68e11a3b-110d-4457-aeca-506b14113a7c",
            "056f753c-ba63-40e6-8bf3-ef3a382469ad"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "hyde_33_gt2",
            "hyde_33_gt1"
        ],
        "node_id_2": [
            "72f34479-baee-44d0-88da-0fb8ffab169a",
            "1f8c762f-7890-4d02-8254-700fe2786de2"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 52.69855503692512,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 117.0,
        "local_dem_headroom": 64.30144496307489
    }
]
enw_bsp_hyde 53.45264 -2.07376 0 0 0 0 0
[]
117.0 64.30144496307489
29 29 kendal bsp 0 enw
[
    "173653ae-2fb6-42dc-8293-a33b4ff9ed85"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "kendal_132_gt1",
            "kendal_132_gt2"
        ],
        "node_id_1": [
            "6a61ede2-b38c-43d5-a443-ea56e2dc5390",
            "ddebada9-0f2a-4254-a5d7-62c6424e4204"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "kendal_33_gt1",
            "kendal_33_gt2"
        ],
        "node_id_2": [
            "3c47fca6-9aac-47f9-8b29-9074dc5c97d4",
            "1aed9e6a-b67f-4fca-a038-ac4a32b71c63"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 84.85,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_148",
            "enw__ecr_project_209",
            "enw__ecr_project_210",
            "enw__ecr_project_523"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 89.54096598965967,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 32.150000000000006,
        "local_dem_headroom": 27.459034010340332
    }
]
enw_bsp_kendal 54.31969 -2.74168 609051 0 0 enw_gsp_harker_hutton 609600
[]
32.150000000000006 27.459034010340332
30 30 lancaster bsp 0 enw
[
    "6f7fdeb7-bebf-4292-aa56-b1d6fe3a596a"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "lancas_132_gt2",
            "lancas_132_gt3",
            "lancas_132_gt1"
        ],
        "node_id_1": [
            "4a2e4714-ca26-41a4-8713-dc5a69b701e4",
            "7f29d895-f8e3-427e-a77e-e6483fb27fa1",
            "572fd667-027f-48de-8889-996b8b8aa2b5"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "lancas_33_gt2",
            "lancas_33_gt3",
            "lancas_33_gt1"
        ],
        "node_id_2": [
            "922528c7-6f0c-4e69-a5d9-a451279dcb5b",
            "3be83b10-68a2-40e1-ac73-ef88ebf7a17f",
            "c7753005-1ecd-4b0a-8bf7-9dfa5289f63e"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 82.13,
        "accepted_import": 25.0,
        "project_id": [
            "enw__ecr_project_392",
            "enw__ecr_project_514",
            "enw__ecr_project_194",
            "enw__ecr_project_372",
            "enw__ecr_project_505",
            "enw__ecr_project_517"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 97.00813544179773,
        "firm_capacity": 135.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 52.870000000000005,
        "local_dem_headroom": 12.991864558202266
    }
]
enw_bsp_lancaster 54.06622 -2.78639 609904 0 0 enw_gsp_heysham 609900
[]
52.870000000000005 12.991864558202266
31 31 leyland bsp 0 enw
[
    "34db85e9-5219-4a8a-9678-e666538f676b"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "leylan_132_gt1",
            "leylan_132_gt2"
        ],
        "node_id_1": [
            "baf5e28d-5149-4a50-97e3-df2dc7eb442d",
            "0f52fd7e-3351-4f1a-958d-31bf97b14b87"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "leylan_33_gt1",
            "leylan_33_gt2"
        ],
        "node_id_2": [
            "4d472275-3a2f-438d-ae61-b4ae50377eeb",
            "42593eeb-5057-40a1-8591-e7b629ab3a29"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            116.1,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 11.8,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_301",
            "enw__ecr_project_211",
            "enw__ecr_project_29",
            "enw__ecr_project_545"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 82.09933426853928,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 105.2,
        "local_dem_headroom": 34.90066573146072
    }
]
enw_bsp_leyland 53.70478 -2.69663 401212 0 0 enw_gsp_penwortham_east_rochdale 400240
[]
105.2 34.90066573146072
32 32 longsight bsp 0 enw
[
    "c032b94e-7a5a-4a15-ac4e-a687617b2f81"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "longsi_132_gt2",
            "longsi_132_gt1"
        ],
        "node_id_1": [
            "84aa5ab2-c5a1-4278-9757-5b46d5908d05",
            "6dd01a67-8db5-4499-9b20-576424b7a777"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "longsi_33_gt2",
            "longsi_33_gt1"
        ],
        "node_id_2": [
            "2ebae950-0d20-44ef-a70e-6728642fc1c4",
            "32d16ca9-8a37-455a-a0e0-f7edee1a5228"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 6.72,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_142",
            "enw__ecr_project_52",
            "enw__ecr_project_361"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 76.17073599361304,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 110.28,
        "local_dem_headroom": 40.829264006386964
    }
]
enw_bsp_longsight 53.46086 -2.21901 100004 0 0 enw_gsp_bredbury 305953
[]
110.28 40.829264006386964
33 33 lower darwen bsp 0 enw
[
    "a063f39a-54cd-46f2-bff8-72ed7698ed51"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "lowdar_132_gt2lowdar_33_gt2from_icn",
            "lowdar_132_gt1lowdar_33_gt1from_icn"
        ],
        "node_id_1": [
            "8089826e-ba7e-48e7-9d97-06b52e3c635c",
            "893aab37-2291-4642-af03-08bede342b49"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "lowdar_33_gt2",
            "lowdar_33_gt1"
        ],
        "node_id_2": [
            "cfb0206c-3265-4b68-9c36-57a3033de3b4",
            "98afdd38-d108-441d-8491-3a91a185d0ff"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 67.33415250142019,
        "firm_capacity": 85.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 85.0,
        "local_dem_headroom": 17.665847498579808
    }
]
enw_bsp_lower_darwen 53.72038 -2.45999 400016 0 0 0 0
[]
85.0 17.665847498579808
34 34 lytham bsp 0 enw
[
    "40357030-8cdd-40f8-b2b1-dba983c68caa"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "lytham_132_gt1",
            "lytham_132_gt2"
        ],
        "node_id_1": [
            "1c34723c-035c-4e20-b48f-17b6889a7c19",
            "e7eba632-8847-4b5b-8e28-cafaaa971f93"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "lytham_33_gt1",
            "lytham_33_gt2"
        ],
        "node_id_2": [
            "6f34cc6b-6ab3-4fe3-ab42-92aeb3d3e7d2",
            "c156639f-d3f7-4233-bbc1-3398912a0bff"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            75.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 111.05263157894737,
        "accepted_import": 70.0,
        "project_id": [
            "enw__ecr_project_61",
            "enw__ecr_project_152",
            "enw__ecr_project_504",
            "enw__ecr_project_560"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 31.779882006432327,
        "firm_capacity": 78.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": -33.05263157894737,
        "local_dem_headroom": -23.77988200643233
    }
]
enw_bsp_lytham 53.75633 -2.98215 400107 0 0 enw_gsp_penwortham_east_rochdale 400240
[]
-33.05263157894737 -23.77988200643233
35 35 moss nook bsp 0 enw
[
    "6dce090d-8d94-444e-8251-79ad0561c9e9"
]
[
    11.0,
    33.0,
    132.0
]
[
    {
        "node_1": [
            "mosnok_132_gt3",
            "mosnok_132_gt2",
            "mosnok_132_gt1"
        ],
        "node_id_1": [
            "e1db3b5f-b194-47cc-87c9-9dce14d8343a",
            "227f9c20-952f-4d6d-8ee0-3a12da6b7fb7",
            "6df425a3-e028-47d4-bf38-3541e02c0b4c"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "mosnok_33_gt3",
            "mosnok_33_gt2",
            "mosnok_33_gt1"
        ],
        "node_id_2": [
            "0a084627-1ae0-44b6-bb7a-09db30c92a84",
            "ff1e7bd6-3237-4f03-8fcb-06af59103f17",
            "e8b8cb43-3820-424f-8ea1-182a08a6a9fe"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            75.0,
            75.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 1.25,
        "accepted_import": 1.25,
        "project_id": [
            "enw__ecr_project_363",
            "enw__ecr_project_518"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 113.61114335737093,
        "firm_capacity": 178.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 176.75,
        "local_dem_headroom": 63.138856642629065
    },
    {
        "node_1": [
            "mosnok_132_gt1a"
        ],
        "node_id_1": [
            "746f2e04-2cd9-47fc-92b2-5f123d346414"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "mosnok_11_gt1a"
        ],
        "node_id_2": [
            "38283367-c032-4bc9-a4ba-c0168c3b849e"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            37.5
        ],
        "eme_rating": [],
        "transformer_count": 1,
        "accepted_export": 1.25,
        "accepted_import": 1.25,
        "project_id": [
            "enw__ecr_project_429",
            "enw__ecr_project_363",
            "enw__ecr_project_518"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 113.61114335737093,
        "firm_capacity": 178.0,
        "spare": [
            false
        ],
        "local_gen_headroom": 176.75,
        "local_dem_headroom": 63.138856642629065
    }
]
enw_bsp_moss_nook 53.36201 -2.2408 100005 0 0 enw_gsp_south_manchester 100091
[]
353.5 126.27771328525813
36 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
37 37 orrell bsp 0 enw
[
    "09c68e05-57f1-47ad-a911-39008900100a",
    "dbd8eb02-7744-47e0-b00a-36cab2ccd9ff"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "orrell_132_gt1",
            "orrell_132_gt2"
        ],
        "node_id_1": [
            "0f8571fd-e25f-4da3-bdd0-5bee19ea82f1",
            "a5cc9e9b-d55b-4e4b-a4ad-edf86d1f1662"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "orrell_33_gt1",
            "orrell_33_gt2"
        ],
        "node_id_2": [
            "22fcf270-6370-4dc2-8dc7-75670b18dcfa",
            "2b68b6ec-2ca5-4d51-b0e8-ab0d6e6d6583"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 70.0,
        "accepted_import": 70.0,
        "project_id": [
            "enw__ecr_project_511",
            "enw__ecr_project_539"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 43.50155036566105,
        "firm_capacity": 78.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 8.0,
        "local_dem_headroom": -35.50155036566105
    }
]
enw_bsp_orrell 53.5356 -2.71374 200430 0 0 enw_gsp_washway_farm 200419
[]
8.0 -35.50155036566105
38 38 padiham bsp 0 enw
[
    "45e25bb8-4427-44d8-bb22-4b3626116fc7"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "nelson_132_gt1",
            "nelson_132_gt2",
            "padiha_132_gt1",
            "padiha_132_gt2"
        ],
        "node_id_1": [
            "be1f866f-5669-438a-956e-0a6b32167552",
            "d1098472-6689-491f-8879-48d6755af141",
            "944dc6b8-aa31-49c1-8737-2b9a5948e50c",
            "8d5e54f6-9cab-4350-b981-3c8b353f7eb2"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "nelson_33_gt1",
            "nelson_33_gt2",
            "padiha_33_gt1",
            "padiha_33_gt2"
        ],
        "node_id_2": [
            "a62ad712-197a-421d-9478-dc7e05a42467",
            "508b9dd1-371d-456d-bc02-c1b595359339",
            "3df081c6-06e3-41a5-acc8-1e795edeff94",
            "c9339c57-300d-496a-90fa-4cc28b12364f"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0,
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 4,
        "accepted_export": 20.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_174"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 72.25666983199581,
        "firm_capacity": 103.49999999999999,
        "spare": [
            false,
            false,
            false,
            false
        ],
        "local_gen_headroom": 83.49999999999999,
        "local_dem_headroom": 31.243330168004178
    }
]
enw_bsp_padiham 53.79502 -2.32919 400071 0 0 0 0
[]
83.49999999999999 31.243330168004178
39 39 peel bsp 0 enw
[
    "5c7c277b-8f10-4bc3-bd93-01276d5ed0f0"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "peel_132_gt2",
            "peel_132_gt1"
        ],
        "node_id_1": [
            "8a64edb6-ed8b-4b42-b84a-a89a6048fe11",
            "9079643f-87e1-468b-977b-8fa6991f60ee"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "peel_33_gt2",
            "peel_33_gt1"
        ],
        "node_id_2": [
            "4a85e163-4287-4680-b7e4-8b984a6de0a8",
            "8cc0695c-3f15-4579-af01-03c580f28523"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            58.5,
            58.5
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 41.98947368421052,
        "accepted_import": 21.989473684210527,
        "project_id": [
            "enw__ecr_project_391",
            "enw__ecr_project_140",
            "enw__ecr_project_149"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 43.05994742319629,
        "firm_capacity": 58.5,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 16.510526315789477,
        "local_dem_headroom": -6.549421107406818
    }
]
enw_bsp_peel 53.78114 -2.9776 400119 0 0 enw_gsp_penwortham_east_rochdale 400240
[]
16.510526315789477 -6.549421107406818
40 40 preston east bsp 0 enw
[
    "5e0c3aee-3531-4a2f-a500-b9771b3ed46c"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "preste_132_gt2",
            "preste_132_gt1"
        ],
        "node_id_1": [
            "97cf5ee8-c59a-4c9c-a894-df2970aa18a9",
            "2c4148d3-19eb-4b25-818d-64c6a6e34941"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "preste_33_gt2",
            "preste_33_gt1"
        ],
        "node_id_2": [
            "628b526b-2afe-495f-972f-1ab9046681a0",
            "16020857-4e55-44d0-b348-8ddebf2e3cb5"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 21.05263157894737,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_248"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 62.82375224165701,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 95.94736842105263,
        "local_dem_headroom": 54.17624775834299
    }
]
enw_bsp_preston_east 53.79104 -2.6584 400400 0 0 0 0
[]
95.94736842105263 54.17624775834299
41 41 radcliffe bsp 0 enw
[
    "97a825ee-39c4-4702-b596-6c605ad50a24"
]
[
    11.0,
    132.0
]
[
    {
        "node_1": [
            "radcli_132_gt1",
            "radcli_132_gt2"
        ],
        "node_id_1": [
            "5c96fa7c-378a-4eba-9a06-97c79e81b62f",
            "01aca573-c945-495b-8329-8a64f10393d0"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "radcli_11_gt1",
            "radcli_11_gt2"
        ],
        "node_id_2": [
            "b234edbf-775f-4635-96a0-68cdb1bcb8e2",
            "9bcb3cf2-a009-4d04-a107-745fc68723dd"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            37.5,
            37.5
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 28.33976353363159,
        "firm_capacity": 38.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 38.0,
        "local_dem_headroom": 9.66023646636841
    }
]
enw_bsp_radcliffe 53.55209 -2.33968 200208 0 0 enw_gsp_kearsley 200220
[]
38.0 9.66023646636841
42 42 red bank bsp 0 enw
[
    "710cc102-e46d-476a-b238-d6946f7b64bc"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "redban_132_gt2",
            "redban_132_gt3"
        ],
        "node_id_1": [
            "7580b707-8226-4dcf-b306-f94e02393744",
            "70ae8737-6d5f-4946-9d29-234c576fe854"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "redban_33_gt2",
            "redban_33_gt3"
        ],
        "node_id_2": [
            "4f7f63e3-f239-4688-9ad5-f1901864c18a",
            "fae543a2-cfe4-4724-9e6d-14a975cb1fd7"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 67.65380503490722,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 117.0,
        "local_dem_headroom": 49.34619496509278
    }
]
enw_bsp_red_bank 53.49001 -2.23427 100503 0 0 enw_gsp_kearsley 200220
[]
117.0 49.34619496509278
43 43 ribble bsp 0 enw
[
    "1fc78b00-f1cb-445a-922f-303ac26dff94"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "ribble_132_gt3",
            "ribble_132_gt2",
            "ribble_132_gt1"
        ],
        "node_id_1": [
            "188d88d3-2ac1-4917-85b8-7e2d4e290e36",
            "5b0f2dbe-fec7-4609-9f20-8b9c565c1926",
            "c8a94bbd-cdc6-469d-85f0-a7c7f43c90d4"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "ribble_33_gt3",
            "ribble_33_gt2",
            "ribble_33_gt1"
        ],
        "node_id_2": [
            "29eb90e0-72b7-4015-96d8-a3daf511e276",
            "ce2a6394-4d9e-4abc-ab7f-4bc4b66d72fe",
            "c978008f-5de3-4c8c-8140-c8b88b056984"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 12.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_343"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 126.75723354527189,
        "firm_capacity": 234.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 222.0,
        "local_dem_headroom": 107.24276645472811
    }
]
enw_bsp_ribble 53.75725 -2.73184 400421 0 0 0 0
[]
222.0 107.24276645472811
44 44 rochdale central bsp 0 enw
[
    "20cf26ad-091a-43e4-a2ed-dec637ef9d81"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "danest_132_broccen_33_gt2from_icn",
            "danest_132_aroccen_33_gt1from_icn"
        ],
        "node_id_1": [
            "33046b34-6bb3-416a-b853-03f54a0d58e9",
            "bd362a65-f958-45d6-b3ba-7ce41062bbcc"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "roccen_33_gt2",
            "roccen_33_gt1"
        ],
        "node_id_2": [
            "075ddec8-94ed-4099-a9c3-c981367f8029",
            "39d4c1bf-ec9c-44e6-bc2d-e79e47c8b684"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 99.9,
        "accepted_import": 79.9,
        "project_id": [
            "enw__ecr_project_541",
            "enw__ecr_project_558",
            "enw__ecr_project_561"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 29.827996885851448,
        "firm_capacity": 78.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": -21.900000000000006,
        "local_dem_headroom": -31.727996885851454
    }
]
enw_bsp_rochdale_central 53.61653 -2.16602 304882 0 0 0 0
[]
-21.900000000000006 -31.727996885851454
45 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
46 46 royton bsp 0 enw
[
    "ebf05de1-bf40-4b79-9356-c258fce453e9"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "royton_132_gt1",
            "royton_132_gt2"
        ],
        "node_id_1": [
            "97f73b9e-58e9-4fc4-af28-0489e36b3b57",
            "6fb72319-1bbd-41b3-b53e-5dd1a4db4d8f"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "royton_33_gt1",
            "royton_33_gt2"
        ],
        "node_id_2": [
            "905b5bb8-66aa-4554-91a6-dd3a2cc3a147",
            "af604465-5290-4ba6-97c1-a3aba4523669"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 27.05263157894737,
        "accepted_import": 6.0,
        "project_id": [
            "enw__ecr_project_72",
            "enw__ecr_project_308"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 32.46750098673368,
        "firm_capacity": 68.5872,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 41.534568421052626,
        "local_dem_headroom": 30.119699013266313
    }
]
enw_bsp_royton 53.56464 -2.11572 300009 0 0 0 0
[]
41.534568421052626 30.119699013266313
47 47 sale bsp 0 enw
[
    "4019fc78-1d79-4a7f-86fa-829008834c9a"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "sale_132_gt1",
            "sale_132_gt2"
        ],
        "node_id_1": [
            "5f4af9b5-791d-45a6-b9fe-36499435e0d9",
            "17c8b225-c001-432c-ae17-a321e04a8ddb"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "sale_33_gt1",
            "sale_33_gt2"
        ],
        "node_id_2": [
            "3ef28994-82ea-4ba6-b5b7-1500090e7317",
            "95a56076-d76b-4c86-824e-9d438c9e999d"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            75.0,
            75.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 26.315789473684212,
        "accepted_import": 25.0,
        "project_id": [
            "enw__ecr_project_2",
            "enw__ecr_project_167"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 47.202788850906146,
        "firm_capacity": 78.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 51.68421052631579,
        "local_dem_headroom": 5.7972111490938545
    }
]
enw_bsp_sale 53.42581 -2.31835 0 0 0 0 100092
[]
51.68421052631579 5.7972111490938545
48 48 sandgate bsp 0 enw
[
    "926bba6e-65fc-411a-868e-499f01b002f9"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "barrow_132_gt1",
            "barrow_132_gt2",
            "sandga_132_gt2"
        ],
        "node_id_1": [
            "5f66a4aa-653c-4ee3-8bbd-cabdb6a3b475",
            "576e6e6a-0d42-47d0-a6e0-a7cb871de997",
            "71e7255b-ce97-4677-a033-1389554b9a28"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "barrow_33_gt1",
            "barrow_33_gt2",
            "sandga_33_gt2"
        ],
        "node_id_2": [
            "5d3651b7-8624-4649-8c4b-baaa94a2df2d",
            "f5940b56-1491-457b-b774-66fc1d2cb1a2",
            "5796ccab-ec44-4c6c-925d-e61e3e41579f"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0,
            75.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 38.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_207"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 60.71551000728844,
        "firm_capacity": 126.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 88.0,
        "local_dem_headroom": 65.28448999271157
    }
]
enw_bsp_sandgate 54.12391 -3.23018 609001 0 0 enw_gsp_harker_hutton 609600
[]
88.0 65.28448999271157
49 49 shap bsp 0 enw
[
    "cb3c8ff9-197a-4076-b2b0-a789a0e7cd96"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "penrit_132_gt2",
            "penrit_132_gt1",
            "shap_132_gt1"
        ],
        "node_id_1": [
            "843f2b5c-cbec-4f58-bf76-7376e390cb15",
            "f99e5755-02ab-48df-9a3d-d218302c67a2",
            "8b42beb1-8e95-4895-97a9-f3163781735d"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "penrit_33_gt2",
            "penrit_33_gt1",
            "shap_33_gt1"
        ],
        "node_id_2": [
            "9d474353-bbb5-48f7-8f00-70971c08f87d",
            "423ba34f-67c3-4fc4-af65-792d3505c770",
            "b7cf2472-a26e-477b-96d0-2d9a4baecaa6"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0,
            58.5
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 135.25263157894736,
        "accepted_import": 44.05263157894737,
        "project_id": [
            "enw__ecr_project_56",
            "enw__ecr_project_63",
            "enw__ecr_project_247",
            "enw__ecr_project_60",
            "enw__ecr_project_48",
            "enw__ecr_project_422",
            "enw__ecr_project_161",
            "enw__ecr_project_200",
            "enw__ecr_project_375",
            "enw__ecr_project_394",
            "enw__ecr_project_555"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 74.05916243196245,
        "firm_capacity": 118.2,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": -17.052631578947356,
        "local_dem_headroom": 0.08820598909018429
    }
]
enw_bsp_shap 54.66637 -2.77723 609657 0 0 enw_gsp_harker_hutton 609600
[]
-17.052631578947356 0.08820598909018429
50 50 skelmersdale bsp 0 enw
[
    "ec16f43c-bc6d-4503-80c7-860e17ca191a"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "skelme_132_gt1",
            "skelme_132_gt2"
        ],
        "node_id_1": [
            "a9f5f8e7-6c4c-45ba-a2e3-a5119915d7dd",
            "8ab29dde-e16b-40dc-99ea-981b74f4eae5"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "skelme_33_gt1",
            "skelme_33_gt2"
        ],
        "node_id_2": [
            "41f565b1-77ca-49f9-aa27-d650b79b9863",
            "9a7a8ec2-bb43-49f8-a1fc-1c5c6dde9670"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 2.5,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_1",
            "enw__ecr_project_135"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 60.058708872199006,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 114.5,
        "local_dem_headroom": 56.941291127800994
    }
]
enw_bsp_skelmersdale 53.56076 -2.79859 200401 0 0 enw_gsp_washway_farm 200419
[]
114.5 56.941291127800994
51 51 spadeadam bsp 0 enw
[
    "7b1c1a11-4a3f-48ca-aea1-f5230ef7dc7b"
]
[
    11.0,
    132.0
]
[
    {
        "node_1": [
            "spadea_132_gt2",
            "spadea_132_gt1"
        ],
        "node_id_1": [
            "d2da7515-390b-48b4-8d9f-e976a316143a",
            "77fe4c9d-d32d-42f3-9299-6b5190f658c3"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "spadea_11_gt2",
            "spadea_11_gt1"
        ],
        "node_id_2": [
            "3b1e21e8-0f8c-4512-832a-6e63d6b05a66",
            "85a25d5c-92f5-4aba-a8b5-a243f13ccc77"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            37.5,
            37.5
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 10.994078603778,
        "firm_capacity": 38.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 38.0,
        "local_dem_headroom": 27.005921396222
    }
]
enw_bsp_spadeadam 55.02622 -2.60662 609621 0 0 0 0
[]
38.0 27.005921396222
52 52 stainburn bsp 0 enw
[
    "d6ce8d2c-531b-4af6-8eb7-20ea7c88c440"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "siddic_132_gt1",
            "stainb_132_gt1",
            "stainb_132_gt2"
        ],
        "node_id_1": [
            "609c8539-af5a-4675-9605-c2c1d75a01d9",
            "0d87e5bf-0ba6-4977-b6f4-6b34d4157993",
            "5a4408e8-e7cf-4166-bd73-d3a990a45ac8"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "siddic_33_gt1",
            "stainb_33_gt1",
            "stainb_33_gt2"
        ],
        "node_id_2": [
            "d4961ee9-8eeb-4189-9e9a-1bf7c76efd43",
            "9edbb027-c03c-4e47-945b-202f1a32e842",
            "9249ed2a-13c6-46be-a097-3bb7bf551d51"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 19.775,
        "accepted_import": 7.26,
        "project_id": [
            "enw__ecr_project_495",
            "enw__ecr_project_335",
            "enw__ecr_project_379"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 97.39743751941866,
        "firm_capacity": 131.9,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 112.125,
        "local_dem_headroom": 27.24256248058135
    }
]
enw_bsp_stainburn 54.64948 -3.51144 609311 0 0 enw_gsp_harker_hutton 609600
[]
112.125 27.24256248058135
53 53 stretford bsp 0 enw
[
    "e158449d-e42b-4239-91ae-e547382e2f54"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "stretf_132_gt2",
            "stretf_132_gt1"
        ],
        "node_id_1": [
            "4307186c-1427-4694-8a5f-f2c4f89f41a2",
            "8f5c2cb2-926e-4413-9af6-ad8c07ad8973"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "stretf_33_gt2",
            "stretf_33_gt1"
        ],
        "node_id_2": [
            "12abc110-168b-48b4-a764-f615a460709c",
            "c9c89af3-8a52-42bf-9118-1622477c3e22"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 3.0,
        "accepted_import": 3.0,
        "project_id": [
            "enw__ecr_project_322"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 64.27280998085104,
        "firm_capacity": 103.5,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 100.5,
        "local_dem_headroom": 36.22719001914896
    }
]
enw_bsp_stretford 53.4523 -2.30113 100505 0 0 enw_gsp_south_manchester 100091
[]
100.5 36.22719001914896
54 54 stuart street bsp 0 enw
[
    "8872d5b8-528f-413d-b907-57127859306c"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "stuart_132_gt1",
            "stuart_132_gt3",
            "stuart_132_gt2"
        ],
        "node_id_1": [
            "58a206b4-b351-4e0f-8322-ba3c2b625316",
            "50e75220-eb7c-45a4-a937-b3c79aba1678",
            "70e8123c-0e72-4313-8eaa-3aefa85e91b3"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "stuart_33_gt1",
            "stuart_33_gt3",
            "stuart_33_gt2"
        ],
        "node_id_2": [
            "31ce2e84-73e8-44c3-902b-89efcff90ad0",
            "13adda35-f660-45b8-8b55-0a3e3980e114",
            "8ecc446c-609f-4b78-8a9b-307185c684b1"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 19.33684210526316,
        "accepted_import": 10.0,
        "project_id": [
            "enw__ecr_project_216",
            "enw__ecr_project_479",
            "enw__ecr_project_38"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 99.77663080078332,
        "firm_capacity": 207.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 187.66315789473686,
        "local_dem_headroom": 97.22336919921668
    }
]
enw_bsp_stuart_street 53.48612 -2.19476 0 0 0 0 0
[]
187.66315789473686 97.22336919921668
55 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
56 56 trimpell bsp 0 enw
[
    "320f473d-c05e-48fb-a2be-368871fedb63"
]
[
    11.0,
    132.0
]
[
    {
        "node_1": [
            "trimpe_132_gt2",
            "trimpe_132_gt1"
        ],
        "node_id_1": [
            "1f72ac82-e112-4586-958f-99ca1671d1bb",
            "847bfd03-deb2-4ac5-8059-8409efef26af"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "trimpe_11_gt2",
            "trimpe_11_gt1"
        ],
        "node_id_2": [
            "cf1e5c82-1902-426f-a6c7-6c0fb0f69631",
            "df576e30-1fa3-49a9-84ec-242ad5a85902"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            56.25,
            56.25
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 3.8474942976406115,
        "firm_capacity": 23.815,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 23.815,
        "local_dem_headroom": 19.96750570235939
    }
]
enw_bsp_trimpell 54.01945 -2.89654 609918 0 0 enw_gsp_heysham 609900
[]
23.815 19.96750570235939
57 57 ulverston bsp 0 enw
[
    "6cb8e0b5-610e-4dcc-b2f0-cbc8386ac023"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "ulvers_132_gt2ulvers_33_gt2from_icn",
            "ulvers_132_gt1ulvers_33_gt1from_icn"
        ],
        "node_id_1": [
            "6e6d5ccf-79cc-4daf-89f4-81ff559a049c",
            "7a447ae6-0da9-462c-b3a0-9d0ca6785cb6"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "ulvers_33_gt2",
            "ulvers_33_gt1"
        ],
        "node_id_2": [
            "136741af-1960-484c-bf98-020dbc886a4f",
            "73b3d8f9-ec8f-4512-9455-69e32407a91d"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 55.0,
        "accepted_import": 45.0,
        "project_id": [
            "enw__ecr_project_522",
            "enw__ecr_project_338"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 40.08844456098011,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 62.0,
        "local_dem_headroom": 31.911555439019892
    }
]
enw_bsp_ulverston 54.1907 -3.11215 609036 0 0 enw_gsp_harker_hutton 609600
[]
62.0 31.911555439019892
58 58 vernon park bsp 0 enw
[
    "0a41afed-1450-467a-bef7-92ee30980067"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "vernon_132_gt3",
            "vernon_132_ju1"
        ],
        "node_id_1": [
            "0b7dcf89-4c37-405d-a538-2b0c5445688d",
            "199ed606-4e17-471c-93ad-0467a0ad191e"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "vernon_33_gt3",
            "vernon_33_gt4"
        ],
        "node_id_2": [
            "b45a1960-790f-44ce-a26f-61a7777659dc",
            "1d3c8e70-cd00-4669-ad51-ddaa93922729"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 22.45263157894737,
        "accepted_import": 21.05263157894737,
        "project_id": [
            "enw__ecr_project_453",
            "enw__ecr_project_187",
            "enw__ecr_project_386"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 68.90748710237195,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 94.54736842105262,
        "local_dem_headroom": 27.039881318680685
    }
]
enw_bsp_vernon_park 53.41552 -2.13492 300289 0 0 enw_gsp_bredbury 305953
[]
94.54736842105262 27.039881318680685
59 59 west didsbury bsp 0 enw
[
    "ea1acfe1-d96b-41fa-bc00-51e22e4e5db6"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "wdidsb_132_gt1",
            "wdidsb_132_gt2",
            "wdidsb_132_gt3"
        ],
        "node_id_1": [
            "45f7538c-b8c8-4f9f-a73a-64f85e010953",
            "c330eaa5-04d9-4cd4-8af8-5f3fe790cea8",
            "c934514f-f890-48da-b2bc-89c79520dafc"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "wdidsb_33_gt1",
            "wdidsb_33_gt2",
            "wdidsb_33_gt3"
        ],
        "node_id_2": [
            "1f2eaf20-7aa6-453a-a215-5918c6246aad",
            "38c4372b-6c64-4946-9170-5c638a30f467",
            "2344d773-b261-443c-95ff-ff45778504cb"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0,
            60.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 94.93233103722451,
        "firm_capacity": 124.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 124.0,
        "local_dem_headroom": 29.067668962775485
    }
]
enw_bsp_west_didsbury 53.42927 -2.25292 0 0 0 enw_gsp_south_manchester 100091
[]
124.0 29.067668962775485
60 60 westhoughton bsp 0 enw
[
    "bbf2c8cd-efda-4564-8e1a-43a5842adc53"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "westho_132_gt2",
            "westho_132_gt1"
        ],
        "node_id_1": [
            "eb8e9e1e-8d18-416a-afa3-0a05d90e7064",
            "20e2897c-2ab5-4d84-a016-d27f480a17d2"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "westho_33_gt2",
            "westho_33_gt1"
        ],
        "node_id_2": [
            "7993dffb-6b67-4bba-9392-d6fab99f30b3",
            "267c93d7-e519-48a4-848e-ef262714c413"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 68.12210526315789,
        "accepted_import": 47.06947368421053,
        "project_id": [
            "enw__ecr_project_325",
            "enw__ecr_project_312",
            "enw__ecr_project_403",
            "enw__ecr_project_507"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 56.886748815513826,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 48.87789473684211,
        "local_dem_headroom": 13.043777500275645
    }
]
enw_bsp_westhoughton 53.55846 -2.51787 200413 0 0 enw_gsp_kearsley 200220
[]
48.87789473684211 13.043777500275645
61 61 wigan bsp 0 enw
[
    "46b526c3-515d-4683-91ef-b015ba7ad47b"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "wigan_132_gt1",
            "wigan_132_gt2"
        ],
        "node_id_1": [
            "50512700-4ea1-400b-a7c0-a5399c74eb81",
            "8a32b26f-b5c6-4781-8283-3b04a01d1508"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "wigan_33_gt1",
            "wigan_33_gt2"
        ],
        "node_id_2": [
            "5e53c8a7-0c52-42b7-ab5f-387433445cef",
            "c579d10e-6f21-4e25-bf2a-b42537306e7d"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 40.0,
        "accepted_import": 40.0,
        "project_id": [
            "enw__ecr_project_181"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 53.470294691783494,
        "firm_capacity": 72.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 32.0,
        "local_dem_headroom": -21.470294691783494
    }
]
enw_bsp_wigan 53.53645 -2.62967 200421 0 0 enw_gsp_washway_farm 200419
[]
32.0 -21.470294691783494
62 62 wrightington bsp 0 enw
[
    "7e6c2822-e76d-40fc-a7a6-2ba23b424bf0"
]
[
    33.0,
    132.0
]
[
    {
        "node_1": [
            "wright_132_gt2",
            "wright_132_gt1"
        ],
        "node_id_1": [
            "7b7c3fae-c5ad-4b96-baaf-2a2031d2d1ef",
            "0533903a-4ded-4bfe-895e-ef150b4fe16b"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "wright_33_gt2",
            "wright_33_gt1"
        ],
        "node_id_2": [
            "ac5c7d3c-166f-4df3-86e7-7e842b7e5b30",
            "5d91c370-0614-446e-a2cd-6eeefc64a39a"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 63.76,
        "accepted_import": 28.759999999999998,
        "project_id": [
            "enw__ecr_project_157",
            "enw__ecr_project_385",
            "enw__ecr_project_559",
            "enw__ecr_project_146",
            "enw__ecr_project_198",
            "enw__ecr_project_202"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 92.06297802993612,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 53.24,
        "local_dem_headroom": -3.8229780299361167
    }
]
enw_bsp_wrightington 53.61411 -2.70439 0 0 0 enw_gsp_penwortham_east_rochdale 400240
[]
53.24 -3.8229780299361167
63 63 albion primary 0 enw
[
    "dbd28e74-f208-4384-9a38-f42515f4881c"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "albist_33_t11",
            "albist_33_t12"
        ],
        "node_id_1": [
            "45228145-ea4e-4a2d-8f33-68f816e14604",
            "15827f79-f032-4843-bb15-bfcac8f97c4d"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "albist_33_t11albist_6.6_ato_icn",
            "albist_33_t12albist_6.6_bto_icn"
        ],
        "node_id_2": [
            "1ad8cffb-81a8-42d8-9137-af5e64ea40f3",
            "012cac6b-880c-410b-87c4-82d05c301632"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 11.994425011312268,
        "firm_capacity": 22.863,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 22.863,
        "local_dem_headroom": 10.868574988687731
    }
]
enw_primary_albion 53.73007 -2.49506 400019 enw_bsp_lower_darwen 400016 0 0
[]
22.863 10.868574988687731
64 64 alston primary 0 enw
[
    "384bb466-e492-4dd4-aef0-5bc1ca57d637"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "alston_33_t11"
        ],
        "node_id_1": [
            "106a0ccf-6fe8-408a-9ad6-0b52041a1ea6"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "alston_33_aalston_11_ato_icn"
        ],
        "node_id_2": [
            "6c7d5265-248e-43f2-8c52-fc3c5dfee1ad"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            3.87
        ],
        "eme_rating": [],
        "transformer_count": 1,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 2.0942008088105077,
        "firm_capacity": 1.7,
        "spare": [
            false
        ],
        "local_gen_headroom": 1.7,
        "local_dem_headroom": -0.3942008088105078
    }
]
enw_primary_alston 54.81253 -2.43515 609652 enw_bsp_shap 609657 enw_gsp_harker_hutton 609600
[]
1.7 -0.3942008088105078
65 65 ambleside primary 0 enw
[
    "ce76c226-1f6e-4eda-935c-c3a0d878d8d7"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "ambles_33_t12",
            "ambles_33_t11"
        ],
        "node_id_1": [
            "c3440e10-6236-449a-b4dd-fe950f3b73e5",
            "faf7ef30-9fbf-45e6-aa4f-7b348e894002"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ambles_33_t12ambles_11_bto_icn",
            "ambles_33_t11ambles_11_ato_icn"
        ],
        "node_id_2": [
            "1af053af-2fb6-43ca-bc52-703cb1e88a6a",
            "bafc346d-0288-441a-b6ec-269b26622d88"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 9.96244398236327,
        "firm_capacity": 17.8,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 17.8,
        "local_dem_headroom": 7.8375560176367305
    }
]
enw_primary_ambleside 54.42302 -2.96291 609058 enw_bsp_kendal 609051 enw_gsp_harker_hutton 609600
[]
17.8 7.8375560176367305
66 66 ancoats north primary 0 enw
[
    "ecc5fa8f-0f8f-4b0d-a89e-c6078a37d720"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "ancnor_33_bancnor_6.6_bfrom_icn",
            "ancnor_33_t11",
            "ancnor_33_t14"
        ],
        "node_id_1": [
            "b3b55c53-f3e8-4101-a694-70b5ab91618b",
            "46f75f59-59a9-470c-8cb9-60f4cec46b7d",
            "0987f7d5-b9eb-4ad0-b416-299033d4d1af"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ancnor_33_bancnor_6.6_bto_icn",
            "ancnor_33_aancnor_6.6_ato_icn",
            "ancnor_33_t14ancnor_6.6_cto_icn"
        ],
        "node_id_2": [
            "5caa8ce7-b457-4e36-a8c5-04bd686432ea",
            "5b1b4020-0e16-4d30-a95f-db21927c7dbd",
            "c95f1135-8e5d-4332-a6c2-5d1ef0d25813"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 25.941353167236546,
        "firm_capacity": 36.113,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 36.113,
        "local_dem_headroom": 10.171646832763454
    }
]
enw_primary_ancoats_north 53.48608 -2.2274 100601 enw_bsp_red_bank 100503 0 0
[]
36.113 10.171646832763454
67 67 annes primary 0 enw
[
    "bb797727-49c4-413c-b49d-17bd4d1d9734"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "stanne_33_t12",
            "stanne_33_t11"
        ],
        "node_id_1": [
            "3ed48f5f-27e3-4546-9a4d-aa018b047da4",
            "a342b8a8-5deb-4f2e-9597-0ea6b22b2a7c"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "stanne_33_t12stanne_6.6_bto_icn",
            "stanne_33_t11stanne_6.6_ato_icn"
        ],
        "node_id_2": [
            "37e6bd4f-22fb-4476-ac24-b99da9c6dbed",
            "0b453fdc-c87c-4af3-9332-072797d0a957"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            17.64,
            17.64
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 6.598401972721808,
        "firm_capacity": 17.5,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 17.5,
        "local_dem_headroom": 10.901598027278192
    }
]
enw_primary_annes 53.76027 -3.0378 400111 enw_bsp_lytham 400107 enw_gsp_penwortham_east_rochdale 400240
[]
17.5 10.901598027278192
68 68 annie pit primary 0 enw
[
    "909f0d3c-41fd-45d7-a0e7-143a778d0a5b"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "annipi_33_t12annipi_11_bfrom_icn",
            "annipi_33_t11"
        ],
        "node_id_1": [
            "129dedce-2f8b-48a2-a28e-7e4014bb6073",
            "badbb66b-52af-413f-a32d-914ceed38467"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "annipi_33_t12annipi_11_bto_icn",
            "annipi_33_t11annipi_11_ato_icn"
        ],
        "node_id_2": [
            "5874df73-9ec4-4323-8dfd-01bf2e56da58",
            "7ef851ae-a423-4599-8427-ddfb26857f59"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 14.943698421544589,
        "firm_capacity": 22.86,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 22.86,
        "local_dem_headroom": 7.9163015784554105
    }
]
enw_primary_annie_pit 54.63551 -3.55085 609303 enw_bsp_stainburn 609311 enw_gsp_harker_hutton 609600
[]
22.86 7.9163015784554105
69 69 ansdell primary 0 enw
[
    "63bc21aa-3fd7-4806-a4cc-f71f1f834c29"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "ansdel_33_aansdel_6.6_afrom_icn",
            "ansdel_33_bansdel_6.6_bfrom_icn"
        ],
        "node_id_1": [
            "46fd2d42-4d30-4b66-9bcf-8e79d1efca23",
            "533aaa11-c9b4-4770-a82a-5ce278a63829"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ansdel_33_aansdel_6.6_ato_icn",
            "ansdel_33_bansdel_6.6_bto_icn"
        ],
        "node_id_2": [
            "6688a481-bd57-429f-ac65-e82911b40f13",
            "3bbeb145-75dd-440c-a9b3-9fc44c215f6b"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 8.055048110156784,
        "firm_capacity": 16.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 16.0,
        "local_dem_headroom": 7.944951889843216
    }
]
enw_primary_ansdell 53.7465 -2.99588 400101 enw_bsp_lytham 400107 enw_gsp_penwortham_east_rochdale 400240
[]
16.0 7.944951889843216
70 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
71 71 arnside primary 0 enw
[
    "1bc3101e-5c22-4114-8653-b8489c79a324"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "arnsid_33_aarnsid_11_afrom_icn",
            "arnsid_33_barnsid_11_bfrom_icn"
        ],
        "node_id_1": [
            "236aaf09-ffe7-4c3c-87d6-821543955385",
            "3c0b3c35-2d64-4cc6-9662-db0db4307fee"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "arnsid_33_aarnsid_11_ato_icn",
            "arnsid_33_barnsid_11_bto_icn"
        ],
        "node_id_2": [
            "2cde5131-738c-4638-9793-78fa417cfe76",
            "82b0dd6b-ba00-40ab-9f22-8f321b5883ca"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            15.0,
            15.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 4.038821080413622,
        "firm_capacity": 15.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 15.0,
        "local_dem_headroom": 10.961178919586377
    }
]
enw_primary_arnside 54.19635 -2.8212 609052 enw_bsp_kendal 609051 enw_gsp_harker_hutton 609600
[]
15.0 10.961178919586377
72 72 ashton golborne primary 0 enw
[
    "d923fc1e-fd95-4961-a2b3-b602797d1a48"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "ashgo_33_t11",
            "ashgo_33_t12"
        ],
        "node_id_1": [
            "bb5e3bdf-f275-49aa-a67e-608de523acb5",
            "45013ef2-fa68-4789-8593-f6a193093883"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ashtgo_33_aashtgo_6.6_ato_icn",
            "ashtgo_33_bashtgo_6.6_bto_icn"
        ],
        "node_id_2": [
            "cc641e2e-3a09-4d91-a4a8-73dc78b6a983",
            "2141e7a1-514c-4b98-98db-737a6acf11e2"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 14.36061288157478,
        "firm_capacity": 21.2,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 21.2,
        "local_dem_headroom": 6.839387118425218
    }
]
enw_primary_ashton_golborne 53.47498 -2.59493 205308 enw_bsp_golborne 205308 0 0
[]
21.2 6.839387118425218
73 73 ashton on mersey primary 0 enw
[
    "24921054-3717-4349-a141-709c8c32283a"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "ashmer_33_bashmer_6.6_bfrom_icn",
            "ashmer_33_aashmer_6.6_afrom_icn"
        ],
        "node_id_1": [
            "b4d3cb9f-afab-4f9e-bbaa-2e3672fd38a2",
            "d1acc62a-5112-4698-b3ea-a488e6659fec"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ashmer_33_bashmer_6.6_bto_icn",
            "ashmer_33_aashmer_6.6_ato_icn"
        ],
        "node_id_2": [
            "42603324-ae7d-44ff-a1b6-9170edd18e17",
            "d4f79bac-2b8a-4d0d-9401-4d5ce031fd5b"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 11.90622977993901,
        "firm_capacity": 22.86,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 22.86,
        "local_dem_headroom": 10.953770220060989
    }
]
enw_primary_ashton_on_mersey 53.42681 -2.34492 100102 0 0 0 100092
[]
22.86 10.953770220060989
74 74 ashton ribble primary 0 enw
[
    "af80431e-7886-42cf-a983-e2e1dc2aca45"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "ashton_33_t11"
        ],
        "node_id_1": [
            "91fef7e2-59a1-48f0-9fbe-61d65975301f"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ashton_33_t11ashton_6.6_ato_icn"
        ],
        "node_id_2": [
            "2da7abac-c65f-4f97-801e-ac771141516d"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            13.0
        ],
        "eme_rating": [],
        "transformer_count": 1,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 7.230921725052623,
        "firm_capacity": 10.5,
        "spare": [
            false
        ],
        "local_gen_headroom": 10.5,
        "local_dem_headroom": 3.2690782749473772
    }
]
enw_primary_ashton_ribble 53.75725 -2.73184 0 enw_bsp_ribble 400421 0 0
[]
10.5 3.2690782749473772
75 75 ashton under lyne primary 0 enw
[
    "a3bfecb6-e93f-4fb7-9d57-cd1202ba41a3"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "ashunl_33_t13",
            "ashunl_33_t12",
            "ashunl_33_t11"
        ],
        "node_id_1": [
            "a060a11c-181c-46e1-ad7d-786f63d35322",
            "9d07d000-27ba-4f20-b12a-b6a69986bfc5",
            "c023664b-0847-452d-ae56-fb9abc1c3f72"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ashunl_33_t13ashunl_6.6_cto_icn",
            "ashunl_33_t12ashunl_6.6_bto_icn",
            "ashunl_33_t11ashunl_6.6_ato_icn"
        ],
        "node_id_2": [
            "f09809e6-eb08-4657-8eb1-f05fe7d2453a",
            "a666d0b1-d51e-40ea-bf49-4ecb3a194a30",
            "acd7fcf3-0d9c-45a7-b05d-b9b1de9b671c"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 21.57876572645956,
        "firm_capacity": 36.113,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 36.113,
        "local_dem_headroom": 14.534234273540438
    }
]
enw_primary_ashton_under_lyne 53.49047 -2.10269 307115 enw_bsp_heyrod 304200 0 0
[]
36.113 14.534234273540438
76 76 ashwood dale primary 0 enw
[
    "4af71c2f-6a1a-45ea-a0c9-229836dc3036"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "ashwod_33_t11",
            "ashwod_33_t12"
        ],
        "node_id_1": [
            "2b8ebf55-48f2-4288-8dd4-733d661e21e1",
            "f78e4f9a-8330-4ebb-9ecf-ee88055da460"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ashwod_33_t11ashwod_6.6_ato_icn",
            "ashwod_33_t12ashwod_6.6_bto_icn"
        ],
        "node_id_2": [
            "e629215d-fef5-41de-b47d-5228a85dbfe0",
            "49abb87a-1495-4298-beb3-0c845e2b7f11"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 13.271091618230315,
        "firm_capacity": 19.719,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 19.719,
        "local_dem_headroom": 6.447908381769686
    }
]
enw_primary_ashwood_dale 53.25445 -1.90388 301467 enw_bsp_buxton 303846 0 0
[]
19.719 6.447908381769686
77 77 askam primary 0 enw
[
    "0cd86167-784b-45e4-8147-3252518fe0b1"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "askam_33_t11askam_11_afrom_icn"
        ],
        "node_id_1": [
            "68a11053-78fc-42c2-998e-26ff6fc992a0"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "askam_33_t11askam_11_ato_icn"
        ],
        "node_id_2": [
            "fba7e812-942f-4602-8175-4563d5445ad7"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 1,
        "accepted_export": 10.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_522"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 15.35768095223473,
        "firm_capacity": 20.02,
        "spare": [
            false
        ],
        "local_gen_headroom": 10.02,
        "local_dem_headroom": 4.662319047765269
    }
]
enw_primary_askam 54.18998 -3.20391 609038 enw_bsp_ulverston 609036 enw_gsp_harker_hutton 609600
[]
10.02 4.662319047765269
78 78 askerton castle primary 0 enw
[
    "4c181164-9c46-4816-897b-6ae18b327963"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "askcas_33_t11askcas_11_afrom_icn"
        ],
        "node_id_1": [
            "c2c7d93a-5652-46a1-ae75-e60030e61804"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "askcas_33_t11askcas_11_ato_icn"
        ],
        "node_id_2": [
            "1780ca45-b056-4d5b-8db5-dd424eef7646"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            3.87
        ],
        "eme_rating": [],
        "transformer_count": 1,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 1.329303193057368,
        "firm_capacity": 2.3,
        "spare": [
            false
        ],
        "local_gen_headroom": 2.3,
        "local_dem_headroom": 0.9706968069426318
    }
]
enw_primary_askerton_castle 55.01287 -2.70834 609610 enw_bsp_spadeadam 609621 enw_gsp_harker_hutton 609600
[]
2.3 0.9706968069426318
79 79 aspatria primary 0 enw
[
    "0407a240-c669-4a4a-ada9-fb25c8239c70"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "aspatr_33_t11",
            "aspatr_33_baspatr_11_bfrom_icn"
        ],
        "node_id_1": [
            "d1d2d588-0e4f-4bff-996e-6fdf31e37cb9",
            "d36b5ab9-49a8-48d1-984a-4b8bc9356df4"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "aspatr_33_t11aspatr_11_ato_icn",
            "aspatr_33_baspatr_11_bto_icn"
        ],
        "node_id_2": [
            "f3bc800f-729b-42ac-abc7-14832297b255",
            "0a9176aa-8940-420c-8234-f8a0fc2323f0"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            13.0,
            13.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 2.525,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_495"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 8.305118080139241,
        "firm_capacity": 13.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 10.475,
        "local_dem_headroom": 4.694881919860759
    }
]
enw_primary_aspatria 54.77351 -3.33215 609304 enw_bsp_stainburn 609311 enw_gsp_harker_hutton 609600
[]
10.475 4.694881919860759
80 80 atherton town centre primary 0 enw
[
    "bc30d206-e183-410a-943b-6a3628fb61e7"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "athetc_33_t11",
            "athetc_33_t12"
        ],
        "node_id_1": [
            "710f6ea9-d4a7-45e5-962a-8ba60645559e",
            "514d290f-79c6-42bb-9571-7c39afeea5ee"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "athetc_33_t11athetc_11_ato_icn",
            "athetc_33_t12athetc_11_bto_icn"
        ],
        "node_id_2": [
            "c6047afe-684f-41c8-a0a0-ad00e9943f7a",
            "722c04a7-f594-450c-9e6c-62ffc320e278"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            36.54,
            37.296
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 24.050633716787544,
        "firm_capacity": 33.24,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 33.24,
        "local_dem_headroom": 9.189366283212458
    }
]
enw_primary_atherton_town_centre 53.51405 -2.51233 0 enw_bsp_atherton 205317 enw_gsp_kearsley 200220
[]
33.24 9.189366283212458
81 81 athletic primary 0 enw
[
    "c8e78bbd-446f-4825-807e-09fbc2bee5a1"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "athlst_33_bathlst_6.6_bfrom_icn",
            "athlst_33_aathlst_6.6_afrom_icn"
        ],
        "node_id_1": [
            "6548c6c3-bb13-41a2-9e5d-05204e11cb1f",
            "a9d70ec4-d274-437e-9c8d-fee73b7e68a7"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "athlst_33_bathlst_6.6_bto_icn",
            "athlst_33_aathlst_6.6_ato_icn"
        ],
        "node_id_2": [
            "fcefac1e-6cd4-419e-a587-d21886f0de15",
            "583316af-8a35-438a-afa4-0cb8bc64ab7a"
        ],
        "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": 10.70747421756772,
        "firm_capacity": 17.5,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 17.5,
        "local_dem_headroom": 6.79252578243228
    }
]
enw_primary_athletic 53.78608 -2.22368 400052 enw_bsp_burnley 401053 0 0
[]
17.5 6.79252578243228
82 82 avenham primary 0 enw
[
    "a37eaf98-5848-45f0-8b6f-a886bf3cd2ac"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "avenha_33_aavenha_6.6_afrom_icn",
            "avenha_33_bavenha_6.6_bfrom_icn"
        ],
        "node_id_1": [
            "0983e466-a2a3-4ec2-af97-040029ad00a6",
            "99b053ec-459d-4ef8-b672-2b39f2b902c1"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "avenha_33_aavenha_6.6_ato_icn",
            "avenha_33_bavenha_6.6_bto_icn"
        ],
        "node_id_2": [
            "8631409e-b4d5-434d-98b4-4d2c8d5a30e7",
            "ed0f6dae-18c0-49e4-8e18-23f846ade3a6"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 9.791660999422312,
        "firm_capacity": 22.863,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 22.863,
        "local_dem_headroom": 13.071339000577687
    }
]
enw_primary_avenham 53.75695 -2.69892 400402 enw_bsp_preston_east 400400 0 0
[]
22.863 13.071339000577687
83 83 baguley primary 0 enw
[
    "b62ada92-d6a6-4b5f-b60a-ba7e081f83dd"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "baguly_33_abaguly_11_afrom_icn",
            "baguly_33_bbaguly_11_bfrom_icn"
        ],
        "node_id_1": [
            "c13ffa68-94ef-4b92-9bc6-2472cb379723",
            "1bdf8540-1d09-40fd-aeb9-7fa5430f35e1"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "baguly_33_abaguly_11_ato_icn",
            "baguly_33_bbaguly_11_bto_icn"
        ],
        "node_id_2": [
            "397fc55b-e398-45a0-897f-c3c1cbfe8e89",
            "868e98db-afd8-4bba-9b71-71b0f3de83af"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 1.3157894736842106,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_2"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 15.134982242590228,
        "firm_capacity": 22.863,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 21.547210526315787,
        "local_dem_headroom": 7.728017757409772
    }
]
enw_primary_baguley 53.39757 -2.2937 100103 0 0 0 100092
[]
21.547210526315787 7.728017757409772
84 84 bamber bridge primary 0 enw
[
    "1b7b5997-e1a2-4be8-adeb-89bcb8720ee4"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "bambri_33_t12",
            "bambri_33_t11"
        ],
        "node_id_1": [
            "cecab4f8-4fa8-431d-9bfe-e872a77145fb",
            "f15c25c8-2eb3-4e42-a183-225b16c32ecf"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "bambri_33_bbambri_11_bto_icn",
            "bambri_33_abambri_11_ato_icn"
        ],
        "node_id_2": [
            "5ce10f4e-fd7a-4c73-bce7-ffc8b8b08490",
            "dc3611a1-30cb-4e6c-b8d1-bd602e641c38"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 13.275296491566056,
        "firm_capacity": 22.863,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 22.863,
        "local_dem_headroom": 9.587703508433943
    }
]
enw_primary_bamber_bridge 53.73471 -2.66173 400201 enw_bsp_ribble 400421 0 0
[]
22.863 9.587703508433943
85 85 barbara primary 0 enw
[
    "3b435e0f-707f-423a-aae9-67bcb4ad0511"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "barbar_33_t12",
            "barbar_33_t11"
        ],
        "node_id_1": [
            "51bd3c2e-dd02-4313-8084-853c63cd69d6",
            "2bb72cf4-3861-4139-8fa1-6779745cbff0"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "barbar_33_t12barbar_6.6_bto_icn",
            "barbar_33_t11barbar_6.6_ato_icn"
        ],
        "node_id_2": [
            "d7ca39e6-66d1-438c-8e19-0f194316c882",
            "45270555-4e94-4f46-911a-ff92e483545a"
        ],
        "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": 13.043566886312167,
        "firm_capacity": 15.6,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 15.6,
        "local_dem_headroom": 2.5564331136878327
    }
]
enw_primary_barbara 53.56417 -2.44396 200104 enw_bsp_bolton 200111 enw_gsp_kearsley 200220
[]
15.6 2.5564331136878327
86 86 barrow devonshire rd primary 0 enw
[
    "8e608534-ede1-4562-a08b-effa241561c5"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "barrow_33_bbarrow_11_bfrom_icn",
            "barrow_33_abarrow_11_afrom_icn"
        ],
        "node_id_1": [
            "64488b9d-177a-43c2-b295-1751e0d44727",
            "32232cd9-ee2b-4fbd-85fa-1457165c4f3c"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "barrow_33_bbarrow_11_bto_icn",
            "barrow_33_abarrow_11_ato_icn"
        ],
        "node_id_2": [
            "077a9c4d-bf37-4eba-af47-6ab96d4b3a56",
            "059b827f-80a0-448f-b513-aa654b660b8d"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 12.5,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_530"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 9.35412810545146,
        "firm_capacity": 23.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 10.5,
        "local_dem_headroom": 13.64587189454854
    }
]
enw_primary_barrow_devonshire_rd 54.12391 -3.23018 609001 enw_bsp_sandgate 609001 enw_gsp_harker_hutton 609600
[]
10.5 13.64587189454854
87 87 barton dock rd primary 0 enw
[
    "d10ab3fc-a0e4-4b60-8327-f3498e4ef1a5"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "bardrd_33_t12",
            "bardrd_33_t11"
        ],
        "node_id_1": [
            "6cd08f8f-83ab-4380-adc3-a25a5e720867",
            "d9097235-172d-4923-9973-65b3e6bd21ee"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "bardrd_33_t12bardrd_6.6_bto_icn",
            "bardrd_33_t11bardrd_6.6_ato_icn"
        ],
        "node_id_2": [
            "89e238e3-1147-446c-bc80-bbe1126d042b",
            "351bba60-0482-4ddc-a526-6807d5cdc8f2"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            16.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 8.774232623708887,
        "firm_capacity": 12.5,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 12.5,
        "local_dem_headroom": 3.725767376291113
    }
]
enw_primary_barton_dock_rd 53.47087 -2.35076 100611 enw_bsp_barton 100501 0 100092
[]
12.5 3.725767376291113
88 88 bedford primary 0 enw
[
    "4c1cb5c9-c92f-4b79-80a8-6c877ffd32f8"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "bedford_33_t12",
            "bedford_33_t11"
        ],
        "node_id_1": [
            "06893b74-e23a-4d48-b06c-1c7133e2b671",
            "0138cda9-acdb-470a-8883-47ff7dac9ea2"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "bedford_33_t12bedford_11_bto_icn",
            "bedford_33_t11bedford_11_ato_icn"
        ],
        "node_id_2": [
            "663894ea-e9bc-4f0f-8ad0-1ffe8f6b1569",
            "53c2dedc-7a2e-44b9-a02e-1a4c64f382c6"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 17.798736492920252,
        "firm_capacity": 23.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 23.0,
        "local_dem_headroom": 5.201263507079748
    }
]
enw_primary_bedford 53.4946 -2.51025 205315 enw_bsp_atherton 205317 enw_gsp_kearsley 200220
[]
23.0 5.201263507079748
89 89 belgrave primary 0 enw
[
    "073cfc7e-975e-44fa-b57a-265e8af77fdf"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "belgra_33_t12",
            "belgra_33_t11"
        ],
        "node_id_1": [
            "6f9268c7-1b29-4b81-9c0c-70523eda69e0",
            "0471ebf6-0403-4f37-88ac-685d08321246"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "belgra_33_t12belgra_6.6_bto_icn",
            "belgra_33_t11belgra_6.6_ato_icn"
        ],
        "node_id_2": [
            "015c4d1b-ec7a-4dad-bb03-9f27808121a5",
            "da3c04ea-8554-4794-9004-55bc6f4552a4"
        ],
        "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": 8.85092701070618,
        "firm_capacity": 17.5,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 17.5,
        "local_dem_headroom": 8.64907298929382
    }
]
enw_primary_belgrave 53.52691 -2.10682 300832 enw_bsp_greenhill 300024 0 0
[]
17.5 8.64907298929382
90 90 benchill primary 0 enw
[
    "8c34c3e0-3702-4d01-a189-6e3b369e0a42"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "benchi_33_t11"
        ],
        "node_id_1": [
            "76b33273-6a35-408b-8955-47fd5461ca9e"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "benchi_33_t11benchi_11_ato_icn"
        ],
        "node_id_2": [
            "ccd63449-e76d-4997-be34-d3b464368c5b"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            17.5
        ],
        "eme_rating": [],
        "transformer_count": 1,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 3.8335623355843214,
        "firm_capacity": 12.0,
        "spare": [
            false
        ],
        "local_gen_headroom": 12.0,
        "local_dem_headroom": 8.166437664415678
    }
]
enw_primary_benchill 53.38859 -2.26507 100104 0 0 enw_gsp_south_manchester 100091
[]
12.0 8.166437664415678
91 91 bentham primary 0 enw
[
    "1d4f6c61-f028-480f-9eae-42874ca0dac5"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "bentha_33_abentha_11_afrom_icn"
        ],
        "node_id_1": [
            "1df72a86-65ce-4e6c-9cb4-408af038fbfe"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "bentha_33_abentha_11_ato_icn"
        ],
        "node_id_2": [
            "eea09210-e78a-489c-9365-452fa81d8563"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            8.127
        ],
        "eme_rating": [],
        "transformer_count": 1,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 4.4583105339188105,
        "firm_capacity": 5.5,
        "spare": [
            false
        ],
        "local_gen_headroom": 5.5,
        "local_dem_headroom": 1.0416894660811895
    }
]
enw_primary_bentham 54.12591 -2.50852 609963 enw_bsp_kendal 609051 enw_gsp_harker_hutton 609600
[]
5.5 1.0416894660811895
92 92 bispham primary 0 enw
[
    "ec0e01ec-4a16-4d81-b6c9-6108d7764151"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "moorpk_33_tee",
            "bispha_33_bbispha_6.6_cfrom_icn"
        ],
        "node_id_1": [
            "68154e67-c0a5-4407-8a2e-7bda30a1f84b",
            "d0117e02-21c8-421e-aed4-20e966d08bf2"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "moorpk_33_teebispha_6.6_ato_icn",
            "bispha_33_bbispha_6.6_bto_icn"
        ],
        "node_id_2": [
            "0caf99b6-2cd9-4cea-b863-173a042e7659",
            "d57b25a3-f44e-4b8c-b29a-3eb8cb00baac"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 16.416799358299734,
        "firm_capacity": 22.863,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 22.863,
        "local_dem_headroom": 6.4462006417002655
    }
]
enw_primary_bispham 53.84897 -3.04054 400102 enw_bsp_bispham 400102 enw_gsp_penwortham_east_rochdale 400240
[]
22.863 6.4462006417002655
93 93 blackbull primary 0 enw
[
    "75547665-5a90-46eb-8525-d33a0b6be87a"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "blabul_33_t12",
            "blabul_33_t11"
        ],
        "node_id_1": [
            "9faa0766-5227-4d09-83f5-cd2f8a1b623d",
            "b19d1c33-96fd-4c47-8a40-c889fb78514a"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "blabul_33_bblabul_6.6_bto_icn",
            "blabul_33_ablabul_6.6_ato_icn"
        ],
        "node_id_2": [
            "40e12421-f35e-479d-a73e-9f42a3fd18e6",
            "9ce44c1e-af51-47f2-894c-881b269a54af"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 16.921869223054568,
        "firm_capacity": 22.863,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 22.863,
        "local_dem_headroom": 5.941130776945432
    }
]
enw_primary_blackbull 53.79123 -2.71458 400403 enw_bsp_ribble 400421 0 0
[]
22.863 5.941130776945432
94 94 blackburn primary 0 enw
[
    "ccaff536-eba3-4316-bdd4-066d1e83e16e"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "blackb_33_ablackb_6.6_afrom_icn",
            "samlzo_33_te2"
        ],
        "node_id_1": [
            "169641ef-4644-452b-af1f-cfd00ee5708c",
            "4d358162-e130-4df1-899b-31392de81462"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "blackb_33_ablackb_6.6_ato_icn",
            "samlzo_33_te2blackb_6.6_bto_icn"
        ],
        "node_id_2": [
            "90cb7897-5231-4dfd-a873-eea49350e329",
            "052e58f6-7506-4e48-94da-b57e95c4dbff"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            32.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 20.525160324014774,
        "firm_capacity": 42.183,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 42.183,
        "local_dem_headroom": 21.657839675985226
    }
]
enw_primary_blackburn 53.7592 -2.44764 400001 enw_bsp_blackburn 400001 0 0
[]
42.183 21.657839675985226
95 95 blackfriars primary 0 enw
[
    "d0daa524-02ef-47d4-8452-f4dc51a13015"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "blafri_33_t11",
            "blafri_33_bblafri_6.6_bfrom_icn"
        ],
        "node_id_1": [
            "d89a4cfc-22b2-4b44-96d5-14aff9434f30",
            "4a062340-8eda-4237-befa-992b6849a66c"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "blafri_33_t11blafri_6.6_ato_icn",
            "blafri_33_bblafri_6.6_bto_icn"
        ],
        "node_id_2": [
            "607814a0-93ef-46a1-95f7-0ac1ca9fc6ef",
            "c9ed46d5-0b21-467b-a1ce-b545de39cb56"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 12.238689076833886,
        "firm_capacity": 17.8,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 17.8,
        "local_dem_headroom": 5.561310923166115
    }
]
enw_primary_blackfriars 53.48826 -2.25719 100639 0 100504 enw_gsp_kearsley 200220
[]
17.8 5.561310923166115
96 96 blackley primary 0 enw
[
    "ede6d12f-8ea4-4281-8d53-446a90694132"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "blackl_33_t12",
            "blackl_33_t11"
        ],
        "node_id_1": [
            "df4cbb87-d0fe-4936-b7b7-6a0f22ed2c77",
            "1e0330d4-f9bc-42b5-9f43-f53480d01564"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "blackl_33_t12blackl_6.6_bto_icn",
            "blackl_33_t11blackl_6.6_ato_icn"
        ],
        "node_id_2": [
            "325780e3-58aa-4f9d-bf6d-fc7efc6e6e68",
            "45b1b455-720c-4963-b7e3-6f52ac686226"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 12.46000183880961,
        "firm_capacity": 22.863,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 22.863,
        "local_dem_headroom": 10.40299816119039
    }
]
enw_primary_blackley 53.52561 -2.24495 100605 enw_bsp_red_bank 100503 0 0
[]
22.863 10.40299816119039
97 97 blackpool primary 0 enw
[
    "d9fa6c43-c518-40b6-b807-00b1c69c473b"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "blackp_33_bblackp_6.6_bfrom_icn",
            "blackp_33_ablackp_6.6_afrom_icn"
        ],
        "node_id_1": [
            "ac8f568e-971a-4b31-acc4-4a6e54ed479b",
            "97c8cbb3-29a4-4f44-83ac-85a7b10a444a"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "blackp_33_bblackp_6.6_bto_icn",
            "blackp_33_ablackp_6.6_ato_icn"
        ],
        "node_id_2": [
            "c7bcecea-14e8-417b-b46f-ed0e61193798",
            "2f491f25-67b5-4be5-8d14-299ff74e8355"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            32.0,
            26.46
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 11.040925924903547,
        "firm_capacity": 23.75,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 23.75,
        "local_dem_headroom": 12.709074075096453
    }
]
enw_primary_blackpool 53.80944 -3.05179 400113 enw_bsp_blackpool 400113 enw_gsp_penwortham_east_rochdale 400240
[]
23.75 12.709074075096453
98 98 bollington primary 0 enw
[
    "cae2048a-07dd-4fa7-afed-a27a837d3cef"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "boling_33_aboling_11_afrom_icn",
            "boling_33_bboling_11_bfrom_icn"
        ],
        "node_id_1": [
            "4c87ec59-859b-4bfc-982d-3521d80d82a2",
            "d2dfbb6e-cf02-4ee5-a5c3-241a75012413"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "boling_33_aboling_11_ato_icn",
            "boling_33_bboling_11_bto_icn"
        ],
        "node_id_2": [
            "82f537ff-8d54-4f8e-981a-8bbdfa2ecf39",
            "e4d39ac4-7e98-482a-8467-ca469669ef7a"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            13.0,
            13.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 8.497430159944358,
        "firm_capacity": 13.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 13.0,
        "local_dem_headroom": 4.502569840055642
    }
]
enw_primary_bollington 53.29769 -2.10626 301435 0 0 0 0
[]
13.0 4.502569840055642
99 99 bolton by bowland primary 0 enw
[
    "09953b20-51c1-4a77-a0d9-ad57471135ac"
]
[
    11.0,
    33.0
]
[
    {
        "node_1": [
            "bobybo_33_t11bobybo_11_afrom_icn"
        ],
        "node_id_1": [
            "d18b98e6-0f07-4d07-87c0-1968489fc7e8"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "bobybo_33_t11bobybo_11_ato_icn"
        ],
        "node_id_2": [
            "e9ef641f-810a-4625-9d1c-301ef073df4b"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            9.5
        ],
        "eme_rating": [],
        "transformer_count": 1,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 3.1877991837999904,
        "firm_capacity": 3.0,
        "spare": [
            false
        ],
        "local_gen_headroom": 3.0,
        "local_dem_headroom": -0.1877991837999904
    }
]
enw_primary_bolton_by_bowland 53.59102 -2.42059 200114 enw_bsp_bolton 200111 enw_gsp_kearsley 200220
[]
3.0 -0.1877991837999904
100 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "distribution_substations" (
"location" TEXT,
  "type" TEXT,
  "licence" TEXT,
  "source" TEXT,
  "substation_ids" TEXT,
  "voltages" TEXT,
  "transformers" TEXT,
  "substation_type_id" TEXT,
  "latitude" REAL,
  "longitude" REAL,
  "source_id" TEXT,
  "bsp_group_id" TEXT,
  "bsp_group_name" TEXT,
  "gsp_group_id" TEXT,
  "gsp_group_name" TEXT,
  "other_substation_ids" TEXT,
  "global_gen_headroom" REAL,
  "global_dem_headroom" REAL
);
Powered by Datasette · Queries took 1.2ms