results

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

8 rows where candidate_id = 21419

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
163493 163493 RUDY BOJORQUEZ 21419 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8609 6530002A 55 107 162
163496 163496 RUDY BOJORQUEZ 21419 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8609 6530004A 39 127 166
163499 163499 RUDY BOJORQUEZ 21419 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8609 6530040A 57 123 180
163502 163502 RUDY BOJORQUEZ 21419 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8609 6530041B 116 289 405
163505 163505 RUDY BOJORQUEZ 21419 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8609 6530043A 18 79 97
163508 163508 RUDY BOJORQUEZ 21419 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8609 6530045B 14 32 46
163511 163511 RUDY BOJORQUEZ 21419 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8609 6530046A 28 61 89
163514 163514 RUDY BOJORQUEZ 21419 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8609 6530046B 15 39 54

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