results

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

21 rows where candidate_id = 21072

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
314612 314612 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350005B 16 194 210
314614 314614 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350007A 60 602 662
314616 314616 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350008A 74 775 849
314618 314618 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350012A 51 274 325
314620 314620 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350017A 76 772 848
314622 314622 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350022A 82 517 599
314624 314624 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350027A 65 328 393
314626 314626 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350029A 80 782 862
314628 314628 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350038A 21 179 200
314630 314630 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350043A 65 465 530
314632 314632 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350049A 63 654 717
314634 314634 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350052A 0 4 4
314636 314636 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350057A 47 245 292
314638 314638 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350058C 76 821 897
314640 314640 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350061A 2 4 6
314642 314642 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350101A 0 0 0
314644 314644 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350102A 25 174 199
314646 314646 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350104E 0 28 28
314648 314648 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350105A 2 8 10
314650 314650 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350106A 0 24 24
314652 314652 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350106B 4 15 19

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