results

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

5 rows where candidate_id = 23128

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
169261 169261 SHARON KALANI 23128 TORRANCE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9257 7150025A 161 536 697
169263 169263 SHARON KALANI 23128 TORRANCE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9257 7150048A 98 314 412
169265 169265 SHARON KALANI 23128 TORRANCE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9257 7150060A 152 613 765
169267 169267 SHARON KALANI 23128 TORRANCE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9257 7150061A 334 940 1274
169269 169269 SHARON KALANI 23128 TORRANCE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9257 7150116B 147 564 711

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