results

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

9 rows where candidate_id = 23151

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
22955 22955 JORDAN HENRY 23151 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 2550002A 170 444 614
22958 22958 JORDAN HENRY 23151 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 2550007A 157 366 523
22961 22961 JORDAN HENRY 23151 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 2550018A 179 297 476
22964 22964 JORDAN HENRY 23151 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 2550021A 181 374 555
22967 22967 JORDAN HENRY 23151 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 3150040A 89 227 316
22970 22970 JORDAN HENRY 23151 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 3200001A 153 314 467
22973 22973 JORDAN HENRY 23151 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 3200004A 156 378 534
22976 22976 JORDAN HENRY 23151 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 3200018A 119 244 363
22979 22979 JORDAN HENRY 23151 GLENDALE UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area A 9380 4610017A 127 292 419

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