viewcalc_parliament_composition

Table actions

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

22 rows where "date" is on date 1925-10-29

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ election_id date party_id seats cabinet_id cabinet_formation calculation_date
4175 4175 860 1925-10-29 794 116 1168 0 2023-03-13 20:38:18
4176 4176 860 1925-10-29 368 99 1168 0 2023-03-13 20:38:18
4177 4177 860 1925-10-29 2566 24 1168 0 2023-03-13 20:38:18
4178 4178 860 1925-10-29 2427 2 1168 0 2023-03-13 20:38:18
4179 4179 860 1925-10-29 1189 2 1168 0 2023-03-13 20:38:18
4180 4180 860 1925-10-29 2577 2 1168 0 2023-03-13 20:38:18
19605 19605 1035 1925-10-29 649 45 1572 1 2023-03-13 20:38:18
19606 19606 1035 1925-10-29 558 131 1572 1 2023-03-13 20:38:18
19607 19607 1035 1925-10-29 2691 32 1572 1 2023-03-13 20:38:18
19608 19608 1035 1925-10-29 137 69 1572 1 2023-03-13 20:38:18
19609 19609 1035 1925-10-29 2697 19 1572 1 2023-03-13 20:38:18
19610 19610 1035 1925-10-29 2693 51 1572 1 2023-03-13 20:38:18
19611 19611 1035 1925-10-29 2692 103 1572 1 2023-03-13 20:38:18
19612 19612 1035 1925-10-29 2695 14 1572 1 2023-03-13 20:38:18
19613 19613 1035 1925-10-29 2701 5 1572 1 2023-03-13 20:38:18
19614 19614 1035 1925-10-29 2703 4 1572 1 2023-03-13 20:38:18
19615 19615 1035 1925-10-29 2704 2 1572 1 2023-03-13 20:38:18
19616 19616 1035 1925-10-29 2706 1 1572 1 2023-03-13 20:38:18
19617 19617 1035 1925-10-29 2707 1 1572 1 2023-03-13 20:38:18
19618 19618 1035 1925-10-29 2698 12 1572 1 2023-03-13 20:38:18
19619 19619 1035 1925-10-29 2696 4 1572 1 2023-03-13 20:38:18
20804 20804 1035 1925-10-29 610 0 1572 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
);