results

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

5 rows where candidate_id = 24475

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
236523 236523 FRANK GARCIA 24475 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9719 4200005A 179 375 554
236525 236525 FRANK GARCIA 24475 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9719 4200008A 274 594 868
236527 236527 FRANK GARCIA 24475 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9719 4200011A 225 480 705
236529 236529 FRANK GARCIA 24475 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9719 4200015A 320 537 857
236531 236531 FRANK GARCIA 24475 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9719 9990690A 0 0 0

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