candidates

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

2 rows where contest_id = 8697

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21560 JOSE SANCHEZ Non Partisan MONTEREY PARK CITY SPECIAL MUNICIPAL ELECTION Member of the City Council, 3rd District (Unexpired term ending November 5, 2024) 8697 1462
21564 TAMMY C. WONG Non Partisan MONTEREY PARK CITY SPECIAL MUNICIPAL ELECTION Member of the City Council, 3rd District (Unexpired term ending November 5, 2024) 8697 868

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