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)
Suggested facets: date (date), calculation_date (date)
Link | rowid | election_id | date ▼ | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
4888 | 4888 | 987 | 1902-05-11 | 401 | 75 | 0 | 2023-03-13 20:38:18 | |
4889 | 4889 | 987 | 1902-05-11 | 2587 | 175 | 0 | 2023-03-13 20:38:18 | |
4890 | 4890 | 987 | 1902-05-11 | 2589 | 145 | 0 | 2023-03-13 20:38:18 | |
4891 | 4891 | 987 | 1902-05-11 | 1539 | 45 | 0 | 2023-03-13 20:38:18 | |
4892 | 4892 | 987 | 1902-05-11 | 2585 | 117 | 0 | 2023-03-13 20:38:18 | |
4893 | 4893 | 987 | 1902-05-11 | 2592 | 18 | 0 | 2023-03-13 20:38:18 | |
4852 | 4852 | 982 | 1902-10-26 | 531 | 36 | 0 | 2023-03-13 20:38:18 | |
4853 | 4853 | 982 | 1902-10-26 | 886 | 4 | 0 | 2023-03-13 20:38:18 | |
4854 | 4854 | 982 | 1902-10-26 | 458 | 20 | 0 | 2023-03-13 20:38:18 | |
4855 | 4855 | 982 | 1902-10-26 | 26 | 100 | 0 | 2023-03-13 20:38:18 | |
4856 | 4856 | 982 | 1902-10-26 | 35 | 7 | 0 | 2023-03-13 20:38:18 | |
4651 | 4651 | 944 | 1903-09-16 | 1435 | 52 | 1378 | 0 | 2023-03-13 20:38:18 |
4652 | 4652 | 944 | 1903-09-16 | 647 | 48 | 1378 | 0 | 2023-03-13 20:38:18 |
4653 | 4653 | 944 | 1903-09-16 | 104 | 5 | 1378 | 0 | 2023-03-13 20:38:18 |
4654 | 4654 | 944 | 1903-09-16 | 2473 | 10 | 1378 | 0 | 2023-03-13 20:38:18 |
4655 | 4655 | 944 | 1903-09-16 | 2415 | 2 | 1378 | 0 | 2023-03-13 20:38:18 |
3531 | 3531 | 730 | 1903-12-16 | 1938 | 25 | 997 | 0 | 2023-03-13 20:38:18 |
3532 | 3532 | 730 | 1903-12-16 | 1898 | 26 | 997 | 0 | 2023-03-13 20:38:18 |
3533 | 3533 | 730 | 1903-12-16 | 2299 | 1 | 997 | 0 | 2023-03-13 20:38:18 |
3534 | 3534 | 730 | 1903-12-16 | 1253 | 23 | 997 | 0 | 2023-03-13 20:38:18 |
4215 | 4215 | 870 | 1904-05-29 | 2423 | 38 | 1376 | 0 | 2023-03-13 20:38:18 |
4216 | 4216 | 870 | 1904-05-29 | 2422 | 19 | 1376 | 0 | 2023-03-13 20:38:18 |
4217 | 4217 | 870 | 1904-05-29 | 63 | 22 | 1376 | 0 | 2023-03-13 20:38:18 |
4218 | 4218 | 870 | 1904-05-29 | 2300 | 1 | 1376 | 0 | 2023-03-13 20:38:18 |
4219 | 4219 | 870 | 1904-05-29 | 2481 | 1 | 1376 | 0 | 2023-03-13 20:38:18 |
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 |
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 );