viewcalc_parliament_composition

Table actions

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

23 rows where "date" is on date 1993-01-12

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ election_id date party_id seats cabinet_id cabinet_formation calculation_date
12261 12261 294 1993-01-12 1415 29 420 1 2023-03-13 20:38:18
12262 12262 294 1993-01-12 1072 15 420 1 2023-03-13 20:38:18
12263 12263 294 1993-01-12 1432 18 420 1 2023-03-13 20:38:18
12264 12264 294 1993-01-12 1142 74 420 1 2023-03-13 20:38:18
12265 12265 294 1993-01-12 2248 9 420 1 2023-03-13 20:38:18
12266 12266 294 1993-01-12 2247 5 420 1 2023-03-13 20:38:18
13224 13224 382 1993-01-12 199 1 559 1 2023-03-13 20:38:18
13225 13225 382 1993-01-12 65 1 559 1 2023-03-13 20:38:18
13226 13226 382 1993-01-12 179 4 559 1 2023-03-13 20:38:18
13227 13227 382 1993-01-12 1047 15 559 1 2023-03-13 20:38:18
13228 13228 382 1993-01-12 706 14 559 1 2023-03-13 20:38:18
13229 13229 382 1993-01-12 1252 22 559 1 2023-03-13 20:38:18
13230 13230 382 1993-01-12 16 10 559 1 2023-03-13 20:38:18
13231 13231 382 1993-01-12 143 6 559 1 2023-03-13 20:38:18
13232 13232 382 1993-01-12 981 12 559 1 2023-03-13 20:38:18
13233 13233 382 1993-01-12 1619 5 559 1 2023-03-13 20:38:18
14388 14388 359 1993-01-12 1580 4 748 1 2023-03-13 20:38:18
14389 14389 359 1993-01-12 1573 1 748 1 2023-03-13 20:38:18
14390 14390 359 1993-01-12 280 68 748 1 2023-03-13 20:38:18
14391 14391 359 1993-01-12 30 5 748 1 2023-03-13 20:38:18
14392 14392 359 1993-01-12 651 10 748 1 2023-03-13 20:38:18
14393 14393 359 1993-01-12 1393 45 748 1 2023-03-13 20:38:18
14394 14394 359 1993-01-12 318 33 748 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
);