info_id

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

100 rows

View and edit SQL

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 confidence-vote 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 2 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    
122 cabinet_support 99 arab-list Arab lists Arab satellite lists (Israel only) https://en.wikipedia.org/wiki/Arab_satellite_lists  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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")
);
CREATE INDEX "info_id_67219af6" ON "info_id" ("table_variable");
CREATE INDEX "info_id_3ba08eca" ON "info_id" ("order");
CREATE INDEX "info_id_2ffcd08c" ON "info_id" ("short");
Powered by Datasette · Query took 19.246ms · Data source: ParlGov · About: simonw/parlgov-datasette