results

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

4 rows where candidate_id = 24135

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
43031 43031 BRUCE LEE SILVERSTEIN 24135 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9714 4050002A 235 648 883
43036 43036 BRUCE LEE SILVERSTEIN 24135 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9714 4050051A 267 779 1046
43041 43041 BRUCE LEE SILVERSTEIN 24135 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9714 4050059B 267 747 1014
43046 43046 BRUCE LEE SILVERSTEIN 24135 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9714 9990244A 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]);