transmission_circuits: 3

This data as json

rowid node_1 node_2 circuit_length equipment summer_rating source licence year status voltage rating node_1_substation_id source_id node_1_location site_code voltages node_1_name node_1_type source_node_1 licence_node_1 transformer_id transformers transformer_count retain_edits longitude latitude node_2_substation_id source_id_node_2 node_2_location site_code_node_2 voltages_node_2 node_2_name node_2_type source_node_2 licence_node_2 transformer_id_node_2 transformers_node_2 transformer_count_node_2 retain_edits_node_2 longitude_node_2 latitude_node_2 circuit_id is_ignored
3 abha4b exet41 0.0 ohl 2168.0 eso nget 2024 current 400.0 2168.0 eso_nget_gsp_aberthaw "abha4" aberthaw abth "[132.0, 275.0]" aberthaw gsp eso nget 
[
    "eso_nget_transformer_2",
    "eso_nget_transformer_3",
    "eso_nget_transformer_4",
    "eso_nget_transformer_0",
    "eso_nget_transformer_1"
]
 "[{\"transformer_id\": [\"eso_nget_transformer_0\", \"eso_nget_transformer_1\", \"eso_nget_transformer_2\"], \"node_1\": [\"abth2\"], \"voltage_1\": 275.0, \"node_2\": [\"abth1\"], \"voltage_2\": 132.0, \"nom_rating\": [279.0, 211.0, 212.0], \"transformer_count\": 3, \"year\": [2024.0, 2024.0, 2024.0], \"status\": [\"current\", \"current\", \"current\"]}, {\"transformer_id\": [\"eso_nget_transformer_3\", \"eso_nget_transformer_4\"], \"node_1\": [\"abha4\"], \"voltage_1\": 400.0, \"node_2\": [\"abha1\"], \"voltage_2\": 132.0, \"nom_rating\": [275.0, 264.0], \"transformer_count\": 2, \"year\": [2024.0, 2024.0], \"status\": [\"current\", \"current\"]}]" 8.0 0 -3.4031964719859773 51.388336183940226 eso_nget_gsp_exeter exet4 exeter exet 
[
    132.0,
    400.0
]
 exeter gsp eso nget 
[
    "eso_nget_transformer_257",
    "eso_nget_transformer_258",
    "eso_nget_transformer_259"
]
 
[
    {
        "transformer_id": [
            "eso_nget_transformer_257",
            "eso_nget_transformer_258",
            "eso_nget_transformer_259"
        ],
        "node_1": [
            "exet4"
        ],
        "voltage_1": 400.0,
        "node_2": [
            "exet1"
        ],
        "voltage_2": 132.0,
        "nom_rating": [
            278.0,
            278.0,
            269.0
        ],
        "transformer_count": 3,
        "year": [
            2024.0,
            2024.0,
            2024.0
        ],
        "status": [
            "current",
            "current",
            "current"
        ]
    }
]
 2.0 0.0 -3.4051950406148737 50.76753246083073 eso_circuit_2 0