results

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

6 rows where candidate_id = 24267

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
114092 114092 JOE FRANKLIN 24267 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100017A 609 2126 2735
114098 114098 JOE FRANKLIN 24267 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100019A 440 1669 2109
114104 114104 JOE FRANKLIN 24267 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100026A 417 1812 2229
114110 114110 JOE FRANKLIN 24267 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100040A 448 1607 2055
114116 114116 JOE FRANKLIN 24267 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4100061A 576 1895 2471
114122 114122 JOE FRANKLIN 24267 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]);