results

Data source: Los Angeles County Registrar-Recorder/County Clerk

5,980 rows where contest_id = 8877

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
225184 225184 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050001B 16 28 44
225185 225185 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050001B 16 22 38
225186 225186 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050002C 1 0 1
225187 225187 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050002C 1 0 1
225188 225188 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050003A 99 279 378
225189 225189 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050003A 239 209 448
225190 225190 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050004B 13 82 95
225191 225191 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050004B 67 41 108
225192 225192 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050011A 0 0 0
225193 225193 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050011A 0 1 1
225194 225194 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050014A 21 101 122
225195 225195 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050014A 60 101 161
225196 225196 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050023A 0 0 0
225197 225197 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050023A 3 0 3
225198 225198 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050042A 0 2 2
225199 225199 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050042A 0 0 0
225200 225200 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050063A 126 332 458
225201 225201 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050063A 257 333 590
225202 225202 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070001B 3 19 22
225203 225203 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070001B 2 5 7
225204 225204 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070002A 2 23 25
225205 225205 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070002A 3 14 17
225206 225206 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070004C 4 20 24
225207 225207 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070004C 3 11 14
225208 225208 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070004E 15 88 103
225209 225209 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070004E 10 21 31
225210 225210 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070006N 9 14 23
225211 225211 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070006N 1 17 18
225212 225212 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070007A 43 311 354
225213 225213 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070007A 48 59 107
225214 225214 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070008A 37 201 238
225215 225215 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070008A 40 81 121
225216 225216 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070027B 0 2 2
225217 225217 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070027B 0 0 0
225218 225218 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041A 52 301 353
225219 225219 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041A 86 136 222
225220 225220 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041B 15 78 93
225221 225221 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041B 17 18 35
225222 225222 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041K 1 7 8
225223 225223 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041K 1 1 2
225224 225224 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070207A 1 16 17
225225 225225 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070207A 0 13 13
225226 225226 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080004A 89 587 676
225227 225227 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080004A 106 179 285
225228 225228 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080012A 75 634 709
225229 225229 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080012A 78 204 282
225230 225230 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080021A 115 807 922
225231 225231 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080021A 123 234 357
225232 225232 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080025A 77 528 605
225233 225233 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080025A 79 154 233
225234 225234 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080038A 67 356 423
225235 225235 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080038A 79 137 216
225236 225236 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080043A 75 525 600
225237 225237 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080043A 70 156 226
225238 225238 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080050A 103 601 704
225239 225239 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080050A 89 219 308
225240 225240 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090002B 1 3 4
225241 225241 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090002B 1 1 2
225242 225242 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090003A 102 432 534
225243 225243 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090003A 322 384 706
225244 225244 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090006A 4 7 11
225245 225245 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090006A 3 10 13
225246 225246 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090011A 0 14 14
225247 225247 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090011A 0 8 8
225248 225248 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090025A 1 4 5
225249 225249 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090025A 0 0 0
225250 225250 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150004A 114 611 725
225251 225251 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150004A 66 169 235
225252 225252 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150008A 74 265 339
225253 225253 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150008A 44 50 94
225254 225254 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150009A 79 397 476
225255 225255 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150009A 42 81 123
225256 225256 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150011A 80 525 605
225257 225257 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150011A 57 88 145
225258 225258 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150012A 120 617 737
225259 225259 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150012A 76 126 202
225260 225260 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150016D 119 724 843
225261 225261 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150016D 110 166 276
225262 225262 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150018A 153 768 921
225263 225263 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150018A 61 126 187
225264 225264 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150021A 51 286 337
225265 225265 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150021A 24 66 90
225266 225266 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150025A 118 512 630
225267 225267 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150025A 56 109 165
225268 225268 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150028B 44 315 359
225269 225269 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150028B 26 82 108
225270 225270 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150032A 128 546 674
225271 225271 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150032A 68 123 191
225272 225272 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150033A 95 369 464
225273 225273 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150033A 41 83 124
225274 225274 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150037A 50 308 358
225275 225275 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150037A 31 48 79
225276 225276 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150042A 81 445 526
225277 225277 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150042A 39 106 145
225278 225278 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150049A 103 481 584
225279 225279 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150049A 64 127 191
225280 225280 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150060A 64 359 423
225281 225281 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150060A 27 77 104
225282 225282 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150065A 73 263 336
225283 225283 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150065A 37 43 80

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [results] (
   [candidate_id] INTEGER REFERENCES [candidates]([id]),
   [contest_id] INTEGER REFERENCES [contests]([id]),
   [precinct_id] TEXT REFERENCES [precincts]([precinct]),
   [polling_place] INTEGER,
   [vote_by_mail] INTEGER,
   [total] INTEGER
);
CREATE INDEX [idx_results_precinct_id]
    ON [results] ([precinct_id]);
CREATE INDEX [idx_results_contest_id]
    ON [results] ([contest_id]);
CREATE INDEX [idx_results_candidate_id]
    ON [results] ([candidate_id]);