party
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by name_ascii descending
This data as json, CSV (advanced)
Link | rowid | id | country_id | family_id | name_short | name_english | name | name_ascii ▲ | name_nonlatin | wikipedia | data_source | description | comment | cmp | euprofiler | ees | morgan | castles_mair | huber_inglehart | ray | benoit_laver | chess | old_countryID | old_partyID |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
942 | 942 | 1812 | Japan 5 | 12 12 | vac | vacancy | vacancy | vacancy | ||||||||||||||||
659 | 659 | 1226 | Switzerland 40 | 14 14 | S | Solidarity | solidaritéS | solidariteS | http://en.wikipedia.org/wiki/Solidarit%C3%A9S | 756 | 17 | |||||||||||||
827 | 827 | 1552 | Italy 26 | 12 12 | none | no party affiliation | senzo partito | senzo partito | 380 | 990 | ||||||||||||||
500 | 500 | 947 | France 43 | 12 12 | none | no party affiliation | sans étiquette | sans etiquette | 250 | 990 | ||||||||||||||
422 | 422 | 786 | Sweden 35 | 12 12 | none | no party affiliation | partilös | partilos | 752 | 990 | ||||||||||||||
334 | 334 | 610 | Germany 54 | 12 12 | none | no party affiliation | parteilos | parteilos | 276 | 990 | ||||||||||||||
651 | 651 | 1211 | Switzerland 40 | 12 12 | none | no party affiliation | parteilos | parteilos | 756 | 990 | ||||||||||||||
257 | 257 | 453 | United Kingdom 44 | 12 12 | etc | others | others | others | 826 | 995 | ||||||||||||||
406 | 406 | 753 | Slovenia 60 | 12 12 | etc | others | others | others | 705 | 995 | ||||||||||||||
566 | 566 | 1055 | Japan 5 | 12 12 | etc | others | others | others | 392 | 995 | ||||||||||||||
584 | 584 | 1091 | Poland 74 | 12 12 | etc | others | others | others | 616 | 995 | ||||||||||||||
734 | 734 | 1365 | New Zealand 11 | 12 12 | etc | others | others | others | 554 | 995 | ||||||||||||||
741 | 741 | 1377 | Spain 27 | 12 12 | etc | others | others | others | 724 | 995 | ||||||||||||||
885 | 885 | 1659 | Slovakia 1 | 12 12 | etc | others | others | others | 703 | 995 | ||||||||||||||
1284 | 1284 | 2352 | Israel 34 | 12 12 | etc | others | others | others | ||||||||||||||||
1396 | 1396 | 2488 | Belgium 64 | 12 12 | etc | others | others | others | ||||||||||||||||
1435 | 1435 | 2576 | Denmark 21 | 12 12 | etc | others | others | others | ||||||||||||||||
1436 | 1436 | 2577 | Canada 29 | 12 12 | etc | others | others | others | ||||||||||||||||
1437 | 1437 | 2578 | Norway 9 | 12 12 | etc | others | others | others | ||||||||||||||||
1438 | 1438 | 2579 | Switzerland 40 | 12 12 | etc | others | others | others | ||||||||||||||||
1527 | 1527 | 2687 | Austria 59 | 12 12 | etc | others | others | others | ||||||||||||||||
1631 | 1631 | 2802 | Lithuania 15 | 12 12 | etc | others | others | others | ||||||||||||||||
1526 | 1526 | 2686 | Austria 59 | 12 12 | one-seat | one-seat | one-seat | one-seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
249 | 249 | 441 | Romania 23 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | 642 | 995 | |||||||||||||
270 | 270 | 474 | Norway 9 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | 578 | 18 | |||||||||||||
360 | 360 | 652 | Lithuania 15 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | 440 | 995 | |||||||||||||
503 | 503 | 952 | Hungary 39 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | 348 | 35 | |||||||||||||
1225 | 1225 | 2287 | Poland 74 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | Only coded if there are no other observations for the parties. Party names included in 'description' of election result. | ||||||||||||||
1226 | 1226 | 2288 | Netherlands 8 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | Only coded if there are no other observations for the parties. Party names included in 'description' of election result. | ||||||||||||||
1227 | 1227 | 2289 | Germany 54 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | Only coded if there are no other observations for the parties. Party names included in 'description' of election result. | ||||||||||||||
1228 | 1228 | 2290 | Luxembourg 7 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | Only coded if there are no other observations for the parties. Party names included in 'description' of election result. | ||||||||||||||
1229 | 1229 | 2291 | Portugal 63 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | Only coded if there are no other observations for the parties. Party names included in 'description' of election result. | ||||||||||||||
1232 | 1232 | 2294 | Spain 27 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1233 | 1233 | 2295 | Croatia 62 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1234 | 1234 | 2296 | United Kingdom 44 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1235 | 1235 | 2297 | Japan 5 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1236 | 1236 | 2298 | Ireland 37 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1237 | 1237 | 2299 | Australia 33 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1238 | 1238 | 2300 | Belgium 64 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1240 | 1240 | 2302 | Italy 26 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1241 | 1241 | 2303 | Switzerland 40 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1249 | 1249 | 2313 | Israel 34 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1339 | 1339 | 2413 | Finland 67 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | Only coded if there are no other observations for the parties. Party names included in 'description' of election result. | ||||||||||||||
1671 | 1671 | 2859 | France 43 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1687 | 1687 | 2879 | Latvia 55 | 12 12 | one-seat | one seat | one seat | one seat | Parties that won one seat in a single election and less than one percent vote share. | |||||||||||||||
1169 | 1169 | 2216 | Ireland 37 | 12 12 | no-seat | no seat | no seat | no-seat | Largest party that won no seats in an election and less than one percent vote share. | |||||||||||||||
1033 | 1033 | 2034 | Germany 54 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1042 | 1042 | 2052 | Belgium 64 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1043 | 1043 | 2053 | Poland 74 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1044 | 1044 | 2054 | Finland 67 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1045 | 1045 | 2055 | Austria 59 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1046 | 1046 | 2056 | Spain 27 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1047 | 1047 | 2057 | Australia 33 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1048 | 1048 | 2058 | Denmark 21 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1049 | 1049 | 2059 | Italy 26 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1054 | 1054 | 2067 | Canada 29 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1057 | 1057 | 2070 | New Zealand 11 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1066 | 1066 | 2080 | France 43 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1081 | 1081 | 2100 | Norway 9 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1089 | 1089 | 2110 | Netherlands 8 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1091 | 1091 | 2112 | Iceland 56 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1108 | 1108 | 2141 | Japan 5 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1114 | 1114 | 2149 | Luxembourg 7 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1128 | 1128 | 2168 | Greece 41 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | |||||||||||||||
1131 | 1131 | 2171 | Malta 72 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1244 | 1244 | 2308 | Israel 34 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1252 | 1252 | 2316 | Turkey 20 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | |||||||||||||||
1283 | 1283 | 2350 | Hungary 39 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
1331 | 1331 | 2405 | Sweden 35 | 12 12 | no-seat | no seat | no seat | no seat | ||||||||||||||||
1421 | 1421 | 2562 | United Kingdom 44 | 12 12 | no-seat | no seat | no seat | no seat | ||||||||||||||||
1487 | 1487 | 2636 | Lithuania 15 | 12 12 | no-seat | no seat | no seat | no seat | ||||||||||||||||
1675 | 1675 | 2864 | Portugal 63 | 12 12 | no-seat | no seat | no seat | no seat | Largest party that won no seats in an election and less than one percent vote share. | Only coded if there are no other observations for the party. Party name included in 'description' of election result. | ||||||||||||||
19 | 19 | 30 | Ireland 37 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 1372000 | 372 | 990 | |||||||||||||
32 | 32 | 58 | Lithuania 15 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 440 | 990 | ||||||||||||||
67 | 67 | 123 | Israel 34 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 376 | 990 | ||||||||||||||
70 | 70 | 133 | Bulgaria 10 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 100 | 990 | ||||||||||||||
71 | 71 | 134 | Iceland 56 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 352 | 990 | ||||||||||||||
155 | 155 | 288 | Latvia 55 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 428 | 990 | ||||||||||||||
238 | 238 | 426 | Estonia 75 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 233 | 990 | ||||||||||||||
298 | 298 | 534 | Cyprus 51 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 196 | 990 | ||||||||||||||
372 | 372 | 674 | Netherlands 8 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 528 | 990 | ||||||||||||||
395 | 395 | 729 | Portugal 63 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 620 | 990 | ||||||||||||||
411 | 411 | 761 | Romania 23 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 642 | 990 | ||||||||||||||
427 | 427 | 793 | Norway 9 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 578 | 990 | ||||||||||||||
482 | 482 | 905 | Japan 5 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 392 | 990 | ||||||||||||||
534 | 534 | 1002 | Luxembourg 7 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 442 | 990 | ||||||||||||||
540 | 540 | 1011 | Poland 74 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 616 | 990 | ||||||||||||||
625 | 625 | 1166 | Spain 27 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 724 | 990 | ||||||||||||||
637 | 637 | 1189 | Canada 29 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 124 | 990 | ||||||||||||||
676 | 676 | 1262 | New Zealand 11 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 554 | 990 | ||||||||||||||
728 | 728 | 1358 | Greece 41 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 300 | 990 | ||||||||||||||
729 | 729 | 1359 | Slovakia 1 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 703 | 990 | ||||||||||||||
737 | 737 | 1370 | Slovenia 60 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 705 | 990 | ||||||||||||||
749 | 749 | 1396 | Australia 33 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 36 | 990 | ||||||||||||||
783 | 783 | 1458 | Belgium 64 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 56 | 990 | ||||||||||||||
836 | 836 | 1567 | Czech Republic 68 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 203 | 990 | ||||||||||||||
838 | 838 | 1572 | Malta 72 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 470 | 990 | ||||||||||||||
853 | 853 | 1599 | United Kingdom 44 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | 826 | 990 | ||||||||||||||
1153 | 1153 | 2197 | Croatia 62 | 12 12 | none | no party affiliation | no party affiliation | no party affiliation | ||||||||||||||||
603 | 603 | 1128 | Denmark 21 | 12 12 | none | no party affiliation | ingen | ingen | 208 | 990 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party("id", "country_id", "family_id", "name_short", "name_english", "name", "name_ascii", "name_nonlatin", "wikipedia", "data_source", "description", "comment", "cmp", "euprofiler", "ees", "morgan", "castles_mair", "huber_inglehart", "ray", "benoit_laver", "chess", "old_countryID", "old_partyID", FOREIGN KEY([country_id]) REFERENCES [country]([id]), FOREIGN KEY([family_id]) REFERENCES [party_family]([id]) );