results

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

6 rows where candidate_id = 24271

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
114093 114093 NINA TARNAY 24271 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100017A 396 1851 2247
114099 114099 NINA TARNAY 24271 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100019A 270 1375 1645
114105 114105 NINA TARNAY 24271 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100026A 282 1531 1813
114111 114111 NINA TARNAY 24271 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100040A 316 1550 1866
114117 114117 NINA TARNAY 24271 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100061A 445 1945 2390
114123 114123 NINA TARNAY 24271 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]);