home / parlgov

Menu
  • Search all tables
  • GraphQL API

parlgov

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

Custom SQL query returning 101 rows (show)

This data as json, CSV

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