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 |