viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by cabinet_id
This data as json, CSV (advanced)
Link | rowid | election_id | date | party_id | seats | cabinet_id ▼ | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
4025 | 4025 | 813 | 1983-11-06 | 507 | 117 | 0 | 2023-03-13 20:38:18 | |
4026 | 4026 | 813 | 1983-11-06 | 110 | 71 | 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 | |
4446 | 4446 | 912 | 1922-06-22 | 2447 | 58 | 0 | 2023-03-13 20:38:18 | |
4447 | 4447 | 912 | 1922-06-22 | 318 | 17 | 0 | 2023-03-13 20:38:18 | |
4448 | 4448 | 912 | 1922-06-22 | 2563 | 7 | 0 | 2023-03-13 20:38:18 | |
4449 | 4449 | 912 | 1922-06-22 | 30 | 9 | 0 | 2023-03-13 20:38:18 | |
4450 | 4450 | 912 | 1922-06-22 | 2523 | 1 | 0 | 2023-03-13 20:38:18 | |
4451 | 4451 | 912 | 1922-06-22 | 280 | 36 | 0 | 2023-03-13 20:38:18 | |
4530 | 4530 | 930 | 1919-10-26 | 2527 | 27 | 0 | 2023-03-13 20:38:18 | |
4531 | 4531 | 930 | 1919-10-26 | 701 | 8 | 0 | 2023-03-13 20:38:18 | |
4532 | 4532 | 930 | 1919-10-26 | 2453 | 7 | 0 | 2023-03-13 20:38:18 | |
4533 | 4533 | 930 | 1919-10-26 | 2451 | 2 | 0 | 2023-03-13 20:38:18 | |
4534 | 4534 | 930 | 1919-10-26 | 2450 | 3 | 0 | 2023-03-13 20:38:18 | |
4535 | 4535 | 930 | 1919-10-26 | 2290 | 1 | 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 | |
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 | |
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 | |
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 | |
5228 | 5228 | 1030 | 1919-02-16 | 973 | 72 | 0 | 2023-03-13 20:38:18 | |
5229 | 5229 | 1030 | 1919-02-16 | 1013 | 69 | 0 | 2023-03-13 20:38:18 | |
5230 | 5230 | 1030 | 1919-02-16 | 2672 | 8 | 0 | 2023-03-13 20:38:18 | |
5231 | 5231 | 1030 | 1919-02-16 | 2673 | 2 | 0 | 2023-03-13 20:38:18 | |
5232 | 5232 | 1030 | 1919-02-16 | 2676 | 5 | 0 | 2023-03-13 20:38:18 | |
5233 | 5233 | 1030 | 1919-02-16 | 2677 | 3 | 0 | 2023-03-13 20:38:18 | |
5234 | 5234 | 1030 | 1919-02-16 | 2689 | 1 | 0 | 2023-03-13 20:38:18 | |
5235 | 5235 | 1030 | 1919-02-16 | 2688 | 1 | 0 | 2023-03-13 20:38:18 | |
5236 | 5236 | 1030 | 1919-02-16 | 2686 | 4 | 0 | 2023-03-13 20:38:18 | |
5237 | 5237 | 1030 | 1919-02-16 | 2678 | 2 | 0 | 2023-03-13 20:38:18 | |
5238 | 5238 | 1030 | 1919-02-16 | 2675 | 3 | 0 | 2023-03-13 20:38:18 | |
5239 | 5239 | 1031 | 1919-01-19 | 2690 | 22 | 0 | 2023-03-13 20:38:18 | |
5240 | 5240 | 1031 | 1919-01-19 | 558 | 165 | 0 | 2023-03-13 20:38:18 | |
5241 | 5241 | 1031 | 1919-01-19 | 2691 | 74 | 0 | 2023-03-13 20:38:18 | |
5242 | 5242 | 1031 | 1919-01-19 | 137 | 73 | 0 | 2023-03-13 20:38:18 | |
5243 | 5243 | 1031 | 1919-01-19 | 2697 | 16 | 0 | 2023-03-13 20:38:18 | |
5244 | 5244 | 1031 | 1919-01-19 | 2693 | 23 | 0 | 2023-03-13 20:38:18 | |
5245 | 5245 | 1031 | 1919-01-19 | 2692 | 41 | 0 | 2023-03-13 20:38:18 | |
5246 | 5246 | 1031 | 1919-01-19 | 2701 | 4 | 0 | 2023-03-13 20:38:18 | |
5247 | 5247 | 1031 | 1919-01-19 | 2289 | 2 | 0 | 2023-03-13 20:38:18 | |
5248 | 5248 | 1031 | 1919-01-19 | 2696 | 3 | 0 | 2023-03-13 20:38:18 | |
6830 | 6830 | 462 | 1990-03-10 | 675 | 2 | 0 | 2023-03-13 20:38:18 | |
6831 | 6831 | 462 | 1990-03-10 | 21 | 4 | 0 | 2023-03-13 20:38:18 | |
6832 | 6832 | 462 | 1990-03-10 | 1408 | 9 | 0 | 2023-03-13 20:38:18 | |
6833 | 6833 | 462 | 1990-03-10 | 1144 | 3 | 0 | 2023-03-13 20:38:18 | |
6834 | 6834 | 462 | 1990-03-10 | 58 | 6 | 0 | 2023-03-13 20:38:18 | |
6835 | 6835 | 462 | 1990-03-10 | 1446 | 46 | 0 | 2023-03-13 20:38:18 | |
6836 | 6836 | 462 | 1990-03-10 | 1623 | 7 | 0 | 2023-03-13 20:38:18 | |
6837 | 6837 | 462 | 1990-03-10 | 1045 | 58 | 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 | |
9331 | 9331 | 905 | 1918-12-14 | 332 | 7 | 0 | 2023-03-13 20:38:18 | |
9332 | 9332 | 905 | 1918-12-14 | 2503 | 9 | 0 | 2023-03-13 20:38:18 | |
9333 | 9333 | 905 | 1918-12-14 | 2504 | 2 | 0 | 2023-03-13 20:38:18 | |
9334 | 9334 | 905 | 1918-12-14 | 1599 | 1 | 0 | 2023-03-13 20:38:18 | |
9335 | 9335 | 905 | 1918-12-14 | 2508 | 4 | 0 | 2023-03-13 20:38:18 | |
9336 | 9336 | 905 | 1918-12-14 | 2296 | 1 | 0 | 2023-03-13 20:38:18 | |
9337 | 9337 | 905 | 1918-12-14 | 453 | 8 | 0 | 2023-03-13 20:38:18 | |
9465 | 9465 | 764 | 1968-01-10 | 1253 | 41 | 1 | 1 | 2023-03-13 20:38:18 |
9466 | 9466 | 764 | 1968-01-10 | 1411 | 61 | 1 | 1 | 2023-03-13 20:38:18 |
9467 | 9467 | 764 | 1968-01-10 | 184 | 21 | 1 | 1 | 2023-03-13 20:38:18 |
9468 | 9468 | 764 | 1968-01-10 | 1396 | 1 | 1 | 1 | 2023-03-13 20:38:18 |
2820 | 2820 | 615 | 1998-10-03 | 811 | 24 | 2 | 0 | 2023-03-13 20:38:18 |
2821 | 2821 | 615 | 1998-10-03 | 1656 | 14 | 2 | 0 | 2023-03-13 20:38:18 |
2822 | 2822 | 615 | 1998-10-03 | 521 | 17 | 2 | 0 | 2023-03-13 20:38:18 |
2823 | 2823 | 615 | 1998-10-03 | 526 | 21 | 2 | 0 | 2023-03-13 20:38:18 |
2824 | 2824 | 615 | 1998-10-03 | 550 | 8 | 2 | 0 | 2023-03-13 20:38:18 |
2825 | 2825 | 615 | 1998-10-03 | 32 | 16 | 2 | 0 | 2023-03-13 20:38:18 |
9469 | 9469 | 534 | 1998-04-08 | 239 | 8 | 2 | 1 | 2023-03-13 20:38:18 |
9470 | 9470 | 534 | 1998-04-08 | 309 | 5 | 2 | 1 | 2023-03-13 20:38:18 |
9471 | 9471 | 534 | 1998-04-08 | 759 | 18 | 2 | 1 | 2023-03-13 20:38:18 |
9472 | 9472 | 534 | 1998-04-08 | 1557 | 4 | 2 | 1 | 2023-03-13 20:38:18 |
9473 | 9473 | 534 | 1998-04-08 | 32 | 6 | 2 | 1 | 2023-03-13 20:38:18 |
9474 | 9474 | 534 | 1998-04-08 | 526 | 17 | 2 | 1 | 2023-03-13 20:38:18 |
9475 | 9475 | 534 | 1998-04-08 | 1042 | 8 | 2 | 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 );