results

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

38 rows where contest_id = 9906

✎ 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
253710 253710 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100001A 248 549 797
253711 253711 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100001A 141 179 320
253712 253712 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100004A 3 13 16
253713 253713 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100004A 1 0 1
253714 253714 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100006A 131 383 514
253715 253715 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100006A 58 99 157
253716 253716 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100007A 292 570 862
253717 253717 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100007A 95 142 237
253718 253718 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100010A 354 718 1072
253719 253719 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100010A 125 166 291
253720 253720 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100014A 409 946 1355
253721 253721 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100014A 151 238 389
253722 253722 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100016A 76 121 197
253723 253723 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100016A 33 52 85
253724 253724 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100020A 306 572 878
253725 253725 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100020A 117 154 271
253726 253726 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100025A 317 670 987
253727 253727 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100025A 95 124 219
253728 253728 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100027A 241 573 814
253729 253729 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100027A 82 164 246
253730 253730 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100028A 0 0 0
253731 253731 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100028A 0 0 0
253732 253732 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100036A 408 762 1170
253733 253733 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100036A 146 241 387
253734 253734 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100054A 304 563 867
253735 253735 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100054A 105 127 232
253736 253736 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100743A 0 0 0
253737 253737 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100743A 0 0 0
253738 253738 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990696A 0 0 0
253739 253739 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990696A 0 0 0
253740 253740 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990697A 0 0 0
253741 253741 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990697A 0 0 0
253742 253742 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990698A 0 0 0
253743 253743 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990698A 0 0 0
253744 253744 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990699A 0 0 0
253745 253745 NO 23936 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990699A 0 0 0
253746 253746 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 9990700A 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]);