viewcalc_parliament_composition

Table actions

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

23 rows where "date" is on date 2006-04-09

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ election_id date party_id seats cabinet_id cabinet_formation calculation_date
504 504 107 2006-04-09 1321 41 567 0 2023-03-13 20:38:18
505 505 107 2006-04-09 1296 18 567 0 2023-03-13 20:38:18
506 506 107 2006-04-09 1048 220 567 0 2023-03-13 20:38:18
507 507 107 2006-04-09 52 4 567 0 2023-03-13 20:38:18
508 508 107 2006-04-09 910 15 567 0 2023-03-13 20:38:18
509 509 107 2006-04-09 1436 26 567 0 2023-03-13 20:38:18
510 510 107 2006-04-09 2302 1 567 0 2023-03-13 20:38:18
511 511 107 2006-04-09 1063 1 567 0 2023-03-13 20:38:18
512 512 107 2006-04-09 399 10 567 0 2023-03-13 20:38:18
513 513 107 2006-04-09 1661 16 567 0 2023-03-13 20:38:18
514 514 107 2006-04-09 1030 4 567 0 2023-03-13 20:38:18
515 515 107 2006-04-09 927 1 567 0 2023-03-13 20:38:18
516 516 107 2006-04-09 596 140 567 0 2023-03-13 20:38:18
517 517 107 2006-04-09 1246 6 567 0 2023-03-13 20:38:18
518 518 107 2006-04-09 373 71 567 0 2023-03-13 20:38:18
519 519 107 2006-04-09 226 39 567 0 2023-03-13 20:38:18
520 520 107 2006-04-09 693 17 567 0 2023-03-13 20:38:18
900 900 194 2006-04-09 434 23 188 0 2023-03-13 20:38:18
901 901 194 2006-04-09 952 1 188 0 2023-03-13 20:38:18
902 902 194 2006-04-09 1426 20 188 0 2023-03-13 20:38:18
903 903 194 2006-04-09 546 11 188 0 2023-03-13 20:38:18
904 904 194 2006-04-09 921 141 188 0 2023-03-13 20:38:18
905 905 194 2006-04-09 1591 190 188 0 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
);