results

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

94 rows where precinct_id = "4400031A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
8192 8192 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 4400031A 32 60 92
8193 8193 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 4400031A 20 105 125
19628 19628 YES 20683 STATE MEASURE 27 8824 4400031A 9 24 33
19629 19629 NO 20684 STATE MEASURE 27 8824 4400031A 56 194 250
27749 27749 YES 20681 STATE MEASURE 26 8823 4400031A 8 45 53
27750 27750 NO 20682 STATE MEASURE 26 8823 4400031A 55 171 226
34683 34683 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 4400031A 28 98 126
34684 34684 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 4400031A 25 51 76
40747 40747 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 4400031A 34 79 113
40748 40748 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 4400031A 18 88 106
47120 47120 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 4400031A 30 110 140
47121 47121 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 4400031A 22 51 73
53240 53240 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 4400031A 32 105 137
53241 53241 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 4400031A 21 51 72
59366 59366 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 4400031A 28 107 135
59367 59367 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 4400031A 25 46 71
66295 66295 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 4400031A 40 87 127
66296 66296 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 4400031A 27 122 149
72275 72275 FIONA MA 20562 TREASURER 8766 4400031A 26 123 149
72276 72276 JACK M. GUERRERO 20561 TREASURER 8766 4400031A 40 87 127
78255 78255 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 4400031A 39 83 122
78256 78256 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 4400031A 27 124 151
88287 88287 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 4400031A 27 134 161
88288 88288 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 4400031A 39 81 120
94447 94447 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 4400031A 25 82 107
94448 94448 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 4400031A 19 78 97
105920 105920 YES 20688 STATE MEASURE 29 8826 4400031A 15 55 70
105921 105921 NO 20689 STATE MEASURE 29 8826 4400031A 47 156 203
113141 113141 YES 21263 COUNTY MEASURE C 8943 4400031A 33 114 147
113142 113142 NO 21264 COUNTY MEASURE C 8943 4400031A 29 87 116
119137 119137 YES 20686 STATE MEASURE 28 8825 4400031A 29 134 163
119138 119138 NO 20687 STATE MEASURE 28 8825 4400031A 35 83 118
126495 126495 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 4400031A 27 112 139
126496 126496 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 4400031A 31 70 101
132565 132565 YES 20690 STATE MEASURE 30 8827 4400031A 11 90 101
132566 132566 NO 20691 STATE MEASURE 30 8827 4400031A 55 128 183
138761 138761 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 4400031A 29 99 128
138762 138762 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 4400031A 16 59 75
142623 142623 MICHAEL MCMAHON 20771 MEMBER OF THE STATE ASSEMBLY, 41st District 8724 4400031A 40 83 123
142624 142624 CHRIS HOLDEN 20482 MEMBER OF THE STATE ASSEMBLY, 41st District 8724 4400031A 26 126 152
145193 145193 YES 20679 STATE MEASURE 1 8822 4400031A 32 152 184
145194 145194 NO 20680 STATE MEASURE 1 8822 4400031A 35 67 102
151543 151543 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 4400031A 26 133 159
151544 151544 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 4400031A 38 79 117
158049 158049 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 4400031A 39 122 161
158050 158050 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 4400031A 14 29 43
166658 166658 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 4400031A 30 98 128
166659 166659 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 4400031A 23 52 75
176262 176262 BRIAN DAHLE 20554 GOVERNOR 8762 4400031A 42 85 127
176263 176263 GAVIN NEWSOM 20553 GOVERNOR 8762 4400031A 25 131 156
182746 182746 MALIA M. COHEN 20560 CONTROLLER 8765 4400031A 23 108 131
182747 182747 LANHEE J. CHEN 20559 CONTROLLER 8765 4400031A 43 100 143
191374 191374 JUDY CHU 20526 UNITED STATES REPRESENTATIVE, 28th District 8748 4400031A 26 136 162
191375 191375 WES HALLMAN 20525 UNITED STATES REPRESENTATIVE, 28th District 8748 4400031A 40 78 118
194520 194520 ROB BONTA 20564 ATTORNEY GENERAL 8767 4400031A 27 124 151
194521 194521 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 4400031A 39 89 128
200500 200500 YES 20692 STATE MEASURE 31 8828 4400031A 34 149 183
200501 200501 NO 20693 STATE MEASURE 31 8828 4400031A 31 65 96
206836 206836 YES 21153 COUNTY MEASURE A 8930 4400031A 31 134 165
206837 206837 NO 21154 COUNTY MEASURE A 8930 4400031A 33 70 103
212816 212816 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 4400031A 11 42 53
212817 212817 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 4400031A 34 116 150
221368 221368 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 4400031A 40 86 126
221369 221369 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 4400031A 26 124 150
227586 227586 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 4400031A 29 108 137
227587 227587 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 4400031A 25 56 81
233942 233942 ALEX VILLANUEVA 20574 SHERIFF 8772 4400031A 35 80 115
233943 233943 ROBERT LUNA 20573 SHERIFF 8772 4400031A 27 123 150
240198 240198 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 4400031A 30 106 136
240199 240199 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 4400031A 23 47 70
247434 247434 YES 21326 MONROVIA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE MM 8951 4400031A 33 115 148
247435 247435 NO 21327 MONROVIA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE MM 8951 4400031A 32 91 123
249923 249923 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 4400031A 27 96 123
249924 249924 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 4400031A 26 52 78
260667 260667 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 4400031A 29 64 93
260668 260668 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 4400031A 27 112 139
266647 266647 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 4400031A 30 108 138
266648 266648 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 4400031A 22 54 76
272627 272627 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 4400031A 31 109 140
272628 272628 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 4400031A 22 39 61
278631 278631 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 4400031A 31 102 133
278632 278632 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 4400031A 22 45 67
286249 286249 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 4400031A 24 101 125
286250 286250 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 4400031A 28 53 81
292267 292267 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 4400031A 30 108 138
292268 292268 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 4400031A 22 54 76
297309 297309 SERGE HADDAD 20599 UPPER SAN GABRIEL VALLEY MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8418 4400031A 12 72 84
297310 297310 TONY FELLOW 20635 UPPER SAN GABRIEL VALLEY MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8418 4400031A 43 105 148
299843 299843 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 4400031A 32 109 141
299844 299844 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 4400031A 20 46 66
311034 311034 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 4400031A 31 119 150
311035 311035 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 4400031A 22 33 55
319782 319782 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 4400031A 29 109 138
319783 319783 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 4400031A 24 44 68

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