candidates

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

4 rows where contest_id = 9700

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24338 LUCIANO A. AGUILAR Non Partisan HAWTHORNE CITY GENERAL MUNICIPAL ELECTION Mayor 9700 4639
24339 L. DAVID PATTERSON Non Partisan HAWTHORNE CITY GENERAL MUNICIPAL ELECTION Mayor 9700 7366
24343 ALEX VARGAS Non Partisan HAWTHORNE CITY GENERAL MUNICIPAL ELECTION Mayor 9700 11100
24346 LEITHELLE WILLIAMS Non Partisan HAWTHORNE CITY GENERAL MUNICIPAL ELECTION Mayor 9700 1020

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