candidates

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

7 rows where contest_id = 8518

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
20720 YESENIA MARIA CUARENTA Non Partisan PARAMOUNT UNIFIED SCHOOL DISTRICT Governing Board Member 8518 2921
20799 SANDRA NILDA CUEVAS Non Partisan PARAMOUNT UNIFIED SCHOOL DISTRICT Governing Board Member 8518 2535
20838 CARMEN PATRICIA GOMEZ Non Partisan PARAMOUNT UNIFIED SCHOOL DISTRICT Governing Board Member 8518 2802
20844 ROSE MARY MENDEZ Non Partisan PARAMOUNT UNIFIED SCHOOL DISTRICT Governing Board Member 8518 2650
20915 SONIA OLMOS DE LEON Non Partisan PARAMOUNT UNIFIED SCHOOL DISTRICT Governing Board Member 8518 3761
20921 MARCIE GARCIA-BRIDGES Non Partisan PARAMOUNT UNIFIED SCHOOL DISTRICT Governing Board Member 8518 1903
21313 ALICIA LINDEN ANDERSON Non Partisan PARAMOUNT UNIFIED SCHOOL DISTRICT Governing Board Member 8518 3136

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