results

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

6 rows where candidate_id = 21520

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
204405 204405 JOHN PICKHAVER 21520 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250001A 61 268 329
204410 204410 JOHN PICKHAVER 21520 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250003A 53 258 311
204415 204415 JOHN PICKHAVER 21520 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250004A 85 425 510
204420 204420 JOHN PICKHAVER 21520 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250006A 59 259 318
204425 204425 JOHN PICKHAVER 21520 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250011A 55 294 349
204430 204430 JOHN PICKHAVER 21520 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250017B 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]);