results

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

104 rows where precinct_id = "7700122A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
9708 9708 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 7700122A 27 75 102
9709 9709 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 7700122A 26 97 123
14810 14810 NICKOLAS LEWIS 21674 WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Clerk 8617 7700122A 48 171 219
21144 21144 YES 20683 STATE MEASURE 27 8824 7700122A 14 45 59
21145 21145 NO 20684 STATE MEASURE 27 8824 7700122A 51 166 217
29265 29265 YES 20681 STATE MEASURE 26 8823 7700122A 17 60 77
29266 29266 NO 20682 STATE MEASURE 26 8823 7700122A 48 153 201
36199 36199 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 7700122A 22 127 149
36200 36200 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 7700122A 31 34 65
42263 42263 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 7700122A 26 76 102
42264 42264 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 7700122A 29 105 134
48636 48636 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 7700122A 26 124 150
48637 48637 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 7700122A 33 41 74
54756 54756 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 7700122A 27 119 146
54757 54757 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 7700122A 29 42 71
60882 60882 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 7700122A 24 122 146
60883 60883 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 7700122A 32 37 69
67811 67811 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 7700122A 42 68 110
67812 67812 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 7700122A 23 135 158
73791 73791 FIONA MA 20562 TREASURER 8766 7700122A 21 144 165
73792 73792 JACK M. GUERRERO 20561 TREASURER 8766 7700122A 46 58 104
79771 79771 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 7700122A 41 65 106
79772 79772 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 7700122A 25 137 162
85169 85169 SUE AUGINO 21671 WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8618 7700122A 21 25 46
85170 85170 COLLEEN B. ROZATTI 21673 WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8618 7700122A 22 89 111
85171 85171 MARSHA SOLORIO 21672 WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8618 7700122A 14 66 80
85881 85881 CINDY RUIZ 20617 WALNUT VALLEY UNIFIED SCHOOL DISTRICT Governing Board Member 8491 7700122A 38 137 175
85882 85882 YI TONY TORNG 20618 WALNUT VALLEY UNIFIED SCHOOL DISTRICT Governing Board Member 8491 7700122A 29 94 123
85883 85883 HONG DIANA ZHAO 20631 WALNUT VALLEY UNIFIED SCHOOL DISTRICT Governing Board Member 8491 7700122A 17 46 63
85884 85884 HELEN HALL 20612 WALNUT VALLEY UNIFIED SCHOOL DISTRICT Governing Board Member 8491 7700122A 40 126 166
89803 89803 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 7700122A 24 144 168
89804 89804 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 7700122A 42 67 109
95963 95963 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 7700122A 29 106 135
95964 95964 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 7700122A 26 71 97
107436 107436 YES 20688 STATE MEASURE 29 8826 7700122A 15 81 96
107437 107437 NO 20689 STATE MEASURE 29 8826 7700122A 49 127 176
114657 114657 YES 21263 COUNTY MEASURE C 8943 7700122A 19 149 168
114658 114658 NO 21264 COUNTY MEASURE C 8943 7700122A 43 52 95
120653 120653 YES 20686 STATE MEASURE 28 8825 7700122A 34 150 184
120654 120654 NO 20687 STATE MEASURE 28 8825 7700122A 32 62 94
123835 123835 BOB ARCHULETA 20471 STATE SENATOR, 30th District 8718 7700122A 24 144 168
123836 123836 MITCH CLEMMONS 20470 STATE SENATOR, 30th District 8718 7700122A 42 59 101
128011 128011 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 7700122A 23 136 159
128012 128012 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 7700122A 36 64 100
134081 134081 YES 20690 STATE MEASURE 30 8827 7700122A 16 99 115
134082 134082 NO 20691 STATE MEASURE 30 8827 7700122A 48 108 156
140277 140277 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 7700122A 35 93 128
140278 140278 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 7700122A 20 81 101
146709 146709 YES 20679 STATE MEASURE 1 8822 7700122A 28 169 197
146710 146710 NO 20680 STATE MEASURE 1 8822 7700122A 36 43 79
153059 153059 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 7700122A 26 142 168
153060 153060 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 7700122A 39 67 106
159565 159565 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 7700122A 30 131 161
159566 159566 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 7700122A 25 30 55
168174 168174 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 7700122A 25 120 145
168175 168175 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 7700122A 28 41 69
177778 177778 BRIAN DAHLE 20554 GOVERNOR 8762 7700122A 48 64 112
177779 177779 GAVIN NEWSOM 20553 GOVERNOR 8762 7700122A 19 145 164
184262 184262 MALIA M. COHEN 20560 CONTROLLER 8765 7700122A 23 132 155
184263 184263 LANHEE J. CHEN 20559 CONTROLLER 8765 7700122A 44 73 117
196036 196036 ROB BONTA 20564 ATTORNEY GENERAL 8767 7700122A 24 137 161
196037 196037 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 7700122A 43 64 107
202016 202016 YES 20692 STATE MEASURE 31 8828 7700122A 30 148 178
202017 202017 NO 20693 STATE MEASURE 31 8828 7700122A 33 60 93
208352 208352 YES 21153 COUNTY MEASURE A 8930 7700122A 33 152 185
208353 208353 NO 21154 COUNTY MEASURE A 8930 7700122A 33 48 81
214332 214332 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 7700122A 21 56 77
214333 214333 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 7700122A 34 120 154
222884 222884 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 7700122A 40 64 104
222885 222885 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 7700122A 26 138 164
229102 229102 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 7700122A 28 138 166
229103 229103 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 7700122A 34 34 68
235458 235458 ALEX VILLANUEVA 20574 SHERIFF 8772 7700122A 37 86 123
235459 235459 ROBERT LUNA 20573 SHERIFF 8772 7700122A 29 114 143
241714 241714 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 7700122A 23 119 142
241715 241715 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 7700122A 33 40 73
246585 246585 GRACE F. NAPOLITANO 20531 UNITED STATES REPRESENTATIVE, 31st District 8751 7700122A 21 144 165
246586 246586 DANIEL BOCIC MARTINEZ 20532 UNITED STATES REPRESENTATIVE, 31st District 8751 7700122A 45 59 104
251439 251439 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 7700122A 22 119 141
251440 251440 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 7700122A 31 38 69
262183 262183 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 7700122A 29 59 88
262184 262184 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 7700122A 25 131 156
268163 268163 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 7700122A 28 121 149
268164 268164 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 7700122A 34 50 84
274143 274143 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 7700122A 28 124 152
274144 274144 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 7700122A 25 37 62
280147 280147 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 7700122A 26 115 141
280148 280148 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 7700122A 29 46 75
287765 287765 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 7700122A 22 82 104
287766 287766 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 7700122A 30 93 123
293783 293783 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 7700122A 25 126 151
293784 293784 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 7700122A 36 41 77
301359 301359 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 7700122A 23 127 150
301360 301360 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 7700122A 34 38 72
312550 312550 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 7700122A 28 118 146
312551 312551 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 7700122A 26 42 68
314674 314674 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700122A 4 29 33
314675 314675 FREDRICK SYKES 21668 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700122A 33 97 130
314676 314676 HOSSEIN RAMBOD SOTOODEH 21669 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700122A 1 6 7
314677 314677 TONY WU 21670 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700122A 28 77 105

Next page

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