results

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

70 rows where precinct_id = "5150072A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
15553 15553 SASHA RENÉE PÉREZ 23394 STATE SENATOR, 25th District 9502 5150072A 45 149 194
15554 15554 ELIZABETH WONG AHLERS 23393 STATE SENATOR, 25th District 9502 5150072A 43 59 102
26559 26559 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 5150072A 52 61 113
26560 26560 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 5150072A 0 0 0
26561 26561 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 5150072A 42 155 197
26562 26562 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 5150072A 1 3 4
26563 26563 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 5150072A 1 0 1
26564 26564 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 5150072A 2 3 5
43647 43647 YES 24174 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PF 9936 5150072A 62 146 208
43648 43648 NO 24175 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PF 9936 5150072A 17 36 53
53403 53403 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 5150072A 52 68 120
53404 53404 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 5150072A 42 147 189
61429 61429 YES 23601 STATE MEASURE 36 9874 5150072A 65 142 207
61430 61430 NO 23602 STATE MEASURE 36 9874 5150072A 23 68 91
66377 66377 YES 24179 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PL 9938 5150072A 51 133 184
66378 66378 NO 24180 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PL 9938 5150072A 34 72 106
70138 70138 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 5150072A 43 66 109
70139 70139 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 5150072A 26 98 124
78446 78446 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 5150072A 47 118 165
78447 78447 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 5150072A 32 77 109
90000 90000 YES 23584 STATE MEASURE 3 9867 5150072A 47 151 198
90001 90001 NO 23585 STATE MEASURE 3 9867 5150072A 39 59 98
100574 100574 YES 23593 STATE MEASURE 33 9871 5150072A 33 104 137
100575 100575 NO 23594 STATE MEASURE 33 9871 5150072A 55 105 160
109060 109060 YES 23599 STATE MEASURE 35 9873 5150072A 53 144 197
109061 109061 NO 23600 STATE MEASURE 35 9873 5150072A 30 60 90
114032 114032 YES 24190 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PB 9940 5150072A 53 159 212
114033 114033 NO 24191 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PB 9940 5150072A 24 29 53
117696 117696 YES 23766 COUNTY MEASURE A 9880 5150072A 40 109 149
117697 117697 NO 23767 COUNTY MEASURE A 9880 5150072A 49 92 141
125776 125776 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 5150072A 35 71 106
125777 125777 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 5150072A 32 89 121
134188 134188 YES 23597 STATE MEASURE 34 9872 5150072A 43 98 141
134189 134189 NO 23598 STATE MEASURE 34 9872 5150072A 38 97 135
139172 139172 YES 24192 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PC 9941 5150072A 54 154 208
139173 139173 NO 24193 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PC 9941 5150072A 24 38 62
139304 139304 YES 23523 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE R 9862 5150072A 42 131 173
139305 139305 NO 23524 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE R 9862 5150072A 40 70 110
139794 139794 JUDY CHU 23454 UNITED STATES REPRESENTATIVE, 28th District 9533 5150072A 48 153 201
139795 139795 APRIL A. VERLATO 23455 UNITED STATES REPRESENTATIVE, 28th District 9533 5150072A 43 58 101
144410 144410 YES 23591 STATE MEASURE 32 9870 5150072A 45 123 168
144411 144411 NO 23592 STATE MEASURE 32 9870 5150072A 43 88 131
153312 153312 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 5150072A 41 109 150
153313 153313 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 5150072A 35 64 99
167772 167772 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 5150072A 51 66 117
167773 167773 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 5150072A 42 149 191
175872 175872 YES 23712 STATE MEASURE 2 9878 5150072A 41 135 176
175873 175873 NO 23713 STATE MEASURE 2 9878 5150072A 47 71 118
184580 184580 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 5150072A 48 95 143
184581 184581 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 5150072A 20 61 81
195238 195238 YES 23714 STATE MEASURE 4 9879 5150072A 48 141 189
195239 195239 NO 23715 STATE MEASURE 4 9879 5150072A 39 65 104
205114 205114 YES 23589 STATE MEASURE 6 9869 5150072A 45 126 171
205115 205115 NO 23590 STATE MEASURE 6 9869 5150072A 39 81 120
213090 213090 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 5150072A 22 65 87
213091 213091 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 5150072A 46 91 137
221086 221086 YES 23587 STATE MEASURE 5 9868 5150072A 31 112 143
221087 221087 NO 23588 STATE MEASURE 5 9868 5150072A 55 94 149
226046 226046 YES 24176 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PR 9937 5150072A 40 125 165
226047 226047 NO 24177 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PR 9937 5150072A 36 63 99
236194 236194 YES 24181 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PA 9939 5150072A 52 153 205
236195 236195 NO 24182 PASADENA CITY GENERAL MUNICIPAL ELECTION - MEASURE PA 9939 5150072A 21 34 55
237742 237742 JENNIFER HALL LEE 24404 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 2 9759 5150072A 41 119 160
237743 237743 JUAN CARLOS PEREZ 24405 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 2 9759 5150072A 34 60 94
255230 255230 YES 23521 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE EE 9861 5150072A 50 140 190
255231 255231 NO 23522 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE EE 9861 5150072A 35 64 99
256231 256231 JOHN HARABEDIAN 23407 MEMBER OF THE STATE ASSEMBLY, 41st District 9509 5150072A 43 141 184
256232 256232 MICHELLE DEL ROSARIO MARTINEZ 23408 MEMBER OF THE STATE ASSEMBLY, 41st District 9509 5150072A 49 68 117
260316 260316 YES 24240 COUNTY MEASURE G 9961 5150072A 37 96 133
260317 260317 NO 24241 COUNTY MEASURE G 9961 5150072A 46 95 141

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