results

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

5 rows where candidate_id = 21537

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
225158 225158 CARMEN PEREZ 21537 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200001A 26 115 141
225164 225164 CARMEN PEREZ 21537 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200011A 30 112 142
225170 225170 CARMEN PEREZ 21537 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200013A 37 109 146
225176 225176 CARMEN PEREZ 21537 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200014A 27 124 151
225182 225182 CARMEN PEREZ 21537 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200015A 37 117 154

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