results

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

21 rows where candidate_id = 21073

✎ 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
314613 314613 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350005B 38 141 179
314615 314615 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350007A 112 422 534
314617 314617 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350008A 137 549 686
314619 314619 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350012A 72 232 304
314621 314621 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350017A 115 556 671
314623 314623 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350022A 161 497 658
314625 314625 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350027A 94 276 370
314627 314627 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350029A 144 509 653
314629 314629 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350038A 30 140 170
314631 314631 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350043A 127 417 544
314633 314633 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350049A 111 396 507
314635 314635 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350052A 4 10 14
314637 314637 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350057A 67 226 293
314639 314639 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350058C 145 581 726
314641 314641 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350061A 4 5 9
314643 314643 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350101A 0 5 5
314645 314645 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350102A 35 138 173
314647 314647 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350104E 4 20 24
314649 314649 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350105A 0 8 8
314651 314651 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350106A 8 14 22
314653 314653 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350106B 2 11 13

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