results

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

98 rows where precinct_id = "6700064A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
9390 9390 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6700064A 37 33 70
9391 9391 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6700064A 13 75 88
20826 20826 YES 20683 STATE MEASURE 27 8824 6700064A 14 30 44
20827 20827 NO 20684 STATE MEASURE 27 8824 6700064A 49 108 157
28947 28947 YES 20681 STATE MEASURE 26 8823 6700064A 23 51 74
28948 28948 NO 20682 STATE MEASURE 26 8823 6700064A 40 82 122
35881 35881 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6700064A 30 63 93
35882 35882 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6700064A 18 33 51
41945 41945 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6700064A 33 48 81
41946 41946 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6700064A 19 58 77
48318 48318 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6700064A 25 79 104
48319 48319 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6700064A 24 27 51
54438 54438 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6700064A 26 69 95
54439 54439 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6700064A 21 27 48
60564 60564 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6700064A 31 69 100
60565 60565 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6700064A 17 28 45
67493 67493 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 6700064A 34 39 73
67494 67494 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 6700064A 27 96 123
73473 73473 FIONA MA 20562 TREASURER 8766 6700064A 25 97 122
73474 73474 JACK M. GUERRERO 20561 TREASURER 8766 6700064A 36 42 78
79453 79453 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 6700064A 36 36 72
79454 79454 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 6700064A 25 98 123
89485 89485 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 6700064A 25 104 129
89486 89486 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 6700064A 36 36 72
95645 95645 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6700064A 41 65 106
95646 95646 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6700064A 12 44 56
107118 107118 YES 20688 STATE MEASURE 29 8826 6700064A 27 53 80
107119 107119 NO 20689 STATE MEASURE 29 8826 6700064A 36 86 122
114339 114339 YES 21263 COUNTY MEASURE C 8943 6700064A 27 72 99
114340 114340 NO 21264 COUNTY MEASURE C 8943 6700064A 34 49 83
120335 120335 YES 20686 STATE MEASURE 28 8825 6700064A 37 92 129
120336 120336 NO 20687 STATE MEASURE 28 8825 6700064A 25 44 69
127693 127693 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6700064A 25 92 117
127694 127694 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6700064A 32 35 67
133763 133763 YES 20690 STATE MEASURE 30 8827 6700064A 19 45 64
133764 133764 NO 20691 STATE MEASURE 30 8827 6700064A 43 89 132
139959 139959 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6700064A 33 57 90
139960 139960 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6700064A 20 51 71
146391 146391 YES 20679 STATE MEASURE 1 8822 6700064A 29 97 126
146392 146392 NO 20680 STATE MEASURE 1 8822 6700064A 34 38 72
152741 152741 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6700064A 26 99 125
152742 152742 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6700064A 35 35 70
159247 159247 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6700064A 32 65 97
159248 159248 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6700064A 16 29 45
162141 162141 BLANCA PACHECO 20510 MEMBER OF THE STATE ASSEMBLY, 64th District 8740 6700064A 27 104 131
162142 162142 RAUL ORTIZ, JR. 20509 MEMBER OF THE STATE ASSEMBLY, 64th District 8740 6700064A 34 34 68
163238 163238 ERIC J. CHING 20544 UNITED STATES REPRESENTATIVE, 38th District 8757 6700064A 35 36 71
163239 163239 LINDA T. SÁNCHEZ 20543 UNITED STATES REPRESENTATIVE, 38th District 8757 6700064A 27 104 131
167856 167856 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6700064A 26 72 98
167857 167857 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6700064A 21 26 47
177460 177460 BRIAN DAHLE 20554 GOVERNOR 8762 6700064A 38 39 77
177461 177461 GAVIN NEWSOM 20553 GOVERNOR 8762 6700064A 24 99 123
183944 183944 MALIA M. COHEN 20560 CONTROLLER 8765 6700064A 25 97 122
183945 183945 LANHEE J. CHEN 20559 CONTROLLER 8765 6700064A 36 41 77
195718 195718 ROB BONTA 20564 ATTORNEY GENERAL 8767 6700064A 27 101 128
195719 195719 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 6700064A 34 37 71
201698 201698 YES 20692 STATE MEASURE 31 8828 6700064A 27 81 108
201699 201699 NO 20693 STATE MEASURE 31 8828 6700064A 35 53 88
208034 208034 YES 21153 COUNTY MEASURE A 8930 6700064A 36 99 135
208035 208035 NO 21154 COUNTY MEASURE A 8930 6700064A 27 34 61
214014 214014 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6700064A 11 42 53
214015 214015 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6700064A 41 67 108
218936 218936 DENISE DOLOR 20667 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 19 48 67
218937 218937 JOSEPH VELASCO III 20634 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 30 79 109
218938 218938 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 12 25 37
218939 218939 CHARLES LUAS 20626 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 24 52 76
222566 222566 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 6700064A 34 40 74
222567 222567 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 6700064A 27 94 121
228784 228784 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 6700064A 32 98 130
228785 228785 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 6700064A 21 16 37
235140 235140 ALEX VILLANUEVA 20574 SHERIFF 8772 6700064A 31 58 89
235141 235141 ROBERT LUNA 20573 SHERIFF 8772 6700064A 29 76 105
241396 241396 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6700064A 29 73 102
241397 241397 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6700064A 19 22 41
245323 245323 TOM UMBERG 20473 STATE SENATOR, 34th District 8719 6700064A 22 99 121
245324 245324 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700064A 37 39 76
251121 251121 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6700064A 28 75 103
251122 251122 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6700064A 21 23 44
261865 261865 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6700064A 28 30 58
261866 261866 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6700064A 24 80 104
267845 267845 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6700064A 30 81 111
267846 267846 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6700064A 20 31 51
273825 273825 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6700064A 23 71 94
273826 273826 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6700064A 24 25 49
279829 279829 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6700064A 26 66 92
279830 279830 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6700064A 22 28 50
287447 287447 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6700064A 20 40 60
287448 287448 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6700064A 34 66 100
293465 293465 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6700064A 27 75 102
293466 293466 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6700064A 22 32 54
301041 301041 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6700064A 29 75 104
301042 301042 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6700064A 20 24 44
312232 312232 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 6700064A 35 69 104
312233 312233 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 6700064A 14 28 42
315087 315087 OSCAR VALLADARES 20941 RIO HONDO COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 8813 6700064A 24 72 96
315088 315088 VANESSA C. TYSON 21309 RIO HONDO COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 8813 6700064A 28 45 73
320980 320980 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 6700064A 27 67 94
320981 320981 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 6700064A 21 30 51

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