results

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

6 rows where candidate_id = 24284

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
233424 233424 MICHAEL M. BROWN 24284 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600012A 140 400 540
233430 233430 MICHAEL M. BROWN 24284 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600030A 82 320 402
233436 233436 MICHAEL M. BROWN 24284 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600031C 108 323 431
233442 233442 MICHAEL M. BROWN 24284 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600032A 156 587 743
233448 233448 MICHAEL M. BROWN 24284 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600033A 124 423 547
233454 233454 MICHAEL M. BROWN 24284 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 9990608A 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]);