commons_library_dashboard_countries

Data license: Open Parliament Licence · Data source: UK Parliament election results website

6 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commons_library_dashboard_id, country_id

id ▼ commons_library_dashboard_id country_id
1 Dentists and dental practices 1 England 2
2 GPs and GP practices 2 England 2
3 Health conditions 3 England 2
4 Road traffic collisions and casualties 4 England 2
5 Road traffic collisions and casualties 4 Wales 6
6 Road traffic collisions and casualties 4 Scotland 5

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "commons_library_dashboard_countries" (
   [id] INTEGER PRIMARY KEY,
   [commons_library_dashboard_id] INTEGER REFERENCES [commons_library_dashboards]([id]),
   [country_id] INTEGER REFERENCES [countries]([id])
);
CREATE INDEX [idx_commons_library_dashboard_countries_country_id]
    ON [commons_library_dashboard_countries] ([country_id]);
CREATE INDEX [idx_commons_library_dashboard_countries_commons_library_dashboard_id]
    ON [commons_library_dashboard_countries] ([commons_library_dashboard_id]);