home / la-county-primary-election-results-2024

results

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

6 rows where candidate_id = 23118

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
127837 127837 VICTORIA GARCIA 23118 SAN FERNANDO CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 3, 2024) 9414 6050001A 37 91 128
127840 127840 VICTORIA GARCIA 23118 SAN FERNANDO CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 3, 2024) 9414 6050002A 36 84 120
127843 127843 VICTORIA GARCIA 23118 SAN FERNANDO CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 3, 2024) 9414 6050005A 70 120 190
127846 127846 VICTORIA GARCIA 23118 SAN FERNANDO CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 3, 2024) 9414 6050009A 47 103 150
127849 127849 VICTORIA GARCIA 23118 SAN FERNANDO CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 3, 2024) 9414 6050012A 57 96 153
127852 127852 VICTORIA GARCIA 23118 SAN FERNANDO CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 3, 2024) 9414 6050020A 79 161 240

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.594ms · Data source: Los Angeles County Registrar-Recorder/County Clerk