results

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

24 rows where candidate_id = 21563

✎ 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
24829 24829 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500001E 1 6 7
24831 24831 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500002A 41 133 174
24833 24833 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500004A 26 110 136
24835 24835 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500009A 97 604 701
24837 24837 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500015A 10 52 62
24839 24839 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500016A 76 239 315
24841 24841 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500017A 59 299 358
24843 24843 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500021A 29 97 126
24845 24845 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500022A 100 392 492
24847 24847 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500023B 11 71 82
24849 24849 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500024A 65 254 319
24851 24851 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500026A 105 421 526
24853 24853 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500027B 8 40 48
24855 24855 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500031A 75 234 309
24857 24857 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500034A 47 207 254
24859 24859 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500035A 13 127 140
24861 24861 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500035C 9 27 36
24863 24863 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500036A 1 6 7
24865 24865 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500040A 22 66 88
24867 24867 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500042A 56 178 234
24869 24869 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500044A 88 543 631
24871 24871 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500047A 72 262 334
24873 24873 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500047C 4 24 28
24875 24875 AMY LEE 21563 MONTEREY PARK CITY GENERAL MUNICIPAL ELECTION City Treasurer 8696 4500090A 33 131 164

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