master_data
Tables schema
distribution_circuits
circuit_id, circuit_name, source, licence, equipment, node_id_1, node_id_2, node_name_1, node_name_2, substation_id_1, substation_id_2, substation_name_1, substation_name_2, rating, circuit_length, normally_open, voltage, gsp_group_id, gsp_group_name, node_1_type, node_1_substation_type_id, node_2_type, node_2_substation_type_id, circuit_gen_headroom, circuit_dem_headroom, global_gen_headroom, global_dem_headroom, upstream_constraint_gen, upstream_constraint_dem, path
>10,000 rows
distribution_projects
customer_name, customer_site, address_line_1, address_line_2, city, county, postcode, gsp, bsp, primary, voltage, licence, energy_source, connection_status, connected_export, date_connected, accepted_export, accepted_import, date_accepted, longitude, latitude, source, gsp_location, bsp_location, primary_location, ecr_project_id, primary_substation_type_id, bsp_substation_type_id, gsp_substation_type_id, country, assumed_bsp_substation, assumed_gsp_substation, outside_bsp_boundary, outside_gsp_boundary, assumed_coordinates, repd_project_id
>10,000 rows
distribution_substations
location, type, licence, source, substation_ids, voltages, transformers, substation_type_id, latitude, longitude, source_id, bsp_group_id, bsp_group_name, gsp_group_id, gsp_group_name, other_substation_ids, global_gen_headroom, global_dem_headroom
4,615 rows
transmission_circuits
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
2,764 rows
transmission_substations
substation_id, source_id, location, site_code, voltages, name, type, source, licence, transformer_id, transformers, transformer_count, retain_edits, longitude, latitude, connected, diagram_url
556 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
918 rows