results

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

11 rows where candidate_id = 21066

✎ 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
142339 142339 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070004C 4 15 19
142341 142341 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070004E 18 42 60
142343 142343 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070006N 2 8 10
142345 142345 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070007A 56 106 162
142347 142347 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 1000016A 194 896 1090
142349 142349 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 1000075B 13 53 66
142351 142351 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 1000076A 128 591 719
142353 142353 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 4060001A 25 51 76
142355 142355 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 4060002A 2 1 3
142357 142357 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 4060004A 24 55 79
142359 142359 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 7100007A 10 25 35

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