viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows
This data as json, CSV (advanced)
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
301 | 301 | 71 | 1954-03-08 | 66 | 1 | 738 | 0 | 2023-03-13 20:38:18 |
302 | 302 | 71 | 1954-03-08 | 1118 | 24 | 738 | 0 | 2023-03-13 20:38:18 |
303 | 303 | 71 | 1954-03-08 | 1219 | 13 | 738 | 0 | 2023-03-13 20:38:18 |
304 | 304 | 71 | 1954-03-08 | 1292 | 43 | 738 | 0 | 2023-03-13 20:38:18 |
305 | 305 | 73 | 1960-11-15 | 1634 | 4 | 467 | 0 | 2023-03-13 20:38:18 |
306 | 306 | 73 | 1960-11-15 | 1605 | 38 | 467 | 0 | 2023-03-13 20:38:18 |
307 | 307 | 73 | 1960-11-15 | 1644 | 11 | 467 | 0 | 2023-03-13 20:38:18 |
308 | 308 | 73 | 1960-11-15 | 590 | 32 | 467 | 0 | 2023-03-13 20:38:18 |
309 | 309 | 73 | 1960-11-15 | 538 | 6 | 467 | 0 | 2023-03-13 20:38:18 |
310 | 310 | 73 | 1960-11-15 | 1629 | 76 | 467 | 0 | 2023-03-13 20:38:18 |
311 | 311 | 73 | 1960-11-15 | 812 | 1 | 467 | 0 | 2023-03-13 20:38:18 |
312 | 312 | 73 | 1960-11-15 | 211 | 11 | 467 | 0 | 2023-03-13 20:38:18 |
313 | 313 | 74 | 2002-05-15 | 345 | 7 | 749 | 0 | 2023-03-13 20:38:18 |
314 | 314 | 74 | 2002-05-15 | 357 | 9 | 749 | 0 | 2023-03-13 20:38:18 |
315 | 315 | 74 | 2002-05-15 | 742 | 23 | 749 | 0 | 2023-03-13 20:38:18 |
316 | 316 | 74 | 2002-05-15 | 744 | 2 | 749 | 0 | 2023-03-13 20:38:18 |
317 | 317 | 74 | 2002-05-15 | 235 | 43 | 749 | 0 | 2023-03-13 20:38:18 |
318 | 318 | 74 | 2002-05-15 | 1409 | 24 | 749 | 0 | 2023-03-13 20:38:18 |
319 | 319 | 74 | 2002-05-15 | 756 | 10 | 749 | 0 | 2023-03-13 20:38:18 |
320 | 320 | 74 | 2002-05-15 | 1206 | 4 | 749 | 0 | 2023-03-13 20:38:18 |
321 | 321 | 74 | 2002-05-15 | 456 | 26 | 749 | 0 | 2023-03-13 20:38:18 |
322 | 322 | 74 | 2002-05-15 | 1251 | 2 | 749 | 0 | 2023-03-13 20:38:18 |
323 | 323 | 75 | 1946-11-10 | 1539 | 90 | 150 | 0 | 2023-03-13 20:38:18 |
324 | 324 | 75 | 1946-11-10 | 1086 | 158 | 150 | 0 | 2023-03-13 20:38:18 |
325 | 325 | 75 | 1946-11-10 | 1094 | 5 | 150 | 0 | 2023-03-13 20:38:18 |
326 | 326 | 75 | 1946-11-10 | 686 | 166 | 150 | 0 | 2023-03-13 20:38:18 |
327 | 327 | 75 | 1946-11-10 | 890 | 55 | 150 | 0 | 2023-03-13 20:38:18 |
328 | 328 | 75 | 1946-11-10 | 1297 | 70 | 150 | 0 | 2023-03-13 20:38:18 |
329 | 329 | 76 | 1962-06-18 | 1392 | 30 | 619 | 1 | 2023-03-13 20:38:18 |
330 | 330 | 76 | 1962-06-18 | 794 | 116 | 619 | 1 | 2023-03-13 20:38:18 |
331 | 331 | 76 | 1962-06-18 | 368 | 99 | 619 | 1 | 2023-03-13 20:38:18 |
332 | 332 | 76 | 1962-06-18 | 296 | 19 | 619 | 1 | 2023-03-13 20:38:18 |
333 | 333 | 76 | 1962-06-18 | 2085 | 1 | 619 | 1 | 2023-03-13 20:38:18 |
334 | 334 | 77 | 1970-03-16 | 1292 | 36 | 203 | 0 | 2023-03-13 20:38:18 |
335 | 335 | 77 | 1970-03-16 | 66 | 1 | 203 | 0 | 2023-03-13 20:38:18 |
336 | 336 | 77 | 1970-03-16 | 200 | 18 | 203 | 0 | 2023-03-13 20:38:18 |
337 | 337 | 77 | 1970-03-16 | 585 | 11 | 203 | 0 | 2023-03-13 20:38:18 |
338 | 338 | 77 | 1970-03-16 | 395 | 52 | 203 | 0 | 2023-03-13 20:38:18 |
339 | 339 | 77 | 1970-03-16 | 1219 | 8 | 203 | 0 | 2023-03-13 20:38:18 |
340 | 340 | 77 | 1970-03-16 | 1118 | 37 | 203 | 0 | 2023-03-13 20:38:18 |
341 | 341 | 77 | 1970-03-16 | 94 | 36 | 203 | 0 | 2023-03-13 20:38:18 |
342 | 342 | 77 | 1970-03-16 | 1463 | 1 | 203 | 0 | 2023-03-13 20:38:18 |
343 | 343 | 79 | 2009-07-05 | 1254 | 15 | 425 | 0 | 2023-03-13 20:38:18 |
344 | 344 | 79 | 2009-07-05 | 1160 | 40 | 425 | 0 | 2023-03-13 20:38:18 |
345 | 345 | 79 | 2009-07-05 | 1541 | 116 | 425 | 0 | 2023-03-13 20:38:18 |
346 | 346 | 79 | 2009-07-05 | 636 | 10 | 425 | 0 | 2023-03-13 20:38:18 |
347 | 347 | 79 | 2009-07-05 | 535 | 21 | 425 | 0 | 2023-03-13 20:38:18 |
348 | 348 | 79 | 2009-07-05 | 1286 | 38 | 425 | 0 | 2023-03-13 20:38:18 |
349 | 349 | 80 | 2004-10-03 | 16 | 7 | 292 | 0 | 2023-03-13 20:38:18 |
350 | 350 | 80 | 2004-10-03 | 1047 | 9 | 292 | 0 | 2023-03-13 20:38:18 |
351 | 351 | 80 | 2004-10-03 | 1252 | 23 | 292 | 0 | 2023-03-13 20:38:18 |
352 | 352 | 80 | 2004-10-03 | 179 | 29 | 292 | 0 | 2023-03-13 20:38:18 |
353 | 353 | 80 | 2004-10-03 | 706 | 10 | 292 | 0 | 2023-03-13 20:38:18 |
354 | 354 | 80 | 2004-10-03 | 1587 | 4 | 292 | 0 | 2023-03-13 20:38:18 |
355 | 355 | 80 | 2004-10-03 | 65 | 1 | 292 | 0 | 2023-03-13 20:38:18 |
356 | 356 | 80 | 2004-10-03 | 981 | 6 | 292 | 0 | 2023-03-13 20:38:18 |
357 | 357 | 80 | 2004-10-03 | 199 | 1 | 292 | 0 | 2023-03-13 20:38:18 |
358 | 358 | 81 | 1981-05-26 | 345 | 17 | 563 | 0 | 2023-03-13 20:38:18 |
359 | 359 | 81 | 1981-05-26 | 1409 | 26 | 563 | 0 | 2023-03-13 20:38:18 |
360 | 360 | 81 | 1981-05-26 | 1194 | 3 | 563 | 0 | 2023-03-13 20:38:18 |
361 | 361 | 81 | 1981-05-26 | 1452 | 3 | 563 | 0 | 2023-03-13 20:38:18 |
362 | 362 | 81 | 1981-05-26 | 212 | 2 | 563 | 0 | 2023-03-13 20:38:18 |
363 | 363 | 81 | 1981-05-26 | 342 | 3 | 563 | 0 | 2023-03-13 20:38:18 |
364 | 364 | 81 | 1981-05-26 | 235 | 48 | 563 | 0 | 2023-03-13 20:38:18 |
365 | 365 | 81 | 1981-05-26 | 1251 | 3 | 563 | 0 | 2023-03-13 20:38:18 |
366 | 366 | 81 | 1981-05-26 | 625 | 1 | 563 | 0 | 2023-03-13 20:38:18 |
367 | 367 | 81 | 1981-05-26 | 742 | 44 | 563 | 0 | 2023-03-13 20:38:18 |
368 | 368 | 82 | 1995-04-08 | 228 | 7 | 640 | 0 | 2023-03-13 20:38:18 |
369 | 369 | 82 | 1995-04-08 | 1342 | 25 | 640 | 0 | 2023-03-13 20:38:18 |
370 | 370 | 82 | 1995-04-08 | 147 | 3 | 640 | 0 | 2023-03-13 20:38:18 |
371 | 371 | 82 | 1995-04-08 | 1360 | 9 | 640 | 0 | 2023-03-13 20:38:18 |
372 | 372 | 82 | 1995-04-08 | 205 | 4 | 640 | 0 | 2023-03-13 20:38:18 |
373 | 373 | 82 | 1995-04-08 | 1455 | 15 | 640 | 0 | 2023-03-13 20:38:18 |
374 | 374 | 83 | 2007-03-04 | 1597 | 19 | 274 | 0 | 2023-03-13 20:38:18 |
375 | 375 | 83 | 2007-03-04 | 113 | 31 | 274 | 0 | 2023-03-13 20:38:18 |
376 | 376 | 83 | 2007-03-04 | 417 | 6 | 274 | 0 | 2023-03-13 20:38:18 |
377 | 377 | 83 | 2007-03-04 | 1137 | 29 | 274 | 0 | 2023-03-13 20:38:18 |
378 | 378 | 83 | 2007-03-04 | 1448 | 10 | 274 | 0 | 2023-03-13 20:38:18 |
379 | 379 | 83 | 2007-03-04 | 219 | 6 | 274 | 0 | 2023-03-13 20:38:18 |
380 | 380 | 84 | 1979-03-19 | 1292 | 35 | 492 | 0 | 2023-03-13 20:38:18 |
381 | 381 | 84 | 1979-03-19 | 1219 | 4 | 492 | 0 | 2023-03-13 20:38:18 |
382 | 382 | 84 | 1979-03-19 | 94 | 36 | 492 | 0 | 2023-03-13 20:38:18 |
383 | 383 | 84 | 1979-03-19 | 1463 | 9 | 492 | 0 | 2023-03-13 20:38:18 |
384 | 384 | 84 | 1979-03-19 | 395 | 52 | 492 | 0 | 2023-03-13 20:38:18 |
385 | 385 | 84 | 1979-03-19 | 200 | 7 | 492 | 0 | 2023-03-13 20:38:18 |
386 | 386 | 84 | 1979-03-19 | 1118 | 47 | 492 | 0 | 2023-03-13 20:38:18 |
387 | 387 | 84 | 1979-03-19 | 585 | 9 | 492 | 0 | 2023-03-13 20:38:18 |
388 | 388 | 84 | 1979-03-19 | 66 | 1 | 492 | 0 | 2023-03-13 20:38:18 |
389 | 389 | 85 | 1982-10-28 | 637 | 2 | 406 | 0 | 2023-03-13 20:38:18 |
390 | 390 | 85 | 1982-10-28 | 1361 | 8 | 406 | 0 | 2023-03-13 20:38:18 |
391 | 391 | 85 | 1982-10-28 | 757 | 1 | 406 | 0 | 2023-03-13 20:38:18 |
392 | 392 | 85 | 1982-10-28 | 902 | 202 | 406 | 0 | 2023-03-13 20:38:18 |
393 | 393 | 85 | 1982-10-28 | 894 | 12 | 406 | 0 | 2023-03-13 20:38:18 |
394 | 394 | 85 | 1982-10-28 | 135 | 11 | 406 | 0 | 2023-03-13 20:38:18 |
395 | 395 | 85 | 1982-10-28 | 645 | 107 | 406 | 0 | 2023-03-13 20:38:18 |
396 | 396 | 85 | 1982-10-28 | 1026 | 1 | 406 | 0 | 2023-03-13 20:38:18 |
397 | 397 | 85 | 1982-10-28 | 118 | 4 | 406 | 0 | 2023-03-13 20:38:18 |
398 | 398 | 85 | 1982-10-28 | 1317 | 2 | 406 | 0 | 2023-03-13 20:38:18 |
399 | 399 | 88 | 1953-06-28 | 1319 | 7 | 766 | 0 | 2023-03-13 20:38:18 |
400 | 400 | 88 | 1953-06-28 | 1342 | 21 | 766 | 0 | 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 );