results

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

8 rows where candidate_id = 21447

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
162582 162582 PAT KEARNEY 21447 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650001B 1 1 2
162587 162587 PAT KEARNEY 21447 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650002A 66 292 358
162592 162592 PAT KEARNEY 21447 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650004A 22 98 120
162597 162597 PAT KEARNEY 21447 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650005A 28 67 95
162602 162602 PAT KEARNEY 21447 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650006A 55 160 215
162607 162607 PAT KEARNEY 21447 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650011A 54 224 278
162612 162612 PAT KEARNEY 21447 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650015A 45 240 285
162617 162617 PAT KEARNEY 21447 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650018B 63 232 295

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