Allocate seats on a fictional national level
read "ef2019.csv"
select partei !== "Übrige"
project partei, fiktive_waehlende sum
relation number
set i = 0
while i < 60
set i = i+ 1
insert i
end while
write "numberlist.csv"
join cross
extend quotient = fiktive_waehlende_sum/number
order quotient 9
limit 1 200
print 10
project partei, number count
order number_count 9
write "seats2019national.csv"
print
partei | fiktive_waehlende_sum | number | quotient |
---|---|---|---|
SVP | 620349.899000000092 | 1 | 620349.899000000092 |
SP | 408134.044999999809 | 1 | 408134.044999999809 |
FDP | 358078.654999999912 | 1 | 358078.654999999912 |
GPS | 319996.956999999937 | 1 | 319996.956999999937 |
SVP | 620349.899000000092 | 2 | 310174.949500000046 |
CVP | 275854.993000000017 | 1 | 275854.993000000017 |
SVP | 620349.899000000092 | 3 | 206783.299666666688 |
SP | 408134.044999999809 | 2 | 204067.022499999905 |
GLP | 189162.470999999961 | 1 | 189162.470999999961 |
FDP | 358078.654999999912 | 2 | 179039.327499999956 |
GPS | 319996.956999999937 | 2 | 159998.478499999968 |
SVP | 620349.899000000092 | 4 | 155087.474750000023 |
CVP | 275854.993000000017 | 2 | 137927.496500000008 |
SP | 408134.044999999809 | 3 | 136044.681666666613 |
SVP | 620349.899000000092 | 5 | 124069.979800000001 |
FDP | 358078.654999999912 | 3 | 119359.551666666623 |
GPS | 319996.956999999937 | 3 | 106665.652333333317 |
SVP | 620349.899000000092 | 6 | 103391.649833333344 |
SP | 408134.044999999809 | 4 | 102033.511249999952 |
GLP | 189162.470999999961 | 2 | 94581.235499999981 |
CVP | 275854.993000000017 | 3 | 91951.664333333334 |
FDP | 358078.654999999912 | 4 | 89519.663749999978 |
SVP | 620349.899000000092 | 7 | 88621.41414285716 |
SP | 408134.044999999809 | 5 | 81626.808999999965 |
GPS | 319996.956999999937 | 4 | 79999.239249999984 |
SVP | 620349.899000000092 | 8 | 77543.737375000012 |
FDP | 358078.654999999912 | 5 | 71615.730999999985 |
CVP | 275854.993000000017 | 4 | 68963.748250000004 |
SVP | 620349.899000000092 | 9 | 68927.766555555572 |
SP | 408134.044999999809 | 6 | 68022.340833333306 |
GPS | 319996.956999999937 | 5 | 63999.391399999986 |
GLP | 189162.470999999961 | 3 | 63054.156999999985 |
SVP | 620349.899000000092 | 10 | 62034.9899 |
FDP | 358078.654999999912 | 6 | 59679.775833333311 |
BDP | 59206.052000000003 | 1 | 59206.052000000011 |
SP | 408134.044999999809 | 7 | 58304.863571428541 |
SVP | 620349.899000000092 | 11 | 56395.445363636369 |
CVP | 275854.993000000017 | 5 | 55170.998600000006 |
GPS | 319996.956999999937 | 6 | 53332.826166666659 |
SVP | 620349.899000000092 | 12 | 51695.824916666672 |
FDP | 358078.654999999912 | 7 | 51154.093571428559 |
SP | 408134.044999999809 | 8 | 51016.755624999976 |
EVP | 50317.221999999994 | 1 | 50317.221999999994 |
SVP | 620349.899000000092 | 13 | 47719.223000000005 |
GLP | 189162.470999999961 | 4 | 47290.61774999999 |
CVP | 275854.993000000017 | 6 | 45975.832166666667 |
GPS | 319996.956999999937 | 7 | 45713.850999999988 |
SP | 408134.044999999809 | 9 | 45348.227222222202 |
FDP | 358078.654999999912 | 8 | 44759.831874999989 |
SVP | 620349.899000000092 | 14 | 44310.70707142858 |
SVP | 620349.899000000092 | 15 | 41356.659933333336 |
SP | 408134.044999999809 | 10 | 40813.404499999982 |
GPS | 319996.956999999937 | 8 | 39999.619624999992 |
FDP | 358078.654999999912 | 9 | 39786.51722222221 |
CVP | 275854.993000000017 | 7 | 39407.856142857148 |
SVP | 620349.899000000092 | 16 | 38771.868687500006 |
GLP | 189162.470999999961 | 5 | 37832.494199999994 |
SP | 408134.044999999809 | 11 | 37103.094999999979 |
SVP | 620349.899000000092 | 17 | 36491.170529411771 |
FDP | 358078.654999999912 | 10 | 35807.865499999993 |
GPS | 319996.956999999937 | 9 | 35555.217444444439 |
CVP | 275854.993000000017 | 8 | 34481.874125000002 |
SVP | 620349.899000000092 | 18 | 34463.883277777786 |
SP | 408134.044999999809 | 12 | 34011.170416666653 |
SVP | 620349.899000000092 | 19 | 32649.994684210527 |
FDP | 358078.654999999912 | 11 | 32552.604999999992 |
GPS | 319996.956999999937 | 10 | 31999.695699999993 |
GLP | 189162.470999999961 | 6 | 31527.078499999992 |
SP | 408134.044999999809 | 13 | 31394.926538461525 |
SVP | 620349.899000000092 | 20 | 31017.49495 |
CVP | 275854.993000000017 | 9 | 30650.554777777779 |
FDP | 358078.654999999912 | 12 | 29839.887916666656 |
BDP | 59206.052000000003 | 2 | 29603.026000000005 |
SVP | 620349.899000000092 | 21 | 29540.471380952386 |
SP | 408134.044999999809 | 14 | 29152.431785714271 |
GPS | 319996.956999999937 | 11 | 29090.632454545448 |
SVP | 620349.899000000092 | 22 | 28197.722681818184 |
CVP | 275854.993000000017 | 10 | 27585.499300000003 |
FDP | 358078.654999999912 | 13 | 27544.511923076916 |
SP | 408134.044999999809 | 15 | 27208.93633333332 |
GLP | 189162.470999999961 | 7 | 27023.210142857137 |
SVP | 620349.899000000092 | 23 | 26971.734739130439 |
GPS | 319996.956999999937 | 12 | 26666.413083333329 |
SVP | 620349.899000000092 | 24 | 25847.912458333336 |
FDP | 358078.654999999912 | 14 | 25577.046785714279 |
SP | 408134.044999999809 | 16 | 25508.377812499988 |
PdA/Sol. | 25428.161 | 1 | 25428.161 |
EVP | 50317.221999999994 | 2 | 25158.610999999997 |
CVP | 275854.993000000017 | 11 | 25077.726636363637 |
SVP | 620349.899000000092 | 25 | 24813.995960000004 |
GPS | 319996.956999999937 | 13 | 24615.150538461534 |
EDU | 24147.272999999997 | 1 | 24147.272999999997 |
SP | 408134.044999999809 | 17 | 24007.884999999987 |
FDP | 358078.654999999912 | 15 | 23871.910333333326 |
SVP | 620349.899000000092 | 26 | 23859.611500000003 |
GLP | 189162.470999999961 | 8 | 23645.308874999995 |
CVP | 275854.993000000017 | 12 | 22987.916083333334 |
SVP | 620349.899000000092 | 27 | 22975.922185185187 |
GPS | 319996.956999999937 | 14 | 22856.925499999994 |
SP | 408134.044999999809 | 18 | 22674.113611111101 |
FDP | 358078.654999999912 | 16 | 22379.915937499994 |
SVP | 620349.899000000092 | 28 | 22155.35353571429 |
SP | 408134.044999999809 | 19 | 21480.739210526306 |
SVP | 620349.899000000092 | 29 | 21391.375827586209 |
GPS | 319996.956999999937 | 15 | 21333.130466666662 |
CVP | 275854.993000000017 | 13 | 21219.614846153847 |
FDP | 358078.654999999912 | 17 | 21063.450294117643 |
GLP | 189162.470999999961 | 9 | 21018.052333333329 |
SVP | 620349.899000000092 | 30 | 20678.329966666668 |
SP | 408134.044999999809 | 20 | 20406.702249999991 |
SVP | 620349.899000000092 | 31 | 20011.287064516131 |
GPS | 319996.956999999937 | 16 | 19999.809812499996 |
FDP | 358078.654999999912 | 18 | 19893.258611111105 |
BDP | 59206.052000000003 | 3 | 19735.350666666669 |
CVP | 275854.993000000017 | 14 | 19703.928071428574 |
SP | 408134.044999999809 | 21 | 19434.954523809516 |
SVP | 620349.899000000092 | 32 | 19385.934343750003 |
GLP | 189162.470999999961 | 10 | 18916.247099999997 |
FDP | 358078.654999999912 | 19 | 18846.244999999995 |
GPS | 319996.956999999937 | 17 | 18823.350411764703 |
SVP | 620349.899000000092 | 33 | 18798.481787878791 |
SP | 408134.044999999809 | 22 | 18551.54749999999 |
CVP | 275854.993000000017 | 15 | 18390.332866666668 |
SVP | 620349.899000000092 | 34 | 18245.585264705885 |
Lega | 18196.981 | 1 | 18196.981 |
FDP | 358078.654999999912 | 20 | 17903.932749999996 |
GPS | 319996.956999999937 | 18 | 17777.60872222222 |
SP | 408134.044999999809 | 23 | 17744.958478260862 |
SVP | 620349.899000000092 | 35 | 17724.282828571431 |
CVP | 275854.993000000017 | 16 | 17240.937062500001 |
SVP | 620349.899000000092 | 36 | 17231.941638888893 |
GLP | 189162.470999999961 | 11 | 17196.588272727269 |
FDP | 358078.654999999912 | 21 | 17051.36452380952 |
SP | 408134.044999999809 | 24 | 17005.585208333327 |
GPS | 319996.956999999937 | 19 | 16841.945105263156 |
EVP | 50317.221999999994 | 3 | 16772.407333333333 |
SVP | 620349.899000000092 | 37 | 16766.213486486489 |
SP | 408134.044999999809 | 25 | 16325.361799999993 |
SVP | 620349.899000000092 | 38 | 16324.997342105264 |
FDP | 358078.654999999912 | 22 | 16276.302499999996 |
CVP | 275854.993000000017 | 17 | 16226.764294117647 |
GPS | 319996.956999999937 | 20 | 15999.847849999996 |
SVP | 620349.899000000092 | 39 | 15906.407666666672 |
GLP | 189162.470999999961 | 12 | 15763.539249999996 |
SP | 408134.044999999809 | 26 | 15697.463269230762 |
FDP | 358078.654999999912 | 23 | 15568.637173913041 |
SVP | 620349.899000000092 | 40 | 15508.747475 |
CVP | 275854.993000000017 | 18 | 15325.27738888889 |
GPS | 319996.956999999937 | 21 | 15237.95033333333 |
SVP | 620349.899000000092 | 41 | 15130.485341463418 |
SP | 408134.044999999809 | 27 | 15116.075740740736 |
FDP | 358078.654999999912 | 24 | 14919.943958333328 |
BDP | 59206.052000000003 | 4 | 14801.513000000003 |
SVP | 620349.899000000092 | 42 | 14770.235690476193 |
SP | 408134.044999999809 | 28 | 14576.215892857135 |
GLP | 189162.470999999961 | 13 | 14550.959307692305 |
GPS | 319996.956999999937 | 22 | 14545.316227272724 |
CVP | 275854.993000000017 | 19 | 14518.683842105263 |
SVP | 620349.899000000092 | 43 | 14426.741837209305 |
FDP | 358078.654999999912 | 25 | 14323.146199999996 |
SVP | 620349.899000000092 | 44 | 14098.861340909092 |
SP | 408134.044999999809 | 29 | 14073.587758620683 |
GPS | 319996.956999999937 | 23 | 13912.91117391304 |
CVP | 275854.993000000017 | 20 | 13792.749650000002 |
SVP | 620349.899000000092 | 45 | 13785.553311111113 |
FDP | 358078.654999999912 | 26 | 13772.255961538458 |
SP | 408134.044999999809 | 30 | 13604.46816666666 |
GLP | 189162.470999999961 | 14 | 13511.605071428568 |
SVP | 620349.899000000092 | 46 | 13485.86736956522 |
GPS | 319996.956999999937 | 24 | 13333.206541666665 |
FDP | 358078.654999999912 | 27 | 13262.172407407405 |
SVP | 620349.899000000092 | 47 | 13198.934021276598 |
SP | 408134.044999999809 | 31 | 13165.614354838703 |
CVP | 275854.993000000017 | 21 | 13135.952047619048 |
SVP | 620349.899000000092 | 48 | 12923.956229166668 |
GPS | 319996.956999999937 | 25 | 12799.878279999997 |
FDP | 358078.654999999912 | 28 | 12788.52339285714 |
SP | 408134.044999999809 | 32 | 12754.188906249994 |
PdA/Sol. | 25428.161 | 2 | 12714.0805 |
SVP | 620349.899000000092 | 49 | 12660.202020408165 |
GLP | 189162.470999999961 | 15 | 12610.831399999997 |
EVP | 50317.221999999994 | 4 | 12579.305499999999 |
CVP | 275854.993000000017 | 22 | 12538.863318181819 |
SVP | 620349.899000000092 | 50 | 12406.997980000002 |
SP | 408134.044999999809 | 33 | 12367.698333333328 |
FDP | 358078.654999999912 | 29 | 12347.539827586204 |
GPS | 319996.956999999937 | 26 | 12307.575269230767 |
SVP | 620349.899000000092 | 51 | 12163.723509803924 |
EDU | 24147.272999999997 | 2 | 12073.636499999999 |
SP | 408134.044999999809 | 34 | 12003.942499999994 |
CVP | 275854.993000000017 | 23 | 11993.695347826088 |
FDP | 358078.654999999912 | 30 | 11935.955166666663 |
SVP | 620349.899000000092 | 52 | 11929.805750000001 |
GPS | 319996.956999999937 | 27 | 11851.739148148146 |
BDP | 59206.052000000003 | 5 | 11841.2104 |
GLP | 189162.470999999961 | 16 | 11822.654437499998 |
SVP | 620349.899000000092 | 53 | 11704.7150754717 |
SP | 408134.044999999809 | 35 | 11660.972714285708 |
FDP | 358078.654999999912 | 31 | 11550.924354838708 |
CVP | 275854.993000000017 | 24 | 11493.958041666667 |
partei | number_count |
---|---|
SVP | 53 |
SP | 35 |
FDP | 31 |
GPS | 27 |
CVP | 24 |
GLP | 16 |
BDP | 5 |
EVP | 4 |
PdA/Sol. | 2 |
EDU | 2 |
Lega | 1 |