election
Data source: ParlGov · About: simonw/parlgov-datasette
14 rows where "date" is on date 1989-06-18
This data as json, CSV (advanced)
Suggested facets: type_id, country_id, seats_total, electorate, comment, previous_parliament_election_id, previous_ep_election_id, previous_cabinet_id, old_countryID, old_parlID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40 | 40 | 46 | 1 | Ireland 37 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(Ireland) | 15 | 2453451 | 1675119 | 1632728 | eie | 590 590 | 344 344 | Haughey III 77 | 372 | 1019890 | |||
135 | 135 | 158 | 13 | Poland 74 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/Polish_legislative_election,_1989 | 460 | 27026146 | parline | The first polish election after the breakdown of the communism had a special (semi-free or semi-democratic) character. The coding of this election will therefore absorb some more time. | 616 | 19890 | |||||||
179 | 179 | 205 | 13 | Greece 41 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/Greek_legislative_election,_June_1989 | 300 | 8302412 | 6669228 | 6521211 | no-2010 | Inconsistencies with Mackie/Rose (1991/97). | 453 453 | 87 87 | Papandreou A III 39 | 300 | 19890 | ||
208 | 208 | 238 | 1 | Luxembourg 7 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(Luxembourg) | 6 | 218940 | 191342 | 174471 | asl, macr-90 | 183 183 | 109 109 | Santer I 175 | 442 | 1019890 | |||
242 | 242 | 280 | 1 | Italy 26 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(Italy) | 81 | 46346961 | 37572759 | 34804317 | archivio | La Lega Lombarda - Alleanza Nord was an electoral alliance of six minor regionalist parties (comprising Lega Lombarda, Lega Veneta, Piemont Autonomista, Uniun Ligure, Lega Emiliano-Romagnola and Alleanza Toscana) situated in the north of Italy. For the results it is coded with the Party-ID of Lega Lombarda. | 17 17 | 458 458 | De Mita 809 | 380 | 1019890 | ||
257 | 257 | 296 | 1 | Germany 54 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(West_Germany) | 81 | 45773179 | 28508598 | 28206690 | bwl | 588 588 | 610 610 | Kohl III 286 | 276 | 1019890 | |||
265 | 265 | 308 | 1 | Denmark 21 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_%28Denmark%29 | 16 | 3923549 | 1811558 | 1789395 | yb-dnk | 387 387 | 128 128 | Schluter IV 57 | 208 | 1019890 | |||
313 | 313 | 360 | 1 | France 43 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(France) | 81 | 38297496 | 18690692 | 18151416 | ep, frpo, idea | 643 643 | 415 415 | Rocard II 712 | 250 | 1019890 | |||
406 | 406 | 474 | 1 | Spain 27 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(Spain) | 60 | 29283982 | 16022276 | 15657676 | epp | 254 254 | 557 557 | Gonzalez II 834 | 724 | 1019890 | |||
431 | 431 | 504 | 1 | Portugal 63 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(Portugal) | 24 | 8121564 | 4149756 | 4022000 | cne | 480 480 | 535 535 | Silva II 718 | 620 | 1019890 | |||
444 | 444 | 518 | 1 | Greece 41 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(Greece) | 24 | 8347387 | 6668113 | 6544669 | ep | 453 453 | 87 87 | Papandreou A III 39 | 300 | 1019890 | |||
452 | 452 | 526 | 13 | Luxembourg 7 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/Luxembourgian_legislative_election,_1989 | 60 | 218940 | 191777 | 181168 | asl | 183 183 | 109 109 | Santer I 175 | 442 | 19890 | |||
474 | 474 | 553 | 1 | Belgium 64 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(Belgium) | 24 | 7096273 | 6438738 | 5899300 | ibz | 191 191 | 10 10 | Martens VIII 457 | 56 | 1019890 | |||
503 | 503 | 587 | 1 | Netherlands 8 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1989_(Netherlands) | 25 | 11099123 | 5270374 | 5242333 | verk | 62 62 | 341 341 | Lubbers II 550 | 528 | 1019890 |
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]) );