results

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

6 rows where candidate_id = 24331

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
200668 200668 SEAN M. RIVAS 24331 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050005A 109 242 351
200673 200673 SEAN M. RIVAS 24331 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050009A 87 220 307
200678 200678 SEAN M. RIVAS 24331 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050012A 119 282 401
200683 200683 SEAN M. RIVAS 24331 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050016A 204 378 582
200688 200688 SEAN M. RIVAS 24331 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050020A 127 370 497
200693 200693 SEAN M. RIVAS 24331 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 9990252A 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]);