results

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

7 rows where candidate_id = 21022

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
162618 162618 SOO YOO 21022 ABC UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 8426 1070016A 99 448 547
162620 162620 SOO YOO 21022 ABC UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 8426 1070037A 112 518 630
162622 162622 SOO YOO 21022 ABC UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 8426 1070041A 109 616 725
162624 162624 SOO YOO 21022 ABC UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 8426 1070049A 64 375 439
162626 162626 SOO YOO 21022 ABC UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 8426 4800056D 3 21 24
162628 162628 SOO YOO 21022 ABC UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 8426 4800076A 35 189 224
162630 162630 SOO YOO 21022 ABC UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 8426 6230052M 0 3 3

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