results

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

7 rows where candidate_id = 23241

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
195666 195666 VIOLETA ALVAREZ 23241 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700001A 43 82 125
195674 195674 VIOLETA ALVAREZ 23241 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700005E 1 1 2
195682 195682 VIOLETA ALVAREZ 23241 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700007B 60 127 187
195690 195690 VIOLETA ALVAREZ 23241 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700010A 40 103 143
195698 195698 VIOLETA ALVAREZ 23241 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700011B 37 77 114
195706 195706 VIOLETA ALVAREZ 23241 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700012A 41 117 158
195714 195714 VIOLETA ALVAREZ 23241 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700018A 28 60 88

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