candidates
Data source: Los Angeles County Registrar-Recorder/County Clerk
2 rows where contest_id = 9254
This data as json, CSV (advanced)
id ▼ | name | party | contest_id | total_votes |
---|---|---|---|---|
23135 | VICTOR M. GORDO | Non Partisan | PASADENA CITY PRIMARY ELECTION Mayor 9254 | 26610 |
23136 | ALLEN SHAY | Non Partisan | PASADENA CITY PRIMARY ELECTION Mayor 9254 | 6015 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);