results

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

97 rows where precinct_id = "6300006A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
9228 9228 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6300006A 19 24 43
9229 9229 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6300006A 14 48 62
20664 20664 YES 20683 STATE MEASURE 27 8824 6300006A 7 23 30
20665 20665 NO 20684 STATE MEASURE 27 8824 6300006A 41 80 121
23982 23982 CHRISTY SMITH 20523 UNITED STATES REPRESENTATIVE, 27th District 8747 6300006A 11 48 59
23983 23983 MIKE GARCIA 20524 UNITED STATES REPRESENTATIVE, 27th District 8747 6300006A 37 57 94
28785 28785 YES 20681 STATE MEASURE 26 8823 6300006A 15 44 59
28786 28786 NO 20682 STATE MEASURE 26 8823 6300006A 33 60 93
35719 35719 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6300006A 14 50 64
35720 35720 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6300006A 15 21 36
41783 41783 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6300006A 21 36 57
41784 41784 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6300006A 10 37 47
48156 48156 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6300006A 16 53 69
48157 48157 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6300006A 17 23 40
54276 54276 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6300006A 17 49 66
54277 54277 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6300006A 16 22 38
60402 60402 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6300006A 16 46 62
60403 60403 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6300006A 15 25 40
67331 67331 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 6300006A 35 50 85
67332 67332 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 6300006A 13 54 67
73311 73311 FIONA MA 20562 TREASURER 8766 6300006A 12 48 60
73312 73312 JACK M. GUERRERO 20561 TREASURER 8766 6300006A 36 55 91
79291 79291 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 6300006A 34 49 83
79292 79292 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 6300006A 14 54 68
89323 89323 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 6300006A 12 60 72
89324 89324 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 6300006A 35 47 82
95483 95483 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6300006A 16 34 50
95484 95484 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6300006A 14 40 54
106956 106956 YES 20688 STATE MEASURE 29 8826 6300006A 10 35 45
106957 106957 NO 20689 STATE MEASURE 29 8826 6300006A 38 68 106
114177 114177 YES 21263 COUNTY MEASURE C 8943 6300006A 17 44 61
114178 114178 NO 21264 COUNTY MEASURE C 8943 6300006A 26 47 73
120173 120173 YES 20686 STATE MEASURE 28 8825 6300006A 25 64 89
120174 120174 NO 20687 STATE MEASURE 28 8825 6300006A 23 41 64
127531 127531 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6300006A 13 58 71
127532 127532 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6300006A 27 44 71
133601 133601 YES 20690 STATE MEASURE 30 8827 6300006A 6 37 43
133602 133602 NO 20691 STATE MEASURE 30 8827 6300006A 42 65 107
139797 139797 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6300006A 18 32 50
139798 139798 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6300006A 12 45 57
146229 146229 YES 20679 STATE MEASURE 1 8822 6300006A 16 62 78
146230 146230 NO 20680 STATE MEASURE 1 8822 6300006A 30 42 72
152579 152579 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6300006A 13 60 73
152580 152580 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6300006A 35 47 82
159085 159085 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6300006A 20 50 70
159086 159086 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6300006A 9 19 28
167694 167694 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6300006A 17 47 64
167695 167695 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6300006A 15 24 39
177298 177298 BRIAN DAHLE 20554 GOVERNOR 8762 6300006A 36 55 91
177299 177299 GAVIN NEWSOM 20553 GOVERNOR 8762 6300006A 12 52 64
183782 183782 MALIA M. COHEN 20560 CONTROLLER 8765 6300006A 12 53 65
183783 183783 LANHEE J. CHEN 20559 CONTROLLER 8765 6300006A 36 51 87
195556 195556 ROB BONTA 20564 ATTORNEY GENERAL 8767 6300006A 12 54 66
195557 195557 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 6300006A 36 51 87
201536 201536 YES 20692 STATE MEASURE 31 8828 6300006A 27 50 77
201537 201537 NO 20693 STATE MEASURE 31 8828 6300006A 21 54 75
207872 207872 YES 21153 COUNTY MEASURE A 8930 6300006A 18 60 78
207873 207873 NO 21154 COUNTY MEASURE A 8930 6300006A 28 40 68
213852 213852 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6300006A 9 37 46
213853 213853 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6300006A 21 41 62
222404 222404 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 6300006A 36 50 86
222405 222405 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 6300006A 12 56 68
228622 228622 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 6300006A 16 51 67
228623 228623 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 6300006A 21 26 47
234978 234978 ALEX VILLANUEVA 20574 SHERIFF 8772 6300006A 32 60 92
234979 234979 ROBERT LUNA 20573 SHERIFF 8772 6300006A 11 36 47
241234 241234 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6300006A 13 47 60
241235 241235 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6300006A 19 24 43
245184 245184 JOE MESSINA 20783 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 8496 6300006A 25 52 77
245185 245185 REBECCA HINDMAN 20727 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 8496 6300006A 17 41 58
246861 246861 SUZETTE MARTINEZ VALLADARES 20481 MEMBER OF THE STATE ASSEMBLY, 40th District 8723 6300006A 37 55 92
246862 246862 PILAR SCHIAVO 20480 MEMBER OF THE STATE ASSEMBLY, 40th District 8723 6300006A 10 47 57
250959 250959 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6300006A 16 48 64
250960 250960 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6300006A 13 23 36
261703 261703 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6300006A 28 33 61
261704 261704 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6300006A 14 45 59
267683 267683 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6300006A 17 51 68
267684 267684 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6300006A 18 25 43
273663 273663 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6300006A 16 47 63
273664 273664 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6300006A 13 22 35
279667 279667 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6300006A 13 48 61
279668 279668 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6300006A 16 21 37
283412 283412 SAGE G. RAFFERTY 20818 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 2 8783 6300006A 9 34 43
283413 283413 KATHY COLLEY 21113 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 2 8783 6300006A 4 13 17
283414 283414 DIRK MARKS 21055 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 2 8783 6300006A 31 43 74
287285 287285 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6300006A 12 40 52
287286 287286 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6300006A 18 27 45
293303 293303 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6300006A 16 54 70
293304 293304 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6300006A 18 22 40
300879 300879 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6300006A 14 49 63
300880 300880 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6300006A 20 22 42
312070 312070 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 6300006A 19 49 68
312071 312071 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 6300006A 12 22 34
320818 320818 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 6300006A 16 50 66
320819 320819 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 6300006A 14 21 35
324553 324553 SHARLENE ROSE DUZICK 21035 SAUGUS UNION SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 8489 6300006A 23 42 65
324554 324554 CHRISTOPHER TRUNKEY 20794 SAUGUS UNION SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 8489 6300006A 19 48 67

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