results

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

94 rows where precinct_id = "7800170A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
9826 9826 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 7800170A 11 47 58
9827 9827 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 7800170A 12 41 53
21262 21262 YES 20683 STATE MEASURE 27 8824 7800170A 8 23 31
21263 21263 NO 20684 STATE MEASURE 27 8824 7800170A 17 78 95
29383 29383 YES 20681 STATE MEASURE 26 8823 7800170A 8 43 51
29384 29384 NO 20682 STATE MEASURE 26 8823 7800170A 17 56 73
36317 36317 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 7800170A 12 57 69
36318 36318 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 7800170A 8 19 27
42381 42381 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 7800170A 13 36 49
42382 42382 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 7800170A 9 51 60
48754 48754 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 7800170A 12 54 66
48755 48755 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 7800170A 11 29 40
54874 54874 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 7800170A 14 61 75
54875 54875 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 7800170A 8 21 29
61000 61000 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 7800170A 11 46 57
61001 61001 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 7800170A 10 30 40
67929 67929 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 7800170A 13 28 41
67930 67930 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 7800170A 13 77 90
73909 73909 FIONA MA 20562 TREASURER 8766 7800170A 13 79 92
73910 73910 JACK M. GUERRERO 20561 TREASURER 8766 7800170A 13 26 39
79889 79889 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 7800170A 10 28 38
79890 79890 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 7800170A 15 77 92
89921 89921 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 7800170A 14 75 89
89922 89922 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 7800170A 11 35 46
96081 96081 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 7800170A 18 52 70
96082 96082 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 7800170A 5 37 42
107554 107554 YES 20688 STATE MEASURE 29 8826 7800170A 12 52 64
107555 107555 NO 20689 STATE MEASURE 29 8826 7800170A 15 55 70
114775 114775 YES 21263 COUNTY MEASURE C 8943 7800170A 13 58 71
114776 114776 NO 21264 COUNTY MEASURE C 8943 7800170A 13 43 56
120771 120771 YES 20686 STATE MEASURE 28 8825 7800170A 17 70 87
120772 120772 NO 20687 STATE MEASURE 28 8825 7800170A 10 36 46
123889 123889 BOB ARCHULETA 20471 STATE SENATOR, 30th District 8718 7800170A 16 74 90
123890 123890 MITCH CLEMMONS 20470 STATE SENATOR, 30th District 8718 7800170A 10 28 38
128129 128129 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 7800170A 13 67 80
128130 128130 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 7800170A 11 30 41
134199 134199 YES 20690 STATE MEASURE 30 8827 7800170A 6 46 52
134200 134200 NO 20691 STATE MEASURE 30 8827 7800170A 21 61 82
140395 140395 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 7800170A 16 35 51
140396 140396 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 7800170A 4 50 54
146827 146827 YES 20679 STATE MEASURE 1 8822 7800170A 16 69 85
146828 146828 NO 20680 STATE MEASURE 1 8822 7800170A 11 38 49
153177 153177 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 7800170A 14 75 89
153178 153178 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 7800170A 12 33 45
159683 159683 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 7800170A 15 59 74
159684 159684 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 7800170A 7 18 25
163314 163314 ERIC J. CHING 20544 UNITED STATES REPRESENTATIVE, 38th District 8757 7800170A 11 30 41
163315 163315 LINDA T. SÁNCHEZ 20543 UNITED STATES REPRESENTATIVE, 38th District 8757 7800170A 15 79 94
168292 168292 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 7800170A 11 54 65
168293 168293 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 7800170A 10 23 33
177896 177896 BRIAN DAHLE 20554 GOVERNOR 8762 7800170A 12 37 49
177897 177897 GAVIN NEWSOM 20553 GOVERNOR 8762 7800170A 15 72 87
184380 184380 MALIA M. COHEN 20560 CONTROLLER 8765 7800170A 10 71 81
184381 184381 LANHEE J. CHEN 20559 CONTROLLER 8765 7800170A 16 32 48
192108 192108 LISA CALDERON 20502 MEMBER OF THE STATE ASSEMBLY, 56th District 8736 7800170A 15 78 93
192109 192109 JESSICA MARTINEZ 20503 MEMBER OF THE STATE ASSEMBLY, 56th District 8736 7800170A 11 30 41
196154 196154 ROB BONTA 20564 ATTORNEY GENERAL 8767 7800170A 14 71 85
196155 196155 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 7800170A 12 35 47
202134 202134 YES 20692 STATE MEASURE 31 8828 7800170A 15 69 84
202135 202135 NO 20693 STATE MEASURE 31 8828 7800170A 11 38 49
208470 208470 YES 21153 COUNTY MEASURE A 8930 7800170A 14 70 84
208471 208471 NO 21154 COUNTY MEASURE A 8930 7800170A 12 31 43
214450 214450 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 7800170A 8 32 40
214451 214451 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 7800170A 15 56 71
223002 223002 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 7800170A 13 31 44
223003 223003 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 7800170A 13 72 85
229220 229220 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 7800170A 13 65 78
229221 229221 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 7800170A 10 19 29
235576 235576 ALEX VILLANUEVA 20574 SHERIFF 8772 7800170A 14 53 67
235577 235577 ROBERT LUNA 20573 SHERIFF 8772 7800170A 11 52 63
237702 237702 IRMA RODRIGUEZ MOISA 21176 WHITTIER UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 4 8511 7800170A 14 66 80
237703 237703 CHRIS HARDEMAN 20805 WHITTIER UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 4 8511 7800170A 8 26 34
241832 241832 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 7800170A 12 65 77
241833 241833 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 7800170A 10 17 27
251557 251557 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 7800170A 12 54 66
251558 251558 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 7800170A 9 22 31
262301 262301 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 7800170A 10 29 39
262302 262302 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 7800170A 14 61 75
268281 268281 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 7800170A 10 59 69
268282 268282 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 7800170A 12 25 37
274261 274261 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 7800170A 12 49 61
274262 274262 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 7800170A 9 27 36
280265 280265 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 7800170A 13 47 60
280266 280266 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 7800170A 8 29 37
287883 287883 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 7800170A 8 36 44
287884 287884 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 7800170A 14 53 67
293901 293901 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 7800170A 13 51 64
293902 293902 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 7800170A 10 33 43
301477 301477 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 7800170A 8 60 68
301478 301478 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 7800170A 14 22 36
312668 312668 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 7800170A 16 67 83
312669 312669 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 7800170A 6 15 21
321416 321416 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 7800170A 13 50 63
321417 321417 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 7800170A 8 26 34

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