results

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

7 rows where candidate_id = 23240

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
22982 22982 TERRANCE CUMBY 23240 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450007B 1 17 18
22986 22986 TERRANCE CUMBY 23240 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450022B 19 89 108
22990 22990 TERRANCE CUMBY 23240 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450062A 8 17 25
22994 22994 TERRANCE CUMBY 23240 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450072A 19 36 55
22998 22998 TERRANCE CUMBY 23240 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450142A 16 26 42
23002 23002 TERRANCE CUMBY 23240 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450145A 9 23 32
23006 23006 TERRANCE CUMBY 23240 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450150A 1 0 1

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