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

results

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

16 rows where contest_id = 9004

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
169874 169874 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 0300016A 3 9 12
169875 169875 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 0300016A 3 9 12
169876 169876 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 3700048A 0 0 0
169877 169877 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 3700048A 1 1 2
169878 169878 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 3750003A 1 8 9
169879 169879 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 3750003A 0 14 14
169880 169880 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 3750005A 41 143 184
169881 169881 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 3750005A 8 63 71
169882 169882 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 5200043A 89 152 241
169883 169883 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 5200043A 5 131 136
169884 169884 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900007B 5 25 30
169885 169885 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900007B 2 15 17
169886 169886 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900008A 119 163 282
169887 169887 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900008A 51 250 301
169888 169888 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900009A 126 202 328
169889 169889 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900009A 45 266 311

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