{"queries":[{"id":"totaal_per_stembureau_over_elections","compiledQueryString":"select bureau, sum(stemmen) as totaal_stemmen\n from election.party\n where bureau <> 'Totaal'\n group by bureau\n order by bureau asc","inputQueryString":"select bureau, sum(stemmen) as totaal_stemmen\n from election.party\n where bureau <> 'Totaal'\n group by bureau\n order by bureau asc","compiled":false,"inline":true},{"id":"eligible_stations","compiledQueryString":"select bureau, election\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n ORDER BY bureau ASC","inputQueryString":"select bureau, election\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n ORDER BY bureau ASC","compiled":false,"inline":true},{"id":"total_stations","compiledQueryString":"select election, sum(stemmen) as total\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n group by election","inputQueryString":"select election, sum(stemmen) as total\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n group by election","compiled":false,"inline":true},{"id":"d66_loyaal_filter","compiledQueryString":"select bureau\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n and election <> '7. TK2025'\n group by bureau\n having count(bureau) < 2","inputQueryString":"select bureau\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n and election <> '7. TK2025'\n group by bureau\n having count(bureau) < 2","compiled":false,"inline":true},{"id":"d66_loyaal","compiledQueryString":"select p.bureau, p.election, p.stemmen, (p.stemmen / t.total) as relative_vote \nfrom election.party p\njoin (select bureau, election\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n ORDER BY bureau ASC) e on e.bureau = p.bureau AND e.election = p.election\nleft join (select election, sum(stemmen) as total\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n group by election) t on t.election = p.election\nwhere p.aanduiding = '${params.partij}'\n and p.bureau not in ((select bureau\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n and election <> '7. TK2025'\n group by bureau\n having count(bureau) < 2))\nORDER BY p.bureau, p.election ASC","inputQueryString":"select p.bureau, p.election, p.stemmen, (p.stemmen / t.total) as relative_vote \nfrom election.party p\njoin ${eligible_stations} e on e.bureau = p.bureau AND e.election = p.election\nleft join ${total_stations} t on t.election = p.election\nwhere p.aanduiding = '${params.partij}'\n and p.bureau not in (${d66_loyaal_filter})\nORDER BY p.bureau, p.election ASC","compiled":true,"inline":true},{"id":"d66_loyaal_stddev","compiledQueryString":"select bureau, stddev(relative_vote) as std, '/wijk_info/' || url_encode(bureau) as bureau_link\nfrom (select p.bureau, p.election, p.stemmen, (p.stemmen / t.total) as relative_vote \nfrom election.party p\njoin (select bureau, election\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n ORDER BY bureau ASC) e on e.bureau = p.bureau AND e.election = p.election\nleft join (select election, sum(stemmen) as total\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n group by election) t on t.election = p.election\nwhere p.aanduiding = '${params.partij}'\n and p.bureau not in ((select bureau\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n and election <> '7. TK2025'\n group by bureau\n having count(bureau) < 2))\nORDER BY p.bureau, p.election ASC)\nwhere relative_vote > 0.03\ngroup by bureau\norder by std \nlimit 10","inputQueryString":"select bureau, stddev(relative_vote) as std, '/wijk_info/' || url_encode(bureau) as bureau_link\nfrom ${d66_loyaal}\nwhere relative_vote > 0.03\ngroup by bureau\norder by std \nlimit 10","compiled":true,"inline":true},{"id":"d66_minst_loyaal_stddev","compiledQueryString":"select bureau, stddev(relative_vote) as std, '/wijk_info/' || url_encode(bureau) as bureau_link\nfrom (select p.bureau, p.election, p.stemmen, (p.stemmen / t.total) as relative_vote \nfrom election.party p\njoin (select bureau, election\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n ORDER BY bureau ASC) e on e.bureau = p.bureau AND e.election = p.election\nleft join (select election, sum(stemmen) as total\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n group by election) t on t.election = p.election\nwhere p.aanduiding = '${params.partij}'\n and p.bureau not in ((select bureau\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n and election <> '7. TK2025'\n group by bureau\n having count(bureau) < 2))\nORDER BY p.bureau, p.election ASC)\nwhere relative_vote < 0.009\ngroup by bureau\norder by std \nlimit 10","inputQueryString":"select bureau, stddev(relative_vote) as std, '/wijk_info/' || url_encode(bureau) as bureau_link\nfrom ${d66_loyaal}\nwhere relative_vote < 0.009\ngroup by bureau\norder by std \nlimit 10","compiled":true,"inline":true},{"id":"d66_meeste_variatie_stddev","compiledQueryString":"select bureau, stddev(relative_vote) as std, '/wijk_info/' || url_encode(bureau) as bureau_link\nfrom (select p.bureau, p.election, p.stemmen, (p.stemmen / t.total) as relative_vote \nfrom election.party p\njoin (select bureau, election\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n ORDER BY bureau ASC) e on e.bureau = p.bureau AND e.election = p.election\nleft join (select election, sum(stemmen) as total\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n group by election) t on t.election = p.election\nwhere p.aanduiding = '${params.partij}'\n and p.bureau not in ((select bureau\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n and election <> '7. TK2025'\n group by bureau\n having count(bureau) < 2))\nORDER BY p.bureau, p.election ASC)\ngroup by bureau\norder by std desc\nlimit 10","inputQueryString":"select bureau, stddev(relative_vote) as std, '/wijk_info/' || url_encode(bureau) as bureau_link\nfrom ${d66_loyaal}\ngroup by bureau\norder by std desc\nlimit 10","compiled":true,"inline":true},{"id":"d66_interessante_wijken","compiledQueryString":"select p.bureau, p.election, p.aanduiding, p.stemmen, (p.stemmen / t.total) as relative_vote \nfrom election.party p\njoin (select bureau, election\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n ORDER BY bureau ASC) e on e.bureau = p.bureau AND e.election = p.election\nleft join (select election, sum(stemmen) as total\n from election.party\n where bureau <> 'Totaal'\n and aanduiding = '${params.partij}'\n and lower(bureau) NOT LIKE '%briefstem%'\n and lower(bureau) NOT LIKE '%bijzonder%'\n group by election) t on t.election = p.election\nwhere p.aanduiding = '${params.partij}'\nORDER BY p.bureau DESC, p.election ASC","inputQueryString":"select p.bureau, p.election, p.aanduiding, p.stemmen, (p.stemmen / t.total) as relative_vote \nfrom election.party p\njoin ${eligible_stations} e on e.bureau = p.bureau AND e.election = p.election\nleft join ${total_stations} t on t.election = p.election\nwhere p.aanduiding = '${params.partij}'\nORDER BY p.bureau DESC, p.election ASC","compiled":true,"inline":true}]}

Partij

Partij details: CDA