results

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

12 rows where candidate_id = 21214

✎ 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
14830 14830 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550002C 1 7 8
14834 14834 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550019D 0 0 0
14838 14838 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550148A 8 65 73
14842 14842 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150005A 0 4 4
14846 14846 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150040D 14 51 65
14850 14850 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150060D 5 27 32
14854 14854 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150064D 3 5 8
14858 14858 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200001A 85 538 623
14862 14862 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200004A 100 487 587
14866 14866 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200018C 3 20 23
14870 14870 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200019A 105 404 509
14874 14874 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 4610025A 61 203 264

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