results

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

97 rows where precinct_id = "7700157A"

✎ 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
9728 9728 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 7700157A 26 57 83
9729 9729 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 7700157A 18 94 112
14820 14820 NICKOLAS LEWIS 21674 WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Clerk 8617 7700157A 43 139 182
21164 21164 YES 20683 STATE MEASURE 27 8824 7700157A 19 38 57
21165 21165 NO 20684 STATE MEASURE 27 8824 7700157A 39 155 194
29285 29285 YES 20681 STATE MEASURE 26 8823 7700157A 24 69 93
29286 29286 NO 20682 STATE MEASURE 26 8823 7700157A 34 120 154
36219 36219 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 7700157A 32 108 140
36220 36220 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 7700157A 17 30 47
42283 42283 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 7700157A 20 64 84
42284 42284 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 7700157A 26 89 115
48656 48656 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 7700157A 32 105 137
48657 48657 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 7700157A 18 38 56
54776 54776 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 7700157A 28 109 137
54777 54777 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 7700157A 20 33 53
60902 60902 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 7700157A 32 111 143
60903 60903 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 7700157A 18 27 45
67831 67831 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 7700157A 30 53 83
67832 67832 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 7700157A 27 140 167
73811 73811 FIONA MA 20562 TREASURER 8766 7700157A 25 140 165
73812 73812 JACK M. GUERRERO 20561 TREASURER 8766 7700157A 32 56 88
79791 79791 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 7700157A 26 55 81
79792 79792 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 7700157A 30 133 163
85199 85199 SUE AUGINO 21671 WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8618 7700157A 14 19 33
85200 85200 COLLEEN B. ROZATTI 21673 WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8618 7700157A 18 84 102
85201 85201 MARSHA SOLORIO 21672 WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8618 7700157A 16 45 61
89823 89823 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 7700157A 30 138 168
89824 89824 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 7700157A 29 56 85
95983 95983 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 7700157A 28 98 126
95984 95984 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 7700157A 19 57 76
107456 107456 YES 20688 STATE MEASURE 29 8826 7700157A 14 75 89
107457 107457 NO 20689 STATE MEASURE 29 8826 7700157A 46 121 167
114677 114677 YES 21263 COUNTY MEASURE C 8943 7700157A 34 104 138
114678 114678 NO 21264 COUNTY MEASURE C 8943 7700157A 23 70 93
120673 120673 YES 20686 STATE MEASURE 28 8825 7700157A 34 146 180
120674 120674 NO 20687 STATE MEASURE 28 8825 7700157A 26 45 71
128031 128031 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 7700157A 27 130 157
128032 128032 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 7700157A 26 48 74
134101 134101 YES 20690 STATE MEASURE 30 8827 7700157A 16 87 103
134102 134102 NO 20691 STATE MEASURE 30 8827 7700157A 44 107 151
140297 140297 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 7700157A 27 74 101
140298 140298 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 7700157A 18 78 96
146729 146729 YES 20679 STATE MEASURE 1 8822 7700157A 32 137 169
146730 146730 NO 20680 STATE MEASURE 1 8822 7700157A 27 56 83
153079 153079 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 7700157A 30 138 168
153080 153080 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 7700157A 27 52 79
159585 159585 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 7700157A 37 113 150
159586 159586 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 7700157A 12 20 32
168194 168194 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 7700157A 29 107 136
168195 168195 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 7700157A 21 28 49
177798 177798 BRIAN DAHLE 20554 GOVERNOR 8762 7700157A 32 51 83
177799 177799 GAVIN NEWSOM 20553 GOVERNOR 8762 7700157A 27 147 174
184282 184282 MALIA M. COHEN 20560 CONTROLLER 8765 7700157A 28 129 157
184283 184283 LANHEE J. CHEN 20559 CONTROLLER 8765 7700157A 29 66 95
196056 196056 ROB BONTA 20564 ATTORNEY GENERAL 8767 7700157A 29 141 170
196057 196057 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 7700157A 27 52 79
202036 202036 YES 20692 STATE MEASURE 31 8828 7700157A 35 133 168
202037 202037 NO 20693 STATE MEASURE 31 8828 7700157A 25 60 85
208372 208372 YES 21153 COUNTY MEASURE A 8930 7700157A 35 141 176
208373 208373 NO 21154 COUNTY MEASURE A 8930 7700157A 24 42 66
214352 214352 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 7700157A 17 50 67
214353 214353 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 7700157A 29 101 130
222904 222904 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 7700157A 29 51 80
222905 222905 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 7700157A 29 139 168
229122 229122 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 7700157A 35 123 158
229123 229123 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 7700157A 19 29 48
235478 235478 ALEX VILLANUEVA 20574 SHERIFF 8772 7700157A 28 78 106
235479 235479 ROBERT LUNA 20573 SHERIFF 8772 7700157A 28 111 139
241734 241734 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 7700157A 34 112 146
241735 241735 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 7700157A 15 26 41
245975 245975 SUSAN RUBIO 20465 STATE SENATOR, 22nd District 8714 7700157A 32 139 171
245976 245976 VINCENT TSAI 20464 STATE SENATOR, 22nd District 8714 7700157A 26 56 82
246605 246605 GRACE F. NAPOLITANO 20531 UNITED STATES REPRESENTATIVE, 31st District 8751 7700157A 27 138 165
246606 246606 DANIEL BOCIC MARTINEZ 20532 UNITED STATES REPRESENTATIVE, 31st District 8751 7700157A 30 54 84
251459 251459 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 7700157A 30 116 146
251460 251460 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 7700157A 20 26 46
262203 262203 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 7700157A 22 45 67
262204 262204 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 7700157A 28 114 142
268183 268183 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 7700157A 31 110 141
268184 268184 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 7700157A 20 36 56
274163 274163 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 7700157A 31 103 134
274164 274164 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 7700157A 18 32 50
280167 280167 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 7700157A 32 101 133
280168 280168 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 7700157A 16 32 48
287785 287785 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 7700157A 21 74 95
287786 287786 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 7700157A 27 81 108
293803 293803 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 7700157A 32 104 136
293804 293804 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 7700157A 20 36 56
301379 301379 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 7700157A 31 108 139
301380 301380 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 7700157A 19 34 53
312570 312570 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 7700157A 32 115 147
312571 312571 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 7700157A 16 23 39
315968 315968 BLANCA RUBIO 20490 MEMBER OF THE STATE ASSEMBLY, 48th District 8729 7700157A 31 141 172
315969 315969 RYAN MAYE 20773 MEMBER OF THE STATE ASSEMBLY, 48th District 8729 7700157A 28 50 78
321318 321318 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 7700157A 31 106 137
321319 321319 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 7700157A 19 28 47
324586 324586 LETTY LOPEZ 21663 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8619 7700157A 38 154 192

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