results

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

208 rows where contest_id = 9892

✎ 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
200458 200458 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050001F 2 8 10
200459 200459 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050001F 2 15 17
200460 200460 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050003A 0 0 0
200461 200461 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050003A 0 0 0
200462 200462 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050003B 0 0 0
200463 200463 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050003B 0 0 0
200464 200464 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050003D 0 0 0
200465 200465 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050003D 0 0 0
200466 200466 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050004A 0 0 0
200467 200467 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050004A 0 0 0
200468 200468 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050005A 0 0 0
200469 200469 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050005A 0 0 0
200470 200470 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050048A 53 157 210
200471 200471 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050048A 51 82 133
200472 200472 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050063A 0 0 0
200473 200473 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050063A 0 0 0
200474 200474 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050205B 0 0 0
200475 200475 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050205B 0 0 0
200476 200476 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050206A 0 0 0
200477 200477 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050206A 0 0 0
200478 200478 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050207A 0 0 0
200479 200479 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2050207A 0 0 0
200480 200480 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630001A 0 7 7
200481 200481 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630001A 0 1 1
200482 200482 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630001B 17 102 119
200483 200483 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630001B 10 43 53
200484 200484 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630003A 0 0 0
200485 200485 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630003A 0 0 0
200486 200486 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630010A 11 66 77
200487 200487 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630010A 11 27 38
200488 200488 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630049A 382 1304 1686
200489 200489 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630049A 222 645 867
200490 200490 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630063A 267 690 957
200491 200491 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630063A 148 299 447
200492 200492 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630084A 270 1204 1474
200493 200493 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630084A 151 524 675
200494 200494 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630159A 401 1623 2024
200495 200495 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630159A 273 717 990
200496 200496 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630172A 124 530 654
200497 200497 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630172A 74 275 349
200498 200498 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630192A 432 1304 1736
200499 200499 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630192A 242 521 763
200500 200500 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630195A 250 737 987
200501 200501 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630195A 141 326 467
200502 200502 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630199A 180 773 953
200503 200503 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630199A 135 407 542
200504 200504 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630205B 0 0 0
200505 200505 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 2630205B 0 0 0
200506 200506 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 3230003A 416 1118 1534
200507 200507 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 3230003A 326 677 1003
200508 200508 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 3230009A 35 124 159
200509 200509 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 3230009A 37 75 112
200510 200510 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 3900060B 12 25 37
200511 200511 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 3900060B 9 7 16
200512 200512 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 3900061A 38 85 123
200513 200513 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 3900061A 20 28 48
200514 200514 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780003A 25 99 124
200515 200515 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780003A 17 50 67
200516 200516 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780005B 0 0 0
200517 200517 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780005B 0 0 0
200518 200518 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780008A 0 0 0
200519 200519 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780008A 0 0 0
200520 200520 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780008C 0 0 0
200521 200521 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780008C 0 0 0
200522 200522 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780011A 266 729 995
200523 200523 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780011A 145 267 412
200524 200524 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780013A 0 0 0
200525 200525 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780013A 0 0 0
200526 200526 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780017A 0 0 0
200527 200527 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780017A 0 0 0
200528 200528 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780020A 0 0 0
200529 200529 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780020A 0 0 0
200530 200530 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780026A 0 0 0
200531 200531 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 4780026A 0 0 0
200532 200532 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850005A 193 519 712
200533 200533 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850005A 77 151 228
200534 200534 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850012A 353 748 1101
200535 200535 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850012A 191 301 492
200536 200536 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850020A 115 478 593
200537 200537 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850020A 73 270 343
200538 200538 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850031A 0 0 0
200539 200539 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850031A 0 0 0
200540 200540 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850077A 282 901 1183
200541 200541 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850077A 154 456 610
200542 200542 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850117A 307 931 1238
200543 200543 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850117A 166 417 583
200544 200544 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850118A 377 1042 1419
200545 200545 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850118A 176 384 560
200546 200546 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850207B 72 147 219
200547 200547 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850207B 16 55 71
200548 200548 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850211A 382 1253 1635
200549 200549 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850211A 228 630 858
200550 200550 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850221A 216 798 1014
200551 200551 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850221A 151 471 622
200552 200552 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850222A 121 328 449
200553 200553 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 5850222A 48 105 153
200554 200554 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 7800002C 210 547 757
200555 200555 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 7800002C 142 270 412
200556 200556 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 7800003B 0 0 0
200557 200557 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 7800003B 0 0 0

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