results

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

18 rows where candidate_id = 23649

✎ 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
158637 158637 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9000309A 0 0 0
158639 158639 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9000810A 0 0 0
158641 158641 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001027A 27 88 115
158643 158643 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001029A 198 331 529
158645 158645 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001041A 167 394 561
158647 158647 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001044A 318 502 820
158649 158649 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001073A 64 144 208
158651 158651 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001273A 0 0 0
158653 158653 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001999A 143 272 415
158655 158655 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9003122A 203 423 626
158657 158657 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9006618C 107 166 273
158659 158659 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9006667A 164 443 607
158661 158661 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007674A 312 510 822
158663 158663 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007985A 187 377 564
158665 158665 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007985F 4 8 12
158667 158667 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9990243A 0 0 0
158669 158669 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9990276A 0 0 0
158671 158671 NO 23649 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]);