results

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

8 rows where candidate_id = 21489

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
164202 164202 FRANK CHIELLA 21489 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 4100005A 102 344 446
164209 164209 FRANK CHIELLA 21489 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 4100014A 143 404 547
164216 164216 FRANK CHIELLA 21489 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 4100017A 105 332 437
164223 164223 FRANK CHIELLA 21489 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 4100028A 106 438 544
164230 164230 FRANK CHIELLA 21489 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 4100034A 83 255 338
164237 164237 FRANK CHIELLA 21489 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 4100040A 85 248 333
164244 164244 FRANK CHIELLA 21489 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 4100050A 108 342 450
164251 164251 FRANK CHIELLA 21489 MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 4100061A 130 364 494

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