results

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

6 rows where candidate_id = 24333

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
200669 200669 SYLVIA BALLIN 24333 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050005A 62 177 239
200674 200674 SYLVIA BALLIN 24333 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050009A 63 171 234
200679 200679 SYLVIA BALLIN 24333 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050012A 60 208 268
200684 200684 SYLVIA BALLIN 24333 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050016A 146 287 433
200689 200689 SYLVIA BALLIN 24333 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 6050020A 91 306 397
200694 200694 SYLVIA BALLIN 24333 SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9737 9990252A 0 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [results] (
   [candidate_id] INTEGER REFERENCES [candidates]([id]),
   [contest_id] INTEGER REFERENCES [contests]([id]),
   [precinct_id] TEXT REFERENCES [precincts]([precinct]),
   [polling_place] INTEGER,
   [vote_by_mail] INTEGER,
   [total] INTEGER
);
CREATE INDEX [idx_results_precinct_id]
    ON [results] ([precinct_id]);
CREATE INDEX [idx_results_contest_id]
    ON [results] ([contest_id]);
CREATE INDEX [idx_results_candidate_id]
    ON [results] ([candidate_id]);