results
Data source: Los Angeles County Registrar-Recorder/County Clerk
324,654 rows
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited
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]);