results

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

94 rows where precinct_id = "6700071A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
9398 9398 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6700071A 54 101 155
9399 9399 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6700071A 33 133 166
20834 20834 YES 20683 STATE MEASURE 27 8824 6700071A 20 53 73
20835 20835 NO 20684 STATE MEASURE 27 8824 6700071A 83 213 296
28955 28955 YES 20681 STATE MEASURE 26 8823 6700071A 36 87 123
28956 28956 NO 20682 STATE MEASURE 26 8823 6700071A 67 177 244
35889 35889 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6700071A 50 155 205
35890 35890 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6700071A 36 67 103
41953 41953 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6700071A 52 118 170
41954 41954 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6700071A 39 120 159
48326 48326 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6700071A 50 152 202
48327 48327 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6700071A 38 72 110
54446 54446 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6700071A 52 162 214
54447 54447 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6700071A 36 63 99
60572 60572 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6700071A 48 166 214
60573 60573 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6700071A 37 57 94
67501 67501 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 6700071A 57 84 141
67502 67502 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 6700071A 47 178 225
73481 73481 FIONA MA 20562 TREASURER 8766 6700071A 50 179 229
73482 73482 JACK M. GUERRERO 20561 TREASURER 8766 6700071A 54 84 138
79461 79461 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 6700071A 56 74 130
79462 79462 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 6700071A 48 188 236
89493 89493 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 6700071A 53 191 244
89494 89494 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 6700071A 53 76 129
95653 95653 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6700071A 56 167 223
95654 95654 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6700071A 34 75 109
107126 107126 YES 20688 STATE MEASURE 29 8826 6700071A 43 109 152
107127 107127 NO 20689 STATE MEASURE 29 8826 6700071A 59 153 212
114347 114347 YES 21263 COUNTY MEASURE C 8943 6700071A 43 162 205
114348 114348 NO 21264 COUNTY MEASURE C 8943 6700071A 61 92 153
120343 120343 YES 20686 STATE MEASURE 28 8825 6700071A 60 183 243
120344 120344 NO 20687 STATE MEASURE 28 8825 6700071A 45 81 126
127701 127701 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6700071A 46 181 227
127702 127702 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6700071A 50 66 116
133771 133771 YES 20690 STATE MEASURE 30 8827 6700071A 37 124 161
133772 133772 NO 20691 STATE MEASURE 30 8827 6700071A 65 137 202
139967 139967 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6700071A 48 125 173
139968 139968 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6700071A 40 109 149
146399 146399 YES 20679 STATE MEASURE 1 8822 6700071A 45 182 227
146400 146400 NO 20680 STATE MEASURE 1 8822 6700071A 57 85 142
152749 152749 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6700071A 52 182 234
152750 152750 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6700071A 52 77 129
159255 159255 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6700071A 59 171 230
159256 159256 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6700071A 24 50 74
162149 162149 BLANCA PACHECO 20510 MEMBER OF THE STATE ASSEMBLY, 64th District 8740 6700071A 52 188 240
162150 162150 RAUL ORTIZ, JR. 20509 MEMBER OF THE STATE ASSEMBLY, 64th District 8740 6700071A 53 73 126
163246 163246 ERIC J. CHING 20544 UNITED STATES REPRESENTATIVE, 38th District 8757 6700071A 51 78 129
163247 163247 LINDA T. SÁNCHEZ 20543 UNITED STATES REPRESENTATIVE, 38th District 8757 6700071A 53 186 239
167864 167864 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6700071A 55 157 212
167865 167865 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6700071A 32 62 94
177468 177468 BRIAN DAHLE 20554 GOVERNOR 8762 6700071A 57 82 139
177469 177469 GAVIN NEWSOM 20553 GOVERNOR 8762 6700071A 49 184 233
183952 183952 MALIA M. COHEN 20560 CONTROLLER 8765 6700071A 46 184 230
183953 183953 LANHEE J. CHEN 20559 CONTROLLER 8765 6700071A 57 79 136
195726 195726 ROB BONTA 20564 ATTORNEY GENERAL 8767 6700071A 48 190 238
195727 195727 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 6700071A 55 75 130
201706 201706 YES 20692 STATE MEASURE 31 8828 6700071A 49 179 228
201707 201707 NO 20693 STATE MEASURE 31 8828 6700071A 57 86 143
208042 208042 YES 21153 COUNTY MEASURE A 8930 6700071A 62 196 258
208043 208043 NO 21154 COUNTY MEASURE A 8930 6700071A 41 65 106
214022 214022 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6700071A 30 86 116
214023 214023 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6700071A 57 148 205
218964 218964 MIGUEL "MIKE" BEJARANO 21056 WHITTIER UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 8512 6700071A 53 91 144
218965 218965 GARY MENDEZ 20704 WHITTIER UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 8512 6700071A 40 146 186
222574 222574 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 6700071A 57 72 129
222575 222575 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 6700071A 48 186 234
228792 228792 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 6700071A 58 189 247
228793 228793 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 6700071A 35 47 82
235148 235148 ALEX VILLANUEVA 20574 SHERIFF 8772 6700071A 56 123 179
235149 235149 ROBERT LUNA 20573 SHERIFF 8772 6700071A 42 139 181
241404 241404 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6700071A 53 166 219
241405 241405 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6700071A 34 58 92
245331 245331 TOM UMBERG 20473 STATE SENATOR, 34th District 8719 6700071A 47 184 231
245332 245332 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700071A 57 76 133
251129 251129 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6700071A 54 171 225
251130 251130 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6700071A 32 52 84
261873 261873 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6700071A 48 67 115
261874 261874 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6700071A 38 173 211
267853 267853 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6700071A 49 152 201
267854 267854 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6700071A 42 76 118
273833 273833 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6700071A 47 156 203
273834 273834 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6700071A 34 64 98
279837 279837 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6700071A 45 151 196
279838 279838 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6700071A 37 72 109
287455 287455 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6700071A 27 89 116
287456 287456 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6700071A 62 147 209
293473 293473 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6700071A 50 167 217
293474 293474 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6700071A 39 59 98
301049 301049 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6700071A 41 154 195
301050 301050 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6700071A 47 73 120
312240 312240 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 6700071A 59 163 222
312241 312241 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 6700071A 27 61 88
320988 320988 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 6700071A 44 150 194
320989 320989 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 6700071A 40 72 112

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