results

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

6 rows where candidate_id = 24268

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
114096 114096 KAREN KOMATINSKY 24268 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100017A 238 1250 1488
114102 114102 KAREN KOMATINSKY 24268 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100019A 215 1126 1341
114108 114108 KAREN KOMATINSKY 24268 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100026A 221 1193 1414
114114 114114 KAREN KOMATINSKY 24268 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100040A 248 1278 1526
114120 114120 KAREN KOMATINSKY 24268 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100061A 236 1036 1272
114126 114126 KAREN KOMATINSKY 24268 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 9990846A 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]);