Skip to content

Instantly share code, notes, and snippets.

@catrope

catrope/round7-d6.md

Created November 5, 2018 00:10
Show Gist options
  • Save catrope/29b1da2218c5c957da0ca35f1d599d53 to your computer and use it in GitHub Desktop.
Save catrope/29b1da2218c5c957da0ca35f1d599d53 to your computer and use it in GitHub Desktop.
Download ZIP
Last two round totals per precinct in D6 (2018 SF Mayor's race)
Raw
round7-d6.md

sqlite> select precinct, round7, count(*) from ballots where contest='Mayor' and district=6 and round7 not in ('exhausted', 'undervote', 'overvote') group by precinct, round7;

precinct round7 count(*)
Pct 7601 Jane Kim 90
Pct 7601 London Breed 101
Pct 7601 Mark Leno 92
Pct 7602 Jane Kim 125
Pct 7602 London Breed 119
Pct 7602 Mark Leno 119
Pct 7603 Jane Kim 144
Pct 7603 London Breed 90
Pct 7603 Mark Leno 119
Pct 7604 Jane Kim 131
Pct 7604 London Breed 116
Pct 7604 Mark Leno 99
Pct 7605 Jane Kim 78
Pct 7605 London Breed 71
Pct 7605 Mark Leno 66
Pct 7606 Jane Kim 113
Pct 7606 London Breed 117
Pct 7606 Mark Leno 95
Pct 7607 Jane Kim 136
Pct 7607 London Breed 107
Pct 7607 Mark Leno 119
Pct 7608 Jane Kim 37
Pct 7608 London Breed 66
Pct 7608 Mark Leno 46
Pct 7609 Jane Kim 139
Pct 7609 London Breed 120
Pct 7609 Mark Leno 103
Pct 7611 Jane Kim 74
Pct 7611 London Breed 112
Pct 7611 Mark Leno 69
Pct 7612 Jane Kim 71
Pct 7612 London Breed 99
Pct 7612 Mark Leno 74
Pct 7613 Jane Kim 124
Pct 7613 London Breed 125
Pct 7613 Mark Leno 86
Pct 7614 Jane Kim 112
Pct 7614 London Breed 117
Pct 7614 Mark Leno 105
Pct 7615 Jane Kim 95
Pct 7615 London Breed 103
Pct 7615 Mark Leno 60
Pct 7616 Jane Kim 97
Pct 7616 London Breed 224
Pct 7616 Mark Leno 132
Pct 7617 Jane Kim 83
Pct 7617 London Breed 112
Pct 7617 Mark Leno 87
Pct 7618 Jane Kim 108
Pct 7618 London Breed 129
Pct 7618 Mark Leno 138
Pct 7619 Jane Kim 154
Pct 7619 London Breed 165
Pct 7619 Mark Leno 122
Pct 7621 Jane Kim 163
Pct 7621 London Breed 206
Pct 7621 Mark Leno 124
Pct 7622 Jane Kim 90
Pct 7622 London Breed 100
Pct 7622 Mark Leno 76
Pct 7623 Jane Kim 126
Pct 7623 London Breed 90
Pct 7623 Mark Leno 84
Pct 7624 Jane Kim 109
Pct 7624 London Breed 105
Pct 7624 Mark Leno 67
Pct 7625 Jane Kim 106
Pct 7625 London Breed 219
Pct 7625 Mark Leno 130
Pct 7626 Jane Kim 110
Pct 7626 London Breed 212
Pct 7626 Mark Leno 138
Pct 7627 Jane Kim 72
Pct 7627 London Breed 194
Pct 7627 Mark Leno 118
Pct 7628 Jane Kim 120
Pct 7628 London Breed 150
Pct 7628 Mark Leno 133
Pct 7629 Jane Kim 90
Pct 7629 London Breed 113
Pct 7629 Mark Leno 94
Pct 7631 Jane Kim 145
Pct 7631 London Breed 184
Pct 7631 Mark Leno 132
Pct 7632 Jane Kim 123
Pct 7632 London Breed 164
Pct 7632 Mark Leno 154
Pct 7633 Jane Kim 85
Pct 7633 London Breed 141
Pct 7633 Mark Leno 92
Pct 7634 Jane Kim 88
Pct 7634 London Breed 168
Pct 7634 Mark Leno 116
Pct 7635 Jane Kim 66
Pct 7635 London Breed 163
Pct 7635 Mark Leno 92
Pct 7636 Jane Kim 82
Pct 7636 London Breed 184
Pct 7636 Mark Leno 102
Pct 7637 Jane Kim 69
Pct 7637 London Breed 162
Pct 7637 Mark Leno 93
Pct 7638 Jane Kim 109
Pct 7638 London Breed 327
Pct 7638 Mark Leno 141
Pct 7639 Jane Kim 80
Pct 7639 London Breed 212
Pct 7639 Mark Leno 112
Pct 7641 Jane Kim 80
Pct 7641 London Breed 205
Pct 7641 Mark Leno 158
Pct 7642 Jane Kim 60
Pct 7642 London Breed 211
Pct 7642 Mark Leno 61
Pct 7643 Jane Kim 107
Pct 7643 London Breed 191
Pct 7643 Mark Leno 127
Pct 7644 Jane Kim 108
Pct 7644 London Breed 221
Pct 7644 Mark Leno 90
Pct 7645 Jane Kim 49
Pct 7645 London Breed 151
Pct 7645 Mark Leno 90
Pct 7646 Jane Kim 116
Pct 7646 London Breed 208
Pct 7646 Mark Leno 90
Pct 7647 Jane Kim 88
Pct 7647 London Breed 115
Pct 7647 Mark Leno 71
Pct 7649 Jane Kim 82
Pct 7649 London Breed 144
Pct 7649 Mark Leno 82
Pct 7651 Jane Kim 32
Pct 7651 London Breed 106
Pct 7651 Mark Leno 50
Pct 7652 Jane Kim 57
Pct 7652 London Breed 109
Pct 7652 Mark Leno 60
Pct 7653 Jane Kim 110
Pct 7653 London Breed 243
Pct 7653 Mark Leno 84
Raw
round8-d6.md

sqlite> select precinct, round8, count(*) from ballots where contest='Mayor' and district=6 and round8 not in ('exhausted', 'undervote', 'overvote') group by precinct, round8;

precinct round8 count(*)
Pct 7601 London Breed 119
Pct 7601 Mark Leno 149
Pct 7602 London Breed 137
Pct 7602 Mark Leno 207
Pct 7603 London Breed 112
Pct 7603 Mark Leno 226
Pct 7604 London Breed 144
Pct 7604 Mark Leno 187
Pct 7605 London Breed 97
Pct 7605 Mark Leno 103
Pct 7606 London Breed 137
Pct 7606 Mark Leno 171
Pct 7607 London Breed 134
Pct 7607 Mark Leno 210
Pct 7608 London Breed 78
Pct 7608 Mark Leno 60
Pct 7609 London Breed 149
Pct 7609 Mark Leno 172
Pct 7611 London Breed 132
Pct 7611 Mark Leno 106
Pct 7612 London Breed 114
Pct 7612 Mark Leno 124
Pct 7613 London Breed 153
Pct 7613 Mark Leno 156
Pct 7614 London Breed 135
Pct 7614 Mark Leno 179
Pct 7615 London Breed 123
Pct 7615 Mark Leno 107
Pct 7616 London Breed 252
Pct 7616 Mark Leno 193
Pct 7617 London Breed 130
Pct 7617 Mark Leno 131
Pct 7618 London Breed 143
Pct 7618 Mark Leno 220
Pct 7619 London Breed 192
Pct 7619 Mark Leno 232
Pct 7621 London Breed 248
Pct 7621 Mark Leno 219
Pct 7622 London Breed 122
Pct 7622 Mark Leno 129
Pct 7623 London Breed 111
Pct 7623 Mark Leno 165
Pct 7624 London Breed 131
Pct 7624 Mark Leno 125
Pct 7625 London Breed 243
Pct 7625 Mark Leno 181
Pct 7626 London Breed 234
Pct 7626 Mark Leno 206
Pct 7627 London Breed 217
Pct 7627 Mark Leno 154
Pct 7628 London Breed 169
Pct 7628 Mark Leno 220
Pct 7629 London Breed 129
Pct 7629 Mark Leno 153
Pct 7631 London Breed 219
Pct 7631 Mark Leno 218
Pct 7632 London Breed 198
Pct 7632 Mark Leno 231
Pct 7633 London Breed 162
Pct 7633 Mark Leno 136
Pct 7634 London Breed 184
Pct 7634 Mark Leno 173
Pct 7635 London Breed 176
Pct 7635 Mark Leno 135
Pct 7636 London Breed 205
Pct 7636 Mark Leno 151
Pct 7637 London Breed 182
Pct 7637 Mark Leno 135
Pct 7638 London Breed 356
Pct 7638 Mark Leno 194
Pct 7639 London Breed 233
Pct 7639 Mark Leno 154
Pct 7641 London Breed 227
Pct 7641 Mark Leno 207
Pct 7642 London Breed 226
Pct 7642 Mark Leno 94
Pct 7643 London Breed 228
Pct 7643 Mark Leno 179
Pct 7644 London Breed 258
Pct 7644 Mark Leno 146
Pct 7645 London Breed 161
Pct 7645 Mark Leno 121
Pct 7646 London Breed 240
Pct 7646 Mark Leno 157
Pct 7647 London Breed 131
Pct 7647 Mark Leno 127
Pct 7649 London Breed 165
Pct 7649 Mark Leno 129
Pct 7651 London Breed 115
Pct 7651 Mark Leno 61
Pct 7652 London Breed 121
Pct 7652 Mark Leno 94
Pct 7653 London Breed 269
Pct 7653 Mark Leno 146
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment