results

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

16 rows where candidate_id = 21097

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
237547 237547 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230006C 0 8 8
237549 237549 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230007A 88 179 267
237551 237551 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230008A 51 135 186
237553 237553 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230016A 74 148 222
237555 237555 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230017A 24 41 65
237557 237557 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230020A 55 111 166
237559 237559 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230023A 61 135 196
237561 237561 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230027A 69 180 249
237563 237563 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230030A 69 162 231
237565 237565 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230032A 47 117 164
237567 237567 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230036A 69 145 214
237569 237569 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230039A 87 147 234
237571 237571 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230041A 77 145 222
237573 237573 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230045A 43 86 129
237575 237575 NO 21097 PICO RIVERA CITY GENERAL MUNICIPAL ELECTION - MEASURE AB 8907 5230068A 40 157 197
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]);