results

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

5 rows where candidate_id = 23109

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
2307 2307 DAVID ARELLANO 23109 LAKEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9268 3450010A 14 54 68
2309 2309 DAVID ARELLANO 23109 LAKEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9268 3450019A 182 475 657
2311 2311 DAVID ARELLANO 23109 LAKEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9268 3450059A 208 585 793
2313 2313 DAVID ARELLANO 23109 LAKEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9268 3450066A 226 743 969
2315 2315 DAVID ARELLANO 23109 LAKEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9268 3450079B 21 58 79

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