results

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

15 rows where contest_id = 8671

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
243903 243903 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550001B 67 262 329
243904 243904 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550002B 211 610 821
243905 243905 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550006A 85 436 521
243906 243906 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550008A 293 571 864
243907 243907 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550009B 204 618 822
243908 243908 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550010C 4 0 4
243909 243909 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550010G 12 53 65
243910 243910 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550012A 63 188 251
243911 243911 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550019A 6 38 44
243912 243912 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550023F 5 21 26
243913 243913 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550024A 29 117 146
243914 243914 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550025B 189 490 679
243915 243915 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550075A 312 912 1224
243916 243916 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550080A 209 498 707
243917 243917 JEFFREY LAWRENCE CORNEJO, JR. 21383 AZUSA CITY GENERAL MUNICIPAL ELECTION City Clerk 8671 0550086A 78 291 369

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