results

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

5 rows where candidate_id = 21535

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
225156 225156 MAYRA AGUILUZ 21535 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200001A 59 208 267
225162 225162 MAYRA AGUILUZ 21535 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200011A 59 222 281
225168 225168 MAYRA AGUILUZ 21535 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200013A 74 209 283
225174 225174 MAYRA AGUILUZ 21535 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200014A 59 212 271
225180 225180 MAYRA AGUILUZ 21535 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200015A 58 212 270

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