results

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

2,990 rows where candidate_id = 20693

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
198099 198099 NO 20693 STATE MEASURE 31 8828 0050001B 27 24 51
198101 198101 NO 20693 STATE MEASURE 31 8828 0050002C 1 0 1
198103 198103 NO 20693 STATE MEASURE 31 8828 0050003A 292 345 637
198105 198105 NO 20693 STATE MEASURE 31 8828 0050004B 71 79 150
198107 198107 NO 20693 STATE MEASURE 31 8828 0050011A 1 1 2
198109 198109 NO 20693 STATE MEASURE 31 8828 0050014A 80 138 218
198111 198111 NO 20693 STATE MEASURE 31 8828 0050023A 3 0 3
198113 198113 NO 20693 STATE MEASURE 31 8828 0050042A 0 0 0
198115 198115 NO 20693 STATE MEASURE 31 8828 0050063A 322 450 772
198117 198117 NO 20693 STATE MEASURE 31 8828 0070001B 1 6 7
198119 198119 NO 20693 STATE MEASURE 31 8828 0070002A 4 20 24
198121 198121 NO 20693 STATE MEASURE 31 8828 0070004C 7 16 23
198123 198123 NO 20693 STATE MEASURE 31 8828 0070004E 20 46 66
198125 198125 NO 20693 STATE MEASURE 31 8828 0070006N 2 11 13
198127 198127 NO 20693 STATE MEASURE 31 8828 0070007A 60 92 152
198129 198129 NO 20693 STATE MEASURE 31 8828 0070008A 34 111 145
198131 198131 NO 20693 STATE MEASURE 31 8828 0070027B 0 0 0
198133 198133 NO 20693 STATE MEASURE 31 8828 0070041A 85 219 304
198135 198135 NO 20693 STATE MEASURE 31 8828 0070041B 26 25 51
198137 198137 NO 20693 STATE MEASURE 31 8828 0070041K 1 3 4
198139 198139 NO 20693 STATE MEASURE 31 8828 0070207A 0 17 17
198141 198141 NO 20693 STATE MEASURE 31 8828 0080004A 130 281 411
198143 198143 NO 20693 STATE MEASURE 31 8828 0080012A 96 314 410
198145 198145 NO 20693 STATE MEASURE 31 8828 0080021A 157 412 569
198147 198147 NO 20693 STATE MEASURE 31 8828 0080025A 104 260 364
198149 198149 NO 20693 STATE MEASURE 31 8828 0080038A 101 217 318
198151 198151 NO 20693 STATE MEASURE 31 8828 0080043A 101 300 401
198153 198153 NO 20693 STATE MEASURE 31 8828 0080050A 106 346 452
198155 198155 NO 20693 STATE MEASURE 31 8828 0090002B 2 10 12
198157 198157 NO 20693 STATE MEASURE 31 8828 0090003A 357 552 909
198159 198159 NO 20693 STATE MEASURE 31 8828 0090006A 5 15 20
198161 198161 NO 20693 STATE MEASURE 31 8828 0090011A 1 19 20
198163 198163 NO 20693 STATE MEASURE 31 8828 0090025A 0 0 0
198165 198165 NO 20693 STATE MEASURE 31 8828 0150004A 96 334 430
198167 198167 NO 20693 STATE MEASURE 31 8828 0150008A 65 113 178
198169 198169 NO 20693 STATE MEASURE 31 8828 0150009A 58 160 218
198171 198171 NO 20693 STATE MEASURE 31 8828 0150011A 80 200 280
198173 198173 NO 20693 STATE MEASURE 31 8828 0150012A 98 248 346
198175 198175 NO 20693 STATE MEASURE 31 8828 0150016D 134 366 500
198177 198177 NO 20693 STATE MEASURE 31 8828 0150018A 102 287 389
198179 198179 NO 20693 STATE MEASURE 31 8828 0150021A 47 148 195
198181 198181 NO 20693 STATE MEASURE 31 8828 0150025A 93 239 332
198183 198183 NO 20693 STATE MEASURE 31 8828 0150028B 41 168 209
198185 198185 NO 20693 STATE MEASURE 31 8828 0150032A 109 271 380
198187 198187 NO 20693 STATE MEASURE 31 8828 0150033A 73 175 248
198189 198189 NO 20693 STATE MEASURE 31 8828 0150037A 44 115 159
198191 198191 NO 20693 STATE MEASURE 31 8828 0150042A 68 216 284
198193 198193 NO 20693 STATE MEASURE 31 8828 0150049A 83 248 331
198195 198195 NO 20693 STATE MEASURE 31 8828 0150060A 48 155 203
198197 198197 NO 20693 STATE MEASURE 31 8828 0150065A 48 113 161
198199 198199 NO 20693 STATE MEASURE 31 8828 0150067A 113 253 366
198201 198201 NO 20693 STATE MEASURE 31 8828 0150070A 32 63 95
198203 198203 NO 20693 STATE MEASURE 31 8828 0150071A 50 161 211
198205 198205 NO 20693 STATE MEASURE 31 8828 0180002A 26 71 97
198207 198207 NO 20693 STATE MEASURE 31 8828 0200002A 50 164 214
198209 198209 NO 20693 STATE MEASURE 31 8828 0200007B 9 25 34
198211 198211 NO 20693 STATE MEASURE 31 8828 0200013A 74 330 404
198213 198213 NO 20693 STATE MEASURE 31 8828 0200014A 105 276 381
198215 198215 NO 20693 STATE MEASURE 31 8828 0200016A 120 341 461
198217 198217 NO 20693 STATE MEASURE 31 8828 0200017A 57 189 246
198219 198219 NO 20693 STATE MEASURE 31 8828 0200019B 72 203 275
198221 198221 NO 20693 STATE MEASURE 31 8828 0200028A 61 206 267
198223 198223 NO 20693 STATE MEASURE 31 8828 0200030A 170 533 703
198225 198225 NO 20693 STATE MEASURE 31 8828 0200031A 0 0 0
198227 198227 NO 20693 STATE MEASURE 31 8828 0200040A 122 342 464
198229 198229 NO 20693 STATE MEASURE 31 8828 0200051A 49 175 224
198231 198231 NO 20693 STATE MEASURE 31 8828 0200087A 127 350 477
198233 198233 NO 20693 STATE MEASURE 31 8828 0200088A 98 321 419
198235 198235 NO 20693 STATE MEASURE 31 8828 0200091A 54 147 201
198237 198237 NO 20693 STATE MEASURE 31 8828 0300001D 6 29 35
198239 198239 NO 20693 STATE MEASURE 31 8828 0300002A 17 19 36
198241 198241 NO 20693 STATE MEASURE 31 8828 0300002B 3 9 12
198243 198243 NO 20693 STATE MEASURE 31 8828 0300002D 0 2 2
198245 198245 NO 20693 STATE MEASURE 31 8828 0300003A 6 17 23
198247 198247 NO 20693 STATE MEASURE 31 8828 0300013A 25 53 78
198249 198249 NO 20693 STATE MEASURE 31 8828 0350005B 40 113 153
198251 198251 NO 20693 STATE MEASURE 31 8828 0350007A 105 331 436
198253 198253 NO 20693 STATE MEASURE 31 8828 0350008A 117 386 503
198255 198255 NO 20693 STATE MEASURE 31 8828 0350012A 58 187 245
198257 198257 NO 20693 STATE MEASURE 31 8828 0350017A 101 461 562
198259 198259 NO 20693 STATE MEASURE 31 8828 0350022A 104 290 394
198261 198261 NO 20693 STATE MEASURE 31 8828 0350027A 78 179 257
198263 198263 NO 20693 STATE MEASURE 31 8828 0350029A 100 402 502
198265 198265 NO 20693 STATE MEASURE 31 8828 0350038A 22 110 132
198267 198267 NO 20693 STATE MEASURE 31 8828 0350043A 76 268 344
198269 198269 NO 20693 STATE MEASURE 31 8828 0350049A 77 322 399
198271 198271 NO 20693 STATE MEASURE 31 8828 0350052A 4 7 11
198273 198273 NO 20693 STATE MEASURE 31 8828 0350057A 49 141 190
198275 198275 NO 20693 STATE MEASURE 31 8828 0350058C 107 453 560
198277 198277 NO 20693 STATE MEASURE 31 8828 0350061A 3 1 4
198279 198279 NO 20693 STATE MEASURE 31 8828 0350101A 0 4 4
198281 198281 NO 20693 STATE MEASURE 31 8828 0350102A 27 104 131
198283 198283 NO 20693 STATE MEASURE 31 8828 0350104E 3 20 23
198285 198285 NO 20693 STATE MEASURE 31 8828 0350105A 2 6 8
198287 198287 NO 20693 STATE MEASURE 31 8828 0350106A 5 20 25
198289 198289 NO 20693 STATE MEASURE 31 8828 0350106B 2 7 9
198291 198291 NO 20693 STATE MEASURE 31 8828 0400001A 38 91 129
198293 198293 NO 20693 STATE MEASURE 31 8828 0400006A 104 249 353
198295 198295 NO 20693 STATE MEASURE 31 8828 0400008A 91 227 318
198297 198297 NO 20693 STATE MEASURE 31 8828 0400010A 146 415 561

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