results

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

28 rows where contest_id = 8385

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place, 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
218913 218913 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700003A 134 526 660
218914 218914 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700003A 57 210 267
218915 218915 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700003A 90 366 456
218916 218916 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700005A 80 336 416
218917 218917 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700005A 124 429 553
218918 218918 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700005A 69 186 255
218919 218919 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700005A 78 310 388
218920 218920 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700007B 22 69 91
218921 218921 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700007B 28 100 128
218922 218922 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700007B 10 43 53
218923 218923 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700007B 20 64 84
218924 218924 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700024A 30 91 121
218925 218925 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700024A 33 111 144
218926 218926 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700024A 11 45 56
218927 218927 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700024A 24 82 106
218928 218928 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 26 53 79
218929 218929 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 36 87 123
218930 218930 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 14 31 45
218931 218931 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 24 62 86
218932 218932 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700057A 88 336 424
218933 218933 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700057A 138 492 630
218934 218934 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700057A 55 181 236
218935 218935 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700057A 80 330 410
218936 218936 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 19 48 67
218937 218937 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 30 79 109
218938 218938 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 12 25 37
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]);