results

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

5 rows where contest_id = 9731

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
5881 5881 MARTIN J. PETERSEN 24377 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION City Treasurer 9731 5050003A 537 1742 2279
5882 5882 MARTIN J. PETERSEN 24377 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION City Treasurer 9731 5050007A 318 1215 1533
5883 5883 MARTIN J. PETERSEN 24377 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION City Treasurer 9731 5050010B 145 559 704
5884 5884 MARTIN J. PETERSEN 24377 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION City Treasurer 9731 5050012A 173 657 830
5885 5885 MARTIN J. PETERSEN 24377 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION City Treasurer 9731 9990854A 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]);