results

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

8 rows where candidate_id = 21639

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
191048 191048 CHRISTIAN MENDEZ 21639 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800002A 30 84 114
191058 191058 CHRISTIAN MENDEZ 21639 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800005A 23 88 111
191068 191068 CHRISTIAN MENDEZ 21639 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800006A 23 89 112
191078 191078 CHRISTIAN MENDEZ 21639 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800007A 32 74 106
191088 191088 CHRISTIAN MENDEZ 21639 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800009A 25 70 95
191098 191098 CHRISTIAN MENDEZ 21639 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800010A 4 14 18
191108 191108 CHRISTIAN MENDEZ 21639 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800016A 31 71 102
191118 191118 CHRISTIAN MENDEZ 21639 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800017B 3 8 11

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