results

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

8 rows where candidate_id = 20743

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
245268 245268 NO 20743 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION - MEASURE MB 8839 4100005A 288 1088 1376
245270 245270 NO 20743 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION - MEASURE MB 8839 4100014A 388 1817 2205
245272 245272 NO 20743 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION - MEASURE MB 8839 4100017A 328 1631 1959
245274 245274 NO 20743 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION - MEASURE MB 8839 4100028A 304 1706 2010
245276 245276 NO 20743 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION - MEASURE MB 8839 4100034A 272 1143 1415
245278 245278 NO 20743 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION - MEASURE MB 8839 4100040A 264 1101 1365
245280 245280 NO 20743 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION - MEASURE MB 8839 4100050A 255 895 1150
245282 245282 NO 20743 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION - MEASURE MB 8839 4100061A 396 1517 1913

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