results

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

36 rows where contest_id = 9877

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, 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
158637 158637 NO 23649 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
158639 158639 NO 23649 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
158641 158641 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001027A 27 88 115
158642 158642 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001029A 446 1612 2058
158643 158643 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001029A 198 331 529
158644 158644 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001041A 348 1624 1972
158645 158645 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001041A 167 394 561
158646 158646 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001044A 434 1794 2228
158647 158647 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001044A 318 502 820
158648 158648 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001073A 98 515 613
158649 158649 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001073A 64 144 208
158650 158650 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001273A 0 0 0
158651 158651 NO 23649 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
158653 158653 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9001999A 143 272 415
158654 158654 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9003122A 330 1600 1930
158655 158655 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9003122A 203 423 626
158656 158656 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9006618C 235 948 1183
158657 158657 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9006618C 107 166 273
158658 158658 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9006667A 262 1388 1650
158659 158659 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9006667A 164 443 607
158660 158660 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007674A 324 1469 1793
158661 158661 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007674A 312 510 822
158662 158662 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007985A 319 1451 1770
158663 158663 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007985A 187 377 564
158664 158664 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007985F 11 29 40
158665 158665 NO 23649 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9007985F 4 8 12
158666 158666 YES 23648 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE GG 9877 9990243A 0 0 0
158667 158667 NO 23649 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
158669 158669 NO 23649 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
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]);