results

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

3,988 rows where candidate_id = 23597

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
131118 131118 YES 23597 STATE MEASURE 34 9872 0050002B 20 0 20
131120 131120 YES 23597 STATE MEASURE 34 9872 0050002G 0 0 0
131122 131122 YES 23597 STATE MEASURE 34 9872 0050003A 293 390 683
131124 131124 YES 23597 STATE MEASURE 34 9872 0050005A 574 799 1373
131126 131126 YES 23597 STATE MEASURE 34 9872 0050007B 0 0 0
131128 131128 YES 23597 STATE MEASURE 34 9872 0050010A 2 1 3
131130 131130 YES 23597 STATE MEASURE 34 9872 0050014A 85 143 228
131132 131132 YES 23597 STATE MEASURE 34 9872 0050015A 0 0 0
131134 131134 YES 23597 STATE MEASURE 34 9872 0050022D 0 2 2
131136 131136 YES 23597 STATE MEASURE 34 9872 0050023D 0 0 0
131138 131138 YES 23597 STATE MEASURE 34 9872 0050025H 0 0 0
131140 131140 YES 23597 STATE MEASURE 34 9872 0050027A 0 0 0
131142 131142 YES 23597 STATE MEASURE 34 9872 0050029A 0 0 0
131144 131144 YES 23597 STATE MEASURE 34 9872 0050037A 0 0 0
131146 131146 YES 23597 STATE MEASURE 34 9872 0050042A 1 0 1
131148 131148 YES 23597 STATE MEASURE 34 9872 0050055A 0 0 0
131150 131150 YES 23597 STATE MEASURE 34 9872 0050066A 0 0 0
131152 131152 YES 23597 STATE MEASURE 34 9872 0070001A 115 247 362
131154 131154 YES 23597 STATE MEASURE 34 9872 0070002A 9 16 25
131156 131156 YES 23597 STATE MEASURE 34 9872 0070005A 135 409 544
131158 131158 YES 23597 STATE MEASURE 34 9872 0070005B 2 2 4
131160 131160 YES 23597 STATE MEASURE 34 9872 0070006A 168 383 551
131162 131162 YES 23597 STATE MEASURE 34 9872 0070027A 0 0 0
131164 131164 YES 23597 STATE MEASURE 34 9872 0070027B 0 1 1
131166 131166 YES 23597 STATE MEASURE 34 9872 0070027C 0 0 0
131168 131168 YES 23597 STATE MEASURE 34 9872 0070041B 25 42 67
131170 131170 YES 23597 STATE MEASURE 34 9872 0070041F 5 10 15
131172 131172 YES 23597 STATE MEASURE 34 9872 0070207A 3 11 14
131174 131174 YES 23597 STATE MEASURE 34 9872 0080004A 216 590 806
131176 131176 YES 23597 STATE MEASURE 34 9872 0080007A 334 917 1251
131178 131178 YES 23597 STATE MEASURE 34 9872 0080050A 425 1106 1531
131180 131180 YES 23597 STATE MEASURE 34 9872 0080054A 166 398 564
131182 131182 YES 23597 STATE MEASURE 34 9872 0080070A 253 799 1052
131184 131184 YES 23597 STATE MEASURE 34 9872 0090002A 1 0 1
131186 131186 YES 23597 STATE MEASURE 34 9872 0090002B 0 2 2
131188 131188 YES 23597 STATE MEASURE 34 9872 0090002C 0 0 0
131190 131190 YES 23597 STATE MEASURE 34 9872 0090005C 0 0 0
131192 131192 YES 23597 STATE MEASURE 34 9872 0090005G 0 0 0
131194 131194 YES 23597 STATE MEASURE 34 9872 0090006A 4 9 13
131196 131196 YES 23597 STATE MEASURE 34 9872 0090007C 0 1 1
131198 131198 YES 23597 STATE MEASURE 34 9872 0090009A 0 0 0
131200 131200 YES 23597 STATE MEASURE 34 9872 0090010A 0 0 0
131202 131202 YES 23597 STATE MEASURE 34 9872 0090011B 3 5 8
131204 131204 YES 23597 STATE MEASURE 34 9872 0090012A 1 5 6
131206 131206 YES 23597 STATE MEASURE 34 9872 0090017A 0 0 0
131208 131208 YES 23597 STATE MEASURE 34 9872 0090019A 0 0 0
131210 131210 YES 23597 STATE MEASURE 34 9872 0090021A 0 0 0
131212 131212 YES 23597 STATE MEASURE 34 9872 0090023A 0 0 0
131214 131214 YES 23597 STATE MEASURE 34 9872 0090025A 0 3 3
131216 131216 YES 23597 STATE MEASURE 34 9872 0090025B 0 0 0
131218 131218 YES 23597 STATE MEASURE 34 9872 0090026A 360 677 1037
131220 131220 YES 23597 STATE MEASURE 34 9872 0150003A 416 1083 1499
131222 131222 YES 23597 STATE MEASURE 34 9872 0150005D 0 0 0
131224 131224 YES 23597 STATE MEASURE 34 9872 0150005E 0 1 1
131226 131226 YES 23597 STATE MEASURE 34 9872 0150012A 321 840 1161
131228 131228 YES 23597 STATE MEASURE 34 9872 0150016D 372 880 1252
131230 131230 YES 23597 STATE MEASURE 34 9872 0150023A 269 581 850
131232 131232 YES 23597 STATE MEASURE 34 9872 0150025A 254 574 828
131234 131234 YES 23597 STATE MEASURE 34 9872 0150032B 4 5 9
131236 131236 YES 23597 STATE MEASURE 34 9872 0150034A 280 710 990
131238 131238 YES 23597 STATE MEASURE 34 9872 0150042A 172 362 534
131240 131240 YES 23597 STATE MEASURE 34 9872 0150045A 238 639 877
131242 131242 YES 23597 STATE MEASURE 34 9872 0150049A 78 236 314
131244 131244 YES 23597 STATE MEASURE 34 9872 0150055A 37 113 150
131246 131246 YES 23597 STATE MEASURE 34 9872 0150065A 342 739 1081
131248 131248 YES 23597 STATE MEASURE 34 9872 0150070A 55 151 206
131250 131250 YES 23597 STATE MEASURE 34 9872 0150071A 299 780 1079
131252 131252 YES 23597 STATE MEASURE 34 9872 0150078A 71 139 210
131254 131254 YES 23597 STATE MEASURE 34 9872 0150079A 159 435 594
131256 131256 YES 23597 STATE MEASURE 34 9872 0150082A 258 465 723
131258 131258 YES 23597 STATE MEASURE 34 9872 0150085A 112 210 322
131260 131260 YES 23597 STATE MEASURE 34 9872 0180002A 108 214 322
131262 131262 YES 23597 STATE MEASURE 34 9872 0200005A 262 847 1109
131264 131264 YES 23597 STATE MEASURE 34 9872 0200015A 314 666 980
131266 131266 YES 23597 STATE MEASURE 34 9872 0200016A 308 1132 1440
131268 131268 YES 23597 STATE MEASURE 34 9872 0200018A 42 124 166
131270 131270 YES 23597 STATE MEASURE 34 9872 0200019A 146 364 510
131272 131272 YES 23597 STATE MEASURE 34 9872 0200025B 192 541 733
131274 131274 YES 23597 STATE MEASURE 34 9872 0200027A 0 0 0
131276 131276 YES 23597 STATE MEASURE 34 9872 0200029A 104 351 455
131278 131278 YES 23597 STATE MEASURE 34 9872 0200030C 0 0 0
131280 131280 YES 23597 STATE MEASURE 34 9872 0200031A 0 1 1
131282 131282 YES 23597 STATE MEASURE 34 9872 0200040A 430 961 1391
131284 131284 YES 23597 STATE MEASURE 34 9872 0200041A 0 0 0
131286 131286 YES 23597 STATE MEASURE 34 9872 0200046A 185 409 594
131288 131288 YES 23597 STATE MEASURE 34 9872 0200048A 0 1 1
131290 131290 YES 23597 STATE MEASURE 34 9872 0200053A 0 0 0
131292 131292 YES 23597 STATE MEASURE 34 9872 0200064A 52 108 160
131294 131294 YES 23597 STATE MEASURE 34 9872 0200087A 291 855 1146
131296 131296 YES 23597 STATE MEASURE 34 9872 0200094A 0 0 0
131298 131298 YES 23597 STATE MEASURE 34 9872 0200094H 0 0 0
131300 131300 YES 23597 STATE MEASURE 34 9872 0300001D 1 5 6
131302 131302 YES 23597 STATE MEASURE 34 9872 0300001G 22 29 51
131304 131304 YES 23597 STATE MEASURE 34 9872 0300002A 24 60 84
131306 131306 YES 23597 STATE MEASURE 34 9872 0300002B 4 2 6
131308 131308 YES 23597 STATE MEASURE 34 9872 0300002C 1 6 7
131310 131310 YES 23597 STATE MEASURE 34 9872 0300003A 6 10 16
131312 131312 YES 23597 STATE MEASURE 34 9872 0300005A 0 0 0
131314 131314 YES 23597 STATE MEASURE 34 9872 0300006B 0 0 0
131316 131316 YES 23597 STATE MEASURE 34 9872 0300012A 35 52 87

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