external_party_chess
Data source: ParlGov · About: simonw/parlgov-datasette
8 rows where country = 11
This data as json, CSV (advanced)
id ▼ | country | name_short | name | name_english |
---|---|---|---|---|
1101 | 11 | Cons | Conservative Party | Conservative Party |
1102 | 11 | Lab | Labour Party | Labour Party |
1104 | 11 | LibDems | Liberal Democratic Party | Liberal Democratic Party |
1105 | 11 | SNP | Scottish National Party | Scottish National Party |
1106 | 11 | Plaid | Plaid Cymru | Party of Wales |
1107 | 11 | Greens | Green Party | Green Party |
1108 | 11 | UKIP | United Kingdom Independence Party | United Kingdom Independence Party |
1109 | 11 | BNP | British National Party | British National Party |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "external_party_chess" ( "id" integer unsigned NOT NULL PRIMARY KEY, "country" integer unsigned NOT NULL, "name_short" varchar(10) NOT NULL, "name" varchar(100) NOT NULL, "name_english" varchar(100) NOT NULL ); CREATE INDEX "external_party_chess_a9e7aee" ON "external_party_chess" ("country");