candidates

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

6 rows where contest_id = 9857

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24469 KAMALA D. HARRIS Democratic PRESIDENT AND VICE PRESIDENT 9857 2417109
24470 DONALD J. TRUMP Republican PRESIDENT AND VICE PRESIDENT 9857 1189862
24471 ROBERT F. KENNEDY JR. American Independent PRESIDENT AND VICE PRESIDENT 9857 45984
24472 JILL STEIN Green PRESIDENT AND VICE PRESIDENT 9857 41171
24473 CHASE OLIVER Libertarian PRESIDENT AND VICE PRESIDENT 9857 12870
24474 CLAUDIA DE LA CRUZ Peace and Freedom PRESIDENT AND VICE PRESIDENT 9857 21431

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [candidates] (
   [id] INTEGER PRIMARY KEY,
   [name] TEXT,
   [party] TEXT,
   [contest_id] INTEGER REFERENCES [contests]([id]),
   [total_votes] INTEGER
);
CREATE INDEX [idx_candidates_contest_id]
    ON [candidates] ([contest_id]);