results

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

98 rows where precinct_id = "6700025A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
9378 9378 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6700025A 31 58 89
9379 9379 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6700025A 23 63 86
20814 20814 YES 20683 STATE MEASURE 27 8824 6700025A 7 24 31
20815 20815 NO 20684 STATE MEASURE 27 8824 6700025A 60 121 181
28935 28935 YES 20681 STATE MEASURE 26 8823 6700025A 17 44 61
28936 28936 NO 20682 STATE MEASURE 26 8823 6700025A 50 100 150
35869 35869 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6700025A 26 66 92
35870 35870 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6700025A 25 42 67
41933 41933 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6700025A 26 52 78
41934 41934 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6700025A 28 67 95
48306 48306 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6700025A 24 72 96
48307 48307 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6700025A 30 40 70
54426 54426 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6700025A 25 71 96
54427 54427 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6700025A 27 37 64
60552 60552 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6700025A 25 69 94
60553 60553 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6700025A 27 39 66
67481 67481 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 6700025A 46 49 95
67482 67482 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 6700025A 23 91 114
73461 73461 FIONA MA 20562 TREASURER 8766 6700025A 22 89 111
73462 73462 JACK M. GUERRERO 20561 TREASURER 8766 6700025A 46 51 97
79441 79441 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 6700025A 47 47 94
79442 79442 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 6700025A 23 93 116
89473 89473 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 6700025A 23 94 117
89474 89474 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 6700025A 47 49 96
95633 95633 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6700025A 35 75 110
95634 95634 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6700025A 24 48 72
107106 107106 YES 20688 STATE MEASURE 29 8826 6700025A 27 46 73
107107 107107 NO 20689 STATE MEASURE 29 8826 6700025A 40 95 135
114327 114327 YES 21263 COUNTY MEASURE C 8943 6700025A 25 77 102
114328 114328 NO 21264 COUNTY MEASURE C 8943 6700025A 32 52 84
120323 120323 YES 20686 STATE MEASURE 28 8825 6700025A 36 90 126
120324 120324 NO 20687 STATE MEASURE 28 8825 6700025A 32 54 86
127681 127681 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6700025A 26 95 121
127682 127682 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6700025A 35 35 70
133751 133751 YES 20690 STATE MEASURE 30 8827 6700025A 22 61 83
133752 133752 NO 20691 STATE MEASURE 30 8827 6700025A 45 81 126
139947 139947 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6700025A 27 64 91
139948 139948 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6700025A 27 49 76
146379 146379 YES 20679 STATE MEASURE 1 8822 6700025A 22 93 115
146380 146380 NO 20680 STATE MEASURE 1 8822 6700025A 43 48 91
152729 152729 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6700025A 20 92 112
152730 152730 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6700025A 47 48 95
159235 159235 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6700025A 33 85 118
159236 159236 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6700025A 22 24 46
162129 162129 BLANCA PACHECO 20510 MEMBER OF THE STATE ASSEMBLY, 64th District 8740 6700025A 19 93 112
162130 162130 RAUL ORTIZ, JR. 20509 MEMBER OF THE STATE ASSEMBLY, 64th District 8740 6700025A 46 48 94
163226 163226 ERIC J. CHING 20544 UNITED STATES REPRESENTATIVE, 38th District 8757 6700025A 42 45 87
163227 163227 LINDA T. SÁNCHEZ 20543 UNITED STATES REPRESENTATIVE, 38th District 8757 6700025A 25 97 122
167844 167844 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6700025A 24 64 88
167845 167845 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6700025A 28 43 71
177448 177448 BRIAN DAHLE 20554 GOVERNOR 8762 6700025A 46 52 98
177449 177449 GAVIN NEWSOM 20553 GOVERNOR 8762 6700025A 23 92 115
183932 183932 MALIA M. COHEN 20560 CONTROLLER 8765 6700025A 23 86 109
183933 183933 LANHEE J. CHEN 20559 CONTROLLER 8765 6700025A 43 56 99
195706 195706 ROB BONTA 20564 ATTORNEY GENERAL 8767 6700025A 22 89 111
195707 195707 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 6700025A 47 51 98
201686 201686 YES 20692 STATE MEASURE 31 8828 6700025A 40 93 133
201687 201687 NO 20693 STATE MEASURE 31 8828 6700025A 25 48 73
208022 208022 YES 21153 COUNTY MEASURE A 8930 6700025A 28 87 115
208023 208023 NO 21154 COUNTY MEASURE A 8930 6700025A 40 44 84
214002 214002 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6700025A 16 30 46
214003 214003 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6700025A 42 89 131
218928 218928 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 26 53 79
218929 218929 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 36 87 123
218930 218930 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 14 31 45
218931 218931 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 24 62 86
222554 222554 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 6700025A 47 49 96
222555 222555 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 6700025A 22 92 114
228772 228772 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 6700025A 31 83 114
228773 228773 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 6700025A 28 34 62
235128 235128 ALEX VILLANUEVA 20574 SHERIFF 8772 6700025A 43 77 120
235129 235129 ROBERT LUNA 20573 SHERIFF 8772 6700025A 22 66 88
241384 241384 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6700025A 24 70 94
241385 241385 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6700025A 33 41 74
245311 245311 TOM UMBERG 20473 STATE SENATOR, 34th District 8719 6700025A 19 90 109
245312 245312 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700025A 47 49 96
251109 251109 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6700025A 23 77 100
251110 251110 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6700025A 29 30 59
261853 261853 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6700025A 32 43 75
261854 261854 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6700025A 25 78 103
267833 267833 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6700025A 27 73 100
267834 267834 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6700025A 32 39 71
273813 273813 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6700025A 30 59 89
273814 273814 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6700025A 24 48 72
279817 279817 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6700025A 25 64 89
279818 279818 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6700025A 25 43 68
287435 287435 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6700025A 20 46 66
287436 287436 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6700025A 38 74 112
293453 293453 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6700025A 27 75 102
293454 293454 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6700025A 30 38 68
301029 301029 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6700025A 25 67 92
301030 301030 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6700025A 34 46 80
312220 312220 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 6700025A 30 87 117
312221 312221 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 6700025A 26 24 50
315079 315079 OSCAR VALLADARES 20941 RIO HONDO COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 8813 6700025A 39 62 101
315080 315080 VANESSA C. TYSON 21309 RIO HONDO COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 8813 6700025A 20 64 84
320968 320968 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 6700025A 26 63 89
320969 320969 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 6700025A 26 44 70

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