viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
8,267 rows where cabinet_formation = 0 sorted by date
This data as json, CSV (advanced)
Link | rowid | election_id | date ▼ | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
3506 | 3506 | 725 | 1906-12-02 | 1253 | 26 | 1000 | 0 | 2023-03-13 20:38:18 |
3507 | 3507 | 725 | 1906-12-02 | 1898 | 16 | 1000 | 0 | 2023-03-13 20:38:18 |
3508 | 3508 | 725 | 1906-12-02 | 1906 | 2 | 1000 | 0 | 2023-03-13 20:38:18 |
3509 | 3509 | 725 | 1906-12-02 | 1917 | 4 | 1000 | 0 | 2023-03-13 20:38:18 |
3510 | 3510 | 725 | 1906-12-02 | 1938 | 27 | 1000 | 0 | 2023-03-13 20:38:18 |
4224 | 4224 | 872 | 1908-05-24 | 2423 | 37 | 1372 | 0 | 2023-03-13 20:38:18 |
4225 | 4225 | 872 | 1908-05-24 | 63 | 22 | 1372 | 0 | 2023-03-13 20:38:18 |
4226 | 4226 | 872 | 1908-05-24 | 2422 | 19 | 1372 | 0 | 2023-03-13 20:38:18 |
4227 | 4227 | 872 | 1908-05-24 | 1335 | 3 | 1372 | 0 | 2023-03-13 20:38:18 |
4228 | 4228 | 872 | 1908-05-24 | 2481 | 1 | 1372 | 0 | 2023-03-13 20:38:18 |
4796 | 4796 | 972 | 1908-12-01 | 2469 | 50 | 1309 | 0 | 2023-03-13 20:38:18 |
4797 | 4797 | 972 | 1908-12-01 | 2471 | 26 | 1309 | 0 | 2023-03-13 20:38:18 |
4798 | 4798 | 972 | 1908-12-01 | 878 | 1 | 1309 | 0 | 2023-03-13 20:38:18 |
4799 | 4799 | 972 | 1908-12-01 | 1262 | 3 | 1309 | 0 | 2023-03-13 20:38:18 |
4308 | 4308 | 889 | 1909-05-25 | 1629 | 24 | 1363 | 0 | 2023-03-13 20:38:18 |
4309 | 4309 | 889 | 1909-05-25 | 590 | 21 | 1363 | 0 | 2023-03-13 20:38:18 |
4310 | 4310 | 889 | 1909-05-25 | 211 | 15 | 1363 | 0 | 2023-03-13 20:38:18 |
4311 | 4311 | 889 | 1909-05-25 | 2430 | 11 | 1363 | 0 | 2023-03-13 20:38:18 |
4312 | 4312 | 889 | 1909-05-25 | 1128 | 6 | 1363 | 0 | 2023-03-13 20:38:18 |
4313 | 4313 | 889 | 1909-05-25 | 1605 | 37 | 1363 | 0 | 2023-03-13 20:38:18 |
3610 | 3610 | 747 | 1910-04-13 | 1396 | 1 | 1002 | 0 | 2023-03-13 20:38:18 |
3611 | 3611 | 747 | 1910-04-13 | 1253 | 43 | 1002 | 0 | 2023-03-13 20:38:18 |
3612 | 3612 | 747 | 1910-04-13 | 2285 | 31 | 1002 | 0 | 2023-03-13 20:38:18 |
4314 | 4314 | 890 | 1910-05-20 | 1605 | 57 | 1361 | 0 | 2023-03-13 20:38:18 |
4315 | 4315 | 890 | 1910-05-20 | 1629 | 24 | 1361 | 0 | 2023-03-13 20:38:18 |
4316 | 4316 | 890 | 1910-05-20 | 590 | 13 | 1361 | 0 | 2023-03-13 20:38:18 |
4317 | 4317 | 890 | 1910-05-20 | 211 | 20 | 1361 | 0 | 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 | |
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 |
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 |
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 |
4320 | 4320 | 891 | 1913-05-20 | 590 | 7 | 1360 | 0 | 2023-03-13 20:38:18 |
4321 | 4321 | 891 | 1913-05-20 | 211 | 31 | 1360 | 0 | 2023-03-13 20:38:18 |
3613 | 3613 | 748 | 1913-05-31 | 2285 | 38 | 1003 | 0 | 2023-03-13 20:38:18 |
3614 | 3614 | 748 | 1913-05-31 | 1253 | 37 | 1003 | 0 | 2023-03-13 20:38:18 |
4742 | 4742 | 962 | 1914-04-07 | 657 | 86 | 1369 | 0 | 2023-03-13 20:38:18 |
4743 | 4743 | 962 | 1914-04-07 | 892 | 71 | 1369 | 0 | 2023-03-13 20:38:18 |
4744 | 4744 | 962 | 1914-04-07 | 904 | 73 | 1369 | 0 | 2023-03-13 20:38:18 |
4901 | 4901 | 989 | 1914-05-10 | 2581 | 150 | 1398 | 0 | 2023-03-13 20:38:18 |
4902 | 4902 | 989 | 1914-05-10 | 401 | 137 | 1398 | 0 | 2023-03-13 20:38:18 |
4903 | 4903 | 989 | 1914-05-10 | 1539 | 103 | 1398 | 0 | 2023-03-13 20:38:18 |
4904 | 4904 | 989 | 1914-05-10 | 2585 | 96 | 1398 | 0 | 2023-03-13 20:38:18 |
4905 | 4905 | 989 | 1914-05-10 | 2589 | 73 | 1398 | 0 | 2023-03-13 20:38:18 |
4906 | 4906 | 989 | 1914-05-10 | 2594 | 27 | 1398 | 0 | 2023-03-13 20:38:18 |
3503 | 3503 | 724 | 1914-09-05 | 2285 | 32 | 1004 | 0 | 2023-03-13 20:38:18 |
3504 | 3504 | 724 | 1914-09-05 | 1253 | 42 | 1004 | 0 | 2023-03-13 20:38:18 |
3505 | 3505 | 724 | 1914-09-05 | 1396 | 1 | 1004 | 0 | 2023-03-13 20:38:18 |
4703 | 4703 | 953 | 1914-12-11 | 2471 | 40 | 1320 | 0 | 2023-03-13 20:38:18 |
4704 | 4704 | 953 | 1914-12-11 | 2469 | 34 | 1320 | 0 | 2023-03-13 20:38:18 |
4705 | 4705 | 953 | 1914-12-11 | 878 | 3 | 1320 | 0 | 2023-03-13 20:38:18 |
4706 | 4706 | 953 | 1914-12-11 | 2549 | 2 | 1320 | 0 | 2023-03-13 20:38:18 |
4707 | 4707 | 953 | 1914-12-11 | 1262 | 1 | 1320 | 0 | 2023-03-13 20:38:18 |
4748 | 4748 | 964 | 1917-09-16 | 904 | 86 | 1368 | 0 | 2023-03-13 20:38:18 |
4749 | 4749 | 964 | 1917-09-16 | 892 | 62 | 1368 | 0 | 2023-03-13 20:38:18 |
4750 | 4750 | 964 | 1917-09-16 | 657 | 57 | 1368 | 0 | 2023-03-13 20:38:18 |
4751 | 4751 | 964 | 1917-09-16 | 1461 | 9 | 1368 | 0 | 2023-03-13 20:38:18 |
4752 | 4752 | 964 | 1917-09-16 | 2556 | 3 | 1368 | 0 | 2023-03-13 20:38:18 |
4387 | 4387 | 902 | 1917-10-02 | 395 | 92 | 0 | 2023-03-13 20:38:18 | |
4388 | 4388 | 902 | 1917-10-02 | 2434 | 32 | 0 | 2023-03-13 20:38:18 | |
4389 | 4389 | 902 | 1917-10-02 | 94 | 26 | 0 | 2023-03-13 20:38:18 | |
4390 | 4390 | 902 | 1917-10-02 | 585 | 21 | 0 | 2023-03-13 20:38:18 | |
4824 | 4824 | 977 | 1917-10-28 | 531 | 42 | 1463 | 0 | 2023-03-13 20:38:18 |
4825 | 4825 | 977 | 1917-10-28 | 26 | 103 | 1463 | 0 | 2023-03-13 20:38:18 |
4826 | 4826 | 977 | 1917-10-28 | 35 | 20 | 1463 | 0 | 2023-03-13 20:38:18 |
4827 | 4827 | 977 | 1917-10-28 | 886 | 7 | 1463 | 0 | 2023-03-13 20:38:18 |
4828 | 4828 | 977 | 1917-10-28 | 458 | 12 | 1463 | 0 | 2023-03-13 20:38:18 |
4829 | 4829 | 977 | 1917-10-28 | 2579 | 5 | 1463 | 0 | 2023-03-13 20:38:18 |
4582 | 4582 | 937 | 1918-07-03 | 2539 | 30 | 0 | 2023-03-13 20:38:18 | |
4583 | 4583 | 937 | 1918-07-03 | 1451 | 22 | 0 | 2023-03-13 20:38:18 | |
4584 | 4584 | 937 | 1918-07-03 | 300 | 13 | 0 | 2023-03-13 20:38:18 | |
4585 | 4585 | 937 | 1918-07-03 | 405 | 7 | 0 | 2023-03-13 20:38:18 | |
4586 | 4586 | 937 | 1918-07-03 | 2462 | 6 | 0 | 2023-03-13 20:38:18 | |
4587 | 4587 | 937 | 1918-07-03 | 944 | 5 | 0 | 2023-03-13 20:38:18 | |
4588 | 4588 | 937 | 1918-07-03 | 2459 | 4 | 0 | 2023-03-13 20:38:18 | |
4589 | 4589 | 937 | 1918-07-03 | 2457 | 3 | 0 | 2023-03-13 20:38:18 | |
4590 | 4590 | 937 | 1918-07-03 | 1194 | 2 | 0 | 2023-03-13 20:38:18 | |
4591 | 4591 | 937 | 1918-07-03 | 2458 | 1 | 0 | 2023-03-13 20:38:18 | |
9323 | 9323 | 902 | 1918-12-01 | 395 | 92 | 1220 | 0 | 2023-03-13 20:38:18 |
9324 | 9324 | 902 | 1918-12-01 | 94 | 26 | 1220 | 0 | 2023-03-13 20:38:18 |
9325 | 9325 | 902 | 1918-12-01 | 585 | 21 | 1220 | 0 | 2023-03-13 20:38:18 |
9326 | 9326 | 905 | 1918-12-14 | 773 | 382 | 0 | 2023-03-13 20:38:18 | |
9327 | 9327 | 905 | 1918-12-14 | 1556 | 57 | 0 | 2023-03-13 20:38:18 | |
9328 | 9328 | 905 | 1918-12-14 | 659 | 36 | 0 | 2023-03-13 20:38:18 | |
9329 | 9329 | 905 | 1918-12-14 | 2501 | 127 | 0 | 2023-03-13 20:38:18 | |
9330 | 9330 | 905 | 1918-12-14 | 689 | 73 | 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 );