results

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

8 rows where candidate_id = 21635

✎ 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
191042 191042 MIGUEL DE LA ROSA 21635 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800002A 54 143 197
191052 191052 MIGUEL DE LA ROSA 21635 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800005A 45 120 165
191062 191062 MIGUEL DE LA ROSA 21635 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800006A 70 161 231
191072 191072 MIGUEL DE LA ROSA 21635 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800007A 61 177 238
191082 191082 MIGUEL DE LA ROSA 21635 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800009A 62 145 207
191092 191092 MIGUEL DE LA ROSA 21635 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800010A 7 21 28
191102 191102 MIGUEL DE LA ROSA 21635 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800016A 54 118 172
191112 191112 MIGUEL DE LA ROSA 21635 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800017B 3 11 14

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