candidates

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

13 rows where contest_id = 9311

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
22131 JEFF SCHWARTZ Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 2098
22133 ADELE F. ANDRADE-STADLER Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 10721
22511 JEFFERSON CRAIN Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 5988
22602 THOMAS WONG Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 10846
22620 PAUL COLE PADILLA Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 8996
22628 MELISSA MIA MICHELSON Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 8654
22635 KATIE CHAN Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 11975
22636 SAMANTHA LAU Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 10841
22673 ALTON WANG Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 11218
22699 HENRY LO Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 10498
22807 PATRICIA HERNANDEZ Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 13595
22986 MICHAEL A. SOTO Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 7344
22987 MELISSA CERVANTES Democratic MEMBER, COUNTY CENTRAL COMMITTEE, 49TH ASSEMBLY DISTRICT - DEMOCRATIC 9311 9197

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