results

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

2 rows where contest_id = 9345

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
127835 127835 DANIEL FELTS 23121 AVALON CITY GENERAL MUNICIPAL ELECTION Mayor 9345 0500002A 98 117 215
127836 127836 ANNI MARSHALL 23119 AVALON CITY GENERAL MUNICIPAL ELECTION Mayor 9345 0500002A 113 344 457

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]);