results

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

96 rows where precinct_id = "7050078A"

✎ 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
9448 9448 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 7050078A 8 29 37
9449 9449 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 7050078A 7 29 36
20884 20884 YES 20683 STATE MEASURE 27 8824 7050078A 5 23 28
20885 20885 NO 20684 STATE MEASURE 27 8824 7050078A 12 57 69
24718 24718 BURTON BRINK 20492 MEMBER OF THE STATE ASSEMBLY, 49th District 8730 7050078A 8 28 36
24719 24719 MIKE FONG 20491 MEMBER OF THE STATE ASSEMBLY, 49th District 8730 7050078A 9 52 61
25186 25186 YES 21290 PASADENA AREA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE PCC 8946 7050078A 11 52 63
25187 25187 NO 21291 PASADENA AREA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE PCC 8946 7050078A 7 20 27
29005 29005 YES 20681 STATE MEASURE 26 8823 7050078A 4 44 48
29006 29006 NO 20682 STATE MEASURE 26 8823 7050078A 13 36 49
35939 35939 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 7050078A 6 38 44
35940 35940 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 7050078A 5 15 20
42003 42003 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 7050078A 11 45 56
42004 42004 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 7050078A 4 21 25
48376 48376 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 7050078A 8 36 44
48377 48377 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 7050078A 5 22 27
54496 54496 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 7050078A 4 38 42
54497 54497 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 7050078A 6 20 26
60622 60622 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 7050078A 4 41 45
60623 60623 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 7050078A 6 12 18
67551 67551 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 7050078A 10 31 41
67552 67552 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 7050078A 7 47 54
73531 73531 FIONA MA 20562 TREASURER 8766 7050078A 8 49 57
73532 73532 JACK M. GUERRERO 20561 TREASURER 8766 7050078A 9 31 40
79511 79511 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 7050078A 9 32 41
79512 79512 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 7050078A 8 43 51
89543 89543 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 7050078A 9 53 62
89544 89544 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 7050078A 9 27 36
95703 95703 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 7050078A 11 45 56
95704 95704 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 7050078A 4 18 22
103514 103514 NANCY ARMENTA 20649 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 7050078A 7 36 43
103515 103515 DIANE BENITEZ 20650 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 7050078A 5 25 30
103516 103516 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 7050078A 3 12 15
103517 103517 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 7050078A 7 43 50
107176 107176 YES 20688 STATE MEASURE 29 8826 7050078A 5 31 36
107177 107177 NO 20689 STATE MEASURE 29 8826 7050078A 13 47 60
114397 114397 YES 21263 COUNTY MEASURE C 8943 7050078A 6 59 65
114398 114398 NO 21264 COUNTY MEASURE C 8943 7050078A 11 19 30
120393 120393 YES 20686 STATE MEASURE 28 8825 7050078A 11 42 53
120394 120394 NO 20687 STATE MEASURE 28 8825 7050078A 7 38 45
127751 127751 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 7050078A 12 45 57
127752 127752 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 7050078A 4 24 28
133821 133821 YES 20690 STATE MEASURE 30 8827 7050078A 4 34 38
133822 133822 NO 20691 STATE MEASURE 30 8827 7050078A 14 45 59
140017 140017 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 7050078A 11 37 48
140018 140018 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 7050078A 3 22 25
146449 146449 YES 20679 STATE MEASURE 1 8822 7050078A 10 51 61
146450 146450 NO 20680 STATE MEASURE 1 8822 7050078A 6 28 34
152799 152799 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 7050078A 9 53 62
152800 152800 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 7050078A 8 27 35
159305 159305 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 7050078A 7 47 54
159306 159306 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 7050078A 3 7 10
167914 167914 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 7050078A 4 38 42
167915 167915 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 7050078A 6 16 22
177518 177518 BRIAN DAHLE 20554 GOVERNOR 8762 7050078A 9 25 34
177519 177519 GAVIN NEWSOM 20553 GOVERNOR 8762 7050078A 9 54 63
184002 184002 MALIA M. COHEN 20560 CONTROLLER 8765 7050078A 8 44 52
184003 184003 LANHEE J. CHEN 20559 CONTROLLER 8765 7050078A 9 33 42
191636 191636 JUDY CHU 20526 UNITED STATES REPRESENTATIVE, 28th District 8748 7050078A 10 53 63
191637 191637 WES HALLMAN 20525 UNITED STATES REPRESENTATIVE, 28th District 8748 7050078A 8 28 36
195776 195776 ROB BONTA 20564 ATTORNEY GENERAL 8767 7050078A 8 47 55
195777 195777 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 7050078A 9 30 39
201756 201756 YES 20692 STATE MEASURE 31 8828 7050078A 9 47 56
201757 201757 NO 20693 STATE MEASURE 31 8828 7050078A 8 30 38
208092 208092 YES 21153 COUNTY MEASURE A 8930 7050078A 7 52 59
208093 208093 NO 21154 COUNTY MEASURE A 8930 7050078A 10 25 35
214072 214072 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 7050078A 3 24 27
214073 214073 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 7050078A 12 38 50
222624 222624 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 7050078A 8 27 35
222625 222625 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 7050078A 9 52 61
228842 228842 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 7050078A 7 44 51
228843 228843 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 7050078A 7 15 22
235198 235198 ALEX VILLANUEVA 20574 SHERIFF 8772 7050078A 10 38 48
235199 235199 ROBERT LUNA 20573 SHERIFF 8772 7050078A 7 39 46
241454 241454 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 7050078A 4 42 46
241455 241455 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 7050078A 7 12 19
251179 251179 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 7050078A 5 34 39
251180 251180 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 7050078A 4 19 23
261923 261923 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 7050078A 8 13 21
261924 261924 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 7050078A 5 50 55
267903 267903 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 7050078A 7 45 52
267904 267904 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 7050078A 6 19 25
273883 273883 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 7050078A 5 37 42
273884 273884 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 7050078A 4 15 19
279887 279887 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 7050078A 6 35 41
279888 279888 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 7050078A 5 18 23
287505 287505 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 7050078A 9 30 39
287506 287506 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 7050078A 6 28 34
293523 293523 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 7050078A 6 43 49
293524 293524 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 7050078A 7 15 22
301099 301099 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 7050078A 4 46 50
301100 301100 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 7050078A 7 14 21
312290 312290 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 7050078A 4 39 43
312291 312291 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 7050078A 6 15 21
321038 321038 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 7050078A 4 39 43
321039 321039 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 7050078A 7 15 22

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