home / master_data / transmission_circuits

transmission_circuits: 35

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
35 bedd23 wimb2a 0.582 composite 728.0 eso nget 2024 current 275.0 728.0 eso_nget_gsp_beddington "bedd2" beddington bedd "[132.0, 275.0, 400.0]" beddington gsp eso nget
[
    "eso_nget_transformer_42",
    "eso_nget_transformer_38",
    "eso_nget_transformer_40",
    "eso_nget_transformer_37",
    "eso_nget_transformer_39",
    "eso_nget_transformer_44",
    "eso_nget_transformer_45",
    "eso_nget_transformer_43",
    "eso_nget_transformer_41",
    "eso_nget_transformer_46"
]
"[{\"transformer_id\": [\"eso_nget_transformer_37\", \"eso_nget_transformer_38\", \"eso_nget_transformer_39\", \"eso_nget_transformer_40\", \"eso_nget_transformer_41\", \"eso_nget_transformer_42\"], \"node_1\": [\"bedd2\"], \"voltage_1\": 275.0, \"node_2\": [\"bedd1\", \"bedt1\"], \"voltage_2\": 132.0, \"nom_rating\": [258.0, 264.0, 133.0, 273.0, 273.0, 126.0], \"transformer_count\": 6, \"year\": [2024.0, 2024.0, 2024.0, 2024.0, 2024.0, 2024.0], \"status\": [\"current\", \"current\", \"current\", \"current\", \"current\", \"current\"]}, {\"transformer_id\": [\"eso_nget_transformer_43\", \"eso_nget_transformer_44\", \"eso_nget_transformer_45\", \"eso_nget_transformer_46\"], \"node_1\": [\"bedd4\"], \"voltage_1\": 400.0, \"node_2\": [\"bedd2\"], \"voltage_2\": 275.0, \"nom_rating\": [797.0, 797.0, 800.0, 950.0], \"transformer_count\": 4, \"year\": [2024.0, 2024.0, 2024.0, 2024.0], \"status\": [\"current\", \"current\", \"current\", \"current\"]}]" 8.0 0 -0.12843492903589152 51.37307940273063 eso_nget_gsp_wimbledon wimb2 wimbledon wimb
[
    132.0,
    275.0,
    400.0
]
wimbledon gsp eso nget
[
    "eso_nget_transformer_975",
    "eso_nget_transformer_976",
    "eso_nget_transformer_973",
    "eso_nget_transformer_974",
    "eso_nget_transformer_978",
    "eso_nget_transformer_979",
    "eso_nget_transformer_971",
    "eso_nget_transformer_977",
    "eso_nget_transformer_980",
    "eso_nget_transformer_972"
]
[
    {
        "transformer_id": [
            "eso_nget_transformer_971",
            "eso_nget_transformer_980"
        ],
        "node_1": [
            "wimb2"
        ],
        "voltage_1": 275.0,
        "node_2": [
            "wimb1"
        ],
        "voltage_2": 132.0,
        "nom_rating": [
            255.0,
            255.0
        ],
        "transformer_count": 2,
        "year": [
            2024.0,
            2025.0
        ],
        "status": [
            "current",
            "removed"
        ]
    },
    {
        "transformer_id": [
            "eso_nget_transformer_972",
            "eso_nget_transformer_973",
            "eso_nget_transformer_974",
            "eso_nget_transformer_975",
            "eso_nget_transformer_976",
            "eso_nget_transformer_977"
        ],
        "node_1": [
            "wimb4"
        ],
        "voltage_1": 400.0,
        "node_2": [
            "wimb1"
        ],
        "voltage_2": 132.0,
        "nom_rating": [
            240.0,
            240.0,
            240.0,
            240.0,
            240.0,
            240.0
        ],
        "transformer_count": 6,
        "year": [
            2024.0,
            2024.0,
            2024.0,
            2024.0,
            2024.0,
            2024.0
        ],
        "status": [
            "current",
            "current",
            "current",
            "current",
            "current",
            "current"
        ]
    },
    {
        "transformer_id": [
            "eso_nget_transformer_978",
            "eso_nget_transformer_979"
        ],
        "node_1": [
            "wimb4"
        ],
        "voltage_1": 400.0,
        "node_2": [
            "wimb2"
        ],
        "voltage_2": 275.0,
        "nom_rating": [
            950.0,
            950.0
        ],
        "transformer_count": 2,
        "year": [
            2024.0,
            2024.0
        ],
        "status": [
            "current",
            "current"
        ]
    }
]
9.0 0.0 -0.1886627061060906 51.43012144822421 eso_circuit_34 0
Powered by Datasette · Queries took 4.351ms