results

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

19 rows where candidate_id = 20724

✎ 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
187618 187618 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 1770016B 0 3 3
187623 187623 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 1770019A 0 6 6
187628 187628 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3700042A 38 104 142
187633 187633 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3700042G 0 9 9
187638 187638 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3700046A 60 164 224
187643 187643 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3700049A 47 152 199
187648 187648 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3750005A 37 197 234
187653 187653 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3750005B 0 11 11
187658 187658 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5000072D 1 9 10
187663 187663 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5000087A 0 0 0
187668 187668 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200001B 2 20 22
187673 187673 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200002C 1 3 4
187678 187678 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200020A 0 11 11
187683 187683 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200044A 8 28 36
187688 187688 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200050A 1 4 5
187693 187693 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200059B 3 1 4
187698 187698 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200175A 5 8 13
187703 187703 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5202133A 4 13 17
187708 187708 GEORGIA HALLIMAN 20724 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 7900005A 26 107 133

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