results

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

96 rows where precinct_id = "5150216A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
8610 8610 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 5150216A 18 57 75
8611 8611 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 5150216A 34 149 183
20046 20046 YES 20683 STATE MEASURE 27 8824 5150216A 18 59 77
20047 20047 NO 20684 STATE MEASURE 27 8824 5150216A 45 196 241
25110 25110 YES 21290 PASADENA AREA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE PCC 8946 5150216A 50 200 250
25111 25111 NO 21291 PASADENA AREA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE PCC 8946 5150216A 11 48 59
28167 28167 YES 20681 STATE MEASURE 26 8823 5150216A 21 115 136
28168 28168 NO 20682 STATE MEASURE 26 8823 5150216A 42 138 180
35101 35101 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 5150216A 37 142 179
35102 35102 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 5150216A 13 32 45
41165 41165 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 5150216A 27 84 111
41166 41166 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 5150216A 25 128 153
47538 47538 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 5150216A 34 164 198
47539 47539 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 5150216A 15 30 45
53658 53658 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 5150216A 37 148 185
53659 53659 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 5150216A 13 25 38
59784 59784 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 5150216A 37 148 185
59785 59785 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 5150216A 14 30 44
66713 66713 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 5150216A 18 52 70
66714 66714 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 5150216A 47 199 246
72693 72693 FIONA MA 20562 TREASURER 8766 5150216A 47 197 244
72694 72694 JACK M. GUERRERO 20561 TREASURER 8766 5150216A 18 54 72
78673 78673 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 5150216A 17 55 72
78674 78674 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 5150216A 48 189 237
88705 88705 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 5150216A 51 213 264
88706 88706 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 5150216A 15 46 61
94865 94865 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 5150216A 37 99 136
94866 94866 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 5150216A 16 109 125
106338 106338 YES 20688 STATE MEASURE 29 8826 5150216A 26 104 130
106339 106339 NO 20689 STATE MEASURE 29 8826 5150216A 39 149 188
113559 113559 YES 21263 COUNTY MEASURE C 8943 5150216A 47 165 212
113560 113560 NO 21264 COUNTY MEASURE C 8943 5150216A 18 74 92
119555 119555 YES 20686 STATE MEASURE 28 8825 5150216A 46 201 247
119556 119556 NO 20687 STATE MEASURE 28 8825 5150216A 19 52 71
126913 126913 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 5150216A 45 172 217
126914 126914 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 5150216A 13 56 69
132983 132983 YES 20690 STATE MEASURE 30 8827 5150216A 25 129 154
132984 132984 NO 20691 STATE MEASURE 30 8827 5150216A 40 127 167
139179 139179 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 5150216A 31 107 138
139180 139180 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 5150216A 18 102 120
142735 142735 MICHAEL MCMAHON 20771 MEMBER OF THE STATE ASSEMBLY, 41st District 8724 5150216A 17 50 67
142736 142736 CHRIS HOLDEN 20482 MEMBER OF THE STATE ASSEMBLY, 41st District 8724 5150216A 49 201 250
145611 145611 YES 20679 STATE MEASURE 1 8822 5150216A 53 215 268
145612 145612 NO 20680 STATE MEASURE 1 8822 5150216A 10 41 51
151961 151961 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 5150216A 51 210 261
151962 151962 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 5150216A 15 48 63
158467 158467 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 5150216A 36 142 178
158468 158468 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 5150216A 13 32 45
167076 167076 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 5150216A 39 142 181
167077 167077 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 5150216A 11 34 45
170332 170332 YES 20850 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE L 8875 5150216A 53 225 278
170333 170333 NO 20851 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE L 8875 5150216A 12 33 45
176680 176680 BRIAN DAHLE 20554 GOVERNOR 8762 5150216A 19 51 70
176681 176681 GAVIN NEWSOM 20553 GOVERNOR 8762 5150216A 46 209 255
183164 183164 MALIA M. COHEN 20560 CONTROLLER 8765 5150216A 42 172 214
183165 183165 LANHEE J. CHEN 20559 CONTROLLER 8765 5150216A 23 82 105
191512 191512 JUDY CHU 20526 UNITED STATES REPRESENTATIVE, 28th District 8748 5150216A 52 213 265
191513 191513 WES HALLMAN 20525 UNITED STATES REPRESENTATIVE, 28th District 8748 5150216A 14 46 60
194938 194938 ROB BONTA 20564 ATTORNEY GENERAL 8767 5150216A 45 192 237
194939 194939 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 5150216A 20 64 84
200918 200918 YES 20692 STATE MEASURE 31 8828 5150216A 52 187 239
200919 200919 NO 20693 STATE MEASURE 31 8828 5150216A 11 70 81
207254 207254 YES 21153 COUNTY MEASURE A 8930 5150216A 50 203 253
207255 207255 NO 21154 COUNTY MEASURE A 8930 5150216A 14 46 60
213234 213234 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 5150216A 19 100 119
213235 213235 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 5150216A 31 112 143
216571 216571 YES 21350 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE H 8963 5150216A 32 149 181
216572 216572 NO 21351 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE H 8963 5150216A 28 109 137
221786 221786 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 5150216A 17 51 68
221787 221787 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 5150216A 48 199 247
228004 228004 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 5150216A 41 169 210
228005 228005 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 5150216A 10 32 42
234360 234360 ALEX VILLANUEVA 20574 SHERIFF 8772 5150216A 24 69 93
234361 234361 ROBERT LUNA 20573 SHERIFF 8772 5150216A 33 176 209
240616 240616 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 5150216A 40 147 187
240617 240617 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 5150216A 10 28 38
250341 250341 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 5150216A 37 137 174
250342 250342 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 5150216A 12 38 50
261085 261085 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 5150216A 17 48 65
261086 261086 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 5150216A 35 169 204
267065 267065 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 5150216A 40 171 211
267066 267066 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 5150216A 11 27 38
273045 273045 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 5150216A 34 138 172
273046 273046 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 5150216A 14 32 46
279049 279049 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 5150216A 33 136 169
279050 279050 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 5150216A 15 35 50
286667 286667 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 5150216A 28 145 173
286668 286668 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 5150216A 20 58 78
292685 292685 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 5150216A 39 164 203
292686 292686 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 5150216A 12 28 40
300261 300261 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 5150216A 35 145 180
300262 300262 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 5150216A 15 33 48
311452 311452 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 5150216A 39 146 185
311453 311453 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 5150216A 11 30 41
320200 320200 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 5150216A 35 140 175
320201 320201 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 5150216A 13 33 46

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