transmission_circuits: 100

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
100 brin22 chte21 0.0 ohl 1018.0 eso nget 2024 current 275.0 1018.0 eso_nget_gsp_brinsworth "brin2" brinsworth brin "[275.0, 400.0]" brinsworth gsp eso nget 
[
    "eso_nget_transformer_112",
    "eso_nget_transformer_111"
]
 "[{\"transformer_id\": [\"eso_nget_transformer_111\", \"eso_nget_transformer_112\"], \"node_1\": [\"brin4\"], \"voltage_1\": 400.0, \"node_2\": [\"brin2\"], \"voltage_2\": 275.0, \"nom_rating\": [1117.0, 1100.0], \"transformer_count\": 2, \"year\": [2024.0, 2024.0], \"status\": [\"current\", \"current\"]}]" 2.0 0 -1.3496464278446505 53.40110368809431 eso_nget_gsp_chesterfield chte2 chesterfield chte 
[
    132.0,
    275.0,
    400.0
]
 chesterfield gsp eso nget 
[
    "eso_nget_transformer_162",
    "eso_nget_transformer_166",
    "eso_nget_transformer_172",
    "eso_nget_transformer_160",
    "eso_nget_transformer_168",
    "eso_nget_transformer_170",
    "eso_nget_transformer_171",
    "eso_nget_transformer_169",
    "eso_nget_transformer_165",
    "eso_nget_transformer_161",
    "eso_nget_transformer_164",
    "eso_nget_transformer_167",
    "eso_nget_transformer_163",
    "eso_nget_transformer_159"
]
 
[
    {
        "transformer_id": [
            "eso_nget_transformer_159",
            "eso_nget_transformer_160",
            "eso_nget_transformer_161",
            "eso_nget_transformer_162",
            "eso_nget_transformer_163",
            "eso_nget_transformer_164",
            "eso_nget_transformer_165",
            "eso_nget_transformer_166"
        ],
        "node_1": [
            "chte2"
        ],
        "voltage_1": 275.0,
        "node_2": [
            "chte1"
        ],
        "voltage_2": 132.0,
        "nom_rating": [
            261.0,
            240.0,
            278.0,
            251.0,
            261.0,
            240.0,
            278.0,
            251.0
        ],
        "transformer_count": 8,
        "year": [
            2024.0,
            2024.0,
            2024.0,
            2024.0,
            2029.0,
            2029.0,
            2029.0,
            2029.0
        ],
        "status": [
            "current",
            "current",
            "current",
            "current",
            "removed",
            "removed",
            "removed",
            "removed"
        ]
    },
    {
        "transformer_id": [
            "eso_nget_transformer_167",
            "eso_nget_transformer_168",
            "eso_nget_transformer_169",
            "eso_nget_transformer_170"
        ],
        "node_1": [
            "chte4"
        ],
        "voltage_1": 400.0,
        "node_2": [
            "chte1"
        ],
        "voltage_2": 132.0,
        "nom_rating": [
            261.0,
            251.0,
            278.0,
            251.0
        ],
        "transformer_count": 4,
        "year": [
            2029.0,
            2029.0,
            2029.0,
            2029.0
        ],
        "status": [
            "addition",
            "addition",
            "addition",
            "addition"
        ]
    },
    {
        "transformer_id": [
            "eso_nget_transformer_171",
            "eso_nget_transformer_172"
        ],
        "node_1": [
            "chte4"
        ],
        "voltage_1": 400.0,
        "node_2": [
            "chte2"
        ],
        "voltage_2": 275.0,
        "nom_rating": [
            1096.0,
            1096.0
        ],
        "transformer_count": 2,
        "year": [
            2029.0,
            2029.0
        ],
        "status": [
            "addition",
            "addition"
        ]
    }
]
 9.0 0.0 -1.388888174521783 53.22457968667555 eso_circuit_99 0