results

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

18 rows where candidate_id = 21370

✎ 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
23243 23243 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600001A 74 234 308
23245 23245 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600006A 50 212 262
23247 23247 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600009A 53 131 184
23249 23249 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600012A 70 332 402
23251 23251 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600014A 76 323 399
23253 23253 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600016A 72 317 389
23255 23255 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600021E 71 193 264
23257 23257 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600024B 57 210 267
23259 23259 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600025A 83 229 312
23261 23261 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600026B 69 287 356
23263 23263 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600027A 77 211 288
23265 23265 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600029C 70 198 268
23267 23267 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600030G 0 2 2
23269 23269 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600030L 2 4 6
23271 23271 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600035A 64 249 313
23273 23273 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600036A 33 102 135
23275 23275 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600041A 87 329 416
23277 23277 NO 21370 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE RM 8971 0600046A 0 7 7

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