results

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

10 rows where candidate_id = 20622

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
103481 103481 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 2100007A 13 30 43
103485 103485 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 2100110C 0 1 1
103489 103489 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750001A 46 269 315
103493 103493 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750006A 75 411 486
103497 103497 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750007C 15 59 74
103501 103501 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750010A 97 346 443
103505 103505 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750018A 117 387 504
103509 103509 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750023A 42 123 165
103513 103513 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 6100034A 47 156 203
103517 103517 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 7050078A 7 43 50

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