results

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

8 rows where candidate_id = 21840

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
187443 187443 BOBBY BROWN 21840 INGLEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8860 2950027A 19 62 81
187445 187445 BOBBY BROWN 21840 INGLEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8860 2950042A 94 286 380
187447 187447 BOBBY BROWN 21840 INGLEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8860 2950069A 57 187 244
187449 187449 BOBBY BROWN 21840 INGLEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8860 2950081A 65 209 274
187451 187451 BOBBY BROWN 21840 INGLEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8860 2950082A 19 99 118
187453 187453 BOBBY BROWN 21840 INGLEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8860 2950084A 69 311 380
187455 187455 BOBBY BROWN 21840 INGLEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8860 2950088A 86 352 438
187457 187457 BOBBY BROWN 21840 INGLEWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8860 2950090A 1 8 9

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]);