viewcalc_parliament_composition

Table actions

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

21 rows where "date" is on date 2012-06-17

✎ 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
3815 3815 782 2012-06-17 686 10 1037 0 2023-03-13 20:38:18
3816 3816 782 2012-06-17 1539 280 1037 0 2023-03-13 20:38:18
3817 3817 782 2012-06-17 1492 12 1037 0 2023-03-13 20:38:18
3818 3818 782 2012-06-17 177 22 1037 0 2023-03-13 20:38:18
3819 3819 782 2012-06-17 873 17 1037 0 2023-03-13 20:38:18
3820 3820 782 2012-06-17 2077 2 1037 0 2023-03-13 20:38:18
3821 3821 782 2012-06-17 509 2 1037 0 2023-03-13 20:38:18
3822 3822 782 2012-06-17 2078 2 1037 0 2023-03-13 20:38:18
3823 3823 782 2012-06-17 401 6 1037 0 2023-03-13 20:38:18
3824 3824 782 2012-06-17 1058 12 1037 0 2023-03-13 20:38:18
3825 3825 782 2012-06-17 658 194 1037 0 2023-03-13 20:38:18
3826 3826 782 2012-06-17 285 15 1037 0 2023-03-13 20:38:18
3827 3827 782 2012-06-17 270 2 1037 0 2023-03-13 20:38:18
3828 3828 782 2012-06-17 2079 1 1037 0 2023-03-13 20:38:18
3836 3836 784 2012-06-17 47 129 1039 0 2023-03-13 20:38:18
3837 3837 784 2012-06-17 1592 71 1039 0 2023-03-13 20:38:18
3838 3838 784 2012-06-17 1338 33 1039 0 2023-03-13 20:38:18
3839 3839 784 2012-06-17 2091 20 1039 0 2023-03-13 20:38:18
3840 3840 784 2012-06-17 2092 18 1039 0 2023-03-13 20:38:18
3841 3841 784 2012-06-17 2093 17 1039 0 2023-03-13 20:38:18
3842 3842 784 2012-06-17 614 12 1039 0 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
);