viewcalc_parliament_composition

Table actions

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

22 rows where "date" is on date 2008-09-21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: seats, cabinet_formation, calculation_date (date)

Link rowid ▼ election_id date party_id seats cabinet_id cabinet_formation calculation_date
2379 2379 522 2008-09-21 326 9 407 0 2023-03-13 20:38:18
2380 2380 522 2008-09-21 981 5 407 0 2023-03-13 20:38:18
2381 2381 522 2008-09-21 706 29 407 0 2023-03-13 20:38:18
2382 2382 522 2008-09-21 65 1 407 0 2023-03-13 20:38:18
2383 2383 522 2008-09-21 179 28 407 0 2023-03-13 20:38:18
2384 2384 522 2008-09-21 199 1 407 0 2023-03-13 20:38:18
2385 2385 522 2008-09-21 16 5 407 0 2023-03-13 20:38:18
2386 2386 522 2008-09-21 1587 7 407 0 2023-03-13 20:38:18
2387 2387 522 2008-09-21 1252 5 407 0 2023-03-13 20:38:18
17074 17074 720 2008-09-21 1870 29 1135 1 2023-03-13 20:38:18
17075 17075 720 2008-09-21 244 19 1135 1 2023-03-13 20:38:18
17076 17076 720 2008-09-21 788 12 1135 1 2023-03-13 20:38:18
17077 17077 720 2008-09-21 678 12 1135 1 2023-03-13 20:38:18
17078 17078 720 2008-09-21 1816 11 1135 1 2023-03-13 20:38:18
17079 17079 720 2008-09-21 1357 9 1135 1 2023-03-13 20:38:18
17080 17080 720 2008-09-21 1873 4 1135 1 2023-03-13 20:38:18
17081 17081 720 2008-09-21 1303 6 1135 1 2023-03-13 20:38:18
17082 17082 720 2008-09-21 1419 5 1135 1 2023-03-13 20:38:18
17083 17083 720 2008-09-21 1846 4 1135 1 2023-03-13 20:38:18
17084 17084 720 2008-09-21 732 3 1135 1 2023-03-13 20:38:18
17085 17085 720 2008-09-21 805 3 1135 1 2023-03-13 20:38:18
17086 17086 720 2008-09-21 123 3 1135 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
);