results

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

5 rows where candidate_id = 24375

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
11416 11416 DESIREE "DEZ" MYERS 24375 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050003A 306 1057 1363
11419 11419 DESIREE "DEZ" MYERS 24375 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050007A 174 764 938
11422 11422 DESIREE "DEZ" MYERS 24375 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050010B 71 322 393
11425 11425 DESIREE "DEZ" MYERS 24375 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9730 5050012A 101 389 490
11428 11428 DESIREE "DEZ" MYERS 24375 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]);