results

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

8 rows where candidate_id = 21184

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
296522 296522 JOANNA LAM 21184 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 2020004A 13 93 106
296526 296526 JOANNA LAM 21184 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 2040015A 29 113 142
296530 296530 JOANNA LAM 21184 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200001A 32 262 294
296534 296534 JOANNA LAM 21184 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200004A 4 35 39
296538 296538 JOANNA LAM 21184 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200006A 30 178 208
296542 296542 JOANNA LAM 21184 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200007A 99 570 669
296546 296546 JOANNA LAM 21184 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200012A 42 214 256
296550 296550 JOANNA LAM 21184 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200016A 61 377 438

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