master_data
Tables
distribution_circuits
bsp_group, node_1, node_2, voltage, circuit_length, date_published, source, licence, equipment, gsp_group, node_1_name, node_2_name, rating, status, location_gsp_group, location_bsp_group, substation_id_gsp_group, substation_id_bsp_group, node_1_source_id, node_2_source_id, node_1_type, node_1_substation_id, node_2_type, node_2_substation_id, circuit_id, paths, local_dem_headroom, local_gen_headroom, upstream_constraint_dem, upstream_constraint_gen, is_ignored, retain_edits, global_headroom_dem, global_headroom_gen, comments
Many rows
distribution_substations
name, date_published, source, licence, latitude, longitude, type, location, substation_id, transformers, all_voltage, source_id, connected_export, other_substation_ids, comments, detailed_global_headroom, global_gen_headroom, global_dem_headroom
6,655 rows
transmission_circuits
node_1, node_2, circuit_length, equipment, source, date_published, year, voltage, rating, node_1_substation_id, node_1_name, node_1_type, retain_edits, node_2_substation_id, node_2_name, node_2_type, circuit_id, is_ignored, comments
2,385 rows
transmission_substations
substation_id, source_id, location, all_voltage, name, type, source, transformers, longitude, latitude, connected, diagram_url
534 rows
transmission_tec
customer_site, customer_name, connection_site, stage, connected, target_energisation_date, connection_status, source, plant_type, project_id, location, type, substation_id, retain_edits, source_id
1,102 rows