viewcalc_parliament_composition

Table actions

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

10 rows where cabinet_formation = 1 and "date" is on date 2011-10-20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: seats, date (date), calculation_date (date)

Link rowid ▼ election_id date party_id seats cabinet_id cabinet_formation calculation_date
16011 16011 524 2011-10-20 220 62 982 1 2023-03-13 20:38:18
16012 16012 524 2011-10-20 1460 17 982 1 2023-03-13 20:38:18
16013 16013 524 2011-10-20 1620 10 982 1 2023-03-13 20:38:18
16014 16014 524 2011-10-20 1432 14 982 1 2023-03-13 20:38:18
16015 16015 524 2011-10-20 131 28 982 1 2023-03-13 20:38:18
16016 16016 524 2011-10-20 1072 7 982 1 2023-03-13 20:38:18
16017 16017 524 2011-10-20 1759 4 982 1 2023-03-13 20:38:18
16018 16018 524 2011-10-20 1645 4 982 1 2023-03-13 20:38:18
16019 16019 524 2011-10-20 1359 2 982 1 2023-03-13 20:38:18
16020 16020 524 2011-10-20 2391 2 982 1 2023-03-13 20:38:18

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE `viewcalc_parliament_composition` (
  `election_id` INTEGER,
  `date` TEXT,
  `party_id` INTEGER,
  `seats` INTEGER,
  `cabinet_id` INTEGER,
  `cabinet_formation` INTEGER,
  `calculation_date` TEXT
);