viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by date
This data as json, CSV (advanced)
Link | rowid | election_id | date ▼ | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
18567 | 18567 | 988 | 1911-03-02 | 1328 | 2 | 1393 | 1 | 2023-03-13 20:38:18 |
20734 | 20734 | 988 | 1911-03-02 | 401 | 0 | 1393 | 1 | 2023-03-13 20:38:18 |
20735 | 20735 | 988 | 1911-03-02 | 2587 | 0 | 1393 | 1 | 2023-03-13 20:38:18 |
17989 | 17989 | 873 | 1911-06-18 | 2423 | 49 | 1285 | 1 | 2023-03-13 20:38:18 |
17990 | 17990 | 873 | 1911-06-18 | 1335 | 15 | 1285 | 1 | 2023-03-13 20:38:18 |
17991 | 17991 | 873 | 1911-06-18 | 63 | 15 | 1285 | 1 | 2023-03-13 20:38:18 |
17992 | 17992 | 873 | 1911-06-18 | 2422 | 6 | 1285 | 1 | 2023-03-13 20:38:18 |
18568 | 18568 | 988 | 1911-06-27 | 2589 | 91 | 1394 | 1 | 2023-03-13 20:38:18 |
18569 | 18569 | 988 | 1911-06-27 | 2594 | 145 | 1394 | 1 | 2023-03-13 20:38:18 |
18570 | 18570 | 988 | 1911-06-27 | 1539 | 75 | 1394 | 1 | 2023-03-13 20:38:18 |
18571 | 18571 | 988 | 1911-06-27 | 2585 | 105 | 1394 | 1 | 2023-03-13 20:38:18 |
18572 | 18572 | 988 | 1911-06-27 | 2590 | 25 | 1394 | 1 | 2023-03-13 20:38:18 |
18573 | 18573 | 988 | 1911-06-27 | 2581 | 137 | 1394 | 1 | 2023-03-13 20:38:18 |
18574 | 18574 | 988 | 1911-06-27 | 1328 | 2 | 1394 | 1 | 2023-03-13 20:38:18 |
20736 | 20736 | 988 | 1911-06-27 | 401 | 0 | 1394 | 1 | 2023-03-13 20:38:18 |
20779 | 20779 | 988 | 1911-06-27 | 2587 | 0 | 1394 | 1 | 2023-03-13 20:38:18 |
4189 | 4189 | 863 | 1911-09-21 | 794 | 134 | 1468 | 0 | 2023-03-13 20:38:18 |
4190 | 4190 | 863 | 1911-09-21 | 368 | 82 | 1468 | 0 | 2023-03-13 20:38:18 |
4191 | 4191 | 863 | 1911-09-21 | 2577 | 5 | 1468 | 0 | 2023-03-13 20:38:18 |
4739 | 4739 | 961 | 1911-09-24 | 892 | 102 | 0 | 2023-03-13 20:38:18 | |
4740 | 4740 | 961 | 1911-09-24 | 657 | 64 | 0 | 2023-03-13 20:38:18 | |
4741 | 4741 | 961 | 1911-09-24 | 904 | 64 | 0 | 2023-03-13 20:38:18 | |
18486 | 18486 | 961 | 1911-10-07 | 892 | 102 | 1370 | 1 | 2023-03-13 20:38:18 |
18487 | 18487 | 961 | 1911-10-07 | 657 | 64 | 1370 | 1 | 2023-03-13 20:38:18 |
18488 | 18488 | 961 | 1911-10-07 | 904 | 64 | 1370 | 1 | 2023-03-13 20:38:18 |
17358 | 17358 | 863 | 1911-10-10 | 794 | 134 | 1171 | 1 | 2023-03-13 20:38:18 |
17359 | 17359 | 863 | 1911-10-10 | 368 | 82 | 1171 | 1 | 2023-03-13 20:38:18 |
17360 | 17360 | 863 | 1911-10-10 | 2577 | 5 | 1171 | 1 | 2023-03-13 20:38:18 |
4836 | 4836 | 979 | 1911-10-29 | 531 | 38 | 1458 | 0 | 2023-03-13 20:38:18 |
4837 | 4837 | 979 | 1911-10-29 | 886 | 6 | 1458 | 0 | 2023-03-13 20:38:18 |
4838 | 4838 | 979 | 1911-10-29 | 458 | 14 | 1458 | 0 | 2023-03-13 20:38:18 |
4839 | 4839 | 979 | 1911-10-29 | 26 | 114 | 1458 | 0 | 2023-03-13 20:38:18 |
4840 | 4840 | 979 | 1911-10-29 | 35 | 15 | 1458 | 0 | 2023-03-13 20:38:18 |
4841 | 4841 | 979 | 1911-10-29 | 2579 | 2 | 1458 | 0 | 2023-03-13 20:38:18 |
18858 | 18858 | 979 | 1911-12-14 | 531 | 38 | 1459 | 1 | 2023-03-13 20:38:18 |
18859 | 18859 | 979 | 1911-12-14 | 886 | 6 | 1459 | 1 | 2023-03-13 20:38:18 |
18860 | 18860 | 979 | 1911-12-14 | 458 | 14 | 1459 | 1 | 2023-03-13 20:38:18 |
18861 | 18861 | 979 | 1911-12-14 | 26 | 114 | 1459 | 1 | 2023-03-13 20:38:18 |
18862 | 18862 | 979 | 1911-12-14 | 35 | 15 | 1459 | 1 | 2023-03-13 20:38:18 |
18863 | 18863 | 979 | 1911-12-14 | 2579 | 2 | 1459 | 1 | 2023-03-13 20:38:18 |
4699 | 4699 | 952 | 1911-12-19 | 2469 | 33 | 1324 | 1 | 2023-03-13 20:38:18 |
4700 | 4700 | 952 | 1911-12-19 | 2471 | 37 | 1324 | 1 | 2023-03-13 20:38:18 |
4701 | 4701 | 952 | 1911-12-19 | 1262 | 6 | 1324 | 1 | 2023-03-13 20:38:18 |
4702 | 4702 | 952 | 1911-12-19 | 878 | 4 | 1324 | 1 | 2023-03-13 20:38:18 |
18575 | 18575 | 988 | 1912-01-14 | 2589 | 91 | 1395 | 1 | 2023-03-13 20:38:18 |
18576 | 18576 | 988 | 1912-01-14 | 2594 | 145 | 1395 | 1 | 2023-03-13 20:38:18 |
18577 | 18577 | 988 | 1912-01-14 | 1539 | 75 | 1395 | 1 | 2023-03-13 20:38:18 |
18578 | 18578 | 988 | 1912-01-14 | 2585 | 105 | 1395 | 1 | 2023-03-13 20:38:18 |
18579 | 18579 | 988 | 1912-01-14 | 2590 | 25 | 1395 | 1 | 2023-03-13 20:38:18 |
18580 | 18580 | 988 | 1912-01-14 | 2581 | 137 | 1395 | 1 | 2023-03-13 20:38:18 |
18581 | 18581 | 988 | 1912-01-14 | 1328 | 2 | 1395 | 1 | 2023-03-13 20:38:18 |
20737 | 20737 | 988 | 1912-01-14 | 2587 | 0 | 1395 | 1 | 2023-03-13 20:38:18 |
20738 | 20738 | 988 | 1912-01-14 | 401 | 0 | 1395 | 1 | 2023-03-13 20:38:18 |
18523 | 18523 | 946 | 1912-02-20 | 1435 | 41 | 1384 | 1 | 2023-03-13 20:38:18 |
18524 | 18524 | 946 | 1912-02-20 | 647 | 46 | 1384 | 1 | 2023-03-13 20:38:18 |
18525 | 18525 | 946 | 1912-02-20 | 104 | 11 | 1384 | 1 | 2023-03-13 20:38:18 |
18526 | 18526 | 946 | 1912-02-20 | 2415 | 2 | 1384 | 1 | 2023-03-13 20:38:18 |
18527 | 18527 | 946 | 1912-02-20 | 2472 | 23 | 1384 | 1 | 2023-03-13 20:38:18 |
18143 | 18143 | 952 | 1912-03-18 | 2469 | 33 | 1310 | 1 | 2023-03-13 20:38:18 |
18144 | 18144 | 952 | 1912-03-18 | 2471 | 37 | 1310 | 1 | 2023-03-13 20:38:18 |
18145 | 18145 | 952 | 1912-03-18 | 1262 | 6 | 1310 | 1 | 2023-03-13 20:38:18 |
18146 | 18146 | 952 | 1912-03-18 | 878 | 4 | 1310 | 1 | 2023-03-13 20:38:18 |
4233 | 4233 | 874 | 1912-06-02 | 2423 | 101 | 1284 | 1 | 2023-03-13 20:38:18 |
4234 | 4234 | 874 | 1912-06-02 | 63 | 44 | 1284 | 1 | 2023-03-13 20:38:18 |
4235 | 4235 | 874 | 1912-06-02 | 2422 | 39 | 1284 | 1 | 2023-03-13 20:38:18 |
4236 | 4236 | 874 | 1912-06-02 | 2481 | 2 | 1284 | 1 | 2023-03-13 20:38:18 |
18147 | 18147 | 952 | 1912-07-10 | 2469 | 33 | 1311 | 1 | 2023-03-13 20:38:18 |
18148 | 18148 | 952 | 1912-07-10 | 2471 | 37 | 1311 | 1 | 2023-03-13 20:38:18 |
18149 | 18149 | 952 | 1912-07-10 | 1262 | 6 | 1311 | 1 | 2023-03-13 20:38:18 |
18150 | 18150 | 952 | 1912-07-10 | 878 | 4 | 1311 | 1 | 2023-03-13 20:38:18 |
4665 | 4665 | 947 | 1912-10-21 | 647 | 70 | 1384 | 0 | 2023-03-13 20:38:18 |
4666 | 4666 | 947 | 1912-10-21 | 1435 | 20 | 1384 | 0 | 2023-03-13 20:38:18 |
4667 | 4667 | 947 | 1912-10-21 | 104 | 23 | 1384 | 0 | 2023-03-13 20:38:18 |
4668 | 4668 | 947 | 1912-10-21 | 2415 | 6 | 1384 | 0 | 2023-03-13 20:38:18 |
4669 | 4669 | 947 | 1912-10-21 | 2472 | 4 | 1384 | 0 | 2023-03-13 20:38:18 |
18582 | 18582 | 988 | 1913-01-21 | 2589 | 91 | 1396 | 1 | 2023-03-13 20:38:18 |
18583 | 18583 | 988 | 1913-01-21 | 2594 | 145 | 1396 | 1 | 2023-03-13 20:38:18 |
18584 | 18584 | 988 | 1913-01-21 | 1539 | 75 | 1396 | 1 | 2023-03-13 20:38:18 |
18585 | 18585 | 988 | 1913-01-21 | 2585 | 105 | 1396 | 1 | 2023-03-13 20:38:18 |
18586 | 18586 | 988 | 1913-01-21 | 2590 | 25 | 1396 | 1 | 2023-03-13 20:38:18 |
18587 | 18587 | 988 | 1913-01-21 | 2581 | 137 | 1396 | 1 | 2023-03-13 20:38:18 |
18588 | 18588 | 988 | 1913-01-21 | 1328 | 2 | 1396 | 1 | 2023-03-13 20:38:18 |
20780 | 20780 | 988 | 1913-01-21 | 2587 | 0 | 1396 | 1 | 2023-03-13 20:38:18 |
20781 | 20781 | 988 | 1913-01-21 | 401 | 0 | 1396 | 1 | 2023-03-13 20:38:18 |
17734 | 17734 | 947 | 1913-01-31 | 647 | 70 | 1240 | 1 | 2023-03-13 20:38:18 |
17735 | 17735 | 947 | 1913-01-31 | 1435 | 20 | 1240 | 1 | 2023-03-13 20:38:18 |
17736 | 17736 | 947 | 1913-01-31 | 104 | 23 | 1240 | 1 | 2023-03-13 20:38:18 |
17737 | 17737 | 947 | 1913-01-31 | 2415 | 6 | 1240 | 1 | 2023-03-13 20:38:18 |
17738 | 17738 | 947 | 1913-01-31 | 2472 | 4 | 1240 | 1 | 2023-03-13 20:38:18 |
18589 | 18589 | 988 | 1913-03-22 | 2589 | 91 | 1397 | 1 | 2023-03-13 20:38:18 |
18590 | 18590 | 988 | 1913-03-22 | 2594 | 145 | 1397 | 1 | 2023-03-13 20:38:18 |
18591 | 18591 | 988 | 1913-03-22 | 1539 | 75 | 1397 | 1 | 2023-03-13 20:38:18 |
18592 | 18592 | 988 | 1913-03-22 | 2585 | 105 | 1397 | 1 | 2023-03-13 20:38:18 |
18593 | 18593 | 988 | 1913-03-22 | 2590 | 25 | 1397 | 1 | 2023-03-13 20:38:18 |
18594 | 18594 | 988 | 1913-03-22 | 2581 | 137 | 1397 | 1 | 2023-03-13 20:38:18 |
18595 | 18595 | 988 | 1913-03-22 | 1328 | 2 | 1397 | 1 | 2023-03-13 20:38:18 |
20739 | 20739 | 988 | 1913-03-22 | 2587 | 0 | 1397 | 1 | 2023-03-13 20:38:18 |
20740 | 20740 | 988 | 1913-03-22 | 401 | 0 | 1397 | 1 | 2023-03-13 20:38:18 |
4318 | 4318 | 891 | 1913-05-20 | 1629 | 32 | 1360 | 0 | 2023-03-13 20:38:18 |
4319 | 4319 | 891 | 1913-05-20 | 1605 | 44 | 1360 | 0 | 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 );