results

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

3,988 rows where candidate_id = 23712

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
172802 172802 YES 23712 STATE MEASURE 2 9878 0050002B 31 0 31
172804 172804 YES 23712 STATE MEASURE 2 9878 0050002G 1 0 1
172806 172806 YES 23712 STATE MEASURE 2 9878 0050003A 116 211 327
172808 172808 YES 23712 STATE MEASURE 2 9878 0050005A 267 509 776
172810 172810 YES 23712 STATE MEASURE 2 9878 0050007B 0 0 0
172812 172812 YES 23712 STATE MEASURE 2 9878 0050010A 2 0 2
172814 172814 YES 23712 STATE MEASURE 2 9878 0050014A 51 108 159
172816 172816 YES 23712 STATE MEASURE 2 9878 0050015A 0 0 0
172818 172818 YES 23712 STATE MEASURE 2 9878 0050022D 0 2 2
172820 172820 YES 23712 STATE MEASURE 2 9878 0050023D 0 0 0
172822 172822 YES 23712 STATE MEASURE 2 9878 0050025H 0 0 0
172824 172824 YES 23712 STATE MEASURE 2 9878 0050027A 0 0 0
172826 172826 YES 23712 STATE MEASURE 2 9878 0050029A 0 0 0
172828 172828 YES 23712 STATE MEASURE 2 9878 0050037A 0 0 0
172830 172830 YES 23712 STATE MEASURE 2 9878 0050042A 1 0 1
172832 172832 YES 23712 STATE MEASURE 2 9878 0050055A 0 0 0
172834 172834 YES 23712 STATE MEASURE 2 9878 0050066A 0 0 0
172836 172836 YES 23712 STATE MEASURE 2 9878 0070001A 64 232 296
172838 172838 YES 23712 STATE MEASURE 2 9878 0070002A 7 25 32
172840 172840 YES 23712 STATE MEASURE 2 9878 0070005A 99 376 475
172842 172842 YES 23712 STATE MEASURE 2 9878 0070005B 2 3 5
172844 172844 YES 23712 STATE MEASURE 2 9878 0070006A 158 511 669
172846 172846 YES 23712 STATE MEASURE 2 9878 0070027A 0 0 0
172848 172848 YES 23712 STATE MEASURE 2 9878 0070027B 0 1 1
172850 172850 YES 23712 STATE MEASURE 2 9878 0070027C 0 0 0
172852 172852 YES 23712 STATE MEASURE 2 9878 0070041B 21 57 78
172854 172854 YES 23712 STATE MEASURE 2 9878 0070041F 4 7 11
172856 172856 YES 23712 STATE MEASURE 2 9878 0070207A 0 13 13
172858 172858 YES 23712 STATE MEASURE 2 9878 0080004A 137 804 941
172860 172860 YES 23712 STATE MEASURE 2 9878 0080007A 286 1185 1471
172862 172862 YES 23712 STATE MEASURE 2 9878 0080050A 371 1406 1777
172864 172864 YES 23712 STATE MEASURE 2 9878 0080054A 140 468 608
172866 172866 YES 23712 STATE MEASURE 2 9878 0080070A 193 1019 1212
172868 172868 YES 23712 STATE MEASURE 2 9878 0090002A 1 0 1
172870 172870 YES 23712 STATE MEASURE 2 9878 0090002B 0 1 1
172872 172872 YES 23712 STATE MEASURE 2 9878 0090002C 0 0 0
172874 172874 YES 23712 STATE MEASURE 2 9878 0090005C 0 0 0
172876 172876 YES 23712 STATE MEASURE 2 9878 0090005G 0 0 0
172878 172878 YES 23712 STATE MEASURE 2 9878 0090006A 6 12 18
172880 172880 YES 23712 STATE MEASURE 2 9878 0090007C 0 1 1
172882 172882 YES 23712 STATE MEASURE 2 9878 0090009A 0 0 0
172884 172884 YES 23712 STATE MEASURE 2 9878 0090010A 0 0 0
172886 172886 YES 23712 STATE MEASURE 2 9878 0090011B 2 5 7
172888 172888 YES 23712 STATE MEASURE 2 9878 0090012A 0 0 0
172890 172890 YES 23712 STATE MEASURE 2 9878 0090017A 0 0 0
172892 172892 YES 23712 STATE MEASURE 2 9878 0090019A 0 0 0
172894 172894 YES 23712 STATE MEASURE 2 9878 0090021A 0 0 0
172896 172896 YES 23712 STATE MEASURE 2 9878 0090023A 0 0 0
172898 172898 YES 23712 STATE MEASURE 2 9878 0090025A 1 4 5
172900 172900 YES 23712 STATE MEASURE 2 9878 0090025B 0 0 0
172902 172902 YES 23712 STATE MEASURE 2 9878 0090026A 152 460 612
172904 172904 YES 23712 STATE MEASURE 2 9878 0150003A 440 1576 2016
172906 172906 YES 23712 STATE MEASURE 2 9878 0150005D 0 2 2
172908 172908 YES 23712 STATE MEASURE 2 9878 0150005E 0 2 2
172910 172910 YES 23712 STATE MEASURE 2 9878 0150012A 405 1349 1754
172912 172912 YES 23712 STATE MEASURE 2 9878 0150016D 431 1282 1713
172914 172914 YES 23712 STATE MEASURE 2 9878 0150023A 292 918 1210
172916 172916 YES 23712 STATE MEASURE 2 9878 0150025A 354 891 1245
172918 172918 YES 23712 STATE MEASURE 2 9878 0150032B 4 10 14
172920 172920 YES 23712 STATE MEASURE 2 9878 0150034A 285 1053 1338
172922 172922 YES 23712 STATE MEASURE 2 9878 0150042A 169 551 720
172924 172924 YES 23712 STATE MEASURE 2 9878 0150045A 281 867 1148
172926 172926 YES 23712 STATE MEASURE 2 9878 0150049A 71 281 352
172928 172928 YES 23712 STATE MEASURE 2 9878 0150055A 30 144 174
172930 172930 YES 23712 STATE MEASURE 2 9878 0150065A 353 1014 1367
172932 172932 YES 23712 STATE MEASURE 2 9878 0150070A 56 195 251
172934 172934 YES 23712 STATE MEASURE 2 9878 0150071A 331 1057 1388
172936 172936 YES 23712 STATE MEASURE 2 9878 0150078A 90 222 312
172938 172938 YES 23712 STATE MEASURE 2 9878 0150079A 179 619 798
172940 172940 YES 23712 STATE MEASURE 2 9878 0150082A 331 802 1133
172942 172942 YES 23712 STATE MEASURE 2 9878 0150085A 106 299 405
172944 172944 YES 23712 STATE MEASURE 2 9878 0180002A 135 290 425
172946 172946 YES 23712 STATE MEASURE 2 9878 0200005A 373 1599 1972
172948 172948 YES 23712 STATE MEASURE 2 9878 0200015A 455 1188 1643
172950 172950 YES 23712 STATE MEASURE 2 9878 0200016A 331 1733 2064
172952 172952 YES 23712 STATE MEASURE 2 9878 0200018A 69 214 283
172954 172954 YES 23712 STATE MEASURE 2 9878 0200019A 230 827 1057
172956 172956 YES 23712 STATE MEASURE 2 9878 0200025B 256 1186 1442
172958 172958 YES 23712 STATE MEASURE 2 9878 0200027A 0 0 0
172960 172960 YES 23712 STATE MEASURE 2 9878 0200029A 141 679 820
172962 172962 YES 23712 STATE MEASURE 2 9878 0200030C 0 0 0
172964 172964 YES 23712 STATE MEASURE 2 9878 0200031A 0 3 3
172966 172966 YES 23712 STATE MEASURE 2 9878 0200040A 431 1518 1949
172968 172968 YES 23712 STATE MEASURE 2 9878 0200041A 0 0 0
172970 172970 YES 23712 STATE MEASURE 2 9878 0200046A 276 774 1050
172972 172972 YES 23712 STATE MEASURE 2 9878 0200048A 0 0 0
172974 172974 YES 23712 STATE MEASURE 2 9878 0200053A 0 0 0
172976 172976 YES 23712 STATE MEASURE 2 9878 0200064A 65 257 322
172978 172978 YES 23712 STATE MEASURE 2 9878 0200087A 445 1699 2144
172980 172980 YES 23712 STATE MEASURE 2 9878 0200094A 0 0 0
172982 172982 YES 23712 STATE MEASURE 2 9878 0200094H 0 0 0
172984 172984 YES 23712 STATE MEASURE 2 9878 0300001D 1 5 6
172986 172986 YES 23712 STATE MEASURE 2 9878 0300001G 22 24 46
172988 172988 YES 23712 STATE MEASURE 2 9878 0300002A 15 40 55
172990 172990 YES 23712 STATE MEASURE 2 9878 0300002B 1 4 5
172992 172992 YES 23712 STATE MEASURE 2 9878 0300002C 2 6 8
172994 172994 YES 23712 STATE MEASURE 2 9878 0300003A 3 7 10
172996 172996 YES 23712 STATE MEASURE 2 9878 0300005A 0 0 0
172998 172998 YES 23712 STATE MEASURE 2 9878 0300006B 0 0 0
173000 173000 YES 23712 STATE MEASURE 2 9878 0300012A 14 40 54

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