results

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

16 rows where candidate_id = 21096

✎ View and edit SQL

This data as json, CSV (advanced)

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
237548 237548 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230007A 127 582 709
237550 237550 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230008A 135 609 744
237552 237552 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230016A 143 542 685
237554 237554 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230017A 45 191 236
237556 237556 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230020A 100 513 613
237558 237558 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230023A 102 483 585
237560 237560 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230027A 120 580 700
237562 237562 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230030A 107 573 680
237564 237564 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230032A 92 420 512
237566 237566 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230036A 124 522 646
237568 237568 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230039A 164 495 659
237570 237570 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230041A 169 544 713
237572 237572 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230045A 116 400 516
237574 237574 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230068A 119 455 574
237576 237576 YES 21096 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230080A 96 461 557

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