results

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

26 rows where candidate_id = 24393

✎ 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
42797 42797 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950003A 13 24 37
42806 42806 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950008A 35 96 131
42815 42815 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950009A 25 59 84
42824 42824 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950014A 81 214 295
42833 42833 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950027A 35 67 102
42842 42842 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950029A 15 46 61
42851 42851 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950031A 40 89 129
42860 42860 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950042A 61 128 189
42869 42869 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950132A 28 52 80
42878 42878 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950136A 14 73 87
42887 42887 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950138B 36 99 135
42896 42896 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950141B 15 39 54
42905 42905 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950142A 40 77 117
42914 42914 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950152A 4 10 14
42923 42923 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950156A 59 128 187
42932 42932 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950166C 45 88 133
42941 42941 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950168A 64 104 168
42950 42950 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950172A 33 76 109
42959 42959 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950174A 31 70 101
42968 42968 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950178A 72 158 230
42977 42977 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950189A 37 87 124
42986 42986 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950190A 62 141 203
42995 42995 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 0950200A 13 19 32
43004 43004 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 9990268A 0 0 0
43013 43013 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 9990269A 0 0 0
43022 43022 JOHN PARR 24393 BURBANK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9673 9990270A 0 0 0

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