results

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

8 rows where candidate_id = 20459

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
122716 122716 NO 20459 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION - MEASURE AA 8632 0800002A 30 47 77
122718 122718 NO 20459 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION - MEASURE AA 8632 0800005A 27 59 86
122720 122720 NO 20459 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION - MEASURE AA 8632 0800006A 40 56 96
122722 122722 NO 20459 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION - MEASURE AA 8632 0800007A 36 53 89
122724 122724 NO 20459 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION - MEASURE AA 8632 0800009A 28 66 94
122726 122726 NO 20459 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION - MEASURE AA 8632 0800010A 3 13 16
122728 122728 NO 20459 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION - MEASURE AA 8632 0800016A 33 57 90
122730 122730 NO 20459 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION - MEASURE AA 8632 0800017B 1 4 5

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