primary

Tables

ecr

customer_name, customer_site, address_line_1, address_line_2, city, county, postcode, gsp, bsp, primary, voltage, energy_source, connection_status, connected_export, accepted_export, accepted_import, date_accepted, date_published, source, lat, lon, project_id, location_gsp, location_bsp, location_primary, substation_id_gsp, substation_id_bsp, substation_id_primary, retain_edits

>10,000 rows

metadata

date, host, user, git_commit_id, git_branch

1 row

tec

customer_site, customer_name, connection_site, stage, connected, target_energisation_date, connection_status, source, plant_type, project_id, location, x_site_type, x_site_code, type, substation_id, retain_edits

2,080 rows

transformer_flows

name, voltage, firm_capacity, type, date_published, source, max_transformer_flow, min_transformer_flow, location, source_id, substation_id, transformer_flow_id, retain_edits

5,760 rows

transformers

substation_id, voltage_node_1, voltage_node_2, gsp_group, location, licence, source, date_published, type, transformer_id, transformers, retain_edits

5,061 rows

transformers_transmission

substation_id, source_id, location, site_code, all_voltage, name, type, source, transformer_id, transformers, retain_edits

534 rows