results

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

96 rows where precinct_id = "3230009A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
7538 7538 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 3230009A 28 65 93
7539 7539 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 3230009A 14 63 77
18974 18974 YES 20683 STATE MEASURE 27 8824 3230009A 5 35 40
18975 18975 NO 20684 STATE MEASURE 27 8824 3230009A 41 145 186
27095 27095 YES 20681 STATE MEASURE 26 8823 3230009A 10 58 68
27096 27096 NO 20682 STATE MEASURE 26 8823 3230009A 36 121 157
34029 34029 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 3230009A 12 73 85
34030 34030 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 3230009A 28 51 79
40093 40093 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 3230009A 34 75 109
40094 40094 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 3230009A 7 58 65
46466 46466 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 3230009A 10 84 94
46467 46467 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 3230009A 32 50 82
52586 52586 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 3230009A 8 83 91
52587 52587 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 3230009A 34 49 83
58712 58712 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 3230009A 11 79 90
58713 58713 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 3230009A 29 44 73
65641 65641 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 3230009A 40 107 147
65642 65642 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 3230009A 6 73 79
71621 71621 FIONA MA 20562 TREASURER 8766 3230009A 6 72 78
71622 71622 JACK M. GUERRERO 20561 TREASURER 8766 3230009A 41 108 149
77601 77601 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 3230009A 41 99 140
77602 77602 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 3230009A 6 75 81
87633 87633 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 3230009A 7 79 86
87634 87634 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 3230009A 39 107 146
93793 93793 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 3230009A 27 87 114
93794 93794 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 3230009A 12 47 59
105266 105266 YES 20688 STATE MEASURE 29 8826 3230009A 3 35 38
105267 105267 NO 20689 STATE MEASURE 29 8826 3230009A 43 141 184
112487 112487 YES 21263 COUNTY MEASURE C 8943 3230009A 11 88 99
112488 112488 NO 21264 COUNTY MEASURE C 8943 3230009A 35 74 109
118483 118483 YES 20686 STATE MEASURE 28 8825 3230009A 9 87 96
118484 118484 NO 20687 STATE MEASURE 28 8825 3230009A 38 90 128
123523 123523 BOB ARCHULETA 20471 STATE SENATOR, 30th District 8718 3230009A 6 76 82
123524 123524 MITCH CLEMMONS 20470 STATE SENATOR, 30th District 8718 3230009A 41 100 141
125841 125841 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 3230009A 8 76 84
125842 125842 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 3230009A 31 74 105
131911 131911 YES 20690 STATE MEASURE 30 8827 3230009A 5 42 47
131912 131912 NO 20691 STATE MEASURE 30 8827 3230009A 42 138 180
138107 138107 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 3230009A 25 97 122
138108 138108 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 3230009A 8 34 42
144539 144539 YES 20679 STATE MEASURE 1 8822 3230009A 10 90 100
144540 144540 NO 20680 STATE MEASURE 1 8822 3230009A 36 85 121
150889 150889 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 3230009A 9 82 91
150890 150890 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 3230009A 38 99 137
157395 157395 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 3230009A 32 84 116
157396 157396 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 3230009A 10 35 45
162964 162964 ERIC J. CHING 20544 UNITED STATES REPRESENTATIVE, 38th District 8757 3230009A 39 106 145
162965 162965 LINDA T. SÁNCHEZ 20543 UNITED STATES REPRESENTATIVE, 38th District 8757 3230009A 8 74 82
166004 166004 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 3230009A 13 75 88
166005 166005 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 3230009A 26 49 75
175608 175608 BRIAN DAHLE 20554 GOVERNOR 8762 3230009A 41 110 151
175609 175609 GAVIN NEWSOM 20553 GOVERNOR 8762 3230009A 6 72 78
182092 182092 MALIA M. COHEN 20560 CONTROLLER 8765 3230009A 6 70 76
182093 182093 LANHEE J. CHEN 20559 CONTROLLER 8765 3230009A 40 107 147
191914 191914 LISA CALDERON 20502 MEMBER OF THE STATE ASSEMBLY, 56th District 8736 3230009A 7 73 80
191915 191915 JESSICA MARTINEZ 20503 MEMBER OF THE STATE ASSEMBLY, 56th District 8736 3230009A 39 108 147
193866 193866 ROB BONTA 20564 ATTORNEY GENERAL 8767 3230009A 6 71 77
193867 193867 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 3230009A 41 107 148
199846 199846 YES 20692 STATE MEASURE 31 8828 3230009A 12 94 106
199847 199847 NO 20693 STATE MEASURE 31 8828 3230009A 35 81 116
206182 206182 YES 21153 COUNTY MEASURE A 8930 3230009A 10 78 88
206183 206183 NO 21154 COUNTY MEASURE A 8930 3230009A 36 94 130
212162 212162 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 3230009A 11 36 47
212163 212163 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 3230009A 28 99 127
220714 220714 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 3230009A 40 109 149
220715 220715 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 3230009A 7 73 80
226932 226932 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 3230009A 9 80 89
226933 226933 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 3230009A 33 57 90
233288 233288 ALEX VILLANUEVA 20574 SHERIFF 8772 3230009A 38 112 150
233289 233289 ROBERT LUNA 20573 SHERIFF 8772 3230009A 8 69 77
237674 237674 IRMA RODRIGUEZ MOISA 21176 WHITTIER UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 4 8511 3230009A 8 51 59
237675 237675 CHRIS HARDEMAN 20805 WHITTIER UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 4 8511 3230009A 34 101 135
239544 239544 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 3230009A 10 76 86
239545 239545 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 3230009A 31 48 79
249269 249269 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 3230009A 8 72 80
249270 249270 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 3230009A 32 52 84
260013 260013 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 3230009A 27 60 87
260014 260014 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 3230009A 11 72 83
265993 265993 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 3230009A 10 82 92
265994 265994 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 3230009A 30 54 84
271973 271973 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 3230009A 15 83 98
271974 271974 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 3230009A 25 39 64
277977 277977 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 3230009A 9 81 90
277978 277978 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 3230009A 33 41 74
285595 285595 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 3230009A 11 63 74
285596 285596 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 3230009A 30 59 89
291613 291613 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 3230009A 10 80 90
291614 291614 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 3230009A 30 55 85
299189 299189 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 3230009A 14 82 96
299190 299190 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 3230009A 28 53 81
310380 310380 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 3230009A 23 84 107
310381 310381 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 3230009A 19 37 56
315063 315063 OSCAR VALLADARES 20941 RIO HONDO COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 8813 3230009A 21 73 94
315064 315064 VANESSA C. TYSON 21309 RIO HONDO COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 8813 3230009A 17 61 78
319128 319128 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 3230009A 9 79 88
319129 319129 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 3230009A 31 44 75

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