viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by date
This data as json, CSV (advanced)
Link | rowid | election_id | date ▼ | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
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 |
18677 | 18677 | 987 | 1906-03-14 | 2587 | 175 | 1409 | 1 | 2023-03-13 20:38:18 |
18678 | 18678 | 987 | 1906-03-14 | 2589 | 145 | 1409 | 1 | 2023-03-13 20:38:18 |
18679 | 18679 | 987 | 1906-03-14 | 1539 | 45 | 1409 | 1 | 2023-03-13 20:38:18 |
18680 | 18680 | 987 | 1906-03-14 | 2585 | 117 | 1409 | 1 | 2023-03-13 20:38:18 |
18681 | 18681 | 987 | 1906-03-14 | 2592 | 18 | 1409 | 1 | 2023-03-13 20:38:18 |
20731 | 20731 | 987 | 1906-03-14 | 2590 | 0 | 1409 | 1 | 2023-03-13 20:38:18 |
4881 | 4881 | 986 | 1906-05-20 | 401 | 239 | 1411 | 1 | 2023-03-13 20:38:18 |
4882 | 4882 | 986 | 1906-05-20 | 2586 | 67 | 1411 | 1 | 2023-03-13 20:38:18 |
4883 | 4883 | 986 | 1906-05-20 | 1539 | 53 | 1411 | 1 | 2023-03-13 20:38:18 |
4884 | 4884 | 986 | 1906-05-20 | 2587 | 52 | 1411 | 1 | 2023-03-13 20:38:18 |
4885 | 4885 | 986 | 1906-05-20 | 2589 | 107 | 1411 | 1 | 2023-03-13 20:38:18 |
4886 | 4886 | 986 | 1906-05-20 | 2585 | 39 | 1411 | 1 | 2023-03-13 20:38:18 |
4887 | 4887 | 986 | 1906-05-20 | 2590 | 18 | 1411 | 1 | 2023-03-13 20:38:18 |
4220 | 4220 | 871 | 1906-05-27 | 2423 | 50 | 1375 | 1 | 2023-03-13 20:38:18 |
4221 | 4221 | 871 | 1906-05-27 | 1335 | 14 | 1375 | 1 | 2023-03-13 20:38:18 |
4222 | 4222 | 871 | 1906-05-27 | 63 | 15 | 1375 | 1 | 2023-03-13 20:38:18 |
4223 | 4223 | 871 | 1906-05-27 | 2422 | 6 | 1375 | 1 | 2023-03-13 20:38:18 |
4302 | 4302 | 888 | 1906-05-29 | 1605 | 56 | 1367 | 1 | 2023-03-13 20:38:18 |
4303 | 4303 | 888 | 1906-05-29 | 1629 | 24 | 1367 | 1 | 2023-03-13 20:38:18 |
4304 | 4304 | 888 | 1906-05-29 | 590 | 12 | 1367 | 1 | 2023-03-13 20:38:18 |
4305 | 4305 | 888 | 1906-05-29 | 211 | 9 | 1367 | 1 | 2023-03-13 20:38:18 |
4306 | 4306 | 888 | 1906-05-29 | 2430 | 9 | 1367 | 1 | 2023-03-13 20:38:18 |
4307 | 4307 | 888 | 1906-05-29 | 1128 | 4 | 1367 | 1 | 2023-03-13 20:38:18 |
18137 | 18137 | 973 | 1906-06-21 | 2469 | 58 | 1308 | 1 | 2023-03-13 20:38:18 |
18138 | 18138 | 973 | 1906-06-21 | 2471 | 16 | 1308 | 1 | 2023-03-13 20:38:18 |
18139 | 18139 | 973 | 1906-06-21 | 1262 | 6 | 1308 | 1 | 2023-03-13 20:38:18 |
18140 | 18140 | 973 | 1906-08-06 | 2469 | 58 | 1309 | 1 | 2023-03-13 20:38:18 |
18141 | 18141 | 973 | 1906-08-06 | 2471 | 16 | 1309 | 1 | 2023-03-13 20:38:18 |
18142 | 18142 | 973 | 1906-08-06 | 1262 | 6 | 1309 | 1 | 2023-03-13 20:38:18 |
4656 | 4656 | 945 | 1906-08-27 | 647 | 73 | 1385 | 1 | 2023-03-13 20:38:18 |
4657 | 4657 | 945 | 1906-08-27 | 104 | 10 | 1385 | 1 | 2023-03-13 20:38:18 |
4658 | 4658 | 945 | 1906-08-27 | 2415 | 4 | 1385 | 1 | 2023-03-13 20:38:18 |
4659 | 4659 | 945 | 1906-08-27 | 1435 | 36 | 1385 | 1 | 2023-03-13 20:38:18 |
18540 | 18540 | 986 | 1906-10-25 | 401 | 239 | 1390 | 1 | 2023-03-13 20:38:18 |
18541 | 18541 | 986 | 1906-10-25 | 2586 | 67 | 1390 | 1 | 2023-03-13 20:38:18 |
18542 | 18542 | 986 | 1906-10-25 | 1539 | 53 | 1390 | 1 | 2023-03-13 20:38:18 |
18543 | 18543 | 986 | 1906-10-25 | 2587 | 52 | 1390 | 1 | 2023-03-13 20:38:18 |
18544 | 18544 | 986 | 1906-10-25 | 2589 | 107 | 1390 | 1 | 2023-03-13 20:38:18 |
18545 | 18545 | 986 | 1906-10-25 | 2585 | 39 | 1390 | 1 | 2023-03-13 20:38:18 |
18546 | 18546 | 986 | 1906-10-25 | 2590 | 18 | 1390 | 1 | 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 |
18510 | 18510 | 945 | 1907-10-23 | 647 | 73 | 1381 | 1 | 2023-03-13 20:38:18 |
18511 | 18511 | 945 | 1907-10-23 | 104 | 10 | 1381 | 1 | 2023-03-13 20:38:18 |
18512 | 18512 | 945 | 1907-10-23 | 2415 | 4 | 1381 | 1 | 2023-03-13 20:38:18 |
18513 | 18513 | 945 | 1907-10-23 | 1435 | 36 | 1381 | 1 | 2023-03-13 20:38:18 |
18493 | 18493 | 871 | 1907-12-31 | 2423 | 50 | 1373 | 1 | 2023-03-13 20:38:18 |
18494 | 18494 | 871 | 1907-12-31 | 1335 | 14 | 1373 | 1 | 2023-03-13 20:38:18 |
18495 | 18495 | 871 | 1907-12-31 | 63 | 15 | 1373 | 1 | 2023-03-13 20:38:18 |
18496 | 18496 | 871 | 1907-12-31 | 2422 | 6 | 1373 | 1 | 2023-03-13 20:38:18 |
18489 | 18489 | 871 | 1908-01-09 | 2423 | 50 | 1372 | 1 | 2023-03-13 20:38:18 |
18490 | 18490 | 871 | 1908-01-09 | 1335 | 14 | 1372 | 1 | 2023-03-13 20:38:18 |
18491 | 18491 | 871 | 1908-01-09 | 63 | 15 | 1372 | 1 | 2023-03-13 20:38:18 |
18492 | 18492 | 871 | 1908-01-09 | 2422 | 6 | 1372 | 1 | 2023-03-13 20:38:18 |
18514 | 18514 | 945 | 1908-03-18 | 647 | 73 | 1382 | 1 | 2023-03-13 20:38:18 |
18515 | 18515 | 945 | 1908-03-18 | 104 | 10 | 1382 | 1 | 2023-03-13 20:38:18 |
18516 | 18516 | 945 | 1908-03-18 | 2415 | 4 | 1382 | 1 | 2023-03-13 20:38:18 |
18517 | 18517 | 945 | 1908-03-18 | 1435 | 36 | 1382 | 1 | 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 |
18465 | 18465 | 888 | 1908-10-12 | 1605 | 56 | 1363 | 1 | 2023-03-13 20:38:18 |
18466 | 18466 | 888 | 1908-10-12 | 1629 | 24 | 1363 | 1 | 2023-03-13 20:38:18 |
18467 | 18467 | 888 | 1908-10-12 | 590 | 12 | 1363 | 1 | 2023-03-13 20:38:18 |
18468 | 18468 | 888 | 1908-10-12 | 211 | 9 | 1363 | 1 | 2023-03-13 20:38:18 |
18469 | 18469 | 888 | 1908-10-12 | 2430 | 9 | 1363 | 1 | 2023-03-13 20:38:18 |
18470 | 18470 | 888 | 1908-10-12 | 1128 | 4 | 1363 | 1 | 2023-03-13 20:38:18 |
4842 | 4842 | 980 | 1908-10-25 | 531 | 35 | 1458 | 1 | 2023-03-13 20:38:18 |
4843 | 4843 | 980 | 1908-10-25 | 886 | 5 | 1458 | 1 | 2023-03-13 20:38:18 |
4844 | 4844 | 980 | 1908-10-25 | 458 | 15 | 1458 | 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 );