external_party_castles_mair

Table actions

Data source: ParlGov · About: simonw/parlgov-datasette

1 row where name_short = "PvdA" and range_right = "3.0"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ country name name_english name_short range_left range_right left_right respondents
1104 NLD Partij van de Arbeid Labour PvdA 2.0 3.0 2.6 9

Advanced export

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

CSV options: 

CREATE TABLE "external_party_castles_mair" (
    "id" integer unsigned NOT NULL PRIMARY KEY,
    "country" varchar(20) NOT NULL,
    "name" varchar(100) NOT NULL,
    "name_english" varchar(100) NOT NULL,
    "name_short" varchar(100) NOT NULL,
    "range_left" real,
    "range_right" real,
    "left_right" real,
    "respondents" integer unsigned
);
CREATE INDEX "external_party_castles_mair_a9e7aee" ON "external_party_castles_mair" ("country");