results

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

99 rows where precinct_id = "1450149A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
6552 6552 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 1450149A 20 62 82
6553 6553 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 1450149A 25 73 98
17988 17988 YES 20683 STATE MEASURE 27 8824 1450149A 16 27 43
17989 17989 NO 20684 STATE MEASURE 27 8824 1450149A 37 134 171
26109 26109 YES 20681 STATE MEASURE 26 8823 1450149A 19 58 77
26110 26110 NO 20682 STATE MEASURE 26 8823 1450149A 33 100 133
33043 33043 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 1450149A 28 95 123
33044 33044 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 1450149A 13 24 37
39107 39107 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 1450149A 16 47 63
39108 39108 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 1450149A 31 91 122
45480 45480 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 1450149A 28 92 120
45481 45481 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 1450149A 15 36 51
51600 51600 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 1450149A 25 88 113
51601 51601 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 1450149A 14 33 47
57726 57726 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 1450149A 25 92 117
57727 57727 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 1450149A 14 27 41
64655 64655 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 1450149A 14 23 37
64656 64656 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 1450149A 39 137 176
70635 70635 FIONA MA 20562 TREASURER 8766 1450149A 42 140 182
70636 70636 JACK M. GUERRERO 20561 TREASURER 8766 1450149A 11 23 34
76615 76615 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 1450149A 10 19 29
76616 76616 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 1450149A 41 141 182
86647 86647 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 1450149A 43 148 191
86648 86648 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 1450149A 10 13 23
92807 92807 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 1450149A 21 71 92
92808 92808 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 1450149A 26 68 94
103102 103102 FATIMA IQBAL-ZUBAIR 20512 MEMBER OF THE STATE ASSEMBLY, 65th District 8741 1450149A 27 61 88
103103 103103 MIKE ANTHONY GIPSON 20511 MEMBER OF THE STATE ASSEMBLY, 65th District 8741 1450149A 24 98 122
104280 104280 YES 20688 STATE MEASURE 29 8826 1450149A 19 61 80
104281 104281 NO 20689 STATE MEASURE 29 8826 1450149A 33 99 132
111501 111501 YES 21263 COUNTY MEASURE C 8943 1450149A 25 88 113
111502 111502 NO 21264 COUNTY MEASURE C 8943 1450149A 25 50 75
117497 117497 YES 20686 STATE MEASURE 28 8825 1450149A 37 128 165
117498 117498 NO 20687 STATE MEASURE 28 8825 1450149A 16 30 46
124855 124855 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 1450149A 40 131 171
124856 124856 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 1450149A 11 26 37
130925 130925 YES 20690 STATE MEASURE 30 8827 1450149A 21 77 98
130926 130926 NO 20691 STATE MEASURE 30 8827 1450149A 32 84 116
137121 137121 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 1450149A 23 84 107
137122 137122 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 1450149A 25 54 79
143553 143553 YES 20679 STATE MEASURE 1 8822 1450149A 38 122 160
143554 143554 NO 20680 STATE MEASURE 1 8822 1450149A 15 36 51
149903 149903 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 1450149A 42 140 182
149904 149904 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 1450149A 11 15 26
156409 156409 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 1450149A 31 92 123
156410 156410 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 1450149A 9 25 34
165018 165018 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 1450149A 25 93 118
165019 165019 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 1450149A 15 26 41
171104 171104 ANDRES RAMOS 20790 COMPTON COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 1 8443 1450149A 21 80 101
171105 171105 ANTHONY PERRY 21191 COMPTON COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 1 8443 1450149A 23 45 68
171106 171106 SKYY D. FISHER 21288 COMPTON COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 1 8443 1450149A 7 20 27
174622 174622 BRIAN DAHLE 20554 GOVERNOR 8762 1450149A 12 23 35
174623 174623 GAVIN NEWSOM 20553 GOVERNOR 8762 1450149A 42 141 183
181106 181106 MALIA M. COHEN 20560 CONTROLLER 8765 1450149A 41 140 181
181107 181107 LANHEE J. CHEN 20559 CONTROLLER 8765 1450149A 10 23 33
186830 186830 OMAR NAVARRO 20547 UNITED STATES REPRESENTATIVE, 43rd District 8759 1450149A 10 23 33
186831 186831 MAXINE WATERS 20548 UNITED STATES REPRESENTATIVE, 43rd District 8759 1450149A 42 137 179
192880 192880 ROB BONTA 20564 ATTORNEY GENERAL 8767 1450149A 43 146 189
192881 192881 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 1450149A 9 16 25
198860 198860 YES 20692 STATE MEASURE 31 8828 1450149A 31 115 146
198861 198861 NO 20693 STATE MEASURE 31 8828 1450149A 21 45 66
205196 205196 YES 21153 COUNTY MEASURE A 8930 1450149A 44 131 175
205197 205197 NO 21154 COUNTY MEASURE A 8930 1450149A 8 16 24
211176 211176 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 1450149A 21 59 80
211177 211177 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 1450149A 26 72 98
216950 216950 YES 21126 COMPTON CITY SPECIAL MUNICIPAL ELECTION - MEASURE AM 8917 1450149A 13 56 69
216951 216951 NO 21127 COMPTON CITY SPECIAL MUNICIPAL ELECTION - MEASURE AM 8917 1450149A 39 78 117
219728 219728 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 1450149A 13 14 27
219729 219729 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 1450149A 40 148 188
225946 225946 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 1450149A 36 103 139
225947 225947 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 1450149A 12 30 42
232302 232302 ALEX VILLANUEVA 20574 SHERIFF 8772 1450149A 22 55 77
232303 232303 ROBERT LUNA 20573 SHERIFF 8772 1450149A 31 105 136
238558 238558 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 1450149A 25 90 115
238559 238559 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 1450149A 15 31 46
244648 244648 YES 21194 COMPTON UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AAA 8931 1450149A 32 105 137
244649 244649 NO 21195 COMPTON UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AAA 8931 1450149A 18 45 63
248283 248283 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 1450149A 22 93 115
248284 248284 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 1450149A 18 24 42
259027 259027 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 1450149A 21 35 56
259028 259028 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 1450149A 23 102 125
265007 265007 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 1450149A 28 98 126
265008 265008 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 1450149A 19 31 50
270987 270987 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 1450149A 24 91 115
270988 270988 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 1450149A 14 27 41
276991 276991 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 1450149A 22 93 115
276992 276992 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 1450149A 17 25 42
284609 284609 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 1450149A 25 74 99
284610 284610 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 1450149A 21 65 86
290627 290627 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 1450149A 33 100 133
290628 290628 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 1450149A 14 30 44
298203 298203 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 1450149A 29 80 109
298204 298204 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 1450149A 13 38 51
303972 303972 YES 21128 COMPTON CITY SPECIAL MUNICIPAL ELECTION - MEASURE ED 8918 1450149A 29 105 134
303973 303973 NO 21129 COMPTON CITY SPECIAL MUNICIPAL ELECTION - MEASURE ED 8918 1450149A 21 39 60
309394 309394 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 1450149A 23 91 114
309395 309395 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 1450149A 17 28 45
318142 318142 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 1450149A 29 95 124
318143 318143 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 1450149A 10 24 34

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