results

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

22 rows where contest_id = 8409

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place, total

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
142340 142340 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070004C 3 18 21
142341 142341 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070004E 18 42 60
142342 142342 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070004E 9 71 80
142343 142343 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070006N 2 8 10
142344 142344 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070006N 9 27 36
142345 142345 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070007A 56 106 162
142346 142346 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 0070007A 46 252 298
142347 142347 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 1000016A 194 896 1090
142348 142348 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 1000016A 92 793 885
142349 142349 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 1000075B 13 53 66
142350 142350 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 1000075B 4 32 36
142351 142351 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 1000076A 128 591 719
142352 142352 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 1000076A 88 541 629
142353 142353 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 4060001A 25 51 76
142354 142354 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 4060001A 18 63 81
142355 142355 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 4060002A 2 1 3
142356 142356 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 4060002A 1 3 4
142357 142357 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 4060004A 24 55 79
142358 142358 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 4060004A 17 130 147
142359 142359 GARY BURNS 21066 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 7100007A 10 25 35
142360 142360 LEE RENGER 20728 LAS VIRGENES MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8409 7100007A 4 43 47

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