results

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

7 rows where candidate_id = 20626

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
218915 218915 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700003A 90 366 456
218919 218919 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700005A 78 310 388
218923 218923 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700007B 20 64 84
218927 218927 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700024A 24 82 106
218931 218931 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 24 62 86
218935 218935 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700057A 80 330 410
218939 218939 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 24 52 76

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