results

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

8 rows where candidate_id = 21631

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
191044 191044 MARCO BARCENA 21631 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800002A 45 129 174
191054 191054 MARCO BARCENA 21631 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800005A 47 147 194
191064 191064 MARCO BARCENA 21631 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800006A 55 208 263
191074 191074 MARCO BARCENA 21631 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800007A 57 213 270
191084 191084 MARCO BARCENA 21631 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800009A 56 204 260
191094 191094 MARCO BARCENA 21631 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800010A 7 31 38
191104 191104 MARCO BARCENA 21631 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800016A 65 144 209
191114 191114 MARCO BARCENA 21631 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800017B 1 9 10

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