results

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

8 rows where contest_id = 8800

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
5782 5782 RICK ALONZO 21717 MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8800 4450036A 79 268 347
5783 5783 JOSEPH R. SANCHEZ 21709 MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8800 4450036A 35 73 108
5784 5784 ANGIE JIMENEZ 21722 MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8800 4450036A 92 350 442
5785 5785 EDUARDO GARFIAS 21724 MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8800 4450036A 15 50 65
5786 5786 RICK ALONZO 21717 MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8800 4450043A 94 245 339
5787 5787 JOSEPH R. SANCHEZ 21709 MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8800 4450043A 44 81 125
5788 5788 ANGIE JIMENEZ 21722 MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8800 4450043A 90 238 328
5789 5789 EDUARDO GARFIAS 21724 MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8800 4450043A 7 31 38

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