results

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

5 rows where candidate_id = 21536

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
225157 225157 MARIA ROSAS 21536 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200001A 34 122 156
225163 225163 MARIA ROSAS 21536 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200011A 31 104 135
225169 225169 MARIA ROSAS 21536 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200013A 41 118 159
225175 225175 MARIA ROSAS 21536 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200014A 30 120 150
225181 225181 MARIA ROSAS 21536 MAYWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8589 4200015A 37 141 178

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