results

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

107 rows where precinct_id = "6200004A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
8994 8994 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6200004A 7 32 39
8995 8995 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6200004A 2 42 44
20430 20430 YES 20683 STATE MEASURE 27 8824 6200004A 3 23 26
20431 20431 NO 20684 STATE MEASURE 27 8824 6200004A 11 77 88
24652 24652 BURTON BRINK 20492 MEMBER OF THE STATE ASSEMBLY, 49th District 8730 6200004A 9 40 49
24653 24653 MIKE FONG 20491 MEMBER OF THE STATE ASSEMBLY, 49th District 8730 6200004A 5 56 61
25128 25128 YES 21290 PASADENA AREA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE PCC 8946 6200004A 10 51 61
25129 25129 NO 21291 PASADENA AREA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE PCC 8946 6200004A 4 42 46
28551 28551 YES 20681 STATE MEASURE 26 8823 6200004A 5 33 38
28552 28552 NO 20682 STATE MEASURE 26 8823 6200004A 10 66 76
32195 32195 SUBHADRA SU VISWANATHAN 21794 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 5 29 34
32196 32196 TONY CHOU 21793 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 5 33 38
32197 32197 GRETCHEN SHEPHERD ROMEY 21790 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 9 47 56
32198 32198 DIANA MILKIE NIXON 21795 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 2 22 24
32199 32199 GRANT FUJIWARA 21791 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 3 25 28
32200 32200 CALVIN LO 21792 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 5 34 39
32201 32201 STEVEN JONES 21789 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 1 17 18
35485 35485 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6200004A 5 49 54
35486 35486 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6200004A 3 19 22
41549 41549 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6200004A 7 40 47
41550 41550 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6200004A 4 42 46
47922 47922 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6200004A 6 52 58
47923 47923 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6200004A 2 17 19
54042 54042 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6200004A 6 51 57
54043 54043 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6200004A 2 17 19
60168 60168 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6200004A 6 49 55
60169 60169 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6200004A 2 19 21
63178 63178 MACKENZIE MARIE BROWN 21187 SAN MARINO UNIFIED SCHOOL DISTRICT SPECIAL ELECTION Governing Board Member (Unexpired term ending December 13, 2024) 8668 6200004A 3 40 43
63179 63179 FRANCESCA GILL 21408 SAN MARINO UNIFIED SCHOOL DISTRICT SPECIAL ELECTION Governing Board Member (Unexpired term ending December 13, 2024) 8668 6200004A 5 27 32
67097 67097 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 6200004A 9 47 56
67098 67098 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 6200004A 6 50 56
73077 73077 FIONA MA 20562 TREASURER 8766 6200004A 6 51 57
73078 73078 JACK M. GUERRERO 20561 TREASURER 8766 6200004A 9 47 56
79057 79057 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 6200004A 8 47 55
79058 79058 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 6200004A 6 44 50
89089 89089 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 6200004A 6 49 55
89090 89090 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 6200004A 9 46 55
95249 95249 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6200004A 8 56 64
95250 95250 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6200004A 2 22 24
106722 106722 YES 20688 STATE MEASURE 29 8826 6200004A 4 20 24
106723 106723 NO 20689 STATE MEASURE 29 8826 6200004A 11 80 91
113943 113943 YES 21263 COUNTY MEASURE C 8943 6200004A 8 63 71
113944 113944 NO 21264 COUNTY MEASURE C 8943 6200004A 6 36 42
119939 119939 YES 20686 STATE MEASURE 28 8825 6200004A 7 55 62
119940 119940 NO 20687 STATE MEASURE 28 8825 6200004A 8 43 51
127297 127297 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6200004A 6 50 56
127298 127298 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6200004A 6 33 39
133367 133367 YES 20690 STATE MEASURE 30 8827 6200004A 4 33 37
133368 133368 NO 20691 STATE MEASURE 30 8827 6200004A 11 68 79
139563 139563 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6200004A 6 48 54
139564 139564 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6200004A 5 28 33
145995 145995 YES 20679 STATE MEASURE 1 8822 6200004A 10 66 76
145996 145996 NO 20680 STATE MEASURE 1 8822 6200004A 4 32 36
152345 152345 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6200004A 6 48 54
152346 152346 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6200004A 9 46 55
158851 158851 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6200004A 5 53 58
158852 158852 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6200004A 2 15 17
167460 167460 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6200004A 5 50 55
167461 167461 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6200004A 3 18 21
177064 177064 BRIAN DAHLE 20554 GOVERNOR 8762 6200004A 10 52 62
177065 177065 GAVIN NEWSOM 20553 GOVERNOR 8762 6200004A 5 49 54
183548 183548 MALIA M. COHEN 20560 CONTROLLER 8765 6200004A 3 30 33
183549 183549 LANHEE J. CHEN 20559 CONTROLLER 8765 6200004A 12 67 79
191566 191566 JUDY CHU 20526 UNITED STATES REPRESENTATIVE, 28th District 8748 6200004A 7 61 68
191567 191567 WES HALLMAN 20525 UNITED STATES REPRESENTATIVE, 28th District 8748 6200004A 7 38 45
195322 195322 ROB BONTA 20564 ATTORNEY GENERAL 8767 6200004A 5 45 50
195323 195323 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 6200004A 10 52 62
201302 201302 YES 20692 STATE MEASURE 31 8828 6200004A 9 66 75
201303 201303 NO 20693 STATE MEASURE 31 8828 6200004A 5 30 35
207638 207638 YES 21153 COUNTY MEASURE A 8930 6200004A 8 67 75
207639 207639 NO 21154 COUNTY MEASURE A 8930 6200004A 6 32 38
213618 213618 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6200004A 3 12 15
213619 213619 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6200004A 7 65 72
222170 222170 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 6200004A 10 50 60
222171 222171 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 6200004A 5 47 52
228388 228388 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 6200004A 6 55 61
228389 228389 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 6200004A 4 17 21
234744 234744 ALEX VILLANUEVA 20574 SHERIFF 8772 6200004A 7 30 37
234745 234745 ROBERT LUNA 20573 SHERIFF 8772 6200004A 5 58 63
241000 241000 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6200004A 6 52 58
241001 241001 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6200004A 2 17 19
250725 250725 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6200004A 5 49 54
250726 250726 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6200004A 3 19 22
261469 261469 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6200004A 5 31 36
261470 261470 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6200004A 5 47 52
267449 267449 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6200004A 5 59 64
267450 267450 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6200004A 3 17 20
273429 273429 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6200004A 6 51 57
273430 273430 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6200004A 2 17 19
279433 279433 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6200004A 4 50 54
279434 279434 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6200004A 4 19 23
287051 287051 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6200004A 4 49 53
287052 287052 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6200004A 6 22 28
293069 293069 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6200004A 6 53 59
293070 293070 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6200004A 2 18 20
296531 296531 JAMES F. BARGER 21019 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200004A 5 35 40
296532 296532 SHELLEY RYAN 21015 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200004A 10 55 65
296533 296533 C. JOSEPH CHANG 21016 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200004A 8 51 59
296534 296534 JOANNA LAM 21184 SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 6200004A 4 35 39
300645 300645 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6200004A 5 53 58

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