home / la-county-general-election-results-2022

results

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

12 rows where candidate_id = 21750

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
148993 148993 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 0200002A 24 63 87
148996 148996 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 0200013A 33 116 149
148999 148999 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 0200014A 38 105 143
149002 149002 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 0200017A 29 111 140
149005 149005 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 0200019B 22 81 103
149008 149008 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 0200051A 16 63 79
149011 149011 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 0200087A 42 141 183
149014 149014 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 0200088A 43 130 173
149017 149017 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 0200091A 18 62 80
149020 149020 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 5150002A 4 3 7
149023 149023 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 5150002U 3 7 10
149026 149026 RITA MILLER 21750 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 1 8703 5150055A 9 13 22

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]);
Powered by Datasette · Queries took 11.264ms · Data source: Los Angeles County Registrar-Recorder/County Clerk