English Français Deutsch

Relation Election 6

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