results

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

22 rows where candidate_id = 20965

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
32238 32238 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250017B 12 40 52
32240 32240 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250021A 35 136 171
32242 32242 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250031A 31 106 137
32244 32244 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250049A 19 83 102
32246 32246 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250055A 100 261 361
32248 32248 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250057A 20 56 76
32250 32250 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250059A 16 23 39
32252 32252 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250061A 51 150 201
32254 32254 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250062A 54 204 258
32256 32256 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250067A 28 65 93
32258 32258 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250067B 10 26 36
32260 32260 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250073A 71 170 241
32262 32262 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250076A 58 176 234
32264 32264 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250077B 68 227 295
32266 32266 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250086A 23 75 98
32268 32268 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250143A 96 263 359
32270 32270 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250146A 34 131 165
32272 32272 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250147A 68 226 294
32274 32274 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250152B 0 0 0
32276 32276 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250153A 64 170 234
32278 32278 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250155A 0 0 0
32280 32280 FRANK CARLOS GUZMAN 20965 THREE VALLEYS MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 1 8415 5250155B 3 36 39

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