candidates

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

12 rows where contest_id = 9054

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
22184 JOHN MCKINNEY Non Partisan DISTRICT ATTORNEY 9054 87903
22563 DAVID S. MILTON Non Partisan DISTRICT ATTORNEY 9054 63044
22654 MARIA RAMIREZ Non Partisan DISTRICT ATTORNEY 9054 105088
22668 GEORGE GASCÓN Non Partisan DISTRICT ATTORNEY 9054 370654
22685 JONATHAN HATAMI Non Partisan DISTRICT ATTORNEY 9054 194755
22734 ERIC SIDDALL Non Partisan DISTRICT ATTORNEY 9054 82993
22784 DAN KAPELOVITZ Non Partisan DISTRICT ATTORNEY 9054 17622
22797 NATHAN HOCHMAN Non Partisan DISTRICT ATTORNEY 9054 234509
22819 CRAIG J. MITCHELL Non Partisan DISTRICT ATTORNEY 9054 44326
22843 JEFF CHEMERINSKY Non Partisan DISTRICT ATTORNEY 9054 116064
22885 LLOYD "BOBCAT" MASSON Non Partisan DISTRICT ATTORNEY 9054 29306
22907 DEBRA ARCHULETA Non Partisan DISTRICT ATTORNEY 9054 125306

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