candidates

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

4 rows where contest_id = 8490

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
20613 RUDY T. MARTINEZ Non Partisan VALLE LINDO SCHOOL DISTRICT Governing Board Member 8490 644
20614 VERONICA LAURIA Non Partisan VALLE LINDO SCHOOL DISTRICT Governing Board Member 8490 617
20616 REYNALDO REY SOTO Non Partisan VALLE LINDO SCHOOL DISTRICT Governing Board Member 8490 442
21244 JACQUELINE J. RUBIO Non Partisan VALLE LINDO SCHOOL DISTRICT Governing Board Member 8490 791

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