results

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

9 rows where candidate_id = 23152

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
22956 22956 TELLY TSE 23152 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 2550002A 128 828 956
22959 22959 TELLY TSE 23152 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 2550007A 118 702 820
22962 22962 TELLY TSE 23152 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 2550018A 104 722 826
22965 22965 TELLY TSE 23152 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 2550021A 120 777 897
22968 22968 TELLY TSE 23152 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 3150040A 28 310 338
22971 22971 TELLY TSE 23152 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 3200001A 81 678 759
22974 22974 TELLY TSE 23152 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 3200004A 89 960 1049
22977 22977 TELLY TSE 23152 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 3200018A 77 565 642
22980 22980 TELLY TSE 23152 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 4610017A 95 552 647

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