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 |
---|---|---|---|---|---|---|---|---|
4845 | 4845 | 980 | 1908-10-25 | 26 | 105 | 1458 | 1 | 2023-03-13 20:38:18 |
4846 | 4846 | 980 | 1908-10-25 | 35 | 7 | 1458 | 1 | 2023-03-13 20:38:18 |
4290 | 4290 | 885 | 1908-10-26 | 368 | 135 | 1468 | 1 | 2023-03-13 20:38:18 |
4291 | 4291 | 885 | 1908-10-26 | 794 | 85 | 1468 | 1 | 2023-03-13 20:38:18 |
4292 | 4292 | 885 | 1908-10-26 | 1189 | 1 | 1468 | 1 | 2023-03-13 20:38:18 |
16152 | 16152 | 725 | 1908-11-13 | 1253 | 26 | 1001 | 1 | 2023-03-13 20:38:18 |
16153 | 16153 | 725 | 1908-11-13 | 1898 | 16 | 1001 | 1 | 2023-03-13 20:38:18 |
16154 | 16154 | 725 | 1908-11-13 | 1906 | 2 | 1001 | 1 | 2023-03-13 20:38:18 |
16155 | 16155 | 725 | 1908-11-13 | 1917 | 4 | 1001 | 1 | 2023-03-13 20:38:18 |
16156 | 16156 | 725 | 1908-11-13 | 1938 | 27 | 1001 | 1 | 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 |
18181 | 18181 | 972 | 1908-12-19 | 2469 | 50 | 1323 | 1 | 2023-03-13 20:38:18 |
18182 | 18182 | 972 | 1908-12-19 | 2471 | 26 | 1323 | 1 | 2023-03-13 20:38:18 |
18183 | 18183 | 972 | 1908-12-19 | 878 | 1 | 1323 | 1 | 2023-03-13 20:38:18 |
18184 | 18184 | 972 | 1908-12-19 | 1262 | 3 | 1323 | 1 | 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 |
16157 | 16157 | 725 | 1909-06-02 | 1253 | 26 | 1002 | 1 | 2023-03-13 20:38:18 |
16158 | 16158 | 725 | 1909-06-02 | 1898 | 16 | 1002 | 1 | 2023-03-13 20:38:18 |
16159 | 16159 | 725 | 1909-06-02 | 1906 | 2 | 1002 | 1 | 2023-03-13 20:38:18 |
16160 | 16160 | 725 | 1909-06-02 | 1917 | 4 | 1002 | 1 | 2023-03-13 20:38:18 |
16161 | 16161 | 725 | 1909-06-02 | 1938 | 27 | 1002 | 1 | 2023-03-13 20:38:18 |
18547 | 18547 | 986 | 1909-07-24 | 401 | 239 | 1391 | 1 | 2023-03-13 20:38:18 |
18548 | 18548 | 986 | 1909-07-24 | 2586 | 67 | 1391 | 1 | 2023-03-13 20:38:18 |
18549 | 18549 | 986 | 1909-07-24 | 1539 | 53 | 1391 | 1 | 2023-03-13 20:38:18 |
18550 | 18550 | 986 | 1909-07-24 | 2587 | 52 | 1391 | 1 | 2023-03-13 20:38:18 |
18551 | 18551 | 986 | 1909-07-24 | 2589 | 107 | 1391 | 1 | 2023-03-13 20:38:18 |
18552 | 18552 | 986 | 1909-07-24 | 2585 | 39 | 1391 | 1 | 2023-03-13 20:38:18 |
18553 | 18553 | 986 | 1909-07-24 | 2590 | 18 | 1391 | 1 | 2023-03-13 20:38:18 |
18459 | 18459 | 889 | 1909-08-16 | 1629 | 24 | 1362 | 1 | 2023-03-13 20:38:18 |
18460 | 18460 | 889 | 1909-08-16 | 590 | 21 | 1362 | 1 | 2023-03-13 20:38:18 |
18461 | 18461 | 889 | 1909-08-16 | 211 | 15 | 1362 | 1 | 2023-03-13 20:38:18 |
18462 | 18462 | 889 | 1909-08-16 | 2430 | 11 | 1362 | 1 | 2023-03-13 20:38:18 |
18463 | 18463 | 889 | 1909-08-16 | 1128 | 6 | 1362 | 1 | 2023-03-13 20:38:18 |
18464 | 18464 | 889 | 1909-08-16 | 1605 | 37 | 1362 | 1 | 2023-03-13 20:38:18 |
4660 | 4660 | 946 | 1909-10-25 | 1435 | 41 | 1386 | 1 | 2023-03-13 20:38:18 |
4661 | 4661 | 946 | 1909-10-25 | 647 | 46 | 1386 | 1 | 2023-03-13 20:38:18 |
4662 | 4662 | 946 | 1909-10-25 | 104 | 11 | 1386 | 1 | 2023-03-13 20:38:18 |
4663 | 4663 | 946 | 1909-10-25 | 2415 | 2 | 1386 | 1 | 2023-03-13 20:38:18 |
4664 | 4664 | 946 | 1909-10-25 | 2472 | 23 | 1386 | 1 | 2023-03-13 20:38:18 |
18453 | 18453 | 889 | 1909-10-28 | 1629 | 24 | 1361 | 1 | 2023-03-13 20:38:18 |
18454 | 18454 | 889 | 1909-10-28 | 590 | 21 | 1361 | 1 | 2023-03-13 20:38:18 |
18455 | 18455 | 889 | 1909-10-28 | 211 | 15 | 1361 | 1 | 2023-03-13 20:38:18 |
18456 | 18456 | 889 | 1909-10-28 | 2430 | 11 | 1361 | 1 | 2023-03-13 20:38:18 |
18457 | 18457 | 889 | 1909-10-28 | 1128 | 6 | 1361 | 1 | 2023-03-13 20:38:18 |
18458 | 18458 | 889 | 1909-10-28 | 1605 | 37 | 1361 | 1 | 2023-03-13 20:38:18 |
18518 | 18518 | 946 | 1910-02-02 | 1435 | 41 | 1383 | 1 | 2023-03-13 20:38:18 |
18519 | 18519 | 946 | 1910-02-02 | 647 | 46 | 1383 | 1 | 2023-03-13 20:38:18 |
18520 | 18520 | 946 | 1910-02-02 | 104 | 11 | 1383 | 1 | 2023-03-13 20:38:18 |
18521 | 18521 | 946 | 1910-02-02 | 2415 | 2 | 1383 | 1 | 2023-03-13 20:38:18 |
18522 | 18522 | 946 | 1910-02-02 | 2472 | 23 | 1383 | 1 | 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 |
16162 | 16162 | 747 | 1910-04-29 | 1396 | 1 | 1003 | 1 | 2023-03-13 20:38:18 |
16163 | 16163 | 747 | 1910-04-29 | 1253 | 43 | 1003 | 1 | 2023-03-13 20:38:18 |
16164 | 16164 | 747 | 1910-04-29 | 2285 | 31 | 1003 | 1 | 2023-03-13 20:38:18 |
4894 | 4894 | 988 | 1910-05-08 | 2589 | 91 | 1412 | 1 | 2023-03-13 20:38:18 |
4895 | 4895 | 988 | 1910-05-08 | 2594 | 145 | 1412 | 1 | 2023-03-13 20:38:18 |
4896 | 4896 | 988 | 1910-05-08 | 1539 | 75 | 1412 | 1 | 2023-03-13 20:38:18 |
4897 | 4897 | 988 | 1910-05-08 | 2585 | 105 | 1412 | 1 | 2023-03-13 20:38:18 |
4898 | 4898 | 988 | 1910-05-08 | 2590 | 25 | 1412 | 1 | 2023-03-13 20:38:18 |
4899 | 4899 | 988 | 1910-05-08 | 2581 | 137 | 1412 | 1 | 2023-03-13 20:38:18 |
4900 | 4900 | 988 | 1910-05-08 | 1328 | 2 | 1412 | 1 | 2023-03-13 20:38:18 |
20777 | 20777 | 988 | 1910-05-08 | 401 | 0 | 1412 | 1 | 2023-03-13 20:38:18 |
20778 | 20778 | 988 | 1910-05-08 | 2587 | 0 | 1412 | 1 | 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 |
4229 | 4229 | 873 | 1910-05-22 | 2423 | 49 | 1377 | 1 | 2023-03-13 20:38:18 |
4230 | 4230 | 873 | 1910-05-22 | 1335 | 15 | 1377 | 1 | 2023-03-13 20:38:18 |
4231 | 4231 | 873 | 1910-05-22 | 63 | 15 | 1377 | 1 | 2023-03-13 20:38:18 |
4232 | 4232 | 873 | 1910-05-22 | 2422 | 6 | 1377 | 1 | 2023-03-13 20:38:18 |
18449 | 18449 | 890 | 1910-07-05 | 1605 | 57 | 1360 | 1 | 2023-03-13 20:38:18 |
18450 | 18450 | 890 | 1910-07-05 | 1629 | 24 | 1360 | 1 | 2023-03-13 20:38:18 |
18451 | 18451 | 890 | 1910-07-05 | 590 | 13 | 1360 | 1 | 2023-03-13 20:38:18 |
18452 | 18452 | 890 | 1910-07-05 | 211 | 20 | 1360 | 1 | 2023-03-13 20:38:18 |
18554 | 18554 | 988 | 1910-11-03 | 2589 | 91 | 1392 | 1 | 2023-03-13 20:38:18 |
18555 | 18555 | 988 | 1910-11-03 | 2594 | 145 | 1392 | 1 | 2023-03-13 20:38:18 |
18556 | 18556 | 988 | 1910-11-03 | 1539 | 75 | 1392 | 1 | 2023-03-13 20:38:18 |
18557 | 18557 | 988 | 1910-11-03 | 2585 | 105 | 1392 | 1 | 2023-03-13 20:38:18 |
18558 | 18558 | 988 | 1910-11-03 | 2590 | 25 | 1392 | 1 | 2023-03-13 20:38:18 |
18559 | 18559 | 988 | 1910-11-03 | 2581 | 137 | 1392 | 1 | 2023-03-13 20:38:18 |
18560 | 18560 | 988 | 1910-11-03 | 1328 | 2 | 1392 | 1 | 2023-03-13 20:38:18 |
20732 | 20732 | 988 | 1910-11-03 | 401 | 0 | 1392 | 1 | 2023-03-13 20:38:18 |
20733 | 20733 | 988 | 1910-11-03 | 2587 | 0 | 1392 | 1 | 2023-03-13 20:38:18 |
18561 | 18561 | 988 | 1911-03-02 | 2589 | 91 | 1393 | 1 | 2023-03-13 20:38:18 |
18562 | 18562 | 988 | 1911-03-02 | 2594 | 145 | 1393 | 1 | 2023-03-13 20:38:18 |
18563 | 18563 | 988 | 1911-03-02 | 1539 | 75 | 1393 | 1 | 2023-03-13 20:38:18 |
18564 | 18564 | 988 | 1911-03-02 | 2585 | 105 | 1393 | 1 | 2023-03-13 20:38:18 |
18565 | 18565 | 988 | 1911-03-02 | 2590 | 25 | 1393 | 1 | 2023-03-13 20:38:18 |
18566 | 18566 | 988 | 1911-03-02 | 2581 | 137 | 1393 | 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 );