results

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

12 rows where candidate_id = 21133

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
38262 38262 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600002A 83 260 343
38264 38264 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600003A 103 484 587
38266 38266 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600005A 57 294 351
38268 38268 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600006A 160 668 828
38270 38270 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600009A 0 0 0
38272 38272 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600010A 93 345 438
38274 38274 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600016A 161 938 1099
38276 38276 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600024A 70 201 271
38278 38278 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600035A 23 102 125
38280 38280 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600044B 127 602 729
38282 38282 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600071A 158 721 879
38284 38284 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600073A 121 501 622

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