results

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

9 rows where candidate_id = 21516

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
62944 62944 RICHARD J. ROJO 21516 EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8675 2100011A 6 43 49
62946 62946 RICHARD J. ROJO 21516 EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8675 2100013A 34 154 188
62948 62948 RICHARD J. ROJO 21516 EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8675 2100014A 11 19 30
62950 62950 RICHARD J. ROJO 21516 EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8675 2100034G 9 51 60
62952 62952 RICHARD J. ROJO 21516 EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8675 2100115C 0 1 1
62954 62954 RICHARD J. ROJO 21516 EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8675 2100115E 10 28 38
62956 62956 RICHARD J. ROJO 21516 EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8675 2100115F 3 23 26
62958 62958 RICHARD J. ROJO 21516 EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8675 2100118B 3 24 27
62960 62960 RICHARD J. ROJO 21516 EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8675 2100119A 57 178 235

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