results

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

18 rows where candidate_id = 23648

✎ 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
158636 158636 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9000309A 0 0 0
158638 158638 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9000810A 0 0 0
158640 158640 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001027A 61 246 307
158642 158642 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001029A 446 1612 2058
158644 158644 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001041A 348 1624 1972
158646 158646 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001044A 434 1794 2228
158648 158648 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001073A 98 515 613
158650 158650 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001273A 0 0 0
158652 158652 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001999A 249 856 1105
158654 158654 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9003122A 330 1600 1930
158656 158656 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9006618C 235 948 1183
158658 158658 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9006667A 262 1388 1650
158660 158660 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007674A 324 1469 1793
158662 158662 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007985A 319 1451 1770
158664 158664 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007985F 11 29 40
158666 158666 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9990243A 0 0 0
158668 158668 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9990276A 0 0 0
158670 158670 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9990277A 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]);