User:Joalpe/sandbox/state

{{{{{|safesubst: }}}#invoke:String|replace SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } ?item_position wdt:P361* wd:Q17813784. ?item_position wdt:P1697 ?valids. ?item_position wdt:P31 wd:Q40231. {?item_position (wdt:P541/wdt:P279*) wd:Q10265290.} UNION {?item_position (wdt:P541/wdt:P279*) wd:Q10265289.} OPTIONAL {?item_position p:P726 ?statement.} OPTIONAL {?item_position p:P991 ?statement.} OPTIONAL {?statement ps:P726 ?item.} OPTIONAL {?statement ps:P991 ?item.}
 * source={{{{{|safesubst: }}}#invoke:String|replace
 * source={{{{{|safesubst: }}}#invoke:String|replace
 * source={{{{{|safesubst: }}}#invoke:String|replace
 * source={{Wikidata list
 * sparql=SELECT ?item ?party ?acron ?alliance ?item_position ?votes ?valids ?result ?vice WHERE {

OPTIONAL {?statement pq:P1111 ?votes.} OPTIONAL {?statement pq:P102 ?party.} OPTIONAL {?statement pq:P5832 ?alliance.} OPTIONAL {?party wdt:P1813 ?acron.} OPTIONAL {?statement pq:P6149 ?vice.}

BIND(IF (EXISTS {?item_position wdt:P991 ?item}, "9aed9e","f8f9fa") as ?result) } ORDER BY DESC(?votes) }}
 * columns=label:Candidate, ?votes:Votes received,?valids:Percentage, ?result, ?party, ?alliance, ?vice, ?acron
 * section=?item_position
 * sort=
 * min_section=1
 * thumb=128si
 * autolist=fallback
 * wdedit=yes
 * links=red
 * row_template=subst:Template:Mbabel-BSE/Legislative row
 * header_template=subst:Template:Mbabel-BSE/Legislative header

State elections in Acre in 2014 for State Deputy
class='wikitable sortable wd_can_edit' style='width:100%' !Candidate !Party !Coallition !Votes received !Percentage - style="background-color:#9aed9e;" Ney Amorim style="background-color:#9aed9e; text-align: center" Workers' Party (PT) style="background-color:#9aed9e; text-align: center" Popular Front of Acre V style="background-color:#9aed9e; text-align: center" 10213 style="background-color:#9aed9e; text-align: center" 2.52% - style="background-color:#9aed9e;" Daniel Zen style="background-color:#9aed9e; text-align: center" Workers' Party (PT) style="background-color:#9aed9e; text-align: center" Popular Front of Acre V style="background-color:#9aed9e; text-align: center" 7499 style="background-color:#9aed9e; text-align: center" 1.85% - style="background-color:#9aed9e;" Jonas Lima style="background-color:#9aed9e; text-align: center" Workers' Party (PT) style="background-color:#9aed9e; text-align: center" Popular Front of Acre V style="background-color:#9aed9e; text-align: center" 7222 style="background-color:#9aed9e; text-align: center" 1.78% - style="background-color:#9aed9e;" Josa da Farmácia style="background-color:#9aed9e; text-align: center" Podemos (PODE) style="background-color:#9aed9e; text-align: center" Popular Front of Acre V style="background-color:#9aed9e; text-align: center" 6933 style="background-color:#9aed9e; text-align: center" 1.71% - style="background-color:#9aed9e;" Lourival Marques style="background-color:#9aed9e; text-align: center" Workers' Party (PT) style="background-color:#9aed9e; text-align: center" Popular Front of Acre V style="background-color:#9aed9e; text-align: center" 6585 style="background-color:#9aed9e; text-align: center" 1.62% - style="background-color:#9aed9e;" Leila Galvão style="background-color:#9aed9e; text-align: center" Workers' Party (PT) style="background-color:#9aed9e; text-align: center" Popular Front of Acre V style="background-color:#9aed9e; text-align: center" 6167 style="background-color:#9aed9e; text-align: center" 1.52% - style="background-color:#9aed9e;" Maria Antônia Barbosa style="background-color:#9aed9e; text-align: center" Republican Party of the Social Order (PROS) style="background-color:#9aed9e; text-align: center" Popular Front of Acre V style="background-color:#9aed9e; text-align: center" 6100 style="background-color:#9aed9e; text-align: center" 1.5% - style="background-color:#9aed9e;" Eber Machado style="background-color:#9aed9e; text-align: center" Christian Social Democratic Party (DC) style="background-color:#9aed9e; text-align: center" Q48942748 style="background-color:#9aed9e; text-align: center" 5300 style="background-color:#9aed9e; text-align: center" 1.31% - style="background-color:#9aed9e;" Manoel Moraes style="background-color:#9aed9e; text-align: center" Brazilian Socialist Party (PSB) style="background-color:#9aed9e; text-align: center" Brazilian Socialist Party (isolated party) style="background-color:#9aed9e; text-align: center" 5180 style="background-color:#9aed9e; text-align: center" 1.28% - style="background-color:#9aed9e;" Chagas Romão style="background-color:#9aed9e; text-align: center" Democratic Movement Party (MDB) style="background-color:#9aed9e; text-align: center" Q48942481 style="background-color:#9aed9e; text-align: center" 4893 style="background-color:#9aed9e; text-align: center" 1.21% - style="background-color:#9aed9e;" Janilson Leite style="background-color:#9aed9e; text-align: center" Communist Party of Brazil (PCdoB) style="background-color:#9aed9e; text-align: center" Q48941822 style="background-color:#9aed9e; text-align: center" 4439 style="background-color:#9aed9e; text-align: center" 1.09% - style="background-color:#9aed9e;" Eliane Sinhasique style="background-color:#9aed9e; text-align: center" Democratic Movement Party (MDB) style="background-color:#9aed9e; text-align: center" Q48942481 style="background-color:#9aed9e; text-align: center" 4138 style="background-color:#9aed9e; text-align: center" 1.02% - style="background-color:#9aed9e;" Raimundinho da Saúde style="background-color:#9aed9e; text-align: center" Podemos (PODE) style="background-color:#9aed9e; text-align: center" Q48942993 style="background-color:#9aed9e; text-align: center" 3886 style="background-color:#9aed9e; text-align: center" 0.96% - style="background-color:#9aed9e;" Luiz Gonzaga Alves style="background-color:#9aed9e; text-align: center" Brazilian Social Democracy Party (PSDB) style="background-color:#9aed9e; text-align: center" Q48942481 style="background-color:#9aed9e; text-align: center" 3833 style="background-color:#9aed9e; text-align: center" 0.95% - style="background-color:#9aed9e;" Nicolau Júnior style="background-color:#9aed9e; text-align: center" Progressive Party (PP) style="background-color:#9aed9e; text-align: center" Progressive Party (isolated party) style="background-color:#9aed9e; text-align: center" 3827 style="background-color:#9aed9e; text-align: center" 0.94% - style="background-color:#9aed9e;" Juliana Oliveira style="background-color:#9aed9e; text-align: center" Brazilian Republican Party (PRB) style="background-color:#9aed9e; text-align: center" Q48942993 style="background-color:#9aed9e; text-align: center" 3813 style="background-color:#9aed9e; text-align: center" 0.94% - style="background-color:#9aed9e;" Gehlen Diniz style="background-color:#9aed9e; text-align: center" Progressive Party (PP) style="background-color:#9aed9e; text-align: center" Progressive Party (isolated party) style="background-color:#9aed9e; text-align: center" 3785 style="background-color:#9aed9e; text-align: center" 0.93% - style="background-color:#9aed9e;" André da Droga Vale style="background-color:#9aed9e; text-align: center" Progressive Republican Party (PRP) style="background-color:#9aed9e; text-align: center" Progressive Republican Party (isolated party) style="background-color:#9aed9e; text-align: center" 3733 style="background-color:#9aed9e; text-align: center" 0.92% - style="background-color:#9aed9e;" Nelson Sales style="background-color:#9aed9e; text-align: center" Green Party (PV) style="background-color:#9aed9e; text-align: center" Q48943127 style="background-color:#9aed9e; text-align: center" 3557 style="background-color:#9aed9e; text-align: center" 0.88% - style="background-color:#9aed9e;" Jesus Sérgio style="background-color:#9aed9e; text-align: center" Democratic Labour Party (PDT) style="background-color:#9aed9e; text-align: center" Democratic Labour Party (isolated party) style="background-color:#9aed9e; text-align: center" 3483 style="background-color:#9aed9e; text-align: center" 0.86% - style="background-color:#9aed9e;" Jairo Carvalho style="background-color:#9aed9e; text-align: center" Social Democratic Party (PSD) style="background-color:#9aed9e; text-align: center" Social Democratic Party (isolated party) style="background-color:#9aed9e; text-align: center" 3134 style="background-color:#9aed9e; text-align: center" 0.77% - style="background-color:#9aed9e;" Antônio Pedro Mendonça style="background-color:#9aed9e; text-align: center" Democrats (DEM) style="background-color:#9aed9e; text-align: center" Q48943127 style="background-color:#9aed9e; text-align: center" 2876 style="background-color:#9aed9e; text-align: center" 0.71% - style="background-color:#9aed9e;" Whendy Lima style="background-color:#9aed9e; text-align: center" Party of the Republic (PR) style="background-color:#9aed9e; text-align: center" Q48942485 style="background-color:#9aed9e; text-align: center" 2701 style="background-color:#9aed9e; text-align: center" 0.67% - style="background-color:#9aed9e;" Heitor Júnior style="background-color:#9aed9e; text-align: center" Democratic Labour Party (PDT) style="background-color:#9aed9e; text-align: center" Democratic Labour Party (isolated party) style="background-color:#9aed9e; text-align: center" 2683 style="background-color:#9aed9e; text-align: center" 0.66%
 * }

}} = }} }} {| In the decision for the position of state deputy in the state elections of 2014, 24 deputies were elected with a total of 405,514 valid votes. The Superior Electoral Court counted 6,402 blank votes and 6,856 spoilt votes. Of a total of 506,520 eligible voters, 87,748 (NaN%) did not attend the ballot in the first round.
 * pattern=
 * replace=
 * pattern=
 * replace==
 * pattern===
 * replace====
 * pattern====
 * replace====