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

results

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

11 rows where candidate_id = 24370

✎ 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
85420 85420 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 0800002A 196 414 610
85424 85424 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 0800003A 259 505 764
85428 85428 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 0800005A 262 470 732
85432 85432 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 0800007A 274 603 877
85436 85436 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 0800010A 33 88 121
85440 85440 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 0800013A 183 393 576
85444 85444 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 0800017B 18 21 39
85448 85448 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 0800021A 166 377 543
85452 85452 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 9990724A 0 0 0
85456 85456 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 9990725A 0 0 0
85460 85460 MIGUEL DE LA ROSA 24370 BELL GARDENS CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 14, 2026) 9780 9990726A 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.42ms · Data source: Los Angeles County Registrar-Recorder/County Clerk