results

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

13 rows where candidate_id = 23096

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
41444 41444 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850002E 1 0 1
41446 41446 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850008A 73 227 300
41448 41448 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850037A 15 65 80
41450 41450 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850039A 28 65 93
41452 41452 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850058A 36 100 136
41454 41454 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850059A 22 101 123
41456 41456 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850108A 87 361 448
41458 41458 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850415A 57 150 207
41460 41460 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850549A 19 153 172
41462 41462 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850552A 25 116 141
41464 41464 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850555A 33 101 134
41466 41466 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850660A 43 154 197
41468 41468 SHARIFA BATTS 23096 LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 8th District 9250 3850687A 32 100 132

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