results

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

11 rows where candidate_id = 23080

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
112329 112329 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850150A 51 227 278
112332 112332 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850158A 25 118 143
112335 112335 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850159A 26 54 80
112338 112338 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850198A 55 346 401
112341 112341 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850210A 113 588 701
112344 112344 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850212A 114 607 721
112347 112347 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850237A 28 107 135
112350 112350 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850310A 16 80 96
112353 112353 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850416A 145 552 697
112356 112356 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850593A 35 109 144
112359 112359 KETTY CITTERIO 23080 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3850613A 25 53 78

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