candidates

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

5 rows where contest_id = 8541

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
20610 JANESSA LAVOICE Non Partisan BEVERLY HILLS UNIFIED SCHOOL DISTRICT Governing Board Member 8541 719
20706 RACHELLE MARCUS Non Partisan BEVERLY HILLS UNIFIED SCHOOL DISTRICT Governing Board Member 8541 5300
20963 JUDITH MANOUCHEHRI Non Partisan BEVERLY HILLS UNIFIED SCHOOL DISTRICT Governing Board Member 8541 4699
20972 FARRAH DODES Non Partisan BEVERLY HILLS UNIFIED SCHOOL DISTRICT Governing Board Member 8541 2981
20998 MICHAL A. SALKIN Non Partisan BEVERLY HILLS UNIFIED SCHOOL DISTRICT Governing Board Member 8541 2852

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