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: ons_linked

id ▼ name geographic_code ons_linked parent_country_id
1 Great Britain K03000001 0  
2 England E92000001 1 Great Britain 1
3 Ireland      
4 Northern Ireland N92000002 1  
5 Scotland S92000003 1 Great Britain 1
6 Wales W92000004 1 Great Britain 1

Advanced export

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

CSV options: 

CREATE TABLE "countries" (
   [id] INTEGER PRIMARY KEY,
   [name] TEXT,
   [geographic_code] TEXT,
   [ons_linked] INTEGER,
   [parent_country_id] INTEGER REFERENCES [countries]([id])
);
CREATE INDEX [idx_countries_parent_country_id]
    ON [countries] ([parent_country_id]);