results

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

5 rows where candidate_id = 21558

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
244267 244267 THOMAS WONG 21558 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8689 4500015A 12 78 90
244269 244269 THOMAS WONG 21558 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8689 4500040A 15 119 134
244271 244271 THOMAS WONG 21558 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8689 4500044A 60 630 690
244273 244273 THOMAS WONG 21558 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8689 4500047A 105 516 621
244275 244275 THOMAS WONG 21558 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8689 4500047C 11 42 53

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