viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1 sorted by cabinet_formation
This data as json, CSV (advanced)
Link | rowid | election_id | date | party_id | seats | cabinet_id | cabinet_formation ▼ | calculation_date |
---|---|---|---|---|---|---|---|---|
1135 | 1135 | 244 | 1951-05-06 | 984 | 15 | 1472 | 1 | 2023-03-13 20:38:18 |
1136 | 1136 | 244 | 1951-05-06 | 1003 | 14 | 1472 | 1 | 2023-03-13 20:38:18 |
1137 | 1137 | 244 | 1951-05-06 | 1274 | 7 | 1472 | 1 | 2023-03-13 20:38:18 |
1145 | 1145 | 247 | 1975-04-25 | 725 | 116 | 1477 | 1 | 2023-03-13 20:38:18 |
1146 | 1146 | 247 | 1975-04-25 | 260 | 1 | 1477 | 1 | 2023-03-13 20:38:18 |
1147 | 1147 | 247 | 1975-04-25 | 514 | 30 | 1477 | 1 | 2023-03-13 20:38:18 |
1148 | 1148 | 247 | 1975-04-25 | 1281 | 5 | 1477 | 1 | 2023-03-13 20:38:18 |
1149 | 1149 | 247 | 1975-04-25 | 1273 | 81 | 1477 | 1 | 2023-03-13 20:38:18 |
1150 | 1150 | 247 | 1975-04-25 | 2291 | 1 | 1477 | 1 | 2023-03-13 20:38:18 |
1151 | 1151 | 247 | 1975-04-25 | 251 | 16 | 1477 | 1 | 2023-03-13 20:38:18 |
1160 | 1160 | 251 | 1958-06-01 | 892 | 38 | 208 | 1 | 2023-03-13 20:38:18 |
1161 | 1161 | 251 | 1958-06-01 | 657 | 45 | 208 | 1 | 2023-03-13 20:38:18 |
1162 | 1162 | 251 | 1958-06-01 | 1461 | 32 | 208 | 1 | 2023-03-13 20:38:18 |
1163 | 1163 | 251 | 1958-06-01 | 882 | 5 | 208 | 1 | 2023-03-13 20:38:18 |
1164 | 1164 | 251 | 1958-06-01 | 904 | 111 | 208 | 1 | 2023-03-13 20:38:18 |
1205 | 1205 | 258 | 1970-09-20 | 657 | 41 | 577 | 1 | 2023-03-13 20:38:18 |
1206 | 1206 | 258 | 1970-09-20 | 904 | 163 | 577 | 1 | 2023-03-13 20:38:18 |
1207 | 1207 | 258 | 1970-09-20 | 1461 | 71 | 577 | 1 | 2023-03-13 20:38:18 |
1208 | 1208 | 258 | 1970-09-20 | 882 | 17 | 577 | 1 | 2023-03-13 20:38:18 |
1209 | 1209 | 258 | 1970-09-20 | 892 | 58 | 577 | 1 | 2023-03-13 20:38:18 |
1262 | 1262 | 272 | 1953-12-14 | 984 | 18 | 1473 | 1 | 2023-03-13 20:38:18 |
1263 | 1263 | 272 | 1953-12-14 | 1003 | 19 | 1473 | 1 | 2023-03-13 20:38:18 |
1264 | 1264 | 272 | 1953-12-14 | 1274 | 3 | 1473 | 1 | 2023-03-13 20:38:18 |
1279 | 1279 | 281 | 1980-10-05 | 251 | 46 | 328 | 1 | 2023-03-13 20:38:18 |
1280 | 1280 | 281 | 1980-10-05 | 622 | 4 | 328 | 1 | 2023-03-13 20:38:18 |
1281 | 1281 | 281 | 1980-10-05 | 725 | 66 | 328 | 1 | 2023-03-13 20:38:18 |
1282 | 1282 | 281 | 1980-10-05 | 1281 | 2 | 328 | 1 | 2023-03-13 20:38:18 |
1283 | 1283 | 281 | 1980-10-05 | 107 | 6 | 328 | 1 | 2023-03-13 20:38:18 |
1284 | 1284 | 281 | 1980-10-05 | 260 | 1 | 328 | 1 | 2023-03-13 20:38:18 |
1285 | 1285 | 281 | 1980-10-05 | 565 | 4 | 328 | 1 | 2023-03-13 20:38:18 |
1286 | 1286 | 281 | 1980-10-05 | 1273 | 82 | 328 | 1 | 2023-03-13 20:38:18 |
1287 | 1287 | 281 | 1980-10-05 | 514 | 39 | 328 | 1 | 2023-03-13 20:38:18 |
1312 | 1312 | 286 | 1958-03-31 | 794 | 208 | 697 | 1 | 2023-03-13 20:38:18 |
1313 | 1313 | 286 | 1958-03-31 | 368 | 48 | 697 | 1 | 2023-03-13 20:38:18 |
1314 | 1314 | 286 | 1958-03-31 | 296 | 8 | 697 | 1 | 2023-03-13 20:38:18 |
1315 | 1315 | 286 | 1958-03-31 | 2085 | 1 | 697 | 1 | 2023-03-13 20:38:18 |
1336 | 1336 | 290 | 1983-06-09 | 311 | 2 | 646 | 1 | 2023-03-13 20:38:18 |
1337 | 1337 | 290 | 1983-06-09 | 689 | 1 | 646 | 1 | 2023-03-13 20:38:18 |
1338 | 1338 | 290 | 1983-06-09 | 773 | 397 | 646 | 1 | 2023-03-13 20:38:18 |
1339 | 1339 | 290 | 1983-06-09 | 1023 | 1 | 646 | 1 | 2023-03-13 20:38:18 |
1340 | 1340 | 290 | 1983-06-09 | 1210 | 11 | 646 | 1 | 2023-03-13 20:38:18 |
1341 | 1341 | 290 | 1983-06-09 | 319 | 3 | 646 | 1 | 2023-03-13 20:38:18 |
1342 | 1342 | 290 | 1983-06-09 | 1566 | 1 | 646 | 1 | 2023-03-13 20:38:18 |
1343 | 1343 | 290 | 1983-06-09 | 1284 | 2 | 646 | 1 | 2023-03-13 20:38:18 |
1344 | 1344 | 290 | 1983-06-09 | 659 | 17 | 646 | 1 | 2023-03-13 20:38:18 |
1345 | 1345 | 290 | 1983-06-09 | 1556 | 209 | 646 | 1 | 2023-03-13 20:38:18 |
1346 | 1346 | 290 | 1983-06-09 | 1547 | 6 | 646 | 1 | 2023-03-13 20:38:18 |
1354 | 1354 | 292 | 1953-08-10 | 1392 | 15 | 327 | 1 | 2023-03-13 20:38:18 |
1355 | 1355 | 292 | 1953-08-10 | 794 | 51 | 327 | 1 | 2023-03-13 20:38:18 |
1356 | 1356 | 292 | 1953-08-10 | 368 | 171 | 327 | 1 | 2023-03-13 20:38:18 |
1357 | 1357 | 292 | 1953-08-10 | 296 | 23 | 327 | 1 | 2023-03-13 20:38:18 |
1358 | 1358 | 292 | 1953-08-10 | 1189 | 4 | 327 | 1 | 2023-03-13 20:38:18 |
1359 | 1359 | 292 | 1953-08-10 | 2085 | 1 | 327 | 1 | 2023-03-13 20:38:18 |
1372 | 1372 | 295 | 1960-09-18 | 892 | 40 | 424 | 1 | 2023-03-13 20:38:18 |
1373 | 1373 | 295 | 1960-09-18 | 904 | 114 | 424 | 1 | 2023-03-13 20:38:18 |
1374 | 1374 | 295 | 1960-09-18 | 657 | 39 | 424 | 1 | 2023-03-13 20:38:18 |
1375 | 1375 | 295 | 1960-09-18 | 882 | 5 | 424 | 1 | 2023-03-13 20:38:18 |
1376 | 1376 | 295 | 1960-09-18 | 1461 | 34 | 424 | 1 | 2023-03-13 20:38:18 |
1463 | 1463 | 318 | 1967-06-11 | 1360 | 9 | 254 | 1 | 2023-03-13 20:38:18 |
1464 | 1464 | 318 | 1967-06-11 | 1172 | 1 | 254 | 1 | 2023-03-13 20:38:18 |
1465 | 1465 | 318 | 1967-06-11 | 228 | 9 | 254 | 1 | 2023-03-13 20:38:18 |
1466 | 1466 | 318 | 1967-06-11 | 1342 | 23 | 254 | 1 | 2023-03-13 20:38:18 |
1467 | 1467 | 318 | 1967-06-11 | 1455 | 18 | 254 | 1 | 2023-03-13 20:38:18 |
1509 | 1509 | 330 | 1996-05-26 | 1523 | 2 | 911 | 1 | 2023-03-13 20:38:18 |
1510 | 1510 | 330 | 1996-05-26 | 572 | 19 | 911 | 1 | 2023-03-13 20:38:18 |
1511 | 1511 | 330 | 1996-05-26 | 945 | 5 | 911 | 1 | 2023-03-13 20:38:18 |
1512 | 1512 | 330 | 1996-05-26 | 851 | 10 | 911 | 1 | 2023-03-13 20:38:18 |
1513 | 1513 | 330 | 1996-05-26 | 1575 | 20 | 911 | 1 | 2023-03-13 20:38:18 |
1556 | 1556 | 339 | 2001-05-27 | 1049 | 1 | 910 | 1 | 2023-03-13 20:38:18 |
1557 | 1557 | 339 | 2001-05-27 | 851 | 9 | 910 | 1 | 2023-03-13 20:38:18 |
1558 | 1558 | 339 | 2001-05-27 | 1621 | 1 | 910 | 1 | 2023-03-13 20:38:18 |
1559 | 1559 | 339 | 2001-05-27 | 6 | 1 | 910 | 1 | 2023-03-13 20:38:18 |
1560 | 1560 | 339 | 2001-05-27 | 945 | 4 | 910 | 1 | 2023-03-13 20:38:18 |
1561 | 1561 | 339 | 2001-05-27 | 572 | 20 | 910 | 1 | 2023-03-13 20:38:18 |
1562 | 1562 | 339 | 2001-05-27 | 1575 | 19 | 910 | 1 | 2023-03-13 20:38:18 |
1563 | 1563 | 339 | 2001-05-27 | 1523 | 1 | 910 | 1 | 2023-03-13 20:38:18 |
1570 | 1570 | 342 | 1991-05-19 | 1575 | 20 | 912 | 1 | 2023-03-13 20:38:18 |
1571 | 1571 | 342 | 1991-05-19 | 851 | 11 | 912 | 1 | 2023-03-13 20:38:18 |
1572 | 1572 | 342 | 1991-05-19 | 572 | 18 | 912 | 1 | 2023-03-13 20:38:18 |
1573 | 1573 | 342 | 1991-05-19 | 945 | 7 | 912 | 1 | 2023-03-13 20:38:18 |
1648 | 1648 | 365 | 2002-11-24 | 1429 | 17 | 889 | 1 | 2023-03-13 20:38:18 |
1649 | 1649 | 365 | 2002-11-24 | 50 | 18 | 889 | 1 | 2023-03-13 20:38:18 |
1650 | 1650 | 365 | 2002-11-24 | 973 | 69 | 889 | 1 | 2023-03-13 20:38:18 |
1651 | 1651 | 365 | 2002-11-24 | 1013 | 79 | 889 | 1 | 2023-03-13 20:38:18 |
1652 | 1652 | 366 | 1951-09-01 | 878 | 30 | 66 | 1 | 2023-03-13 20:38:18 |
1653 | 1653 | 366 | 1951-09-01 | 997 | 50 | 66 | 1 | 2023-03-13 20:38:18 |
1702 | 1702 | 379 | 1963-06-09 | 1455 | 19 | 851 | 1 | 2023-03-13 20:38:18 |
1703 | 1703 | 379 | 1963-06-09 | 1342 | 24 | 851 | 1 | 2023-03-13 20:38:18 |
1704 | 1704 | 379 | 1963-06-09 | 1360 | 9 | 851 | 1 | 2023-03-13 20:38:18 |
1705 | 1705 | 379 | 1963-06-09 | 228 | 8 | 851 | 1 | 2023-03-13 20:38:18 |
1759 | 1759 | 389 | 1998-03-11 | 211 | 7 | 630 | 1 | 2023-03-13 20:38:18 |
1760 | 1760 | 389 | 1998-03-11 | 1629 | 63 | 630 | 1 | 2023-03-13 20:38:18 |
1761 | 1761 | 389 | 1998-03-11 | 1331 | 4 | 630 | 1 | 2023-03-13 20:38:18 |
1762 | 1762 | 389 | 1998-03-11 | 1418 | 13 | 630 | 1 | 2023-03-13 20:38:18 |
1763 | 1763 | 389 | 1998-03-11 | 1644 | 13 | 630 | 1 | 2023-03-13 20:38:18 |
1764 | 1764 | 389 | 1998-03-11 | 590 | 16 | 630 | 1 | 2023-03-13 20:38:18 |
1765 | 1765 | 389 | 1998-03-11 | 1605 | 42 | 630 | 1 | 2023-03-13 20:38:18 |
1766 | 1766 | 389 | 1998-03-11 | 306 | 5 | 630 | 1 | 2023-03-13 20:38:18 |
1767 | 1767 | 389 | 1998-03-11 | 978 | 4 | 630 | 1 | 2023-03-13 20:38:18 |
1768 | 1768 | 389 | 1998-03-11 | 1324 | 8 | 630 | 1 | 2023-03-13 20:38:18 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE `viewcalc_parliament_composition` ( `election_id` INTEGER, `date` TEXT, `party_id` INTEGER, `seats` INTEGER, `cabinet_id` INTEGER, `cabinet_formation` INTEGER, `calculation_date` TEXT );