results

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

5,980 rows where contest_id = 8826

✎ 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
103518 103518 YES 20688 STATE MEASURE 29 8826 0050001B 12 15 27
103519 103519 NO 20689 STATE MEASURE 29 8826 0050001B 32 51 83
103520 103520 YES 20688 STATE MEASURE 29 8826 0050002C 1 0 1
103521 103521 NO 20689 STATE MEASURE 29 8826 0050002C 2 0 2
103522 103522 YES 20688 STATE MEASURE 29 8826 0050003A 64 166 230
103523 103523 NO 20689 STATE MEASURE 29 8826 0050003A 341 492 833
103524 103524 YES 20688 STATE MEASURE 29 8826 0050004B 10 30 40
103525 103525 NO 20689 STATE MEASURE 29 8826 0050004B 95 120 215
103526 103526 YES 20688 STATE MEASURE 29 8826 0050011A 0 0 0
103527 103527 NO 20689 STATE MEASURE 29 8826 0050011A 1 1 2
103528 103528 YES 20688 STATE MEASURE 29 8826 0050014A 19 48 67
103529 103529 NO 20689 STATE MEASURE 29 8826 0050014A 88 234 322
103530 103530 YES 20688 STATE MEASURE 29 8826 0050023A 0 0 0
103531 103531 NO 20689 STATE MEASURE 29 8826 0050023A 4 0 4
103532 103532 YES 20688 STATE MEASURE 29 8826 0050042A 0 0 0
103533 103533 NO 20689 STATE MEASURE 29 8826 0050042A 0 2 2
103534 103534 YES 20688 STATE MEASURE 29 8826 0050063A 80 174 254
103535 103535 NO 20689 STATE MEASURE 29 8826 0050063A 391 688 1079
103536 103536 YES 20688 STATE MEASURE 29 8826 0070001B 3 10 13
103537 103537 NO 20689 STATE MEASURE 29 8826 0070001B 2 24 26
103538 103538 YES 20688 STATE MEASURE 29 8826 0070002A 1 7 8
103539 103539 NO 20689 STATE MEASURE 29 8826 0070002A 6 38 44
103540 103540 YES 20688 STATE MEASURE 29 8826 0070004C 2 10 12
103541 103541 NO 20689 STATE MEASURE 29 8826 0070004C 6 28 34
103542 103542 YES 20688 STATE MEASURE 29 8826 0070004E 9 54 63
103543 103543 NO 20689 STATE MEASURE 29 8826 0070004E 22 95 117
103544 103544 YES 20688 STATE MEASURE 29 8826 0070006N 4 8 12
103545 103545 NO 20689 STATE MEASURE 29 8826 0070006N 8 30 38
103546 103546 YES 20688 STATE MEASURE 29 8826 0070007A 28 147 175
103547 103547 NO 20689 STATE MEASURE 29 8826 0070007A 94 327 421
103548 103548 YES 20688 STATE MEASURE 29 8826 0070008A 22 88 110
103549 103549 NO 20689 STATE MEASURE 29 8826 0070008A 69 283 352
103550 103550 YES 20688 STATE MEASURE 29 8826 0070027B 0 2 2
103551 103551 NO 20689 STATE MEASURE 29 8826 0070027B 0 0 0
103552 103552 YES 20688 STATE MEASURE 29 8826 0070041A 27 157 184
103553 103553 NO 20689 STATE MEASURE 29 8826 0070041A 140 454 594
103554 103554 YES 20688 STATE MEASURE 29 8826 0070041B 11 33 44
103555 103555 NO 20689 STATE MEASURE 29 8826 0070041B 28 95 123
103556 103556 YES 20688 STATE MEASURE 29 8826 0070041K 1 4 5
103557 103557 NO 20689 STATE MEASURE 29 8826 0070041K 2 6 8
103558 103558 YES 20688 STATE MEASURE 29 8826 0070207A 1 9 10
103559 103559 NO 20689 STATE MEASURE 29 8826 0070207A 0 24 24
103560 103560 YES 20688 STATE MEASURE 29 8826 0080004A 55 278 333
103561 103561 NO 20689 STATE MEASURE 29 8826 0080004A 197 776 973
103562 103562 YES 20688 STATE MEASURE 29 8826 0080012A 39 293 332
103563 103563 NO 20689 STATE MEASURE 29 8826 0080012A 169 899 1068
103564 103564 YES 20688 STATE MEASURE 29 8826 0080021A 76 405 481
103565 103565 NO 20689 STATE MEASURE 29 8826 0080021A 226 1032 1258
103566 103566 YES 20688 STATE MEASURE 29 8826 0080025A 42 295 337
103567 103567 NO 20689 STATE MEASURE 29 8826 0080025A 167 648 815
103568 103568 YES 20688 STATE MEASURE 29 8826 0080038A 46 189 235
103569 103569 NO 20689 STATE MEASURE 29 8826 0080038A 139 505 644
103570 103570 YES 20688 STATE MEASURE 29 8826 0080043A 48 322 370
103571 103571 NO 20689 STATE MEASURE 29 8826 0080043A 142 642 784
103572 103572 YES 20688 STATE MEASURE 29 8826 0080050A 54 313 367
103573 103573 NO 20689 STATE MEASURE 29 8826 0080050A 196 800 996
103574 103574 YES 20688 STATE MEASURE 29 8826 0090002B 0 3 3
103575 103575 NO 20689 STATE MEASURE 29 8826 0090002B 5 9 14
103576 103576 YES 20688 STATE MEASURE 29 8826 0090003A 77 253 330
103577 103577 NO 20689 STATE MEASURE 29 8826 0090003A 441 857 1298
103578 103578 YES 20688 STATE MEASURE 29 8826 0090006A 2 8 10
103579 103579 NO 20689 STATE MEASURE 29 8826 0090006A 5 19 24
103580 103580 YES 20688 STATE MEASURE 29 8826 0090011A 1 5 6
103581 103581 NO 20689 STATE MEASURE 29 8826 0090011A 0 24 24
103582 103582 YES 20688 STATE MEASURE 29 8826 0090025A 1 0 1
103583 103583 NO 20689 STATE MEASURE 29 8826 0090025A 0 4 4
103584 103584 YES 20688 STATE MEASURE 29 8826 0150004A 71 420 491
103585 103585 NO 20689 STATE MEASURE 29 8826 0150004A 147 663 810
103586 103586 YES 20688 STATE MEASURE 29 8826 0150008A 60 187 247
103587 103587 NO 20689 STATE MEASURE 29 8826 0150008A 79 242 321
103588 103588 YES 20688 STATE MEASURE 29 8826 0150009A 62 265 327
103589 103589 NO 20689 STATE MEASURE 29 8826 0150009A 80 324 404
103590 103590 YES 20688 STATE MEASURE 29 8826 0150011A 66 315 381
103591 103591 NO 20689 STATE MEASURE 29 8826 0150011A 110 470 580
103592 103592 YES 20688 STATE MEASURE 29 8826 0150012A 95 406 501
103593 103593 NO 20689 STATE MEASURE 29 8826 0150012A 138 551 689
103594 103594 YES 20688 STATE MEASURE 29 8826 0150016D 101 482 583
103595 103595 NO 20689 STATE MEASURE 29 8826 0150016D 186 672 858
103596 103596 YES 20688 STATE MEASURE 29 8826 0150018A 97 456 553
103597 103597 NO 20689 STATE MEASURE 29 8826 0150018A 156 648 804
103598 103598 YES 20688 STATE MEASURE 29 8826 0150021A 25 179 204
103599 103599 NO 20689 STATE MEASURE 29 8826 0150021A 71 296 367
103600 103600 YES 20688 STATE MEASURE 29 8826 0150025A 65 318 383
103601 103601 NO 20689 STATE MEASURE 29 8826 0150025A 133 475 608
103602 103602 YES 20688 STATE MEASURE 29 8826 0150028B 35 200 235
103603 103603 NO 20689 STATE MEASURE 29 8826 0150028B 50 342 392
103604 103604 YES 20688 STATE MEASURE 29 8826 0150032A 88 400 488
103605 103605 NO 20689 STATE MEASURE 29 8826 0150032A 148 469 617
103606 103606 YES 20688 STATE MEASURE 29 8826 0150033A 76 237 313
103607 103607 NO 20689 STATE MEASURE 29 8826 0150033A 89 341 430
103608 103608 YES 20688 STATE MEASURE 29 8826 0150037A 43 178 221
103609 103609 NO 20689 STATE MEASURE 29 8826 0150037A 59 286 345
103610 103610 YES 20688 STATE MEASURE 29 8826 0150042A 64 353 417
103611 103611 NO 20689 STATE MEASURE 29 8826 0150042A 88 393 481
103612 103612 YES 20688 STATE MEASURE 29 8826 0150049A 73 354 427
103613 103613 NO 20689 STATE MEASURE 29 8826 0150049A 125 469 594
103614 103614 YES 20688 STATE MEASURE 29 8826 0150060A 45 258 303
103615 103615 NO 20689 STATE MEASURE 29 8826 0150060A 60 300 360
103616 103616 YES 20688 STATE MEASURE 29 8826 0150065A 56 158 214
103617 103617 NO 20689 STATE MEASURE 29 8826 0150065A 72 233 305

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]);