results

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

2,191 rows where candidate_id = 23287

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
173045 173045 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0050002B 0 0 0
173053 173053 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0050003A 0 0 0
173061 173061 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0050004A 3 2 5
173069 173069 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0050013A 0 2 2
173077 173077 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0070002A 0 0 0
173085 173085 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0070005A 0 5 5
173093 173093 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0070005B 0 0 0
173101 173101 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0070006A 0 0 0
173109 173109 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0070008A 0 0 0
173117 173117 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0070041B 0 0 0
173125 173125 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0080004A 2 1 3
173133 173133 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0080007A 3 2 5
173141 173141 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0080050A 0 2 2
173149 173149 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0080054A 1 1 2
173157 173157 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0080070A 1 5 6
173165 173165 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0090006A 0 0 0
173173 173173 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0090011B 0 0 0
173181 173181 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0090025A 0 0 0
173189 173189 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0090026A 0 6 6
173197 173197 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150003A 2 5 7
173205 173205 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150012A 0 11 11
173213 173213 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150016D 2 8 10
173221 173221 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150021A 5 7 12
173229 173229 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150023A 1 7 8
173237 173237 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150037A 1 6 7
173245 173245 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150039A 1 12 13
173253 173253 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150049A 3 6 9
173261 173261 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150054A 2 12 14
173269 173269 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150055A 1 7 8
173277 173277 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150065A 4 7 11
173285 173285 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150072A 0 6 6
173293 173293 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150079A 1 14 15
173301 173301 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0150082A 2 3 5
173309 173309 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0180002A 0 0 0
173317 173317 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200011A 5 6 11
173325 173325 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200012A 2 4 6
173333 173333 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200013A 2 5 7
173341 173341 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200015A 5 7 12
173349 173349 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200016A 0 2 2
173357 173357 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200024A 4 6 10
173365 173365 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200025B 1 4 5
173373 173373 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200029A 1 2 3
173381 173381 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200031A 0 0 0
173389 173389 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200038A 2 5 7
173397 173397 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0200087A 2 6 8
173405 173405 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0300001G 0 0 0
173413 173413 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0300002A 0 3 3
173421 173421 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0300002B 0 0 0
173429 173429 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0300016A 0 0 0
173437 173437 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350007A 0 5 5
173445 173445 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350012A 2 6 8
173453 173453 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350020A 0 11 11
173461 173461 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350027A 3 11 14
173469 173469 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350034A 1 5 6
173477 173477 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350038A 0 3 3
173485 173485 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350042A 2 5 7
173493 173493 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350048A 0 2 2
173501 173501 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350054A 1 4 5
173509 173509 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350061A 0 0 0
173517 173517 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0350062B 0 7 7
173525 173525 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0400001A 2 7 9
173533 173533 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0400012A 2 5 7
173541 173541 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0400018A 0 1 1
173549 173549 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0450008A 1 4 5
173557 173557 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0450010A 0 3 3
173565 173565 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0450014A 4 0 4
173573 173573 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0500002A 2 2 4
173581 173581 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0520004A 0 0 0
173589 173589 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0520024A 1 0 1
173597 173597 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0520025A 1 3 4
173605 173605 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0520027A 1 3 4
173613 173613 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550010C 0 0 0
173621 173621 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550011A 1 3 4
173629 173629 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550012A 0 1 1
173637 173637 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550016A 2 0 2
173645 173645 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550018A 1 5 6
173653 173653 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550020A 1 5 6
173661 173661 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550024A 0 1 1
173669 173669 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550073A 1 5 6
173677 173677 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550078A 0 5 5
173685 173685 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0550086A 2 3 5
173693 173693 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600008B 2 5 7
173701 173701 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600014A 1 5 6
173709 173709 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600020A 0 2 2
173717 173717 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600029C 1 5 6
173725 173725 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600034A 1 5 6
173733 173733 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600035A 3 7 10
173741 173741 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600036A 5 7 12
173749 173749 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600037A 2 3 5
173757 173757 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600038A 1 5 6
173765 173765 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600039A 2 2 4
173773 173773 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600041A 1 5 6
173781 173781 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600053A 2 8 10
173789 173789 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0600061A 0 5 5
173797 173797 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0670008A 2 6 8
173805 173805 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0670142A 1 6 7
173813 173813 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0670144A 1 2 3
173821 173821 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0700001A 3 9 12
173829 173829 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0700005E 0 0 0
173837 173837 STEPHEN P LYONS 23287 PRESIDENTIAL PREFERENCE - DEMOCRATIC 9197 0700007B 6 4 10

Next page

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