results

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

25 rows where candidate_id = 20472

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
245284 245284 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700001B 116 208 324
245286 245286 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700003A 168 286 454
245288 245288 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700005A 137 321 458
245290 245290 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700006A 149 186 335
245292 245292 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700007A 37 40 77
245294 245294 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700007B 23 61 84
245296 245296 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700009A 102 106 208
245298 245298 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700012A 111 217 328
245300 245300 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700014A 1 1 2
245302 245302 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700014B 214 503 717
245304 245304 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700019A 66 113 179
245306 245306 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700020A 130 341 471
245308 245308 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700022A 111 184 295
245310 245310 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700024A 32 57 89
245312 245312 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700025A 47 49 96
245314 245314 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700032A 35 75 110
245316 245316 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700035A 62 147 209
245318 245318 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700036A 94 161 255
245320 245320 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700057A 152 293 445
245322 245322 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700062A 30 67 97
245324 245324 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700064A 37 39 76
245326 245326 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700065B 0 3 3
245328 245328 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700068A 127 180 307
245330 245330 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700070A 80 160 240
245332 245332 RHONDA SHADER 20472 STATE SENATOR, 34th District 8719 6700071A 57 76 133

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