results

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

3,988 rows where candidate_id = 23487

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
67068 67068 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050002B 14 0 14
67070 67070 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050002G 1 0 1
67072 67072 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050003A 274 343 617
67074 67074 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050005A 578 717 1295
67076 67076 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050007B 0 0 0
67078 67078 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050010A 1 1 2
67080 67080 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050014A 80 156 236
67082 67082 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050015A 0 0 0
67084 67084 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050022D 0 0 0
67086 67086 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050023D 0 0 0
67088 67088 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050025H 0 0 0
67090 67090 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050027A 0 0 0
67092 67092 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050029A 0 0 0
67094 67094 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050037A 0 0 0
67096 67096 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050042A 0 2 2
67098 67098 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050055A 0 0 0
67100 67100 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050066A 0 0 0
67102 67102 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070001A 107 241 348
67104 67104 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070002A 5 18 23
67106 67106 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070005A 126 331 457
67108 67108 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070005B 1 0 1
67110 67110 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070006A 137 306 443
67112 67112 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070027A 0 0 0
67114 67114 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070027B 2 0 2
67116 67116 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070027C 0 0 0
67118 67118 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070041B 21 42 63
67120 67120 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070041F 3 3 6
67122 67122 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070207A 3 19 22
67124 67124 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080004A 183 543 726
67126 67126 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080007A 286 780 1066
67128 67128 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080050A 370 970 1340
67130 67130 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080054A 143 330 473
67132 67132 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080070A 229 736 965
67134 67134 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090002A 0 0 0
67136 67136 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090002B 0 4 4
67138 67138 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090002C 0 0 0
67140 67140 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090005C 0 0 0
67142 67142 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090005G 0 0 0
67144 67144 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090006A 4 5 9
67146 67146 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090007C 0 1 1
67148 67148 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090009A 0 0 0
67150 67150 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090010A 0 0 0
67152 67152 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090011B 1 5 6
67154 67154 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090012A 1 6 7
67156 67156 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090017A 0 0 0
67158 67158 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090019A 0 0 0
67160 67160 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090021A 0 0 0
67162 67162 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090023A 0 0 0
67164 67164 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090025A 0 2 2
67166 67166 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090025B 0 0 0
67168 67168 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090026A 377 604 981
67170 67170 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150003A 294 814 1108
67172 67172 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150005D 1 1 2
67174 67174 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150005E 0 0 0
67176 67176 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150012A 243 624 867
67178 67178 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150016D 316 722 1038
67180 67180 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150023A 226 443 669
67182 67182 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150025A 202 437 639
67184 67184 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150032B 4 3 7
67186 67186 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150034A 255 569 824
67188 67188 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150042A 144 287 431
67190 67190 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150045A 198 545 743
67192 67192 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150049A 72 181 253
67194 67194 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150055A 37 98 135
67196 67196 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150065A 274 616 890
67198 67198 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150070A 43 130 173
67200 67200 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150071A 251 613 864
67202 67202 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150078A 51 96 147
67204 67204 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150079A 131 339 470
67206 67206 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150082A 228 358 586
67208 67208 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0150085A 72 184 256
67210 67210 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0180002A 67 151 218
67212 67212 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200005A 189 623 812
67214 67214 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200015A 198 408 606
67216 67216 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200016A 292 1104 1396
67218 67218 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200018A 29 95 124
67220 67220 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200019A 109 300 409
67222 67222 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200025B 135 543 678
67224 67224 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200027A 0 0 0
67226 67226 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200029A 74 304 378
67228 67228 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200030C 0 0 0
67230 67230 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200031A 0 0 0
67232 67232 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200040A 351 842 1193
67234 67234 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200041A 0 0 0
67236 67236 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200046A 131 254 385
67238 67238 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200048A 0 0 0
67240 67240 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200053A 0 0 0
67242 67242 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200064A 52 106 158
67244 67244 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200087A 226 622 848
67246 67246 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200094A 0 0 0
67248 67248 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200094H 0 0 0
67250 67250 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300001D 1 4 5
67252 67252 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300001G 17 29 46
67254 67254 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300002A 23 46 69
67256 67256 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300002B 0 3 3
67258 67258 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300002C 1 4 5
67260 67260 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300003A 10 12 22
67262 67262 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300005A 0 0 0
67264 67264 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300006B 0 0 0
67266 67266 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300012A 31 41 72

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