results

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

7,976 rows where contest_id = 9873

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
105990 105990 YES 23599 STATE MEASURE 35 9873 0050002B 30 0 30
105991 105991 NO 23600 STATE MEASURE 35 9873 0050002B 11 1 12
105992 105992 YES 23599 STATE MEASURE 35 9873 0050002G 1 0 1
105993 105993 NO 23600 STATE MEASURE 35 9873 0050002G 0 0 0
105994 105994 YES 23599 STATE MEASURE 35 9873 0050003A 167 339 506
105995 105995 NO 23600 STATE MEASURE 35 9873 0050003A 321 359 680
105996 105996 YES 23599 STATE MEASURE 35 9873 0050005A 390 789 1179
105997 105997 NO 23600 STATE MEASURE 35 9873 0050005A 639 688 1327
105998 105998 YES 23599 STATE MEASURE 35 9873 0050007B 0 0 0
105999 105999 NO 23600 STATE MEASURE 35 9873 0050007B 0 0 0
106000 106000 YES 23599 STATE MEASURE 35 9873 0050010A 2 0 2
106001 106001 NO 23600 STATE MEASURE 35 9873 0050010A 0 0 0
106002 106002 YES 23599 STATE MEASURE 35 9873 0050014A 58 160 218
106003 106003 NO 23600 STATE MEASURE 35 9873 0050014A 112 164 276
106004 106004 YES 23599 STATE MEASURE 35 9873 0050015A 0 0 0
106005 106005 NO 23600 STATE MEASURE 35 9873 0050015A 1 0 1
106006 106006 YES 23599 STATE MEASURE 35 9873 0050022D 0 2 2
106007 106007 NO 23600 STATE MEASURE 35 9873 0050022D 0 0 0
106008 106008 YES 23599 STATE MEASURE 35 9873 0050023D 0 0 0
106009 106009 NO 23600 STATE MEASURE 35 9873 0050023D 0 0 0
106010 106010 YES 23599 STATE MEASURE 35 9873 0050025H 0 0 0
106011 106011 NO 23600 STATE MEASURE 35 9873 0050025H 0 0 0
106012 106012 YES 23599 STATE MEASURE 35 9873 0050027A 1 0 1
106013 106013 NO 23600 STATE MEASURE 35 9873 0050027A 0 0 0
106014 106014 YES 23599 STATE MEASURE 35 9873 0050029A 0 0 0
106015 106015 NO 23600 STATE MEASURE 35 9873 0050029A 0 0 0
106016 106016 YES 23599 STATE MEASURE 35 9873 0050037A 0 0 0
106017 106017 NO 23600 STATE MEASURE 35 9873 0050037A 0 0 0
106018 106018 YES 23599 STATE MEASURE 35 9873 0050042A 1 0 1
106019 106019 NO 23600 STATE MEASURE 35 9873 0050042A 0 2 2
106020 106020 YES 23599 STATE MEASURE 35 9873 0050055A 0 0 0
106021 106021 NO 23600 STATE MEASURE 35 9873 0050055A 0 0 0
106022 106022 YES 23599 STATE MEASURE 35 9873 0050066A 0 0 0
106023 106023 NO 23600 STATE MEASURE 35 9873 0050066A 0 0 0
106024 106024 YES 23599 STATE MEASURE 35 9873 0070001A 76 321 397
106025 106025 NO 23600 STATE MEASURE 35 9873 0070001A 113 190 303
106026 106026 YES 23599 STATE MEASURE 35 9873 0070002A 4 29 33
106027 106027 NO 23600 STATE MEASURE 35 9873 0070002A 9 21 30
106028 106028 YES 23599 STATE MEASURE 35 9873 0070005A 117 500 617
106029 106029 NO 23600 STATE MEASURE 35 9873 0070005A 125 285 410
106030 106030 YES 23599 STATE MEASURE 35 9873 0070005B 3 2 5
106031 106031 NO 23600 STATE MEASURE 35 9873 0070005B 1 4 5
106032 106032 YES 23599 STATE MEASURE 35 9873 0070006A 177 534 711
106033 106033 NO 23600 STATE MEASURE 35 9873 0070006A 152 356 508
106034 106034 YES 23599 STATE MEASURE 35 9873 0070027A 0 0 0
106035 106035 NO 23600 STATE MEASURE 35 9873 0070027A 0 0 0
106036 106036 YES 23599 STATE MEASURE 35 9873 0070027B 2 1 3
106037 106037 NO 23600 STATE MEASURE 35 9873 0070027B 0 0 0
106038 106038 YES 23599 STATE MEASURE 35 9873 0070027C 0 0 0
106039 106039 NO 23600 STATE MEASURE 35 9873 0070027C 0 0 0
106040 106040 YES 23599 STATE MEASURE 35 9873 0070041B 16 59 75
106041 106041 NO 23600 STATE MEASURE 35 9873 0070041B 22 40 62
106042 106042 YES 23599 STATE MEASURE 35 9873 0070041F 3 11 14
106043 106043 NO 23600 STATE MEASURE 35 9873 0070041F 7 2 9
106044 106044 YES 23599 STATE MEASURE 35 9873 0070207A 1 13 14
106045 106045 NO 23600 STATE MEASURE 35 9873 0070207A 5 18 23
106046 106046 YES 23599 STATE MEASURE 35 9873 0080004A 197 914 1111
106047 106047 NO 23600 STATE MEASURE 35 9873 0080004A 184 500 684
106048 106048 YES 23599 STATE MEASURE 35 9873 0080007A 340 1375 1715
106049 106049 NO 23600 STATE MEASURE 35 9873 0080007A 267 723 990
106050 106050 YES 23599 STATE MEASURE 35 9873 0080050A 405 1549 1954
106051 106051 NO 23600 STATE MEASURE 35 9873 0080050A 373 886 1259
106052 106052 YES 23599 STATE MEASURE 35 9873 0080054A 179 563 742
106053 106053 NO 23600 STATE MEASURE 35 9873 0080054A 138 313 451
106054 106054 YES 23599 STATE MEASURE 35 9873 0080070A 219 1143 1362
106055 106055 NO 23600 STATE MEASURE 35 9873 0080070A 261 727 988
106056 106056 YES 23599 STATE MEASURE 35 9873 0090002A 1 0 1
106057 106057 NO 23600 STATE MEASURE 35 9873 0090002A 0 0 0
106058 106058 YES 23599 STATE MEASURE 35 9873 0090002B 0 1 1
106059 106059 NO 23600 STATE MEASURE 35 9873 0090002B 0 6 6
106060 106060 YES 23599 STATE MEASURE 35 9873 0090002C 0 0 0
106061 106061 NO 23600 STATE MEASURE 35 9873 0090002C 0 0 0
106062 106062 YES 23599 STATE MEASURE 35 9873 0090005C 0 0 0
106063 106063 NO 23600 STATE MEASURE 35 9873 0090005C 0 0 0
106064 106064 YES 23599 STATE MEASURE 35 9873 0090005G 0 0 0
106065 106065 NO 23600 STATE MEASURE 35 9873 0090005G 0 1 1
106066 106066 YES 23599 STATE MEASURE 35 9873 0090006A 9 9 18
106067 106067 NO 23600 STATE MEASURE 35 9873 0090006A 8 8 16
106068 106068 YES 23599 STATE MEASURE 35 9873 0090007C 0 1 1
106069 106069 NO 23600 STATE MEASURE 35 9873 0090007C 0 0 0
106070 106070 YES 23599 STATE MEASURE 35 9873 0090009A 0 0 0
106071 106071 NO 23600 STATE MEASURE 35 9873 0090009A 0 0 0
106072 106072 YES 23599 STATE MEASURE 35 9873 0090010A 0 0 0
106073 106073 NO 23600 STATE MEASURE 35 9873 0090010A 0 0 0
106074 106074 YES 23599 STATE MEASURE 35 9873 0090011B 3 11 14
106075 106075 NO 23600 STATE MEASURE 35 9873 0090011B 2 3 5
106076 106076 YES 23599 STATE MEASURE 35 9873 0090012A 0 0 0
106077 106077 NO 23600 STATE MEASURE 35 9873 0090012A 1 7 8
106078 106078 YES 23599 STATE MEASURE 35 9873 0090017A 0 0 0
106079 106079 NO 23600 STATE MEASURE 35 9873 0090017A 0 0 0
106080 106080 YES 23599 STATE MEASURE 35 9873 0090019A 0 0 0
106081 106081 NO 23600 STATE MEASURE 35 9873 0090019A 0 0 0
106082 106082 YES 23599 STATE MEASURE 35 9873 0090021A 0 0 0
106083 106083 NO 23600 STATE MEASURE 35 9873 0090021A 0 0 0
106084 106084 YES 23599 STATE MEASURE 35 9873 0090023A 0 0 0
106085 106085 NO 23600 STATE MEASURE 35 9873 0090023A 0 0 0
106086 106086 YES 23599 STATE MEASURE 35 9873 0090025A 1 3 4
106087 106087 NO 23600 STATE MEASURE 35 9873 0090025A 0 1 1
106088 106088 YES 23599 STATE MEASURE 35 9873 0090025B 0 0 0
106089 106089 NO 23600 STATE MEASURE 35 9873 0090025B 0 0 0

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