candidates

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

10 rows where contest_id = 9758

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24439 STEFANIE LAHART Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 1844
24440 JOHN M. ERICKSON Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 8914
24441 DANNY HANG Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 6695
24442 DORIAN J. JACKSON Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 476
24443 JORDAN COCKERAM Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 1540
24444 LARRY BLOCK Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 4281
24445 GEORGE NICKLE Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 3781
24446 ZEKIAH "Z" WRIGHT Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 3079
24447 WILLIAM WEST SEEGMILLER Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 273
24448 RACHEL SCHMEIDLER Non Partisan CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 642

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