results

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

10 rows where candidate_id = 20843

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
103480 103480 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 2100007A 5 10 15
103484 103484 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 2100110C 0 0 0
103488 103488 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750001A 22 108 130
103492 103492 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750006A 46 171 217
103496 103496 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750007C 4 23 27
103500 103500 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750010A 56 107 163
103504 103504 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750018A 79 199 278
103508 103508 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750023A 13 54 67
103512 103512 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 6100034A 22 60 82
103516 103516 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 7050078A 3 12 15

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