results

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

7 rows where candidate_id = 20634

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
218913 218913 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700003A 134 526 660
218917 218917 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700005A 124 429 553
218921 218921 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700007B 28 100 128
218925 218925 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700024A 33 111 144
218929 218929 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 36 87 123
218933 218933 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700057A 138 492 630
218937 218937 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 30 79 109

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