election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "date" is on date 1974-03-10
This data as json, CSV (advanced)
Link | rowid ▼ | id | type_id | country_id | date | first_round_election_id | early | wikipedia | seats_total | electorate | votes_cast | votes_valid | data_source | description | comment | previous_parliament_election_id | previous_ep_election_id | previous_cabinet_id | old_countryID | old_parlID |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
333 | 333 | 384 | 13 | Belgium 64 | 1974-03-10 | 1 | http://en.wikipedia.org/wiki/Belgian_general_election,_1974 | 212 | 6323027 | 5711639 | 5258531 | ibz | Although the two successor parties of the PSB-BSP (Parti socialiste belge-Belgische Socialistische Partij) were founded in 1978, the IBZ data differentiates between the Flemish and the Wallonian part for the 1977 election results without further specification. Since all other sources (Nohlen, Mackie/Rose, Cevipol) stand in contrast with this, the PSB-BSP is coded as one party. | 591 591 | Leburton 859 | 56 | 19740 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE election("id", "type_id", "country_id", "date", "first_round_election_id", "early", "wikipedia", "seats_total", "electorate", "votes_cast", "votes_valid", "data_source", "description", "comment", "previous_parliament_election_id", "previous_ep_election_id", "previous_cabinet_id", "old_countryID", "old_parlID", FOREIGN KEY([country_id]) REFERENCES [country]([id]), FOREIGN KEY([previous_cabinet_id]) REFERENCES [cabinet]([id]), FOREIGN KEY([previous_parliament_election_id]) REFERENCES [election]([id]), FOREIGN KEY([previous_ep_election_id]) REFERENCES [election]([id]) );