results

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

5 rows where candidate_id = 24376

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
11415 11415 CRAIG QUINN 24376 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050003A 432 1475 1907
11418 11418 CRAIG QUINN 24376 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050007A 240 975 1215
11421 11421 CRAIG QUINN 24376 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050010B 107 431 538
11424 11424 CRAIG QUINN 24376 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050012A 130 517 647
11427 11427 CRAIG QUINN 24376 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 9990854A 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]);