results

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

92 rows where precinct_id = "0520007A"

✎ 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
6008 6008 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 0520007A 4 29 33
6009 6009 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 0520007A 4 24 28
17444 17444 YES 20683 STATE MEASURE 27 8824 0520007A 3 17 20
17445 17445 NO 20684 STATE MEASURE 27 8824 0520007A 6 40 46
25565 25565 YES 20681 STATE MEASURE 26 8823 0520007A 4 29 33
25566 25566 NO 20682 STATE MEASURE 26 8823 0520007A 5 28 33
32499 32499 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 0520007A 3 38 41
32500 32500 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 0520007A 3 14 17
38563 38563 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 0520007A 5 24 29
38564 38564 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 0520007A 3 30 33
44936 44936 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 0520007A 4 34 38
44937 44937 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 0520007A 3 17 20
51056 51056 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 0520007A 4 38 42
51057 51057 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 0520007A 3 14 17
57182 57182 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 0520007A 3 35 38
57183 57183 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 0520007A 3 15 18
64111 64111 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 0520007A 5 23 28
64112 64112 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 0520007A 4 33 37
70091 70091 FIONA MA 20562 TREASURER 8766 0520007A 5 32 37
70092 70092 JACK M. GUERRERO 20561 TREASURER 8766 0520007A 4 26 30
76071 76071 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 0520007A 4 16 20
76072 76072 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0520007A 4 40 44
86103 86103 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 0520007A 4 40 44
86104 86104 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 0520007A 5 18 23
92263 92263 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 0520007A 4 44 48
92264 92264 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 0520007A 2 11 13
103736 103736 YES 20688 STATE MEASURE 29 8826 0520007A 4 27 31
103737 103737 NO 20689 STATE MEASURE 29 8826 0520007A 5 30 35
110957 110957 YES 21263 COUNTY MEASURE C 8943 0520007A 2 33 35
110958 110958 NO 21264 COUNTY MEASURE C 8943 0520007A 6 24 30
116953 116953 YES 20686 STATE MEASURE 28 8825 0520007A 4 49 53
116954 116954 NO 20687 STATE MEASURE 28 8825 0520007A 5 9 14
123305 123305 BOB ARCHULETA 20471 STATE SENATOR, 30th District 8718 0520007A 4 39 43
123306 123306 MITCH CLEMMONS 20470 STATE SENATOR, 30th District 8718 0520007A 5 19 24
124311 124311 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 0520007A 4 33 37
124312 124312 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 0520007A 5 22 27
130381 130381 YES 20690 STATE MEASURE 30 8827 0520007A 2 32 34
130382 130382 NO 20691 STATE MEASURE 30 8827 0520007A 7 26 33
136577 136577 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 0520007A 3 32 35
136578 136578 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 0520007A 3 20 23
143009 143009 YES 20679 STATE MEASURE 1 8822 0520007A 5 48 53
143010 143010 NO 20680 STATE MEASURE 1 8822 0520007A 3 10 13
149359 149359 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 0520007A 4 37 41
149360 149360 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 0520007A 5 20 25
155865 155865 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 0520007A 5 38 43
155866 155866 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 0520007A 1 12 13
162862 162862 ERIC J. CHING 20544 UNITED STATES REPRESENTATIVE, 38th District 8757 0520007A 5 16 21
162863 162863 LINDA T. SÁNCHEZ 20543 UNITED STATES REPRESENTATIVE, 38th District 8757 0520007A 4 42 46
164474 164474 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 0520007A 4 40 44
164475 164475 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 0520007A 3 10 13
174078 174078 BRIAN DAHLE 20554 GOVERNOR 8762 0520007A 5 25 30
174079 174079 GAVIN NEWSOM 20553 GOVERNOR 8762 0520007A 4 33 37
180562 180562 MALIA M. COHEN 20560 CONTROLLER 8765 0520007A 4 38 42
180563 180563 LANHEE J. CHEN 20559 CONTROLLER 8765 0520007A 5 20 25
191784 191784 LISA CALDERON 20502 MEMBER OF THE STATE ASSEMBLY, 56th District 8736 0520007A 4 36 40
191785 191785 JESSICA MARTINEZ 20503 MEMBER OF THE STATE ASSEMBLY, 56th District 8736 0520007A 5 21 26
192336 192336 ROB BONTA 20564 ATTORNEY GENERAL 8767 0520007A 4 36 40
192337 192337 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 0520007A 5 22 27
198316 198316 YES 20692 STATE MEASURE 31 8828 0520007A 4 27 31
198317 198317 NO 20693 STATE MEASURE 31 8828 0520007A 5 31 36
204652 204652 YES 21153 COUNTY MEASURE A 8930 0520007A 5 40 45
204653 204653 NO 21154 COUNTY MEASURE A 8930 0520007A 4 17 21
210632 210632 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 0520007A 6 25 31
210633 210633 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 0520007A 2 29 31
219184 219184 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 0520007A 4 22 26
219185 219185 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 0520007A 5 36 41
225402 225402 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0520007A 3 45 48
225403 225403 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0520007A 4 8 12
231758 231758 ALEX VILLANUEVA 20574 SHERIFF 8772 0520007A 4 22 26
231759 231759 ROBERT LUNA 20573 SHERIFF 8772 0520007A 5 33 38
238014 238014 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 0520007A 3 36 39
238015 238015 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 0520007A 4 13 17
247739 247739 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 0520007A 3 42 45
247740 247740 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 0520007A 3 10 13
258483 258483 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 0520007A 5 23 28
258484 258484 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 0520007A 3 30 33
264463 264463 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0520007A 4 36 40
264464 264464 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0520007A 3 17 20
270443 270443 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 0520007A 3 38 41
270444 270444 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 0520007A 3 13 16
276447 276447 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 0520007A 3 30 33
276448 276448 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 0520007A 3 21 24
284065 284065 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 0520007A 4 17 21
284066 284066 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 0520007A 4 37 41
290083 290083 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 0520007A 4 36 40
290084 290084 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 0520007A 3 16 19
297659 297659 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 0520007A 4 34 38
297660 297660 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 0520007A 3 18 21
308850 308850 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 0520007A 5 35 40
308851 308851 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 0520007A 2 15 17
317598 317598 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 0520007A 2 36 38
317599 317599 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 0520007A 4 13 17

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