candidates

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

6 rows where contest_id = 8568

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21422 MARTIN U. FUENTES Non Partisan CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 593
21423 ELIZABETH ALCANTAR Non Partisan CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1165
21424 BLANCA LOZOYA Non Partisan CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 483
21425 PATRICIA COVARRUBIAS Non Partisan CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 331
21426 MARIA JIMENEZ Non Partisan CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 339
21427 CYNTHIA GONZALEZ Non Partisan CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 880

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