results

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

84 rows where contest_id = 9876

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
1648 1648 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 2400001A 0 0 0
1649 1649 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 2400001A 0 0 0
1650 1650 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000239B 320 638 958
1651 1651 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000239B 41 53 94
1652 1652 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000260A 287 1730 2017
1653 1653 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000260A 139 406 545
1654 1654 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000263A 651 2324 2975
1655 1655 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000263A 60 176 236
1656 1656 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000712A 125 687 812
1657 1657 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000712A 14 63 77
1658 1658 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000841A 38 231 269
1659 1659 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000841A 15 34 49
1660 1660 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000956E 14 98 112
1661 1661 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9000956E 9 18 27
1662 1662 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001080A 128 662 790
1663 1663 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001080A 62 198 260
1664 1664 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001100A 298 1288 1586
1665 1665 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001100A 276 480 756
1666 1666 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001134A 126 772 898
1667 1667 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001134A 56 160 216
1668 1668 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001135B 0 1 1
1669 1669 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001135B 0 0 0
1670 1670 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001177A 229 1000 1229
1671 1671 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001177A 87 214 301
1672 1672 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001180A 186 840 1026
1673 1673 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001180A 45 119 164
1674 1674 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001187A 150 580 730
1675 1675 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001187A 65 148 213
1676 1676 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001195A 149 679 828
1677 1677 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001195A 24 77 101
1678 1678 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001196A 574 2330 2904
1679 1679 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001196A 99 260 359
1680 1680 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001199A 500 2137 2637
1681 1681 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001199A 141 393 534
1682 1682 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001201A 567 1747 2314
1683 1683 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001201A 92 208 300
1684 1684 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001212A 373 1250 1623
1685 1685 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001212A 134 275 409
1686 1686 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001219C 3 12 15
1687 1687 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001219C 7 11 18
1688 1688 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001219F 0 0 0
1689 1689 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001219F 0 0 0
1690 1690 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001226A 413 1804 2217
1691 1691 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001226A 133 366 499
1692 1692 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001352A 204 900 1104
1693 1693 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001352A 180 424 604
1694 1694 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001408A 189 913 1102
1695 1695 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001408A 155 413 568
1696 1696 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001412A 33 195 228
1697 1697 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001412A 32 72 104
1698 1698 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001946B 10 82 92
1699 1699 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001946B 6 26 32
1700 1700 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001946E 30 129 159
1701 1701 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9001946E 6 25 31
1702 1702 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9002607A 238 841 1079
1703 1703 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9002607A 50 114 164
1704 1704 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9003341A 0 0 0
1705 1705 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9003341A 0 0 0
1706 1706 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9004216A 103 225 328
1707 1707 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9004216A 19 14 33
1708 1708 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9005113A 0 0 0
1709 1709 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9005113A 0 1 1
1710 1710 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9005428A 272 1074 1346
1711 1711 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9005428A 225 481 706
1712 1712 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990239A 0 0 0
1713 1713 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990239A 0 0 0
1714 1714 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990242A 0 0 0
1715 1715 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990242A 0 0 0
1716 1716 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990266A 0 0 0
1717 1717 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990266A 0 0 0
1718 1718 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990452A 0 0 0
1719 1719 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990452A 0 0 0
1720 1720 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990454A 0 0 0
1721 1721 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990454A 0 0 0
1722 1722 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990455A 0 0 0
1723 1723 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990455A 0 0 0
1724 1724 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990458A 0 0 0
1725 1725 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990458A 0 0 0
1726 1726 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990459A 0 0 0
1727 1727 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990459A 0 0 0
1728 1728 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990463A 0 0 0
1729 1729 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990463A 0 0 0
1730 1730 YES 23646 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990464A 0 0 0
1731 1731 NO 23647 MOUNTAINS RECREATION AND CONSERVATION AUTHORITY - MEASURE H 9876 9990464A 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]);