viewcalc_parliament_composition

Table actions

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

20,841 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ election_id date party_id seats cabinet_id cabinet_formation calculation_date
1 1 1 1972-11-25 997 32 569 0 2023-03-13 20:38:18
2 2 1 1972-11-25 878 55 569 0 2023-03-13 20:38:18
3 3 2 1999-06-13 1029 14 95 0 2023-03-13 20:38:18
4 4 2 1999-06-13 1594 9 95 0 2023-03-13 20:38:18
5 5 2 1999-06-13 1378 19 95 0 2023-03-13 20:38:18
6 6 2 1999-06-13 723 22 95 0 2023-03-13 20:38:18
7 7 2 1999-06-13 171 1 95 0 2023-03-13 20:38:18
8 8 2 1999-06-13 1192 10 95 0 2023-03-13 20:38:18
9 9 2 1999-06-13 454 18 95 0 2023-03-13 20:38:18
10 10 2 1999-06-13 161 11 95 0 2023-03-13 20:38:18
11 11 2 1999-06-13 290 8 95 0 2023-03-13 20:38:18
12 12 2 1999-06-13 993 15 95 0 2023-03-13 20:38:18
13 13 2 1999-06-13 1110 23 95 0 2023-03-13 20:38:18
14 14 3 2005-09-12 1435 23 300 0 2023-03-13 20:38:18
15 15 3 2005-09-12 1538 11 300 0 2023-03-13 20:38:18
16 16 3 2005-09-12 647 10 300 0 2023-03-13 20:38:18
17 17 3 2005-09-12 104 61 300 0 2023-03-13 20:38:18
18 18 3 2005-09-12 702 11 300 0 2023-03-13 20:38:18
19 19 3 2005-09-12 81 15 300 0 2023-03-13 20:38:18
20 20 3 2005-09-12 351 38 300 0 2023-03-13 20:38:18
21 21 6 1977-06-16 318 17 315 0 2023-03-13 20:38:18
22 22 6 1977-06-16 1393 43 315 0 2023-03-13 20:38:18
23 23 6 1977-06-16 30 4 315 0 2023-03-13 20:38:18
24 24 6 1977-06-16 280 84 315 0 2023-03-13 20:38:18
25 25 8 1971-06-14 1003 28 681 0 2023-03-13 20:38:18
26 26 8 1971-06-14 984 27 681 0 2023-03-13 20:38:18
27 27 11 1953-02-22 769 4 560 0 2023-03-13 20:38:18
28 28 11 1953-02-22 50 14 560 0 2023-03-13 20:38:18
29 29 11 1953-02-22 973 73 560 0 2023-03-13 20:38:18
30 30 11 1953-02-22 1013 74 560 0 2023-03-13 20:38:18
31 31 15 1999-03-21 94 48 100 0 2023-03-13 20:38:18
32 32 15 1999-03-21 585 11 100 0 2023-03-13 20:38:18
33 33 15 1999-03-21 200 1 100 0 2023-03-13 20:38:18
34 34 15 1999-03-21 1062 11 100 0 2023-03-13 20:38:18
35 35 15 1999-03-21 1118 46 100 0 2023-03-13 20:38:18
36 36 15 1999-03-21 395 51 100 0 2023-03-13 20:38:18
37 37 15 1999-03-21 66 1 100 0 2023-03-13 20:38:18
38 38 15 1999-03-21 1292 20 100 0 2023-03-13 20:38:18
39 39 15 1999-03-21 1463 10 100 0 2023-03-13 20:38:18
40 40 15 1999-03-21 638 1 100 0 2023-03-13 20:38:18
41 41 17 1987-06-14 242 17 737 0 2023-03-13 20:38:18
42 42 17 1987-06-14 1560 1 737 0 2023-03-13 20:38:18
43 43 17 1987-06-14 974 1 737 0 2023-03-13 20:38:18
44 44 17 1987-06-14 487 11 737 0 2023-03-13 20:38:18
45 45 17 1987-06-14 831 35 737 0 2023-03-13 20:38:18
46 46 17 1987-06-14 1088 177 737 0 2023-03-13 20:38:18
47 47 17 1987-06-14 1296 13 737 0 2023-03-13 20:38:18
48 48 17 1987-06-14 1633 234 737 0 2023-03-13 20:38:18
49 49 17 1987-06-14 93 21 737 0 2023-03-13 20:38:18
50 50 17 1987-06-14 1424 8 737 0 2023-03-13 20:38:18
51 51 17 1987-06-14 1304 13 737 0 2023-03-13 20:38:18
52 52 17 1987-06-14 1475 94 737 0 2023-03-13 20:38:18
53 53 17 1987-06-14 1030 3 737 0 2023-03-13 20:38:18
54 54 17 1987-06-14 335 2 737 0 2023-03-13 20:38:18
55 55 19 1946-02-17 1335 4 204 0 2023-03-13 20:38:18
56 56 19 1946-02-17 1181 1 204 0 2023-03-13 20:38:18
57 57 19 1946-02-17 63 16 204 0 2023-03-13 20:38:18
58 58 19 1946-02-17 708 23 204 0 2023-03-13 20:38:18
59 59 19 1946-02-17 167 66 204 0 2023-03-13 20:38:18
60 60 19 1946-02-17 1051 92 204 0 2023-03-13 20:38:18
61 61 20 1981-06-21 138 80 1148 0 2023-03-13 20:38:18
62 62 20 1981-06-21 1539 268 1148 0 2023-03-13 20:38:18
63 63 20 1981-06-21 509 59 1148 0 2023-03-13 20:38:18
64 64 20 1981-06-21 686 43 1148 0 2023-03-13 20:38:18
65 65 20 1981-06-21 1492 14 1148 0 2023-03-13 20:38:18
66 66 20 1981-06-21 1414 10 1148 0 2023-03-13 20:38:18
67 67 21 1951-10-28 1167 5 556 0 2023-03-13 20:38:18
68 68 21 1951-10-28 531 48 556 0 2023-03-13 20:38:18
69 69 21 1951-10-28 602 1 556 0 2023-03-13 20:38:18
70 70 21 1951-10-28 26 51 556 0 2023-03-13 20:38:18
71 71 21 1951-10-28 458 5 556 0 2023-03-13 20:38:18
72 72 21 1951-10-28 886 4 556 0 2023-03-13 20:38:18
73 73 21 1951-10-28 35 49 556 0 2023-03-13 20:38:18
74 74 21 1951-10-28 750 23 556 0 2023-03-13 20:38:18
75 75 21 1951-10-28 1264 10 556 0 2023-03-13 20:38:18
76 76 24 1995-03-19 94 44 206 0 2023-03-13 20:38:18
77 77 24 1995-03-19 1292 22 206 0 2023-03-13 20:38:18
78 78 24 1995-03-19 1463 7 206 0 2023-03-13 20:38:18
79 79 24 1995-03-19 66 1 206 0 2023-03-13 20:38:18
80 80 24 1995-03-19 1062 9 206 0 2023-03-13 20:38:18
81 81 24 1995-03-19 200 1 206 0 2023-03-13 20:38:18
82 82 24 1995-03-19 585 11 206 0 2023-03-13 20:38:18
83 83 24 1995-03-19 1009 2 206 0 2023-03-13 20:38:18
84 84 24 1995-03-19 1105 1 206 0 2023-03-13 20:38:18
85 85 24 1995-03-19 395 63 206 0 2023-03-13 20:38:18
86 86 24 1995-03-19 1118 39 206 0 2023-03-13 20:38:18
87 87 25 1990-02-18 1540 16 106 0 2023-03-13 20:38:18
88 88 25 1990-02-18 940 136 106 0 2023-03-13 20:38:18
89 89 25 1990-02-18 905 21 106 0 2023-03-13 20:38:18
90 90 25 1990-02-18 837 45 106 0 2023-03-13 20:38:18
91 91 25 1990-02-18 86 4 106 0 2023-03-13 20:38:18
92 92 25 1990-02-18 2297 1 106 0 2023-03-13 20:38:18
93 93 25 1990-02-18 1193 275 106 0 2023-03-13 20:38:18
94 94 25 1990-02-18 1053 14 106 0 2023-03-13 20:38:18
95 95 27 1998-06-20 1245 20 76 0 2023-03-13 20:38:18
96 96 27 1998-06-20 789 74 76 0 2023-03-13 20:38:18
97 97 27 1998-06-20 688 19 76 0 2023-03-13 20:38:18
98 98 27 1998-06-20 1173 24 76 0 2023-03-13 20:38:18
99 99 27 1998-06-20 829 63 76 0 2023-03-13 20:38:18
100 100 30 1955-10-30 602 1 814 0 2023-03-13 20:38:18

Next page

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
);