home / parlgov

info_id

Data source: ParlGov

99 rows

View and edit SQL

This data as .json

Suggested facets: table_variable, description, wikipedia, old_id

id table_variable order short name description wikipedia old_id
1 election_type 2 ep European Parliament 2
2 party_family 140 agr Agrarian 70
3 party_family 135 chr Christian democracy 50
4 cabinet_termination 5 resignation_pm resignation -- prime minister 5
5 cabinet_termination 7 change_pm change -- prime minister 7
6 party_family 130 lib Liberal 40
7 election_ep_type 1 by-election by-election after accession 1
8 party_family 270 fasc Fascist 89
9 party_family 215 reg Regional 72
10 cabinet_termination 2 change_party change -- party composition change of coalition party composition 2
11 party_family 125 soc Social democracy 30
12 party_family 193 none no family 10
13 election_type 1 parliament Parliamentary election 1
14 party_family 115 com Communist/Socialist 20
15 cabinet_termination 1 election_regular election -- regular election at the end of a legislative period 1
16 party_family 190 spec Special issue single issue parties focussing on particular topics only 76
17 party_family 205 eth Ethnic 74
18 election_ep_type 2 appointments appointments after EU accession 2
19 party_family 120 eco Green/Ecologist 25
21 cabinet_termination 3 election_dissolution election -- dissolution dissolution of parliament and elections before the end of the official term 3
22 party_family 265 nat Nationalist 87
23 cabinet_termination 4 confidencevote losing confidence vote -- RECODE cabinet fails by loosing e.g. vote of confidence, investiture vote, constructive vote of no-confidence 4
24 cabinet_termination 6 resignation_cabinet resignation -- cabinet 6
25 party_family 260 pop Populist populist party 85
26 party_family 145 con Conservative 60
27 party_family 200 all electoral alliance 11
28 party_family 196 code to be coded 99
29 election_ep_type 0 regular regular election 0
30 cabinet_termination 10 other other  
31 party_change_type 4 splinter splinter group New party is formed as splinter group of another party.  
32 party_change_type 3 division division One party divides into two or more new parties.  
33 party_change_type 1 merged merger New party is formed by merging two or more parties that cede to exist.  
34 party_change_type 2 joined joining larger group Party joins a larger group without forming a new party.  
35 party_change_type 5 successor successor Successor party formed by former activists of the predecessor party that ceased to exist.  
36 party_family 240 csp Communist Successor  
37 party_family 292 pens Pensioners  
38 party_family 286 wom Woman  
39 party_family 225 anti Anti-establishment  
40 party_family 150 right Right-wing  
41 party_family 230 a-sys Anti-system  
42 party_family 255 euro European integration  
55 cabinet_support 5 promise support promise  
56 cabinet_support 3 agreement formal agreement  
57 cabinet_support 11 regular informal regular support  
60 party_family 290 tax Taxation  
62 party_change_type 6 politician single politician formed by single (prominent) politician  
63 party_family 250 rel Religious  
64 cabinet_support 13 irregular irregular support  
66 cabinet_support 1 deputy_minister deputy minister  
67 party_family 275 sep Separatist  
68 party_family 235 a-cleric Anti-clericalism http://en.wikipedia.org/wiki/Anti-clericalism  
70 party_family 295 satirical Satirical  
71 person_family_relation 10 sibling sibling (brother/sister)  
72 person_family_relation 2 partner domestic partner  
73 person_family_relation 6 grandchild grand children/parent  
74 person_family_relation 1 spouse spouse  
75 person_family_relation 8 parent-in-law parent-in-law  
76 person_family_relation 5 child children/parent  
77 person_family_relation 7 nephew-niece nephew/niece [uncle/aunt]  
78 person_family_relation 2 spouse-divorce spouse/divorced  
79 party_family 288 animal Animal rights  
80 party_family 500 no-seat no seat Largest party that won no seats in an election and less than one percent vote share.  
81 party_family 245 trans Transition social movement that took part in an election in the process of democratic transition  
82 party_family 282 lib-left Liberal-left  
83 party_family 298 monarch Monarchism  
84 party_family 220 district District party or group in special district provided by national election law  
85 faq_section 1 general General  
86 faq_section 4 contribution Contributions  
88 party_family 510 single single candidate  
89 party_family 278 auton Autonomy  
90 party_family 280 abroad Abroad district  
91 party_family 284 pirate Pirate party http://en.wikipedia.org/wiki/Pirate_Party  
93 party_family 237 cler Clerical  
94 party_family 293 vet Military veterans  
95 party_family 400 min-law electoral law minority Party that benefits from electoral law for minority parties.  
96 party_family 291 credit Social credit http://en.wikipedia.org/wiki/Social_credit  
97 party_family 283 libertas Libertas http://en.wikipedia.org/wiki/Libertas.eu  
98 party_family 515 etc-fam other (family) group of others that belongs to a party family  
99 faq_section 3 release Releases  
100 faq_section 2 data Data  
101 party_family 502 one-seat one seat Parties that won one seat in a single election and less than one percent vote share.  
102 party_family 513 no-party no party used for entries that are no parties and were this proporty does not follow from the party family classification ('no family')  
103 party_family 301 mio Millionaire party created by business person with significant private funding  
104 news_group 1 recent recent election/cabinet  
106 news_group 10 change change data  
107 news_type 1 recent recent event  
108 news_type 90 votes votes level  
109 news_type 9 change change data  
110 news_type 15 stable stable release  
111 news_type 20 presentation presentation  
112 news_type 3 update update  
113 news_type 25 publication publication  
114 news_type 7 new-data new data  
115 news_type 30 announce announcement  
116 news_type 50 misc miscellaneous  
118 party_family 202 caucus parliamentary group  
119 party_family 299 tee Teetotalism  
120 news_type 12 snippets snippets ParlGov snippets on Github -- https://github.com/hdigital/parlgov-snippets  
121 cabinet_support 1 parliamentary-group minister and parliamentary group minister and member of cabinet parliamentary group  
CREATE TABLE "info_id" (
    "id" integer NOT NULL PRIMARY KEY,
    "table_variable" varchar(100) NOT NULL,
    "order" integer unsigned NOT NULL,
    "short" varchar(10) NOT NULL,
    "name" varchar(50) NOT NULL,
    "description" text,
    "wikipedia" varchar(200),
    "old_id" integer unsigned,
    UNIQUE ("table_variable", "short")
)
Powered by Datasette · Query took 11.909ms · Data source: ParlGov