results

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

2,990 rows where candidate_id = 20864

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
225185 225185 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050001B 16 22 38
225187 225187 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050002C 1 0 1
225189 225189 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050003A 239 209 448
225191 225191 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050004B 67 41 108
225193 225193 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050011A 0 1 1
225195 225195 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050014A 60 101 161
225197 225197 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050023A 3 0 3
225199 225199 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050042A 0 0 0
225201 225201 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0050063A 257 333 590
225203 225203 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070001B 2 5 7
225205 225205 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070002A 3 14 17
225207 225207 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070004C 3 11 14
225209 225209 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070004E 10 21 31
225211 225211 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070006N 1 17 18
225213 225213 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070007A 48 59 107
225215 225215 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070008A 40 81 121
225217 225217 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070027B 0 0 0
225219 225219 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041A 86 136 222
225221 225221 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041B 17 18 35
225223 225223 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041K 1 1 2
225225 225225 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0070207A 0 13 13
225227 225227 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080004A 106 179 285
225229 225229 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080012A 78 204 282
225231 225231 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080021A 123 234 357
225233 225233 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080025A 79 154 233
225235 225235 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080038A 79 137 216
225237 225237 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080043A 70 156 226
225239 225239 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0080050A 89 219 308
225241 225241 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090002B 1 1 2
225243 225243 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090003A 322 384 706
225245 225245 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090006A 3 10 13
225247 225247 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090011A 0 8 8
225249 225249 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0090025A 0 0 0
225251 225251 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150004A 66 169 235
225253 225253 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150008A 44 50 94
225255 225255 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150009A 42 81 123
225257 225257 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150011A 57 88 145
225259 225259 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150012A 76 126 202
225261 225261 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150016D 110 166 276
225263 225263 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150018A 61 126 187
225265 225265 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150021A 24 66 90
225267 225267 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150025A 56 109 165
225269 225269 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150028B 26 82 108
225271 225271 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150032A 68 123 191
225273 225273 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150033A 41 83 124
225275 225275 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150037A 31 48 79
225277 225277 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150042A 39 106 145
225279 225279 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150049A 64 127 191
225281 225281 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150060A 27 77 104
225283 225283 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150065A 37 43 80
225285 225285 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150067A 89 139 228
225287 225287 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150070A 23 36 59
225289 225289 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0150071A 32 79 111
225291 225291 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0180002A 17 32 49
225293 225293 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200002A 29 81 110
225295 225295 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200007B 2 13 15
225297 225297 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200013A 55 146 201
225299 225299 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200014A 71 123 194
225301 225301 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200016A 81 148 229
225303 225303 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200017A 30 61 91
225305 225305 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200019B 43 77 120
225307 225307 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200028A 43 78 121
225309 225309 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200030A 132 298 430
225311 225311 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200031A 0 0 0
225313 225313 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200040A 94 186 280
225315 225315 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200051A 35 87 122
225317 225317 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200087A 99 152 251
225319 225319 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200088A 63 126 189
225321 225321 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0200091A 38 71 109
225323 225323 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0300001D 7 16 23
225325 225325 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0300002A 12 17 29
225327 225327 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0300002B 1 4 5
225329 225329 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0300002D 0 2 2
225331 225331 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0300003A 6 15 21
225333 225333 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0300013A 27 52 79
225335 225335 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350005B 39 68 107
225337 225337 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350007A 89 250 339
225339 225339 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350008A 101 288 389
225341 225341 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350012A 50 114 164
225343 225343 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350017A 89 294 383
225345 225345 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350022A 86 195 281
225347 225347 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350027A 65 113 178
225349 225349 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350029A 93 326 419
225351 225351 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350038A 22 68 90
225353 225353 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350043A 80 172 252
225355 225355 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350049A 71 228 299
225357 225357 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350052A 3 6 9
225359 225359 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350057A 43 128 171
225361 225361 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350058C 95 252 347
225363 225363 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350061A 5 0 5
225365 225365 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350101A 0 2 2
225367 225367 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350102A 31 77 108
225369 225369 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350104E 3 9 12
225371 225371 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350105A 2 6 8
225373 225373 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350106A 6 8 14
225375 225375 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0350106B 1 7 8
225377 225377 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0400001A 28 29 57
225379 225379 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0400006A 55 130 185
225381 225381 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0400008A 63 125 188
225383 225383 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0400010A 95 236 331

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