candidates

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

5 rows where contest_id = 9617

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23582 ALMA CARINA CASTRO Non Partisan LYNWOOD UNIFIED SCHOOL DISTRICT Governing Board Member 9617 7035
23699 GARY HARDIE JR. Non Partisan LYNWOOD UNIFIED SCHOOL DISTRICT Governing Board Member 9617 6043
23772 MARIA G. LÓPEZ Non Partisan LYNWOOD UNIFIED SCHOOL DISTRICT Governing Board Member 9617 7724
23897 JORGE A. CASANOVA Non Partisan LYNWOOD UNIFIED SCHOOL DISTRICT Governing Board Member 9617 4740
24009 MARICRUZ SANCHEZ Non Partisan LYNWOOD UNIFIED SCHOOL DISTRICT Governing Board Member 9617 5258

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