results

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

7,976 rows where contest_id = 9868

✎ 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
218016 218016 YES 23587 STATE MEASURE 5 9868 0050002B 30 0 30
218017 218017 NO 23588 STATE MEASURE 5 9868 0050002B 12 1 13
218018 218018 YES 23587 STATE MEASURE 5 9868 0050002G 1 0 1
218019 218019 NO 23588 STATE MEASURE 5 9868 0050002G 0 0 0
218020 218020 YES 23587 STATE MEASURE 5 9868 0050003A 71 140 211
218021 218021 NO 23588 STATE MEASURE 5 9868 0050003A 419 559 978
218022 218022 YES 23587 STATE MEASURE 5 9868 0050005A 165 383 548
218023 218023 NO 23588 STATE MEASURE 5 9868 0050005A 876 1114 1990
218024 218024 YES 23587 STATE MEASURE 5 9868 0050007B 0 0 0
218025 218025 NO 23588 STATE MEASURE 5 9868 0050007B 0 0 0
218026 218026 YES 23587 STATE MEASURE 5 9868 0050010A 0 0 0
218027 218027 NO 23588 STATE MEASURE 5 9868 0050010A 2 1 3
218028 218028 YES 23587 STATE MEASURE 5 9868 0050014A 25 73 98
218029 218029 NO 23588 STATE MEASURE 5 9868 0050014A 151 255 406
218030 218030 YES 23587 STATE MEASURE 5 9868 0050015A 1 0 1
218031 218031 NO 23588 STATE MEASURE 5 9868 0050015A 0 0 0
218032 218032 YES 23587 STATE MEASURE 5 9868 0050022D 0 1 1
218033 218033 NO 23588 STATE MEASURE 5 9868 0050022D 0 1 1
218034 218034 YES 23587 STATE MEASURE 5 9868 0050023D 0 0 0
218035 218035 NO 23588 STATE MEASURE 5 9868 0050023D 0 0 0
218036 218036 YES 23587 STATE MEASURE 5 9868 0050025H 0 0 0
218037 218037 NO 23588 STATE MEASURE 5 9868 0050025H 0 0 0
218038 218038 YES 23587 STATE MEASURE 5 9868 0050027A 1 0 1
218039 218039 NO 23588 STATE MEASURE 5 9868 0050027A 0 0 0
218040 218040 YES 23587 STATE MEASURE 5 9868 0050029A 0 0 0
218041 218041 NO 23588 STATE MEASURE 5 9868 0050029A 0 0 0
218042 218042 YES 23587 STATE MEASURE 5 9868 0050037A 0 0 0
218043 218043 NO 23588 STATE MEASURE 5 9868 0050037A 0 0 0
218044 218044 YES 23587 STATE MEASURE 5 9868 0050042A 1 0 1
218045 218045 NO 23588 STATE MEASURE 5 9868 0050042A 0 2 2
218046 218046 YES 23587 STATE MEASURE 5 9868 0050055A 0 0 0
218047 218047 NO 23588 STATE MEASURE 5 9868 0050055A 0 0 0
218048 218048 YES 23587 STATE MEASURE 5 9868 0050066A 0 0 0
218049 218049 NO 23588 STATE MEASURE 5 9868 0050066A 0 0 0
218050 218050 YES 23587 STATE MEASURE 5 9868 0070001A 34 143 177
218051 218051 NO 23588 STATE MEASURE 5 9868 0070001A 157 367 524
218052 218052 YES 23587 STATE MEASURE 5 9868 0070002A 1 15 16
218053 218053 NO 23588 STATE MEASURE 5 9868 0070002A 13 32 45
218054 218054 YES 23587 STATE MEASURE 5 9868 0070005A 76 282 358
218055 218055 NO 23588 STATE MEASURE 5 9868 0070005A 170 508 678
218056 218056 YES 23587 STATE MEASURE 5 9868 0070005B 2 5 7
218057 218057 NO 23588 STATE MEASURE 5 9868 0070005B 3 3 6
218058 218058 YES 23587 STATE MEASURE 5 9868 0070006A 129 401 530
218059 218059 NO 23588 STATE MEASURE 5 9868 0070006A 213 489 702
218060 218060 YES 23587 STATE MEASURE 5 9868 0070027A 0 0 0
218061 218061 NO 23588 STATE MEASURE 5 9868 0070027A 0 0 0
218062 218062 YES 23587 STATE MEASURE 5 9868 0070027B 0 1 1
218063 218063 NO 23588 STATE MEASURE 5 9868 0070027B 2 0 2
218064 218064 YES 23587 STATE MEASURE 5 9868 0070027C 0 0 0
218065 218065 NO 23588 STATE MEASURE 5 9868 0070027C 0 0 0
218066 218066 YES 23587 STATE MEASURE 5 9868 0070041B 7 31 38
218067 218067 NO 23588 STATE MEASURE 5 9868 0070041B 35 67 102
218068 218068 YES 23587 STATE MEASURE 5 9868 0070041F 3 7 10
218069 218069 NO 23588 STATE MEASURE 5 9868 0070041F 7 6 13
218070 218070 YES 23587 STATE MEASURE 5 9868 0070207A 0 6 6
218071 218071 NO 23588 STATE MEASURE 5 9868 0070207A 6 25 31
218072 218072 YES 23587 STATE MEASURE 5 9868 0080004A 91 588 679
218073 218073 NO 23588 STATE MEASURE 5 9868 0080004A 298 821 1119
218074 218074 YES 23587 STATE MEASURE 5 9868 0080007A 194 926 1120
218075 218075 NO 23588 STATE MEASURE 5 9868 0080007A 414 1166 1580
218076 218076 YES 23587 STATE MEASURE 5 9868 0080050A 267 1043 1310
218077 218077 NO 23588 STATE MEASURE 5 9868 0080050A 522 1393 1915
218078 218078 YES 23587 STATE MEASURE 5 9868 0080054A 106 365 471
218079 218079 NO 23588 STATE MEASURE 5 9868 0080054A 212 517 729
218080 218080 YES 23587 STATE MEASURE 5 9868 0080070A 114 746 860
218081 218081 NO 23588 STATE MEASURE 5 9868 0080070A 375 1128 1503
218082 218082 YES 23587 STATE MEASURE 5 9868 0090002A 0 0 0
218083 218083 NO 23588 STATE MEASURE 5 9868 0090002A 1 0 1
218084 218084 YES 23587 STATE MEASURE 5 9868 0090002B 0 0 0
218085 218085 NO 23588 STATE MEASURE 5 9868 0090002B 0 7 7
218086 218086 YES 23587 STATE MEASURE 5 9868 0090002C 0 0 0
218087 218087 NO 23588 STATE MEASURE 5 9868 0090002C 0 0 0
218088 218088 YES 23587 STATE MEASURE 5 9868 0090005C 0 0 0
218089 218089 NO 23588 STATE MEASURE 5 9868 0090005C 0 0 0
218090 218090 YES 23587 STATE MEASURE 5 9868 0090005G 0 0 0
218091 218091 NO 23588 STATE MEASURE 5 9868 0090005G 0 1 1
218092 218092 YES 23587 STATE MEASURE 5 9868 0090006A 8 8 16
218093 218093 NO 23588 STATE MEASURE 5 9868 0090006A 8 10 18
218094 218094 YES 23587 STATE MEASURE 5 9868 0090007C 0 1 1
218095 218095 NO 23588 STATE MEASURE 5 9868 0090007C 0 0 0
218096 218096 YES 23587 STATE MEASURE 5 9868 0090009A 0 0 0
218097 218097 NO 23588 STATE MEASURE 5 9868 0090009A 0 0 0
218098 218098 YES 23587 STATE MEASURE 5 9868 0090010A 0 0 0
218099 218099 NO 23588 STATE MEASURE 5 9868 0090010A 0 0 0
218100 218100 YES 23587 STATE MEASURE 5 9868 0090011B 1 3 4
218101 218101 NO 23588 STATE MEASURE 5 9868 0090011B 4 11 15
218102 218102 YES 23587 STATE MEASURE 5 9868 0090012A 0 0 0
218103 218103 NO 23588 STATE MEASURE 5 9868 0090012A 1 7 8
218104 218104 YES 23587 STATE MEASURE 5 9868 0090017A 0 0 0
218105 218105 NO 23588 STATE MEASURE 5 9868 0090017A 0 0 0
218106 218106 YES 23587 STATE MEASURE 5 9868 0090019A 0 0 0
218107 218107 NO 23588 STATE MEASURE 5 9868 0090019A 0 0 0
218108 218108 YES 23587 STATE MEASURE 5 9868 0090021A 0 0 0
218109 218109 NO 23588 STATE MEASURE 5 9868 0090021A 0 0 0
218110 218110 YES 23587 STATE MEASURE 5 9868 0090023A 0 0 0
218111 218111 NO 23588 STATE MEASURE 5 9868 0090023A 0 0 0
218112 218112 YES 23587 STATE MEASURE 5 9868 0090025A 0 3 3
218113 218113 NO 23588 STATE MEASURE 5 9868 0090025A 0 1 1
218114 218114 YES 23587 STATE MEASURE 5 9868 0090025B 0 0 0
218115 218115 NO 23588 STATE MEASURE 5 9868 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]);