results

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

7 rows where candidate_id = 23247

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
195672 195672 PABLO SIFUENTES 23247 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700001A 47 88 135
195680 195680 PABLO SIFUENTES 23247 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700005E 0 1 1
195688 195688 PABLO SIFUENTES 23247 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700007B 48 128 176
195696 195696 PABLO SIFUENTES 23247 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700010A 28 93 121
195704 195704 PABLO SIFUENTES 23247 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700011B 31 63 94
195712 195712 PABLO SIFUENTES 23247 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700012A 29 74 103
195720 195720 PABLO SIFUENTES 23247 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700018A 26 56 82

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