results

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

18 rows where candidate_id = 23800

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
250765 250765 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 3300070B 0 0 0
250768 250768 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 6230052K 0 0 0
250771 250771 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 6700005A 192 361 553
250774 250774 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 6700024A 24 47 71
250777 250777 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 6700025A 75 85 160
250780 250780 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 6700030B 180 365 545
250783 250783 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 6700045A 48 50 98
250786 250786 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 6700053C 11 13 24
250789 250789 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 6700063A 12 20 32
250792 250792 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 6700072A 53 82 135
250795 250795 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 9990740A 0 0 0
250798 250798 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 9990746A 0 0 0
250801 250801 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 9990747A 0 0 0
250804 250804 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 9990753A 0 0 0
250807 250807 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 9990754A 0 0 0
250810 250810 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 9990755A 0 0 0
250813 250813 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 9990756A 0 0 0
250816 250816 FRANK AGUIRRE JR. 23800 ORCHARD DALE WATER DISTRICT Member, Board of Directors 9435 9990770A 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]);