results

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

4 rows where candidate_id = 21688

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
304227 304227 RICARDO FOSADO 21688 BELLFLOWER CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8633 0750006A 19 57 76
304229 304229 RICARDO FOSADO 21688 BELLFLOWER CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8633 0750009A 71 174 245
304231 304231 RICARDO FOSADO 21688 BELLFLOWER CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8633 0750037A 37 166 203
304233 304233 RICARDO FOSADO 21688 BELLFLOWER CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8633 0750042A 75 158 233

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