candidates

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

8 rows where contest_id = 9556

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23733 CHRISTINA M. LUCERO Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT Governing Board Member 9556 5238
23864 DIANA E. MIRANDA-DZIB Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT Governing Board Member 9556 4338
23872 SANTOS HERNANDEZ JR. Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT Governing Board Member 9556 4088
23886 RICARDO VAZQUES Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT Governing Board Member 9556 7012
23968 YVONNE S. JUAREZ Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT Governing Board Member 9556 6493
23995 KEVIN PATRICK ROONEY Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT Governing Board Member 9556 1862
24019 JOSE MARI MATA Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT Governing Board Member 9556 5982
24041 ITZEL GUADALUPE HERRERA Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT Governing Board Member 9556 2103

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