results

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

2,990 rows where candidate_id = 20566

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
75854 75854 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0050001B 14 27 41
75856 75856 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0050002C 1 0 1
75858 75858 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0050003A 37 242 279
75860 75860 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0050004B 5 64 69
75862 75862 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0050011A 0 0 0
75864 75864 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0050014A 16 100 116
75866 75866 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0050023A 0 0 0
75868 75868 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0050042A 0 1 1
75870 75870 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0050063A 56 306 362
75872 75872 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070001B 2 26 28
75874 75874 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070002A 0 28 28
75876 75876 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070004C 2 19 21
75878 75878 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070004E 14 98 112
75880 75880 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070006N 8 18 26
75882 75882 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070007A 54 350 404
75884 75884 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070008A 27 201 228
75886 75886 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070027B 0 2 2
75888 75888 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070041A 50 324 374
75890 75890 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070041B 9 94 103
75892 75892 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070041K 1 7 8
75894 75894 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0070207A 1 15 16
75896 75896 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0080004A 96 689 785
75898 75898 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0080012A 57 716 773
75900 75900 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0080021A 113 962 1075
75902 75902 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0080025A 72 665 737
75904 75904 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0080038A 73 451 524
75906 75906 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0080043A 74 615 689
75908 75908 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0080050A 96 687 783
75910 75910 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0090002B 0 3 3
75912 75912 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0090003A 72 409 481
75914 75914 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0090006A 2 10 12
75916 75916 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0090011A 0 10 10
75918 75918 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0090025A 1 4 5
75920 75920 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150004A 105 767 872
75922 75922 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150008A 83 308 391
75924 75924 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150009A 84 425 509
75926 75926 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150011A 83 631 714
75928 75928 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150012A 115 704 819
75930 75930 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150016D 121 790 911
75932 75932 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150018A 152 880 1032
75934 75934 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150021A 36 332 368
75936 75936 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150025A 111 563 674
75938 75938 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150028B 44 346 390
75940 75940 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150032A 133 613 746
75942 75942 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150033A 94 421 515
75944 75944 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150037A 51 351 402
75946 75946 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150042A 71 540 611
75948 75948 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150049A 102 561 663
75950 75950 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150060A 54 386 440
75952 75952 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150065A 77 300 377
75954 75954 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150067A 130 615 745
75956 75956 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150070A 28 151 179
75958 75958 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0150071A 48 362 410
75960 75960 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0180002A 38 151 189
75962 75962 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200002A 94 531 625
75964 75964 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200007B 8 69 77
75966 75966 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200013A 197 1190 1387
75968 75968 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200014A 197 892 1089
75970 75970 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200016A 148 865 1013
75972 75972 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200017A 110 642 752
75974 75974 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200019B 123 717 840
75976 75976 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200028A 126 762 888
75978 75978 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200030A 220 1498 1718
75980 75980 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200031A 0 3 3
75982 75982 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200040A 132 880 1012
75984 75984 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200051A 94 677 771
75986 75986 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200087A 235 1203 1438
75988 75988 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200088A 193 1213 1406
75990 75990 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0200091A 115 648 763
75992 75992 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0300001D 5 12 17
75994 75994 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0300002A 4 18 22
75996 75996 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0300002B 2 4 6
75998 75998 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0300002D 0 0 0
76000 76000 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0300003A 0 9 9
76002 76002 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0300013A 5 36 41
76004 76004 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350005B 8 149 157
76006 76006 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350007A 38 516 554
76008 76008 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350008A 62 693 755
76010 76010 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350012A 47 281 328
76012 76012 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350017A 60 701 761
76014 76014 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350022A 117 678 795
76016 76016 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350027A 63 393 456
76018 76018 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350029A 73 649 722
76020 76020 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350038A 21 161 182
76022 76022 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350043A 69 525 594
76024 76024 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350049A 59 525 584
76026 76026 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350052A 1 7 8
76028 76028 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350057A 31 222 253
76030 76030 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350058C 78 711 789
76032 76032 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350061A 1 8 9
76034 76034 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350101A 0 0 0
76036 76036 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350102A 27 184 211
76038 76038 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350104E 2 24 26
76040 76040 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350105A 0 9 9
76042 76042 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350106A 0 15 15
76044 76044 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0350106B 5 24 29
76046 76046 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0400001A 43 201 244
76048 76048 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0400006A 96 353 449
76050 76050 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0400008A 95 360 455
76052 76052 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0400010A 114 627 741

Next page

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