results

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

5 rows where candidate_id = 21388

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
257935 257935 CESAR ANDRES GARCIA 21388 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 6th District 8577 1900015A 19 56 75
257937 257937 CESAR ANDRES GARCIA 21388 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 6th District 8577 1900015F 4 16 20
257939 257939 CESAR ANDRES GARCIA 21388 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 6th District 8577 1900018A 13 73 86
257941 257941 CESAR ANDRES GARCIA 21388 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 6th District 8577 1900018B 21 139 160
257943 257943 CESAR ANDRES GARCIA 21388 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 6th District 8577 1900037A 7 44 51

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