results

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

8 rows where candidate_id = 24251

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
13493 13493 ERICA DOMINGUEZ 24251 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9681 1550001A 153 258 411
13496 13496 ERICA DOMINGUEZ 24251 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9681 1550002A 1 0 1
13499 13499 ERICA DOMINGUEZ 24251 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9681 1550004A 196 193 389
13502 13502 ERICA DOMINGUEZ 24251 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9681 1550009A 182 189 371
13505 13505 ERICA DOMINGUEZ 24251 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9681 1550020C 0 0 0
13508 13508 ERICA DOMINGUEZ 24251 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9681 9990722A 0 0 0
13511 13511 ERICA DOMINGUEZ 24251 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9681 9990723A 0 0 0
13514 13514 ERICA DOMINGUEZ 24251 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9681 9990727A 0 0 0

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