results

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

19 rows where candidate_id = 23935

✎ 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
253710 253710 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100001A 248 549 797
253712 253712 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100004A 3 13 16
253714 253714 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100006A 131 383 514
253716 253716 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100007A 292 570 862
253718 253718 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100010A 354 718 1072
253720 253720 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100014A 409 946 1355
253722 253722 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100016A 76 121 197
253724 253724 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100020A 306 572 878
253726 253726 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100025A 317 670 987
253728 253728 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100027A 241 573 814
253730 253730 YES 23935 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
253734 253734 YES 23935 PARAMOUNT CITY SPECIAL ELECTION MEASURE LR 9906 5100054A 304 563 867
253736 253736 YES 23935 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
253740 253740 YES 23935 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
253744 253744 YES 23935 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

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