countries

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

3 rows where parent_country_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

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]);