results

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

6 rows where candidate_id = 21519

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
204407 204407 ROBIN PATCH 21519 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250001A 33 103 136
204412 204412 ROBIN PATCH 21519 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250003A 44 78 122
204417 204417 ROBIN PATCH 21519 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250004A 81 137 218
204422 204422 ROBIN PATCH 21519 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250006A 46 112 158
204427 204427 ROBIN PATCH 21519 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250011A 52 106 158
204432 204432 ROBIN PATCH 21519 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250017B 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]);