results

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

7 rows where candidate_id = 23239

✎ 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
22985 22985 ALYSIA RIVERS 23239 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450007B 10 32 42
22989 22989 ALYSIA RIVERS 23239 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450022B 12 49 61
22993 22993 ALYSIA RIVERS 23239 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450062A 15 43 58
22997 22997 ALYSIA RIVERS 23239 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450072A 21 70 91
23001 23001 ALYSIA RIVERS 23239 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450142A 8 33 41
23005 23005 ALYSIA RIVERS 23239 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450145A 12 57 69
23009 23009 ALYSIA RIVERS 23239 COMPTON CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9348 1450150A 1 2 3

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