viewcalc_parliament_composition

Table actions

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

23 rows where "date" is on date 1970-05-14

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: election_id, seats, cabinet_id, cabinet_formation, date (date), calculation_date (date)

Link rowid ▼ election_id date party_id seats cabinet_id cabinet_formation calculation_date
6502 6502 204 1970-05-14 625 1 172 0 2023-03-13 20:38:18
6503 6503 204 1970-05-14 1452 4 172 0 2023-03-13 20:38:18
6504 6504 204 1970-05-14 405 12 172 0 2023-03-13 20:38:18
6505 6505 204 1970-05-14 1409 17 172 0 2023-03-13 20:38:18
6506 6506 204 1970-05-14 742 34 172 0 2023-03-13 20:38:18
6507 6507 204 1970-05-14 345 7 172 0 2023-03-13 20:38:18
6508 6508 204 1970-05-14 300 15 172 0 2023-03-13 20:38:18
6509 6509 204 1970-05-14 1194 5 172 0 2023-03-13 20:38:18
6510 6510 204 1970-05-14 451 38 172 0 2023-03-13 20:38:18
6511 6511 204 1970-05-14 1595 7 172 0 2023-03-13 20:38:18
6512 6512 204 1970-05-14 1251 3 172 0 2023-03-13 20:38:18
6513 6513 204 1970-05-14 342 4 172 0 2023-03-13 20:38:18
6514 6514 204 1970-05-14 402 3 172 0 2023-03-13 20:38:18
14092 14092 77 1970-05-14 1292 36 707 1 2023-03-13 20:38:18
14093 14093 77 1970-05-14 66 1 707 1 2023-03-13 20:38:18
14094 14094 77 1970-05-14 200 18 707 1 2023-03-13 20:38:18
14095 14095 77 1970-05-14 585 11 707 1 2023-03-13 20:38:18
14096 14096 77 1970-05-14 395 52 707 1 2023-03-13 20:38:18
14097 14097 77 1970-05-14 1219 8 707 1 2023-03-13 20:38:18
14098 14098 77 1970-05-14 1118 37 707 1 2023-03-13 20:38:18
14099 14099 77 1970-05-14 94 36 707 1 2023-03-13 20:38:18
14100 14100 77 1970-05-14 1463 1 707 1 2023-03-13 20:38:18
20661 20661 77 1970-05-14 1119 0 707 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
);