home / master_data / transmission_circuits

transmission_circuits: 48

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
48 birk21 cape21 0.0 ohl 762.0 eso nget 2024 current 275.0 762.0 eso_nget_gsp_birkenhead "birk2" birkenhead birk "[132.0, 275.0]" birkenhead gsp eso nget
[
    "eso_nget_transformer_59",
    "eso_nget_transformer_58",
    "eso_nget_transformer_60"
]
"[{\"transformer_id\": [\"eso_nget_transformer_58\", \"eso_nget_transformer_59\", \"eso_nget_transformer_60\"], \"node_1\": [\"birk2\"], \"voltage_1\": 275.0, \"node_2\": [\"birk1\"], \"voltage_2\": 132.0, \"nom_rating\": [261.0, 261.0, 261.0], \"transformer_count\": 3, \"year\": [2024.0, 2024.0, 2024.0], \"status\": [\"current\", \"current\", \"current\"]}]" 2.0 0 -3.062728858526948 53.36579753109759 eso_nget_gsp_capenhurst cape2 capenhurst cape
[
    132.0,
    275.0,
    400.0
]
capenhurst gsp eso nget
[
    "eso_nget_transformer_135",
    "eso_nget_transformer_130",
    "eso_nget_transformer_136",
    "eso_nget_transformer_131",
    "eso_nget_transformer_133",
    "eso_nget_transformer_134",
    "eso_nget_transformer_132"
]
[
    {
        "transformer_id": [
            "eso_nget_transformer_130",
            "eso_nget_transformer_131",
            "eso_nget_transformer_132",
            "eso_nget_transformer_133",
            "eso_nget_transformer_134"
        ],
        "node_1": [
            "cape2"
        ],
        "voltage_1": 275.0,
        "node_2": [
            "cape1"
        ],
        "voltage_2": 132.0,
        "nom_rating": [
            211.0,
            211.0,
            198.0,
            279.0,
            211.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_135",
            "eso_nget_transformer_136"
        ],
        "node_1": [
            "cape4"
        ],
        "voltage_1": 400.0,
        "node_2": [
            "cape2"
        ],
        "voltage_2": 275.0,
        "nom_rating": [
            845.0,
            886.0
        ],
        "transformer_count": 2,
        "year": [
            2024.0,
            2024.0
        ],
        "status": [
            "current",
            "current"
        ]
    }
]
6.0 0.0 -2.9463373991470823 53.26765416924958 eso_circuit_47 0
Powered by Datasette · Queries took 2.096ms