results

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

7,976 rows where contest_id = 9549

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id

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
67069 67069 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050002B 18 1 19
67070 67070 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050002G 1 0 1
67071 67071 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050002G 0 0 0
67072 67072 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050003A 274 343 617
67073 67073 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050003A 105 170 275
67074 67074 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050005A 578 717 1295
67075 67075 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050005A 241 442 683
67076 67076 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050007B 0 0 0
67077 67077 ERICKA J. WILEY 23486 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
67079 67079 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050010A 0 0 0
67080 67080 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050014A 80 156 236
67081 67081 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050014A 37 95 132
67082 67082 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050015A 0 0 0
67083 67083 ERICKA J. WILEY 23486 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
67085 67085 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050022D 0 1 1
67086 67086 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050023D 0 0 0
67087 67087 ERICKA J. WILEY 23486 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
67089 67089 ERICKA J. WILEY 23486 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
67091 67091 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050027A 1 0 1
67092 67092 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050029A 0 0 0
67093 67093 ERICKA J. WILEY 23486 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
67095 67095 ERICKA J. WILEY 23486 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
67097 67097 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050042A 1 0 1
67098 67098 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0050055A 0 0 0
67099 67099 ERICKA J. WILEY 23486 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
67101 67101 ERICKA J. WILEY 23486 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
67103 67103 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070001A 37 155 192
67104 67104 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070002A 5 18 23
67105 67105 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070002A 5 16 21
67106 67106 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070005A 126 331 457
67107 67107 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070005A 82 287 369
67108 67108 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070005B 1 0 1
67109 67109 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070005B 2 4 6
67110 67110 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070006A 137 306 443
67111 67111 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070006A 136 385 521
67112 67112 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070027A 0 0 0
67113 67113 ERICKA J. WILEY 23486 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
67115 67115 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070027B 0 1 1
67116 67116 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070027C 0 0 0
67117 67117 ERICKA J. WILEY 23486 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
67119 67119 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070041B 16 32 48
67120 67120 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070041F 3 3 6
67121 67121 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070041F 3 8 11
67122 67122 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070207A 3 19 22
67123 67123 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0070207A 1 6 7
67124 67124 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080004A 183 543 726
67125 67125 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080004A 115 538 653
67126 67126 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080007A 286 780 1066
67127 67127 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080007A 189 859 1048
67128 67128 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080050A 370 970 1340
67129 67129 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080050A 254 954 1208
67130 67130 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080054A 143 330 473
67131 67131 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080054A 96 357 453
67132 67132 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080070A 229 736 965
67133 67133 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0080070A 149 698 847
67134 67134 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090002A 0 0 0
67135 67135 ERICKA J. WILEY 23486 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
67137 67137 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090002B 0 0 0
67138 67138 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090002C 0 0 0
67139 67139 ERICKA J. WILEY 23486 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
67141 67141 ERICKA J. WILEY 23486 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
67143 67143 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090005G 0 1 1
67144 67144 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090006A 4 5 9
67145 67145 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090006A 11 10 21
67146 67146 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090007C 0 1 1
67147 67147 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090007C 0 0 0
67148 67148 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090009A 0 0 0
67149 67149 ERICKA J. WILEY 23486 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
67151 67151 ERICKA J. WILEY 23486 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
67153 67153 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090011B 2 4 6
67154 67154 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090012A 1 6 7
67155 67155 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090012A 0 1 1
67156 67156 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090017A 0 0 0
67157 67157 ERICKA J. WILEY 23486 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
67159 67159 ERICKA J. WILEY 23486 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
67161 67161 ERICKA J. WILEY 23486 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
67163 67163 ERICKA J. WILEY 23486 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
67165 67165 ERICKA J. WILEY 23486 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
67167 67167 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0090025B 0 0 0

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