results

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

48 rows where contest_id = 8381

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
14827 14827 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550002C 1 5 6
14828 14828 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550002C 0 7 7
14829 14829 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550002C 0 1 1
14830 14830 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550002C 1 7 8
14831 14831 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550019D 0 1 1
14832 14832 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550019D 0 1 1
14833 14833 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550019D 0 1 1
14834 14834 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550019D 0 0 0
14835 14835 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550148A 30 104 134
14836 14836 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550148A 23 81 104
14837 14837 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550148A 13 35 48
14838 14838 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550148A 8 65 73
14839 14839 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150005A 0 4 4
14840 14840 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150005A 0 4 4
14841 14841 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150005A 0 0 0
14842 14842 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150005A 0 4 4
14843 14843 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150040D 20 95 115
14844 14844 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150040D 20 72 92
14845 14845 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150040D 11 27 38
14846 14846 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150040D 14 51 65
14847 14847 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150060D 11 53 64
14848 14848 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150060D 5 59 64
14849 14849 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150060D 2 20 22
14850 14850 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150060D 5 27 32
14851 14851 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150064D 7 16 23
14852 14852 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150064D 6 11 17
14853 14853 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150064D 1 5 6
14854 14854 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150064D 3 5 8
14855 14855 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200001A 137 937 1074
14856 14856 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200001A 136 798 934
14857 14857 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200001A 56 300 356
14858 14858 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200001A 85 538 623
14859 14859 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200004A 186 984 1170
14860 14860 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200004A 159 784 943
14861 14861 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200004A 75 334 409
14862 14862 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200004A 100 487 587
14863 14863 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200018C 10 41 51
14864 14864 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200018C 7 30 37
14865 14865 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200018C 7 18 25
14866 14866 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200018C 3 20 23
14867 14867 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200019A 172 757 929
14868 14868 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200019A 154 667 821
14869 14869 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200019A 63 247 310
14870 14870 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200019A 105 404 509
14871 14871 JAMES BODNAR 20804 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 4610025A 117 439 556
14872 14872 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 4610025A 87 375 462
14873 14873 ALEC HYELER 21250 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 4610025A 48 152 200
14874 14874 JEFFERY W. JOHNSON 21214 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 4610025A 61 203 264

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