results

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

21 rows where candidate_id = 21074

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
85220 85220 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350005B 23 234 257
85222 85222 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350007A 67 670 737
85224 85224 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350008A 96 917 1013
85226 85226 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350012A 57 324 381
85228 85228 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350017A 74 859 933
85230 85230 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350022A 111 661 772
85232 85232 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350027A 80 406 486
85234 85234 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350029A 111 904 1015
85236 85236 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350038A 34 196 230
85238 85238 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350043A 83 574 657
85240 85240 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350049A 77 741 818
85242 85242 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350052A 0 5 5
85244 85244 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350057A 53 315 368
85246 85246 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350058C 99 966 1065
85248 85248 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350061A 4 5 9
85250 85250 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350101A 0 0 0
85252 85252 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350102A 30 213 243
85254 85254 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350104E 1 27 28
85256 85256 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350105A 2 10 12
85258 85258 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350106A 3 29 32
85260 85260 YES 21074 ARCADIA CITY GENERAL MUNICIPAL ELECTION - MEASURE SW 8898 0350106B 5 18 23

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