results

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

7 rows where candidate_id = 23242

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
195667 195667 MONICA ARROYO 23242 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700001A 77 118 195
195675 195675 MONICA ARROYO 23242 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700005E 0 1 1
195683 195683 MONICA ARROYO 23242 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700007B 80 158 238
195691 195691 MONICA ARROYO 23242 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700010A 188 189 377
195699 195699 MONICA ARROYO 23242 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700011B 48 138 186
195707 195707 MONICA ARROYO 23242 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700012A 202 162 364
195715 195715 MONICA ARROYO 23242 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700018A 55 101 156

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