results

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

283,256 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
1 1 YES 22801 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6230052A 1 7 8
2 2 NO 22802 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6230052A 3 5 8
3 3 YES 22801 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6230052D 3 16 19
4 4 NO 22802 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6230052D 1 14 15
5 5 YES 22801 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700019A 33 146 179
6 6 NO 22802 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700019A 26 79 105
7 7 YES 22801 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700040A 31 181 212
8 8 NO 22802 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700040A 41 103 144
9 9 YES 22801 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700054A 44 169 213
10 10 NO 22802 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700054A 37 99 136
11 11 YES 22801 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700064A 79 310 389
12 12 NO 22802 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700064A 89 205 294
13 13 YES 22801 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700070A 83 343 426
14 14 NO 22802 SOUTH WHITTIER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE K 9412 6700070A 77 249 326
15 15 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0050010A 0 0 0
16 16 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0050010A 0 0 0
17 17 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0050010A 0 0 0
18 18 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0050010A 0 1 1
19 19 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200011A 89 428 517
20 20 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200011A 28 204 232
21 21 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200011A 96 462 558
22 22 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200011A 69 174 243
23 23 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200012A 32 217 249
24 24 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200012A 19 139 158
25 25 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200012A 69 304 373
26 26 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200012A 81 199 280
27 27 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200013A 66 321 387
28 28 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200013A 31 123 154
29 29 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200013A 62 281 343
30 30 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200013A 40 112 152
31 31 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200015A 79 339 418
32 32 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200015A 42 179 221
33 33 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200015A 69 277 346
34 34 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200015A 64 99 163
35 35 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200016A 34 269 303
36 36 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200016A 27 158 185
37 37 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200016A 72 527 599
38 38 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200016A 111 280 391
39 39 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200024A 80 403 483
40 40 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200024A 44 216 260
41 41 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200024A 103 548 651
42 42 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200024A 96 213 309
43 43 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200025B 30 143 173
44 44 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200025B 15 111 126
45 45 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200025B 28 172 200
46 46 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200025B 41 43 84
47 47 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200029A 93 397 490
48 48 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200029A 30 179 209
49 49 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200029A 86 459 545
50 50 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200029A 82 155 237
51 51 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200031A 0 0 0
52 52 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200031A 0 2 2
53 53 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200031A 0 1 1
54 54 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200031A 0 0 0
55 55 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200038A 39 268 307
56 56 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200038A 26 122 148
57 57 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200038A 77 448 525
58 58 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200038A 103 317 420
59 59 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200087A 92 373 465
60 60 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200087A 40 163 203
61 61 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200087A 70 331 401
62 62 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0200087A 58 114 172
63 63 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0940005A 1 34 35
64 64 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0940005A 1 12 13
65 65 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0940005A 3 37 40
66 66 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 0940005A 56 66 122
67 67 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1250069A 0 0 0
68 68 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1250069A 0 0 0
69 69 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1250069A 0 0 0
70 70 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1250069A 0 3 3
71 71 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1250081A 0 1 1
72 72 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1250081A 0 2 2
73 73 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1250081A 0 0 0
74 74 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1250081A 0 0 0
75 75 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300006A 10 110 120
76 76 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300006A 45 319 364
77 77 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300006A 32 198 230
78 78 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300006A 161 334 495
79 79 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300009A 42 303 345
80 80 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300009A 103 1016 1119
81 81 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300009A 51 358 409
82 82 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300009A 131 331 462
83 83 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300018A 24 177 201
84 84 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300018A 100 696 796
85 85 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300018A 52 320 372
86 86 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300018A 215 517 732
87 87 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300020A 27 124 151
88 88 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300020A 55 369 424
89 89 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300020A 42 275 317
90 90 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300020A 180 468 648
91 91 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300021A 33 185 218
92 92 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300021A 78 499 577
93 93 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300021A 38 312 350
94 94 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300021A 113 249 362
95 95 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300023C 30 123 153
96 96 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300023C 85 296 381
97 97 JOHN HARABEDIAN 22652 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300023C 37 227 264
98 98 MICHELLE DEL ROSARIO MARTINEZ 22446 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 1300023C 127 179 306
99 99 PHLUNTÉ RIDDLE 22038 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 2020006A 18 80 98
100 100 JED LEANO 22080 MEMBER OF THE STATE ASSEMBLY, 41st District 9030 2020006A 24 70 94

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