viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1 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 |
---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
18475 | 18475 | 887 | 1905-01-14 | 1128 | 1 | 1364 | 1 | 2023-03-13 20:38:18 |
18534 | 18534 | 987 | 1905-01-24 | 401 | 75 | 1388 | 1 | 2023-03-13 20:38:18 |
18535 | 18535 | 987 | 1905-01-24 | 2587 | 175 | 1388 | 1 | 2023-03-13 20:38:18 |
18536 | 18536 | 987 | 1905-01-24 | 2589 | 145 | 1388 | 1 | 2023-03-13 20:38:18 |
18537 | 18537 | 987 | 1905-01-24 | 1539 | 45 | 1388 | 1 | 2023-03-13 20:38:18 |
18538 | 18538 | 987 | 1905-01-24 | 2585 | 117 | 1388 | 1 | 2023-03-13 20:38:18 |
18539 | 18539 | 987 | 1905-01-24 | 2592 | 18 | 1388 | 1 | 2023-03-13 20:38:18 |
18505 | 18505 | 944 | 1905-03-11 | 1435 | 52 | 1380 | 1 | 2023-03-13 20:38:18 |
18506 | 18506 | 944 | 1905-03-11 | 647 | 48 | 1380 | 1 | 2023-03-13 20:38:18 |
18507 | 18507 | 944 | 1905-03-11 | 104 | 5 | 1380 | 1 | 2023-03-13 20:38:18 |
18508 | 18508 | 944 | 1905-03-11 | 2473 | 10 | 1380 | 1 | 2023-03-13 20:38:18 |
18509 | 18509 | 944 | 1905-03-11 | 2415 | 2 | 1380 | 1 | 2023-03-13 20:38:18 |
16148 | 16148 | 730 | 1905-07-05 | 1938 | 25 | 1000 | 1 | 2023-03-13 20:38:18 |
16149 | 16149 | 730 | 1905-07-05 | 1898 | 26 | 1000 | 1 | 2023-03-13 20:38:18 |
16150 | 16150 | 730 | 1905-07-05 | 2299 | 1 | 1000 | 1 | 2023-03-13 20:38:18 |
16151 | 16151 | 730 | 1905-07-05 | 1253 | 23 | 1000 | 1 | 2023-03-13 20:38:18 |
4847 | 4847 | 981 | 1905-10-29 | 531 | 36 | 1457 | 1 | 2023-03-13 20:38:18 |
4848 | 4848 | 981 | 1905-10-29 | 886 | 6 | 1457 | 1 | 2023-03-13 20:38:18 |
4849 | 4849 | 981 | 1905-10-29 | 458 | 19 | 1457 | 1 | 2023-03-13 20:38:18 |
4850 | 4850 | 981 | 1905-10-29 | 26 | 104 | 1457 | 1 | 2023-03-13 20:38:18 |
4851 | 4851 | 981 | 1905-10-29 | 35 | 2 | 1457 | 1 | 2023-03-13 20:38:18 |
4800 | 4800 | 973 | 1905-12-06 | 2469 | 58 | 1326 | 1 | 2023-03-13 20:38:18 |
4801 | 4801 | 973 | 1905-12-06 | 2471 | 16 | 1326 | 1 | 2023-03-13 20:38:18 |
4802 | 4802 | 973 | 1905-12-06 | 1262 | 6 | 1326 | 1 | 2023-03-13 20:38:18 |
18676 | 18676 | 987 | 1906-03-14 | 401 | 75 | 1409 | 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 );