results

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

27 rows where candidate_id = 21597

✎ 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
190901 190901 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700001A 0 5 5
190903 190903 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700007A 7 10 17
190905 190905 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700007B 16 18 34
190907 190907 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700013A 72 212 284
190909 190909 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700014A 10 27 37
190911 190911 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700018A 69 176 245
190913 190913 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700023C 1 5 6
190915 190915 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700025B 1 5 6
190917 190917 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700025C 83 217 300
190919 190919 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700027A 59 202 261
190921 190921 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700033A 0 1 1
190923 190923 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700033H 0 10 10
190925 190925 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700035A 43 133 176
190927 190927 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700036A 48 163 211
190929 190929 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700039A 125 377 502
190931 190931 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700042A 57 177 234
190933 190933 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700044A 72 186 258
190935 190935 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700045A 30 107 137
190937 190937 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700047A 85 195 280
190939 190939 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700051A 22 48 70
190941 190941 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700051B 0 1 1
190943 190943 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700053A 66 176 242
190945 190945 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700091A 9 26 35
190947 190947 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700092A 67 400 467
190949 190949 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700101A 6 23 29
190951 190951 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700103A 56 136 192
190953 190953 JOHN L. JEFFERSON 21597 HAWTHORNE CITY GENERAL MUNICIPAL ELECTION City Clerk 8581 2700109A 63 213 276

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