viewcalc_parliament_composition

Table actions

Data source: ParlGov · About: simonw/parlgov-datasette

31 rows where "date" is on date 2002-07-30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: election_id, seats, cabinet_id, date (date), calculation_date (date)

Link rowid ▼ election_id date party_id seats cabinet_id cabinet_formation calculation_date
16426 16426 797 2002-07-30 276 46 1051 1 2023-03-13 20:38:18
16427 16427 797 2002-07-30 1493 44 1051 1 2023-03-13 20:38:18
16428 16428 797 2002-07-30 1102 24 1051 1 2023-03-13 20:38:18
16429 16429 797 2002-07-30 2196 2 1051 1 2023-03-13 20:38:18
16430 16430 797 2002-07-30 2295 1 1051 1 2023-03-13 20:38:18
16431 16431 797 2002-07-30 1465 17 1051 1 2023-03-13 20:38:18
16432 16432 797 2002-07-30 1384 2 1051 1 2023-03-13 20:38:18
16433 16433 797 2002-07-30 1457 2 1051 1 2023-03-13 20:38:18
16434 16434 797 2002-07-30 1627 4 1051 1 2023-03-13 20:38:18
16435 16435 797 2002-07-30 1044 5 1051 1 2023-03-13 20:38:18
16436 16436 797 2002-07-30 2192 1 1051 1 2023-03-13 20:38:18
16437 16437 797 2002-07-30 2197 3 1051 1 2023-03-13 20:38:18
16938 16938 718 2002-07-30 244 27 1123 1 2023-03-13 20:38:18
16939 16939 718 2002-07-30 678 19 1123 1 2023-03-13 20:38:18
16940 16940 718 2002-07-30 788 17 1123 1 2023-03-13 20:38:18
16941 16941 718 2002-07-30 1419 10 1123 1 2023-03-13 20:38:18
16942 16942 718 2002-07-30 277 4 1123 1 2023-03-13 20:38:18
16943 16943 718 2002-07-30 1850 6 1123 1 2023-03-13 20:38:18
16944 16944 718 2002-07-30 1863 5 1123 1 2023-03-13 20:38:18
16945 16945 718 2002-07-30 214 5 1123 1 2023-03-13 20:38:18
16946 16946 718 2002-07-30 1303 5 1123 1 2023-03-13 20:38:18
16947 16947 718 2002-07-30 1846 3 1123 1 2023-03-13 20:38:18
16948 16948 718 2002-07-30 1357 8 1123 1 2023-03-13 20:38:18
16949 16949 718 2002-07-30 732 3 1123 1 2023-03-13 20:38:18
16950 16950 718 2002-07-30 805 1 1123 1 2023-03-13 20:38:18
16951 16951 718 2002-07-30 615 2 1123 1 2023-03-13 20:38:18
16952 16952 718 2002-07-30 2361 1 1123 1 2023-03-13 20:38:18
16953 16953 718 2002-07-30 123 2 1123 1 2023-03-13 20:38:18
16954 16954 718 2002-07-30 2353 1 1123 1 2023-03-13 20:38:18
16955 16955 718 2002-07-30 1862 3 1123 1 2023-03-13 20:38:18
20698 20698 797 2002-07-30 90 0 1051 1 2023-03-13 20:38:18

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE `viewcalc_parliament_composition` (
  `election_id` INTEGER,
  `date` TEXT,
  `party_id` INTEGER,
  `seats` INTEGER,
  `cabinet_id` INTEGER,
  `cabinet_formation` INTEGER,
  `calculation_date` TEXT
);