results

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

7 rows where candidate_id = 23274

✎ 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
22983 22983 JOEL ESTRADA 23274 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450007B 20 50 70
22987 22987 JOEL ESTRADA 23274 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450022B 18 112 130
22991 22991 JOEL ESTRADA 23274 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450062A 11 60 71
22995 22995 JOEL ESTRADA 23274 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450072A 18 58 76
22999 22999 JOEL ESTRADA 23274 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450142A 33 89 122
23003 23003 JOEL ESTRADA 23274 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450145A 22 65 87
23007 23007 JOEL ESTRADA 23274 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450150A 4 13 17

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