candidates

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

5 rows where contest_id = 9620

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23848 LISA M. IBANEZ Non Partisan MONTEBELLO UNIFIED SCHOOL DISTRICT Governing Board Member 9620 11079
23856 JOANNA L. BARRERAS Non Partisan MONTEBELLO UNIFIED SCHOOL DISTRICT Governing Board Member 9620 7531
23906 ELIZABETH CABRERA Non Partisan MONTEBELLO UNIFIED SCHOOL DISTRICT Governing Board Member 9620 15729
23907 LILIANA MAGANA Non Partisan MONTEBELLO UNIFIED SCHOOL DISTRICT Governing Board Member 9620 17978
23985 AARON REVELES Non Partisan MONTEBELLO UNIFIED SCHOOL DISTRICT Governing Board Member 9620 9390

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