results

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

32 rows where contest_id = 8907

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place, vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
237546 237546 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230006C 0 23 23
237547 237547 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230006C 0 8 8
237548 237548 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230007A 127 582 709
237549 237549 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230007A 88 179 267
237550 237550 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230008A 135 609 744
237551 237551 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230008A 51 135 186
237552 237552 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230016A 143 542 685
237553 237553 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230016A 74 148 222
237554 237554 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230017A 45 191 236
237555 237555 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230017A 24 41 65
237556 237556 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230020A 100 513 613
237557 237557 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230020A 55 111 166
237558 237558 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230023A 102 483 585
237559 237559 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230023A 61 135 196
237560 237560 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230027A 120 580 700
237561 237561 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230027A 69 180 249
237562 237562 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230030A 107 573 680
237563 237563 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230030A 69 162 231
237564 237564 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230032A 92 420 512
237565 237565 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230032A 47 117 164
237566 237566 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230036A 124 522 646
237567 237567 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230036A 69 145 214
237568 237568 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230039A 164 495 659
237569 237569 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230039A 87 147 234
237570 237570 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230041A 169 544 713
237571 237571 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230041A 77 145 222
237572 237572 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230045A 116 400 516
237573 237573 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230045A 43 86 129
237574 237574 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230068A 119 455 574
237575 237575 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230068A 40 157 197
237576 237576 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230080A 96 461 557
237577 237577 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230080A 76 139 215

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