results

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

19 rows where candidate_id = 21278

✎ 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
187615 187615 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 1770016B 0 7 7
187620 187620 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 1770019A 1 10 11
187625 187625 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3700042A 79 150 229
187630 187630 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3700042G 3 6 9
187635 187635 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3700046A 109 219 328
187640 187640 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3700049A 103 222 325
187645 187645 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3750005A 87 247 334
187650 187650 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 3750005B 1 11 12
187655 187655 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5000072D 2 14 16
187660 187660 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5000087A 0 0 0
187665 187665 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200001B 6 16 22
187670 187670 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200002C 2 8 10
187675 187675 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200020A 0 10 10
187680 187680 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200044A 25 22 47
187685 187685 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200050A 2 6 8
187690 187690 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200059B 7 4 11
187695 187695 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5200175A 10 18 28
187700 187700 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 5202133A 7 10 17
187705 187705 ANDREW STEVEN RAMIREZ 21278 KEPPEL UNION SCHOOL DISTRICT Governing Board Member 8459 7900005A 61 151 212

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