results

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

2,210 rows where candidate_id = 22852

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
198800 198800 YES 22852 STATE MEASURE 1 9413 0050002B 6 0 6
198802 198802 YES 22852 STATE MEASURE 1 9413 0050003A 48 120 168
198804 198804 YES 22852 STATE MEASURE 1 9413 0050004A 42 181 223
198806 198806 YES 22852 STATE MEASURE 1 9413 0050010A 0 0 0
198808 198808 YES 22852 STATE MEASURE 1 9413 0050013A 46 161 207
198810 198810 YES 22852 STATE MEASURE 1 9413 0050042A 0 0 0
198812 198812 YES 22852 STATE MEASURE 1 9413 0070002A 2 13 15
198814 198814 YES 22852 STATE MEASURE 1 9413 0070005A 29 217 246
198816 198816 YES 22852 STATE MEASURE 1 9413 0070005B 0 16 16
198818 198818 YES 22852 STATE MEASURE 1 9413 0070006A 73 286 359
198820 198820 YES 22852 STATE MEASURE 1 9413 0070008A 22 112 134
198822 198822 YES 22852 STATE MEASURE 1 9413 0070041B 5 29 34
198824 198824 YES 22852 STATE MEASURE 1 9413 0080004A 72 419 491
198826 198826 YES 22852 STATE MEASURE 1 9413 0080007A 102 648 750
198828 198828 YES 22852 STATE MEASURE 1 9413 0080050A 119 579 698
198830 198830 YES 22852 STATE MEASURE 1 9413 0080054A 58 239 297
198832 198832 YES 22852 STATE MEASURE 1 9413 0080070A 112 698 810
198834 198834 YES 22852 STATE MEASURE 1 9413 0090002A 0 0 0
198836 198836 YES 22852 STATE MEASURE 1 9413 0090006A 2 5 7
198838 198838 YES 22852 STATE MEASURE 1 9413 0090011B 1 5 6
198840 198840 YES 22852 STATE MEASURE 1 9413 0090012A 0 0 0
198842 198842 YES 22852 STATE MEASURE 1 9413 0090025A 0 0 0
198844 198844 YES 22852 STATE MEASURE 1 9413 0090026A 40 254 294
198846 198846 YES 22852 STATE MEASURE 1 9413 0150003A 90 477 567
198848 198848 YES 22852 STATE MEASURE 1 9413 0150012A 104 485 589
198850 198850 YES 22852 STATE MEASURE 1 9413 0150016D 67 332 399
198852 198852 YES 22852 STATE MEASURE 1 9413 0150021A 41 216 257
198854 198854 YES 22852 STATE MEASURE 1 9413 0150023A 79 285 364
198856 198856 YES 22852 STATE MEASURE 1 9413 0150037A 81 377 458
198858 198858 YES 22852 STATE MEASURE 1 9413 0150039A 75 329 404
198860 198860 YES 22852 STATE MEASURE 1 9413 0150049A 51 243 294
198862 198862 YES 22852 STATE MEASURE 1 9413 0150054A 56 373 429
198864 198864 YES 22852 STATE MEASURE 1 9413 0150055A 51 254 305
198866 198866 YES 22852 STATE MEASURE 1 9413 0150065A 109 412 521
198868 198868 YES 22852 STATE MEASURE 1 9413 0150072A 83 317 400
198870 198870 YES 22852 STATE MEASURE 1 9413 0150079A 76 406 482
198872 198872 YES 22852 STATE MEASURE 1 9413 0150082A 91 337 428
198874 198874 YES 22852 STATE MEASURE 1 9413 0180002A 24 65 89
198876 198876 YES 22852 STATE MEASURE 1 9413 0200011A 168 822 990
198878 198878 YES 22852 STATE MEASURE 1 9413 0200012A 92 491 583
198880 198880 YES 22852 STATE MEASURE 1 9413 0200013A 132 568 700
198882 198882 YES 22852 STATE MEASURE 1 9413 0200015A 152 566 718
198884 198884 YES 22852 STATE MEASURE 1 9413 0200016A 108 691 799
198886 198886 YES 22852 STATE MEASURE 1 9413 0200024A 183 883 1066
198888 198888 YES 22852 STATE MEASURE 1 9413 0200025B 63 298 361
198890 198890 YES 22852 STATE MEASURE 1 9413 0200029A 165 799 964
198892 198892 YES 22852 STATE MEASURE 1 9413 0200031A 0 1 1
198894 198894 YES 22852 STATE MEASURE 1 9413 0200038A 126 660 786
198896 198896 YES 22852 STATE MEASURE 1 9413 0200087A 159 588 747
198898 198898 YES 22852 STATE MEASURE 1 9413 0300001G 1 8 9
198900 198900 YES 22852 STATE MEASURE 1 9413 0300002A 5 37 42
198902 198902 YES 22852 STATE MEASURE 1 9413 0300002B 0 14 14
198904 198904 YES 22852 STATE MEASURE 1 9413 0300016A 3 6 9
198906 198906 YES 22852 STATE MEASURE 1 9413 0350007A 35 258 293
198908 198908 YES 22852 STATE MEASURE 1 9413 0350012A 71 490 561
198910 198910 YES 22852 STATE MEASURE 1 9413 0350020A 78 382 460
198912 198912 YES 22852 STATE MEASURE 1 9413 0350027A 63 366 429
198914 198914 YES 22852 STATE MEASURE 1 9413 0350034A 27 267 294
198916 198916 YES 22852 STATE MEASURE 1 9413 0350038A 31 213 244
198918 198918 YES 22852 STATE MEASURE 1 9413 0350042A 65 298 363
198920 198920 YES 22852 STATE MEASURE 1 9413 0350048A 23 212 235
198922 198922 YES 22852 STATE MEASURE 1 9413 0350054A 33 272 305
198924 198924 YES 22852 STATE MEASURE 1 9413 0350061A 6 4 10
198926 198926 YES 22852 STATE MEASURE 1 9413 0350062B 53 423 476
198928 198928 YES 22852 STATE MEASURE 1 9413 0350101A 0 0 0
198930 198930 YES 22852 STATE MEASURE 1 9413 0400001A 58 206 264
198932 198932 YES 22852 STATE MEASURE 1 9413 0400012A 62 193 255
198934 198934 YES 22852 STATE MEASURE 1 9413 0400018A 53 223 276
198936 198936 YES 22852 STATE MEASURE 1 9413 0450008A 61 235 296
198938 198938 YES 22852 STATE MEASURE 1 9413 0450010A 48 184 232
198940 198940 YES 22852 STATE MEASURE 1 9413 0450014A 42 167 209
198942 198942 YES 22852 STATE MEASURE 1 9413 0500002A 98 216 314
198944 198944 YES 22852 STATE MEASURE 1 9413 0520004A 22 171 193
198946 198946 YES 22852 STATE MEASURE 1 9413 0520024A 52 165 217
198948 198948 YES 22852 STATE MEASURE 1 9413 0520025A 51 331 382
198950 198950 YES 22852 STATE MEASURE 1 9413 0520027A 44 76 120
198952 198952 YES 22852 STATE MEASURE 1 9413 0550010C 2 1 3
198954 198954 YES 22852 STATE MEASURE 1 9413 0550011A 83 425 508
198956 198956 YES 22852 STATE MEASURE 1 9413 0550012A 55 218 273
198958 198958 YES 22852 STATE MEASURE 1 9413 0550016A 65 201 266
198960 198960 YES 22852 STATE MEASURE 1 9413 0550018A 53 214 267
198962 198962 YES 22852 STATE MEASURE 1 9413 0550020A 65 220 285
198964 198964 YES 22852 STATE MEASURE 1 9413 0550024A 11 62 73
198966 198966 YES 22852 STATE MEASURE 1 9413 0550073A 88 272 360
198968 198968 YES 22852 STATE MEASURE 1 9413 0550078A 58 296 354
198970 198970 YES 22852 STATE MEASURE 1 9413 0550086A 70 351 421
198972 198972 YES 22852 STATE MEASURE 1 9413 0600008B 65 227 292
198974 198974 YES 22852 STATE MEASURE 1 9413 0600014A 48 265 313
198976 198976 YES 22852 STATE MEASURE 1 9413 0600020A 28 174 202
198978 198978 YES 22852 STATE MEASURE 1 9413 0600029C 39 190 229
198980 198980 YES 22852 STATE MEASURE 1 9413 0600034A 55 179 234
198982 198982 YES 22852 STATE MEASURE 1 9413 0600035A 36 180 216
198984 198984 YES 22852 STATE MEASURE 1 9413 0600036A 59 208 267
198986 198986 YES 22852 STATE MEASURE 1 9413 0600037A 34 113 147
198988 198988 YES 22852 STATE MEASURE 1 9413 0600038A 47 179 226
198990 198990 YES 22852 STATE MEASURE 1 9413 0600039A 57 196 253
198992 198992 YES 22852 STATE MEASURE 1 9413 0600041A 44 156 200
198994 198994 YES 22852 STATE MEASURE 1 9413 0600053A 42 173 215
198996 198996 YES 22852 STATE MEASURE 1 9413 0600061A 24 211 235
198998 198998 YES 22852 STATE MEASURE 1 9413 0670008A 53 181 234

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