results

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

42 rows where contest_id = 8624

✎ 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
11770 11770 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1750001D 76 158 234
11771 11771 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1750001D 34 34 68
11772 11772 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1750001Q 45 88 133
11773 11773 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1750001Q 13 20 33
11774 11774 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1750054B 51 108 159
11775 11775 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1750054B 12 30 42
11776 11776 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1770001B 13 31 44
11777 11777 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1770001B 5 10 15
11778 11778 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1770072A 43 159 202
11779 11779 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1770072A 18 39 57
11780 11780 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1770306B 47 163 210
11781 11781 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 1770306B 16 49 65
11782 11782 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 3680001A 114 244 358
11783 11783 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 3680001A 38 73 111
11784 11784 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 3680001C 18 38 56
11785 11785 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 3680001C 6 14 20
11786 11786 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000020A 226 697 923
11787 11787 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000020A 80 197 277
11788 11788 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000024A 163 496 659
11789 11789 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000024A 43 117 160
11790 11790 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000026A 181 524 705
11791 11791 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000026A 64 198 262
11792 11792 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000032A 104 503 607
11793 11793 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000032A 51 153 204
11794 11794 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000060A 56 202 258
11795 11795 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000060A 13 59 72
11796 11796 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000063A 7 25 32
11797 11797 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000063A 0 4 4
11798 11798 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000066A 89 328 417
11799 11799 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000066A 27 77 104
11800 11800 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000070A 181 567 748
11801 11801 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000070A 57 169 226
11802 11802 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000080C 55 219 274
11803 11803 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000080C 14 69 83
11804 11804 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000104A 190 704 894
11805 11805 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000104A 50 195 245
11806 11806 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000118A 94 293 387
11807 11807 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000118A 21 73 94
11808 11808 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000134A 297 863 1160
11809 11809 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 5000134A 77 228 305
11810 11810 FRANK S. DONATO 20674 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 6300457E 6 3 9
11811 11811 MIKE LANG 21216 ANTELOPE VALLEY-EAST KERN WATER AGENCY Member, Board of Directors, Division 3 8624 6300457E 1 0 1

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