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

results

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

11 rows where candidate_id = 21756

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
324474 324474 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 2020006A 32 215 247
324476 324476 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 2020016A 42 107 149
324478 324478 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 5150022A 104 494 598
324480 324480 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 5150065B 113 743 856
324482 324482 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 5150074D 36 163 199
324484 324484 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 5150081B 2 3 5
324486 324486 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 5150109A 42 348 390
324488 324488 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 5150124A 106 616 722
324490 324490 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 5150186B 127 580 707
324492 324492 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 5150209A 105 687 792
324494 324494 PATRICE MARSHALL MCKENZIE 21756 PASADENA UNIFIED SCHOOL DISTRICT Board of Education, District No. 5 8705 6200006C 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]);
Powered by Datasette · Queries took 10.863ms · Data source: Los Angeles County Registrar-Recorder/County Clerk