results

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

118 rows where precinct_id = "9001997B"

✎ 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
2592 2592 YES 20929 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ULA 8892 9001997B 13 26 39
2593 2593 NO 20930 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ULA 8892 9001997B 11 23 34
4902 4902 YES 20948 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE SP 8894 9001997B 11 15 26
4903 4903 NO 20949 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE SP 8894 9001997B 13 34 47
10886 10886 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 9001997B 11 19 30
10887 10887 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 9001997B 11 27 38
12955 12955 KAREN RUTH BASS 21848 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION Mayor 8847 9001997B 12 26 38
12956 12956 RICK J. CARUSO 21847 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION Mayor 8847 9001997B 15 28 43
15897 15897 KENNETH MEJIA 21852 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION Controller 8849 9001997B 16 37 53
15898 15898 PAUL KORETZ 21851 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION Controller 8849 9001997B 10 13 23
22322 22322 YES 20683 STATE MEASURE 27 8824 9001997B 6 13 19
22323 22323 NO 20684 STATE MEASURE 27 8824 9001997B 19 38 57
30443 30443 YES 20681 STATE MEASURE 26 8823 9001997B 13 22 35
30444 30444 NO 20682 STATE MEASURE 26 8823 9001997B 13 27 40
37377 37377 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 9001997B 14 37 51
37378 37378 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 9001997B 3 8 11
43441 43441 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 9001997B 11 31 42
43442 43442 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 9001997B 12 18 30
49814 49814 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 9001997B 12 33 45
49815 49815 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 9001997B 7 11 18
55934 55934 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 9001997B 18 38 56
55935 55935 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 9001997B 1 5 6
62060 62060 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 9001997B 14 33 47
62061 62061 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 9001997B 4 11 15
68989 68989 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 9001997B 11 12 23
68990 68990 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 9001997B 15 40 55
74969 74969 FIONA MA 20562 TREASURER 8766 9001997B 16 41 57
74970 74970 JACK M. GUERRERO 20561 TREASURER 8766 9001997B 10 12 22
80949 80949 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 9001997B 7 10 17
80950 80950 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 9001997B 17 41 58
84043 84043 GABRIEL BUELNA 20672 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 6 8517 9001997B 14 37 51
84044 84044 ROBERT L. PAYNE 20756 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 6 8517 9001997B 7 10 17
90981 90981 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 9001997B 19 45 64
90982 90982 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 9001997B 9 10 19
97141 97141 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 9001997B 12 33 45
97142 97142 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 9001997B 10 16 26
100836 100836 KELSEY IINO 20637 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION Member of the Board of Trustees, Seat 7 (Unexpired term ending December 13, 2024) 8528 9001997B 9 24 33
100837 100837 MARK DUTTON 21252 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION Member of the Board of Trustees, Seat 7 (Unexpired term ending December 13, 2024) 8528 9001997B 5 3 8
100838 100838 NANCY PEARLMAN 21112 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION Member of the Board of Trustees, Seat 7 (Unexpired term ending December 13, 2024) 8528 9001997B 6 20 26
108614 108614 YES 20688 STATE MEASURE 29 8826 9001997B 11 21 32
108615 108615 NO 20689 STATE MEASURE 29 8826 9001997B 14 29 43
110474 110474 CHERYL C. TURNER 20469 STATE SENATOR, 28th District 8717 9001997B 13 19 32
110475 110475 LOLA SMALLWOOD-CUEVAS 20468 STATE SENATOR, 28th District 8717 9001997B 13 30 43
115835 115835 YES 21263 COUNTY MEASURE C 8943 9001997B 16 28 44
115836 115836 NO 21264 COUNTY MEASURE C 8943 9001997B 8 22 30
121831 121831 YES 20686 STATE MEASURE 28 8825 9001997B 20 43 63
121832 121832 NO 20687 STATE MEASURE 28 8825 9001997B 8 9 17
129189 129189 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 9001997B 14 43 57
129190 129190 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 9001997B 9 9 18
135259 135259 YES 20690 STATE MEASURE 30 8827 9001997B 10 27 37
135260 135260 NO 20691 STATE MEASURE 30 8827 9001997B 15 24 39
141455 141455 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 9001997B 13 28 41
141456 141456 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 9001997B 10 20 30
147887 147887 YES 20679 STATE MEASURE 1 8822 9001997B 22 40 62
147888 147888 NO 20680 STATE MEASURE 1 8822 9001997B 5 11 16
154237 154237 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 9001997B 20 43 63
154238 154238 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 9001997B 5 12 17
160743 160743 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 9001997B 15 35 50
160744 160744 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 9001997B 3 7 10
169352 169352 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 9001997B 14 38 52
169353 169353 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 9001997B 4 6 10
172174 172174 YES 20946 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LH 8893 9001997B 20 37 57
172175 172175 NO 20947 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LH 8893 9001997B 8 14 22
178956 178956 BRIAN DAHLE 20554 GOVERNOR 8762 9001997B 7 11 18
178957 178957 GAVIN NEWSOM 20553 GOVERNOR 8762 9001997B 20 39 59
185440 185440 MALIA M. COHEN 20560 CONTROLLER 8765 9001997B 16 41 57
185441 185441 LANHEE J. CHEN 20559 CONTROLLER 8765 9001997B 10 11 21
189658 189658 YES 21200 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE LA 8934 9001997B 18 33 51
189659 189659 NO 21201 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE LA 8934 9001997B 8 15 23
197214 197214 ROB BONTA 20564 ATTORNEY GENERAL 8767 9001997B 17 41 58
197215 197215 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 9001997B 9 12 21
203194 203194 YES 20692 STATE MEASURE 31 8828 9001997B 14 30 44
203195 203195 NO 20693 STATE MEASURE 31 8828 9001997B 11 22 33
209530 209530 YES 21153 COUNTY MEASURE A 8930 9001997B 22 43 65
209531 209531 NO 21154 COUNTY MEASURE A 8930 9001997B 4 8 12
215510 215510 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 9001997B 10 23 33
215511 215511 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 9001997B 11 27 38
218032 218032 HYDEE FELDSTEIN SOTO 21849 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION City Attorney 8848 9001997B 13 27 40
218033 218033 FAISAL M. GILL 21850 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION City Attorney 8848 9001997B 10 22 32
224062 224062 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 9001997B 5 10 15
224063 224063 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 9001997B 19 41 60
230280 230280 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 9001997B 17 41 58
230281 230281 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 9001997B 3 4 7
236636 236636 ALEX VILLANUEVA 20574 SHERIFF 8772 9001997B 13 27 40
236637 236637 ROBERT LUNA 20573 SHERIFF 8772 9001997B 15 26 41
242892 242892 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 9001997B 15 35 50
242893 242893 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 9001997B 3 9 12
244757 244757 REGGIE JONES-SAWYER 20504 MEMBER OF THE STATE ASSEMBLY, 57th District 8737 9001997B 21 44 65
252617 252617 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 9001997B 12 35 47
252618 252618 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 9001997B 5 10 15
256603 256603 ERNEST H. MORENO 21011 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 4 8516 9001997B 4 12 16
256604 256604 SARA HERNANDEZ 20788 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 4 8516 9001997B 13 29 42
256605 256605 CHRISTINE T. LAMONICA 20699 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 4 8516 9001997B 5 7 12
263361 263361 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 9001997B 7 18 25
263362 263362 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 9001997B 14 32 46
269341 269341 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 9001997B 14 36 50
269342 269342 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 9001997B 6 8 14
275321 275321 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 9001997B 14 37 51
275322 275322 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 9001997B 3 7 10
281325 281325 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 9001997B 16 35 51

Next page

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