home / master_data / transmission_circuits

transmission_circuits: 28

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
28 bark41 wham41 0.124 composite 1710.0 eso nget 2024 current 400.0 1710.0 eso_nget_gsp_barking "bark4" barking bark "[132.0, 275.0, 400.0]" barking gsp eso nget
[
    "eso_nget_transformer_27",
    "eso_nget_transformer_24",
    "eso_nget_transformer_29",
    "eso_nget_transformer_34",
    "eso_nget_transformer_30",
    "eso_nget_transformer_32",
    "eso_nget_transformer_31",
    "eso_nget_transformer_25",
    "eso_nget_transformer_33",
    "eso_nget_transformer_28",
    "eso_nget_transformer_26"
]
"[{\"transformer_id\": [\"eso_nget_transformer_26\", \"eso_nget_transformer_27\", \"eso_nget_transformer_30\", \"eso_nget_transformer_31\", \"eso_nget_transformer_32\"], \"node_1\": [\"bark2\"], \"voltage_1\": 275.0, \"node_2\": [\"barw3\"], \"voltage_2\": 33.0, \"nom_rating\": [109.0, 110.0, 110.0, 109.0, 100.0], \"transformer_count\": 5, \"year\": [2024.0, 2024.0, 2024.0, 2024.0, 2024.0], \"status\": [\"current\", \"current\", \"current\", \"current\", \"current\"]}, {\"transformer_id\": [\"eso_nget_transformer_24\", \"eso_nget_transformer_25\", \"eso_nget_transformer_28\", \"eso_nget_transformer_29\"], \"node_1\": [\"bark2\"], \"voltage_1\": 275.0, \"node_2\": [\"bark1\"], \"voltage_2\": 132.0, \"nom_rating\": [278.0, 268.0, 217.0, 240.0], \"transformer_count\": 4, \"year\": [2024.0, 2024.0, 2024.0, 2024.0], \"status\": [\"current\", \"current\", \"current\", \"current\"]}, {\"transformer_id\": [\"eso_nget_transformer_33\", \"eso_nget_transformer_34\"], \"node_1\": [\"bark4\"], \"voltage_1\": 400.0, \"node_2\": [\"bark2\"], \"voltage_2\": 275.0, \"nom_rating\": [817.0, 817.0], \"transformer_count\": 2, \"year\": [2024.0, 2024.0], \"status\": [\"current\", \"current\"]}]" 12.0 0 0.11432973749079786 51.52070956227175 eso_nget_gsp_westham wham4 west ham wham
[
    132.0,
    400.0
]
west ham gsp eso nget
[
    "eso_nget_transformer_916",
    "eso_nget_transformer_919",
    "eso_nget_transformer_918",
    "eso_nget_transformer_917"
]
[
    {
        "transformer_id": [
            "eso_nget_transformer_916",
            "eso_nget_transformer_917",
            "eso_nget_transformer_918",
            "eso_nget_transformer_919"
        ],
        "node_1": [
            "wham4"
        ],
        "voltage_1": 400.0,
        "node_2": [
            "wham1"
        ],
        "voltage_2": 132.0,
        "nom_rating": [
            264.0,
            263.0,
            271.0,
            263.0
        ],
        "transformer_count": 4,
        "year": [
            2024.0,
            2024.0,
            2024.0,
            2024.0
        ],
        "status": [
            "current",
            "current",
            "current",
            "current"
        ]
    }
]
2.0 0.0 0.000845029453071954 51.51955812450961 eso_circuit_27 0
Powered by Datasette · Queries took 9.114ms