results

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

13 rows where candidate_id = 23092

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
34655 34655 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850047A 20 59 79
34657 34657 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850137A 8 43 51
34659 34659 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850146A 16 19 35
34661 34661 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850151A 22 43 65
34663 34663 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850156A 16 47 63
34665 34665 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850164A 3 7 10
34667 34667 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850170A 34 76 110
34669 34669 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850180A 35 52 87
34671 34671 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850193A 20 49 69
34673 34673 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850420A 25 42 67
34675 34675 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850572A 2 25 27
34677 34677 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850573A 22 48 70
34679 34679 CRISTINO PINTO 23092 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9249 3850611D 12 25 37

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