results

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

7 rows where candidate_id = 23238

✎ 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
22984 22984 LILLIE P. DARDEN 23238 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450007B 9 41 50
22988 22988 LILLIE P. DARDEN 23238 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450022B 15 122 137
22992 22992 LILLIE P. DARDEN 23238 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450062A 18 82 100
22996 22996 LILLIE P. DARDEN 23238 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450072A 34 137 171
23000 23000 LILLIE P. DARDEN 23238 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450142A 21 91 112
23004 23004 LILLIE P. DARDEN 23238 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450145A 15 99 114
23008 23008 LILLIE P. DARDEN 23238 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450150A 8 16 24

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