Seattle mayoral election district summary

gistfile1.txt

# Note: based on elecion night data, from:
# http://www.kingcounty.gov/~/media/depts/elections/results/2017/201711/20171107-ecanvass-election-night.csv
# http://kingcounty.gov/depts/elections/results/2017/201711/reports.aspx

$ dists=(11 32 34 36 37 43 46); for dist in "${dists[@]}"; do echo "District $dist" && grep -E '(Seattle Mayor)' 20171107-ecanvass-election-night.csv | grep -E "^SEA $dist" | awk -F',' '{if ($8=="Jenny Durkan") { jd+=$9 } else if ($8=="Cary Moon") { cm+=$9 } else if ($8=="Registered Voters") { rv+=$9 } } END { print "Durkan " jd ", Moon " cm ", Durkan % " jd * 100 / (jd + cm) ", Moon % " cm * 100 / (jd + cm) ", Turnout % " (jd + cm) * 100 / rv }'; done
District 11
Durkan 741, Moon 846, Durkan % 46.6919, Moon % 53.3081, Turnout % 17.2033
District 32
Durkan 1766, Moon 1011, Durkan % 63.5938, Moon % 36.4062, Turnout % 24.7108
District 34
Durkan 9183, Moon 5351, Durkan % 63.1829, Moon % 36.8171, Turnout % 22.6598
District 36
Durkan 16459, Moon 9735, Durkan % 62.835, Moon % 37.165, Turnout % 23.3362
District 37
Durkan 9017, Moon 7828, Durkan % 53.5292, Moon % 46.4708, Turnout % 21.65
District 43
Durkan 14566, Moon 10413, Durkan % 58.313, Moon % 41.687, Turnout % 23.6479
District 46
Durkan 12442, Moon 6499, Durkan % 65.6882, Moon % 34.3118, Turnout % 24.7314