results

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

5 rows where candidate_id = 21487

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
303562 303562 JEFFREY GOMEZ 21487 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fifth District 8693 0150008A 45 91 136
303564 303564 JEFFREY GOMEZ 21487 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fifth District 8693 0150011A 63 170 233
303566 303566 JEFFREY GOMEZ 21487 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fifth District 8693 0150018A 91 333 424
303568 303568 JEFFREY GOMEZ 21487 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fifth District 8693 0150033A 53 143 196
303570 303570 JEFFREY GOMEZ 21487 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fifth District 8693 0150037A 29 85 114

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