candidates

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

7 rows where contest_id = 8973

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21789 STEVEN JONES Non Partisan SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 667
21790 GRETCHEN SHEPHERD ROMEY Non Partisan SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 2507
21791 GRANT FUJIWARA Non Partisan SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 989
21792 CALVIN LO Non Partisan SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 2220
21793 TONY CHOU Non Partisan SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 2329
21794 SUBHADRA SU VISWANATHAN Non Partisan SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 1458
21795 DIANA MILKIE NIXON Non Partisan SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 871

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