results

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

42 rows where contest_id = 8897

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place

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
314613 314613 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350005B 38 141 179
314614 314614 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350007A 60 602 662
314615 314615 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350007A 112 422 534
314616 314616 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350008A 74 775 849
314617 314617 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350008A 137 549 686
314618 314618 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350012A 51 274 325
314619 314619 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350012A 72 232 304
314620 314620 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350017A 76 772 848
314621 314621 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350017A 115 556 671
314622 314622 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350022A 82 517 599
314623 314623 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350022A 161 497 658
314624 314624 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350027A 65 328 393
314625 314625 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350027A 94 276 370
314626 314626 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350029A 80 782 862
314627 314627 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350029A 144 509 653
314628 314628 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350038A 21 179 200
314629 314629 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350038A 30 140 170
314630 314630 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350043A 65 465 530
314631 314631 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350043A 127 417 544
314632 314632 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350049A 63 654 717
314633 314633 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350049A 111 396 507
314634 314634 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350052A 0 4 4
314635 314635 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350052A 4 10 14
314636 314636 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350057A 47 245 292
314637 314637 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350057A 67 226 293
314638 314638 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350058C 76 821 897
314639 314639 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350058C 145 581 726
314640 314640 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350061A 2 4 6
314641 314641 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350061A 4 5 9
314642 314642 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350101A 0 0 0
314643 314643 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350101A 0 5 5
314644 314644 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350102A 25 174 199
314645 314645 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350102A 35 138 173
314646 314646 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350104E 0 28 28
314647 314647 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350104E 4 20 24
314648 314648 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350105A 2 8 10
314649 314649 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350105A 0 8 8
314650 314650 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350106A 0 24 24
314651 314651 NO 21073 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350106A 8 14 22
314652 314652 YES 21072 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE HT 8897 0350106B 4 15 19
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]);