candidates

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

10 rows where contest_id = 9010

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
21969 ERSKINE LEVI Non Partisan UNITED STATES REPRESENTATIVE, 31st District 9010 1166
22178 GREG HAFIF Democratic UNITED STATES REPRESENTATIVE, 31st District 9010 4914
22599 PEDRO ANTONIO CASAS Republican UNITED STATES REPRESENTATIVE, 31st District 9010 17077
22667 SUSAN RUBIO Democratic UNITED STATES REPRESENTATIVE, 31st District 9010 16006
22748 MARY ANN LUTZ Democratic UNITED STATES REPRESENTATIVE, 31st District 9010 6629
22806 BOB J. ARCHULETA Democratic UNITED STATES REPRESENTATIVE, 31st District 9010 10151
22848 GIL CISNEROS Democratic UNITED STATES REPRESENTATIVE, 31st District 9010 23888
22849 KURT JOSE Democratic UNITED STATES REPRESENTATIVE, 31st District 9010 1415
22909 MARIE MANVEL Non Partisan UNITED STATES REPRESENTATIVE, 31st District 9010 534
23012 DANIEL JOSE BOCIC MARTINEZ Republican UNITED STATES REPRESENTATIVE, 31st District 9010 19464

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