results

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

5 rows where candidate_id = 24374

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
11414 11414 DEREK LAZZARO 24374 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050003A 476 1665 2141
11417 11417 DEREK LAZZARO 24374 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050007A 304 1268 1572
11420 11420 DEREK LAZZARO 24374 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050010B 145 542 687
11423 11423 DEREK LAZZARO 24374 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050012A 157 643 800
11426 11426 DEREK LAZZARO 24374 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]);