results

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

7 rows where candidate_id = 23244

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
195669 195669 FRANCIS FLORES 23244 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700001A 49 86 135
195677 195677 FRANCIS FLORES 23244 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700005E 0 1 1
195685 195685 FRANCIS FLORES 23244 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700007B 41 86 127
195693 195693 FRANCIS FLORES 23244 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700010A 174 95 269
195701 195701 FRANCIS FLORES 23244 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700011B 18 74 92
195709 195709 FRANCIS FLORES 23244 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700012A 178 116 294
195717 195717 FRANCIS FLORES 23244 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700018A 26 69 95

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