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

results

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

5 rows where candidate_id = 24422

✎ 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
231327 231327 MONICA MANALO 24422 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 0400001A 186 607 793
231331 231331 MONICA MANALO 24422 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 0400004A 248 832 1080
231335 231335 MONICA MANALO 24422 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 0400010A 60 167 227
231339 231339 MONICA MANALO 24422 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 9990876A 0 0 0
231343 231343 MONICA MANALO 24422 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 9990877A 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 9.973ms · Data source: Los Angeles County Registrar-Recorder/County Clerk