results

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

19 rows where candidate_id = 23936

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
253711 253711 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100001A 141 179 320
253713 253713 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100004A 1 0 1
253715 253715 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100006A 58 99 157
253717 253717 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100007A 95 142 237
253719 253719 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100010A 125 166 291
253721 253721 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100014A 151 238 389
253723 253723 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100016A 33 52 85
253725 253725 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100020A 117 154 271
253727 253727 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100025A 95 124 219
253729 253729 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100027A 82 164 246
253731 253731 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100028A 0 0 0
253733 253733 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100036A 146 241 387
253735 253735 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100054A 105 127 232
253737 253737 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100743A 0 0 0
253739 253739 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990696A 0 0 0
253741 253741 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990697A 0 0 0
253743 253743 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990698A 0 0 0
253745 253745 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990699A 0 0 0
253747 253747 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990700A 0 0 0

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