results

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

3,988 rows where candidate_id = 23714

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
192168 192168 YES 23714 STATE MEASURE 4 9879 0050002B 29 0 29
192170 192170 YES 23714 STATE MEASURE 4 9879 0050002G 1 0 1
192172 192172 YES 23714 STATE MEASURE 4 9879 0050003A 96 219 315
192174 192174 YES 23714 STATE MEASURE 4 9879 0050005A 245 531 776
192176 192176 YES 23714 STATE MEASURE 4 9879 0050007B 0 0 0
192178 192178 YES 23714 STATE MEASURE 4 9879 0050010A 0 0 0
192180 192180 YES 23714 STATE MEASURE 4 9879 0050014A 43 111 154
192182 192182 YES 23714 STATE MEASURE 4 9879 0050015A 0 0 0
192184 192184 YES 23714 STATE MEASURE 4 9879 0050022D 0 1 1
192186 192186 YES 23714 STATE MEASURE 4 9879 0050023D 0 0 0
192188 192188 YES 23714 STATE MEASURE 4 9879 0050025H 0 0 0
192190 192190 YES 23714 STATE MEASURE 4 9879 0050027A 0 0 0
192192 192192 YES 23714 STATE MEASURE 4 9879 0050029A 0 0 0
192194 192194 YES 23714 STATE MEASURE 4 9879 0050037A 0 0 0
192196 192196 YES 23714 STATE MEASURE 4 9879 0050042A 1 0 1
192198 192198 YES 23714 STATE MEASURE 4 9879 0050055A 0 0 0
192200 192200 YES 23714 STATE MEASURE 4 9879 0050066A 0 0 0
192202 192202 YES 23714 STATE MEASURE 4 9879 0070001A 61 238 299
192204 192204 YES 23714 STATE MEASURE 4 9879 0070002A 5 26 31
192206 192206 YES 23714 STATE MEASURE 4 9879 0070005A 114 407 521
192208 192208 YES 23714 STATE MEASURE 4 9879 0070005B 3 6 9
192210 192210 YES 23714 STATE MEASURE 4 9879 0070006A 201 580 781
192212 192212 YES 23714 STATE MEASURE 4 9879 0070027A 0 0 0
192214 192214 YES 23714 STATE MEASURE 4 9879 0070027B 0 1 1
192216 192216 YES 23714 STATE MEASURE 4 9879 0070027C 0 0 0
192218 192218 YES 23714 STATE MEASURE 4 9879 0070041B 20 58 78
192220 192220 YES 23714 STATE MEASURE 4 9879 0070041F 4 8 12
192222 192222 YES 23714 STATE MEASURE 4 9879 0070207A 0 18 18
192224 192224 YES 23714 STATE MEASURE 4 9879 0080004A 135 829 964
192226 192226 YES 23714 STATE MEASURE 4 9879 0080007A 293 1263 1556
192228 192228 YES 23714 STATE MEASURE 4 9879 0080050A 361 1416 1777
192230 192230 YES 23714 STATE MEASURE 4 9879 0080054A 148 502 650
192232 192232 YES 23714 STATE MEASURE 4 9879 0080070A 200 1061 1261
192234 192234 YES 23714 STATE MEASURE 4 9879 0090002A 1 0 1
192236 192236 YES 23714 STATE MEASURE 4 9879 0090002B 0 0 0
192238 192238 YES 23714 STATE MEASURE 4 9879 0090002C 0 0 0
192240 192240 YES 23714 STATE MEASURE 4 9879 0090005C 0 0 0
192242 192242 YES 23714 STATE MEASURE 4 9879 0090005G 0 0 0
192244 192244 YES 23714 STATE MEASURE 4 9879 0090006A 7 10 17
192246 192246 YES 23714 STATE MEASURE 4 9879 0090007C 0 1 1
192248 192248 YES 23714 STATE MEASURE 4 9879 0090009A 0 0 0
192250 192250 YES 23714 STATE MEASURE 4 9879 0090010A 0 0 0
192252 192252 YES 23714 STATE MEASURE 4 9879 0090011B 1 5 6
192254 192254 YES 23714 STATE MEASURE 4 9879 0090012A 0 0 0
192256 192256 YES 23714 STATE MEASURE 4 9879 0090017A 0 0 0
192258 192258 YES 23714 STATE MEASURE 4 9879 0090019A 0 0 0
192260 192260 YES 23714 STATE MEASURE 4 9879 0090021A 0 0 0
192262 192262 YES 23714 STATE MEASURE 4 9879 0090023A 0 0 0
192264 192264 YES 23714 STATE MEASURE 4 9879 0090025A 0 4 4
192266 192266 YES 23714 STATE MEASURE 4 9879 0090025B 0 0 0
192268 192268 YES 23714 STATE MEASURE 4 9879 0090026A 144 490 634
192270 192270 YES 23714 STATE MEASURE 4 9879 0150003A 452 1668 2120
192272 192272 YES 23714 STATE MEASURE 4 9879 0150005D 0 2 2
192274 192274 YES 23714 STATE MEASURE 4 9879 0150005E 0 1 1
192276 192276 YES 23714 STATE MEASURE 4 9879 0150012A 413 1451 1864
192278 192278 YES 23714 STATE MEASURE 4 9879 0150016D 446 1346 1792
192280 192280 YES 23714 STATE MEASURE 4 9879 0150023A 311 939 1250
192282 192282 YES 23714 STATE MEASURE 4 9879 0150025A 351 948 1299
192284 192284 YES 23714 STATE MEASURE 4 9879 0150032B 5 11 16
192286 192286 YES 23714 STATE MEASURE 4 9879 0150034A 318 1089 1407
192288 192288 YES 23714 STATE MEASURE 4 9879 0150042A 168 563 731
192290 192290 YES 23714 STATE MEASURE 4 9879 0150045A 285 916 1201
192292 192292 YES 23714 STATE MEASURE 4 9879 0150049A 71 297 368
192294 192294 YES 23714 STATE MEASURE 4 9879 0150055A 26 148 174
192296 192296 YES 23714 STATE MEASURE 4 9879 0150065A 365 1063 1428
192298 192298 YES 23714 STATE MEASURE 4 9879 0150070A 57 200 257
192300 192300 YES 23714 STATE MEASURE 4 9879 0150071A 341 1146 1487
192302 192302 YES 23714 STATE MEASURE 4 9879 0150078A 93 249 342
192304 192304 YES 23714 STATE MEASURE 4 9879 0150079A 185 623 808
192306 192306 YES 23714 STATE MEASURE 4 9879 0150082A 342 850 1192
192308 192308 YES 23714 STATE MEASURE 4 9879 0150085A 110 316 426
192310 192310 YES 23714 STATE MEASURE 4 9879 0180002A 138 302 440
192312 192312 YES 23714 STATE MEASURE 4 9879 0200005A 417 1773 2190
192314 192314 YES 23714 STATE MEASURE 4 9879 0200015A 485 1267 1752
192316 192316 YES 23714 STATE MEASURE 4 9879 0200016A 389 1927 2316
192318 192318 YES 23714 STATE MEASURE 4 9879 0200018A 76 243 319
192320 192320 YES 23714 STATE MEASURE 4 9879 0200019A 228 881 1109
192322 192322 YES 23714 STATE MEASURE 4 9879 0200025B 281 1258 1539
192324 192324 YES 23714 STATE MEASURE 4 9879 0200027A 0 0 0
192326 192326 YES 23714 STATE MEASURE 4 9879 0200029A 151 747 898
192328 192328 YES 23714 STATE MEASURE 4 9879 0200030C 0 0 0
192330 192330 YES 23714 STATE MEASURE 4 9879 0200031A 0 3 3
192332 192332 YES 23714 STATE MEASURE 4 9879 0200040A 448 1639 2087
192334 192334 YES 23714 STATE MEASURE 4 9879 0200041A 0 0 0
192336 192336 YES 23714 STATE MEASURE 4 9879 0200046A 296 834 1130
192338 192338 YES 23714 STATE MEASURE 4 9879 0200048A 0 1 1
192340 192340 YES 23714 STATE MEASURE 4 9879 0200053A 0 0 0
192342 192342 YES 23714 STATE MEASURE 4 9879 0200064A 78 303 381
192344 192344 YES 23714 STATE MEASURE 4 9879 0200087A 495 1850 2345
192346 192346 YES 23714 STATE MEASURE 4 9879 0200094A 0 0 0
192348 192348 YES 23714 STATE MEASURE 4 9879 0200094H 0 0 0
192350 192350 YES 23714 STATE MEASURE 4 9879 0300001D 1 2 3
192352 192352 YES 23714 STATE MEASURE 4 9879 0300001G 20 28 48
192354 192354 YES 23714 STATE MEASURE 4 9879 0300002A 13 42 55
192356 192356 YES 23714 STATE MEASURE 4 9879 0300002B 1 3 4
192358 192358 YES 23714 STATE MEASURE 4 9879 0300002C 4 6 10
192360 192360 YES 23714 STATE MEASURE 4 9879 0300003A 3 7 10
192362 192362 YES 23714 STATE MEASURE 4 9879 0300005A 0 0 0
192364 192364 YES 23714 STATE MEASURE 4 9879 0300006B 0 0 0
192366 192366 YES 23714 STATE MEASURE 4 9879 0300012A 18 37 55

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