results

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

5 rows where candidate_id = 20701

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
109499 109499 MEREDITH J. BEACHLY 20701 EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 2250001A 129 487 616
109504 109504 MEREDITH J. BEACHLY 20701 EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 2250003A 103 581 684
109509 109509 MEREDITH J. BEACHLY 20701 EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 2250004A 133 602 735
109514 109514 MEREDITH J. BEACHLY 20701 EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 2250006A 116 502 618
109519 109519 MEREDITH J. BEACHLY 20701 EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 2250011A 130 682 812

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