results

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

7 rows where candidate_id = 20667

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
218912 218912 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700003A 87 354 441
218916 218916 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700005A 80 336 416
218920 218920 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700007B 22 69 91
218924 218924 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700024A 30 91 121
218928 218928 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 26 53 79
218932 218932 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700057A 88 336 424
218936 218936 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 19 48 67

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