results

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

25 rows where candidate_id = 20795

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
170365 170365 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950001A 63 287 350
170372 170372 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950005B 49 232 281
170379 170379 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950006A 53 214 267
170386 170386 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950009E 1 11 12
170393 170393 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950010A 50 284 334
170400 170400 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950014A 84 409 493
170407 170407 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950018A 32 124 156
170414 170414 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950022A 49 283 332
170421 170421 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950029A 18 102 120
170428 170428 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950132A 59 356 415
170435 170435 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950140A 104 401 505
170442 170442 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950141A 53 311 364
170449 170449 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950146A 67 258 325
170456 170456 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950150A 55 218 273
170463 170463 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950153A 25 123 148
170470 170470 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950163A 86 479 565
170477 170477 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950166B 74 425 499
170484 170484 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950167A 31 92 123
170491 170491 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950168A 44 233 277
170498 170498 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950175A 75 524 599
170505 170505 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950184A 59 259 318
170512 170512 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950185A 79 416 495
170519 170519 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950189A 84 426 510
170526 170526 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950190A 77 434 511
170533 170533 BRIAN J. SMITH 20795 BURBANK UNIFIED SCHOOL DISTRICT Governing Board Member 8439 0950198A 60 496 556

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