results

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

94 rows where precinct_id = "0180002A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
5896 5896 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 0180002A 25 71 96
5897 5897 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 0180002A 26 102 128
17332 17332 YES 20683 STATE MEASURE 27 8824 0180002A 14 47 61
17333 17333 NO 20684 STATE MEASURE 27 8824 0180002A 48 174 222
24054 24054 ROBERT PULLEN-MILES 20505 MEMBER OF THE STATE ASSEMBLY, 61st District 8738 0180002A 25 73 98
24055 24055 TINA SIMONE MCKINNOR 20506 MEMBER OF THE STATE ASSEMBLY, 61st District 8738 0180002A 26 114 140
25453 25453 YES 20681 STATE MEASURE 26 8823 0180002A 22 79 101
25454 25454 NO 20682 STATE MEASURE 26 8823 0180002A 39 140 179
32387 32387 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 0180002A 37 132 169
32388 32388 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 0180002A 11 29 40
38451 38451 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 0180002A 25 69 94
38452 38452 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 0180002A 28 112 140
44824 44824 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 0180002A 37 132 169
44825 44825 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 0180002A 13 33 46
50944 50944 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 0180002A 39 129 168
50945 50945 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 0180002A 9 32 41
57070 57070 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 0180002A 36 128 164
57071 57071 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 0180002A 12 33 45
63999 63999 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 0180002A 31 62 93
64000 64000 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 0180002A 28 158 186
69979 69979 FIONA MA 20562 TREASURER 8766 0180002A 33 152 185
69980 69980 JACK M. GUERRERO 20561 TREASURER 8766 0180002A 28 62 90
75959 75959 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 0180002A 24 56 80
75960 75960 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0180002A 38 151 189
85262 85262 HUGO M. ROJAS 21211 CENTINELA VALLEY UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 8804 0180002A 44 149 193
85991 85991 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 0180002A 40 165 205
85992 85992 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 0180002A 23 60 83
92151 92151 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 0180002A 30 88 118
92152 92152 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 0180002A 23 91 114
103624 103624 YES 20688 STATE MEASURE 29 8826 0180002A 24 119 143
103625 103625 NO 20689 STATE MEASURE 29 8826 0180002A 40 102 142
110845 110845 YES 21263 COUNTY MEASURE C 8943 0180002A 32 128 160
110846 110846 NO 21264 COUNTY MEASURE C 8943 0180002A 27 73 100
116841 116841 YES 20686 STATE MEASURE 28 8825 0180002A 47 167 214
116842 116842 NO 20687 STATE MEASURE 28 8825 0180002A 18 58 76
124199 124199 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 0180002A 36 141 177
124200 124200 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 0180002A 23 50 73
130269 130269 YES 20690 STATE MEASURE 30 8827 0180002A 21 130 151
130270 130270 NO 20691 STATE MEASURE 30 8827 0180002A 40 93 133
136465 136465 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 0180002A 23 66 89
136466 136466 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 0180002A 28 114 142
142897 142897 YES 20679 STATE MEASURE 1 8822 0180002A 34 151 185
142898 142898 NO 20680 STATE MEASURE 1 8822 0180002A 30 63 93
149029 149029 ESTEFANY ALEJANDRA CASTANEDA 21025 CENTINELA VALLEY UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 8805 0180002A 24 103 127
149030 149030 VIRGINIA V. GOMEZ 21294 CENTINELA VALLEY UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 8805 0180002A 25 67 92
149247 149247 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 0180002A 40 161 201
149248 149248 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 0180002A 22 61 83
155753 155753 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 0180002A 36 121 157
155754 155754 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 0180002A 9 36 45
164362 164362 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 0180002A 35 128 163
164363 164363 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 0180002A 13 32 45
173966 173966 BRIAN DAHLE 20554 GOVERNOR 8762 0180002A 24 71 95
173967 173967 GAVIN NEWSOM 20553 GOVERNOR 8762 0180002A 41 156 197
180450 180450 MALIA M. COHEN 20560 CONTROLLER 8765 0180002A 33 150 183
180451 180451 LANHEE J. CHEN 20559 CONTROLLER 8765 0180002A 26 68 94
186774 186774 OMAR NAVARRO 20547 UNITED STATES REPRESENTATIVE, 43rd District 8759 0180002A 29 71 100
186775 186775 MAXINE WATERS 20548 UNITED STATES REPRESENTATIVE, 43rd District 8759 0180002A 33 149 182
192224 192224 ROB BONTA 20564 ATTORNEY GENERAL 8767 0180002A 35 157 192
192225 192225 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 0180002A 26 62 88
198204 198204 YES 20692 STATE MEASURE 31 8828 0180002A 36 151 187
198205 198205 NO 20693 STATE MEASURE 31 8828 0180002A 26 71 97
204540 204540 YES 21153 COUNTY MEASURE A 8930 0180002A 45 171 216
204541 204541 NO 21154 COUNTY MEASURE A 8930 0180002A 14 34 48
210520 210520 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 0180002A 18 75 93
210521 210521 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 0180002A 32 96 128
219072 219072 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 0180002A 28 59 87
219073 219073 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 0180002A 31 158 189
225290 225290 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0180002A 36 144 180
225291 225291 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0180002A 17 32 49
231646 231646 ALEX VILLANUEVA 20574 SHERIFF 8772 0180002A 30 95 125
231647 231647 ROBERT LUNA 20573 SHERIFF 8772 0180002A 28 115 143
237902 237902 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 0180002A 38 133 171
237903 237903 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 0180002A 11 28 39
247627 247627 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 0180002A 34 129 163
247628 247628 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 0180002A 13 33 46
258371 258371 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 0180002A 27 59 86
258372 258372 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 0180002A 20 115 135
264351 264351 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0180002A 37 133 170
264352 264352 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0180002A 16 37 53
270331 270331 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 0180002A 32 127 159
270332 270332 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 0180002A 14 32 46
276335 276335 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 0180002A 33 123 156
276336 276336 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 0180002A 13 35 48
283953 283953 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 0180002A 24 69 93
283954 283954 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 0180002A 27 106 133
289971 289971 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 0180002A 38 133 171
289972 289972 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 0180002A 16 33 49
297547 297547 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 0180002A 35 121 156
297548 297548 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 0180002A 13 41 54
308738 308738 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 0180002A 37 119 156
308739 308739 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 0180002A 10 43 53
317486 317486 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 0180002A 34 126 160
317487 317487 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 0180002A 12 34 46
324495 324495 MARISELA RUIZ 21057 CENTINELA VALLEY UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 8803 0180002A 46 154 200

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