viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by date
This data as json, CSV (advanced)
Suggested facets: calculation_date (date)
date (date) >30 ✖
- 1999-12-21 43
- 2002-07-30 31
- 1996-03-11 29
- 1996-01-11 28
- 1999-03-25 26
- 2019-09-17 26
- 2022-11-01 26
- 1933-01-31 25
- 1977-02-15 25
- 1999-07-06 25
- 2020-01-07 25
- 1958-07-01 24
- 2017-03-15 24
- 1970-05-14 23
- 1991-10-20 23
- 1993-01-12 23
- 1996-10-20 23
- 2006-04-09 23
- 2011-12-04 23
- 1925-10-29 22
- 1968-01-23 22
- 2008-09-21 22
- 1935-06-07 21
- 1959-12-17 21
- 1995-01-17 21
- 2012-06-17 21
- 2016-12-12 21
- 1981-05-19 20
- 1991-10-27 20
- 1991-12-23 20
- …
Link | rowid | election_id | date ▼ | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
4206 | 4206 | 868 | 1900-05-27 | 2423 | 86 | 1374 | 1 | 2023-03-13 20:38:18 |
4207 | 4207 | 868 | 1900-05-27 | 63 | 31 | 1374 | 1 | 2023-03-13 20:38:18 |
4208 | 4208 | 868 | 1900-05-27 | 2422 | 32 | 1374 | 1 | 2023-03-13 20:38:18 |
4209 | 4209 | 868 | 1900-05-27 | 2481 | 1 | 1374 | 1 | 2023-03-13 20:38:18 |
4210 | 4210 | 868 | 1900-05-27 | 2488 | 2 | 1374 | 1 | 2023-03-13 20:38:18 |
4648 | 4648 | 943 | 1900-07-01 | 647 | 77 | 1476 | 1 | 2023-03-13 20:38:18 |
4649 | 4649 | 943 | 1900-07-01 | 1435 | 31 | 1476 | 1 | 2023-03-13 20:38:18 |
4650 | 4650 | 943 | 1900-07-01 | 2473 | 6 | 1476 | 1 | 2023-03-13 20:38:18 |
4285 | 4285 | 883 | 1900-11-07 | 368 | 133 | 1466 | 1 | 2023-03-13 20:38:18 |
4286 | 4286 | 883 | 1900-11-07 | 794 | 80 | 1466 | 1 | 2023-03-13 20:38:18 |
3535 | 3535 | 731 | 1901-03-30 | 1898 | 32 | 996 | 1 | 2023-03-13 20:38:18 |
3536 | 3536 | 731 | 1901-03-30 | 1396 | 1 | 996 | 1 | 2023-03-13 20:38:18 |
3537 | 3537 | 731 | 1901-03-30 | 1938 | 26 | 996 | 1 | 2023-03-13 20:38:18 |
3538 | 3538 | 731 | 1901-03-30 | 2299 | 1 | 996 | 1 | 2023-03-13 20:38:18 |
3539 | 3539 | 731 | 1901-03-30 | 1253 | 15 | 996 | 1 | 2023-03-13 20:38:18 |
4293 | 4293 | 886 | 1901-04-03 | 1605 | 76 | 1479 | 1 | 2023-03-13 20:38:18 |
4294 | 4294 | 886 | 1901-04-03 | 590 | 8 | 1479 | 1 | 2023-03-13 20:38:18 |
4295 | 4295 | 886 | 1901-04-03 | 1629 | 14 | 1479 | 1 | 2023-03-13 20:38:18 |
4296 | 4296 | 886 | 1901-04-03 | 2430 | 16 | 1479 | 1 | 2023-03-13 20:38:18 |
18476 | 18476 | 886 | 1901-07-24 | 1605 | 76 | 1365 | 1 | 2023-03-13 20:38:18 |
18477 | 18477 | 886 | 1901-07-24 | 590 | 8 | 1365 | 1 | 2023-03-13 20:38:18 |
18478 | 18478 | 886 | 1901-07-24 | 1629 | 14 | 1365 | 1 | 2023-03-13 20:38:18 |
18479 | 18479 | 886 | 1901-07-24 | 2430 | 16 | 1365 | 1 | 2023-03-13 20:38:18 |
18497 | 18497 | 943 | 1902-04-21 | 647 | 77 | 1378 | 1 | 2023-03-13 20:38:18 |
18498 | 18498 | 943 | 1902-04-21 | 1435 | 31 | 1378 | 1 | 2023-03-13 20:38:18 |
18499 | 18499 | 943 | 1902-04-21 | 2473 | 6 | 1378 | 1 | 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 | |
4211 | 4211 | 869 | 1902-05-25 | 2423 | 54 | 1376 | 1 | 2023-03-13 20:38:18 |
4212 | 4212 | 869 | 1902-05-25 | 63 | 20 | 1376 | 1 | 2023-03-13 20:38:18 |
4213 | 4213 | 869 | 1902-05-25 | 2422 | 10 | 1376 | 1 | 2023-03-13 20:38:18 |
4214 | 4214 | 869 | 1902-05-25 | 2481 | 1 | 1376 | 1 | 2023-03-13 20:38:18 |
18528 | 18528 | 987 | 1902-06-07 | 401 | 75 | 1387 | 1 | 2023-03-13 20:38:18 |
18529 | 18529 | 987 | 1902-06-07 | 2587 | 175 | 1387 | 1 | 2023-03-13 20:38:18 |
18530 | 18530 | 987 | 1902-06-07 | 2589 | 145 | 1387 | 1 | 2023-03-13 20:38:18 |
18531 | 18531 | 987 | 1902-06-07 | 1539 | 45 | 1387 | 1 | 2023-03-13 20:38:18 |
18532 | 18532 | 987 | 1902-06-07 | 2585 | 117 | 1387 | 1 | 2023-03-13 20:38:18 |
18533 | 18533 | 987 | 1902-06-07 | 2592 | 18 | 1387 | 1 | 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 | |
4803 | 4803 | 974 | 1902-11-25 | 2469 | 47 | 1325 | 1 | 2023-03-13 20:38:18 |
4804 | 4804 | 974 | 1902-11-25 | 2471 | 19 | 1325 | 1 | 2023-03-13 20:38:18 |
4805 | 4805 | 974 | 1902-11-25 | 1262 | 10 | 1325 | 1 | 2023-03-13 20:38:18 |
4806 | 4806 | 974 | 1902-11-25 | 1365 | 4 | 1325 | 1 | 2023-03-13 20:38:18 |
18853 | 18853 | 982 | 1902-12-11 | 531 | 36 | 1456 | 1 | 2023-03-13 20:38:18 |
18854 | 18854 | 982 | 1902-12-11 | 886 | 4 | 1456 | 1 | 2023-03-13 20:38:18 |
18855 | 18855 | 982 | 1902-12-11 | 458 | 20 | 1456 | 1 | 2023-03-13 20:38:18 |
18856 | 18856 | 982 | 1902-12-11 | 26 | 100 | 1456 | 1 | 2023-03-13 20:38:18 |
18857 | 18857 | 982 | 1902-12-11 | 35 | 7 | 1456 | 1 | 2023-03-13 20:38:18 |
4297 | 4297 | 887 | 1903-06-16 | 1605 | 73 | 1366 | 1 | 2023-03-13 20:38:18 |
4298 | 4298 | 887 | 1903-06-16 | 1629 | 16 | 1366 | 1 | 2023-03-13 20:38:18 |
4299 | 4299 | 887 | 1903-06-16 | 590 | 12 | 1366 | 1 | 2023-03-13 20:38:18 |
4300 | 4300 | 887 | 1903-06-16 | 2430 | 12 | 1366 | 1 | 2023-03-13 20:38:18 |
4301 | 4301 | 887 | 1903-06-16 | 1128 | 1 | 1366 | 1 | 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 |
16135 | 16135 | 731 | 1903-09-24 | 1898 | 32 | 997 | 1 | 2023-03-13 20:38:18 |
16136 | 16136 | 731 | 1903-09-24 | 1396 | 1 | 997 | 1 | 2023-03-13 20:38:18 |
16137 | 16137 | 731 | 1903-09-24 | 1938 | 26 | 997 | 1 | 2023-03-13 20:38:18 |
16138 | 16138 | 731 | 1903-09-24 | 2299 | 1 | 997 | 1 | 2023-03-13 20:38:18 |
16139 | 16139 | 731 | 1903-09-24 | 1253 | 15 | 997 | 1 | 2023-03-13 20:38:18 |
18500 | 18500 | 944 | 1903-10-22 | 1435 | 52 | 1379 | 1 | 2023-03-13 20:38:18 |
18501 | 18501 | 944 | 1903-10-22 | 647 | 48 | 1379 | 1 | 2023-03-13 20:38:18 |
18502 | 18502 | 944 | 1903-10-22 | 104 | 5 | 1379 | 1 | 2023-03-13 20:38:18 |
18503 | 18503 | 944 | 1903-10-22 | 2473 | 10 | 1379 | 1 | 2023-03-13 20:38:18 |
18504 | 18504 | 944 | 1903-10-22 | 2415 | 2 | 1379 | 1 | 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 |
16140 | 16140 | 730 | 1904-04-27 | 1938 | 25 | 998 | 1 | 2023-03-13 20:38:18 |
16141 | 16141 | 730 | 1904-04-27 | 1898 | 26 | 998 | 1 | 2023-03-13 20:38:18 |
16142 | 16142 | 730 | 1904-04-27 | 2299 | 1 | 998 | 1 | 2023-03-13 20:38:18 |
16143 | 16143 | 730 | 1904-04-27 | 1253 | 23 | 998 | 1 | 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 |
16144 | 16144 | 730 | 1904-08-18 | 1938 | 25 | 999 | 1 | 2023-03-13 20:38:18 |
16145 | 16145 | 730 | 1904-08-18 | 1898 | 26 | 999 | 1 | 2023-03-13 20:38:18 |
16146 | 16146 | 730 | 1904-08-18 | 2299 | 1 | 999 | 1 | 2023-03-13 20:38:18 |
16147 | 16147 | 730 | 1904-08-18 | 1253 | 23 | 999 | 1 | 2023-03-13 20:38:18 |
4287 | 4287 | 884 | 1904-11-03 | 368 | 138 | 1467 | 1 | 2023-03-13 20:38:18 |
4288 | 4288 | 884 | 1904-11-03 | 794 | 75 | 1467 | 1 | 2023-03-13 20:38:18 |
4289 | 4289 | 884 | 1904-11-03 | 1189 | 1 | 1467 | 1 | 2023-03-13 20:38:18 |
18471 | 18471 | 887 | 1905-01-14 | 1605 | 73 | 1364 | 1 | 2023-03-13 20:38:18 |
18472 | 18472 | 887 | 1905-01-14 | 1629 | 16 | 1364 | 1 | 2023-03-13 20:38:18 |
18473 | 18473 | 887 | 1905-01-14 | 590 | 12 | 1364 | 1 | 2023-03-13 20:38:18 |
18474 | 18474 | 887 | 1905-01-14 | 2430 | 12 | 1364 | 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 );