viewcalc_parliament_composition

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

20,107 rows

View and edit SQL

Suggested facets: cabinet_formation, calculation_date (date)

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

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
);
Powered by Datasette · Query took 224.745ms · Data source: ParlGov · About: simonw/parlgov-datasette