results

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

5 rows where candidate_id = 21539

✎ 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
225159 225159 HEBER MARQUEZ 21539 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200001A 51 195 246
225165 225165 HEBER MARQUEZ 21539 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200011A 51 245 296
225171 225171 HEBER MARQUEZ 21539 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200013A 72 211 283
225177 225177 HEBER MARQUEZ 21539 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200014A 54 211 265
225183 225183 HEBER MARQUEZ 21539 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200015A 52 198 250

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