results

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

7,976 rows where contest_id = 9869

✎ 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
202044 202044 YES 23589 STATE MEASURE 6 9869 0050002B 20 0 20
202045 202045 NO 23590 STATE MEASURE 6 9869 0050002B 16 1 17
202046 202046 YES 23589 STATE MEASURE 6 9869 0050002G 1 0 1
202047 202047 NO 23590 STATE MEASURE 6 9869 0050002G 0 0 0
202048 202048 YES 23589 STATE MEASURE 6 9869 0050003A 80 193 273
202049 202049 NO 23590 STATE MEASURE 6 9869 0050003A 403 491 894
202050 202050 YES 23589 STATE MEASURE 6 9869 0050005A 219 418 637
202051 202051 NO 23590 STATE MEASURE 6 9869 0050005A 795 1058 1853
202052 202052 YES 23589 STATE MEASURE 6 9869 0050007B 0 0 0
202053 202053 NO 23590 STATE MEASURE 6 9869 0050007B 0 0 0
202054 202054 YES 23589 STATE MEASURE 6 9869 0050010A 0 0 0
202055 202055 NO 23590 STATE MEASURE 6 9869 0050010A 2 1 3
202056 202056 YES 23589 STATE MEASURE 6 9869 0050014A 35 99 134
202057 202057 NO 23590 STATE MEASURE 6 9869 0050014A 135 224 359
202058 202058 YES 23589 STATE MEASURE 6 9869 0050015A 0 0 0
202059 202059 NO 23590 STATE MEASURE 6 9869 0050015A 1 0 1
202060 202060 YES 23589 STATE MEASURE 6 9869 0050022D 0 1 1
202061 202061 NO 23590 STATE MEASURE 6 9869 0050022D 0 1 1
202062 202062 YES 23589 STATE MEASURE 6 9869 0050023D 0 0 0
202063 202063 NO 23590 STATE MEASURE 6 9869 0050023D 0 0 0
202064 202064 YES 23589 STATE MEASURE 6 9869 0050025H 0 0 0
202065 202065 NO 23590 STATE MEASURE 6 9869 0050025H 0 0 0
202066 202066 YES 23589 STATE MEASURE 6 9869 0050027A 1 0 1
202067 202067 NO 23590 STATE MEASURE 6 9869 0050027A 0 0 0
202068 202068 YES 23589 STATE MEASURE 6 9869 0050029A 0 0 0
202069 202069 NO 23590 STATE MEASURE 6 9869 0050029A 0 0 0
202070 202070 YES 23589 STATE MEASURE 6 9869 0050037A 0 0 0
202071 202071 NO 23590 STATE MEASURE 6 9869 0050037A 0 0 0
202072 202072 YES 23589 STATE MEASURE 6 9869 0050042A 1 0 1
202073 202073 NO 23590 STATE MEASURE 6 9869 0050042A 0 2 2
202074 202074 YES 23589 STATE MEASURE 6 9869 0050055A 0 0 0
202075 202075 NO 23590 STATE MEASURE 6 9869 0050055A 0 0 0
202076 202076 YES 23589 STATE MEASURE 6 9869 0050066A 0 0 0
202077 202077 NO 23590 STATE MEASURE 6 9869 0050066A 0 0 0
202078 202078 YES 23589 STATE MEASURE 6 9869 0070001A 46 200 246
202079 202079 NO 23590 STATE MEASURE 6 9869 0070001A 136 298 434
202080 202080 YES 23589 STATE MEASURE 6 9869 0070002A 3 19 22
202081 202081 NO 23590 STATE MEASURE 6 9869 0070002A 11 30 41
202082 202082 YES 23589 STATE MEASURE 6 9869 0070005A 96 365 461
202083 202083 NO 23590 STATE MEASURE 6 9869 0070005A 145 416 561
202084 202084 YES 23589 STATE MEASURE 6 9869 0070005B 2 6 8
202085 202085 NO 23590 STATE MEASURE 6 9869 0070005B 3 1 4
202086 202086 YES 23589 STATE MEASURE 6 9869 0070006A 148 450 598
202087 202087 NO 23590 STATE MEASURE 6 9869 0070006A 185 430 615
202088 202088 YES 23589 STATE MEASURE 6 9869 0070027A 0 0 0
202089 202089 NO 23590 STATE MEASURE 6 9869 0070027A 0 0 0
202090 202090 YES 23589 STATE MEASURE 6 9869 0070027B 0 0 0
202091 202091 NO 23590 STATE MEASURE 6 9869 0070027B 2 1 3
202092 202092 YES 23589 STATE MEASURE 6 9869 0070027C 0 0 0
202093 202093 NO 23590 STATE MEASURE 6 9869 0070027C 0 0 0
202094 202094 YES 23589 STATE MEASURE 6 9869 0070041B 15 36 51
202095 202095 NO 23590 STATE MEASURE 6 9869 0070041B 25 63 88
202096 202096 YES 23589 STATE MEASURE 6 9869 0070041F 4 4 8
202097 202097 NO 23590 STATE MEASURE 6 9869 0070041F 6 9 15
202098 202098 YES 23589 STATE MEASURE 6 9869 0070207A 0 15 15
202099 202099 NO 23590 STATE MEASURE 6 9869 0070207A 5 17 22
202100 202100 YES 23589 STATE MEASURE 6 9869 0080004A 98 706 804
202101 202101 NO 23590 STATE MEASURE 6 9869 0080004A 280 669 949
202102 202102 YES 23589 STATE MEASURE 6 9869 0080007A 207 1102 1309
202103 202103 NO 23590 STATE MEASURE 6 9869 0080007A 384 950 1334
202104 202104 YES 23589 STATE MEASURE 6 9869 0080050A 288 1194 1482
202105 202105 NO 23590 STATE MEASURE 6 9869 0080050A 476 1201 1677
202106 202106 YES 23589 STATE MEASURE 6 9869 0080054A 119 411 530
202107 202107 NO 23590 STATE MEASURE 6 9869 0080054A 186 454 640
202108 202108 YES 23589 STATE MEASURE 6 9869 0080070A 140 863 1003
202109 202109 NO 23590 STATE MEASURE 6 9869 0080070A 336 994 1330
202110 202110 YES 23589 STATE MEASURE 6 9869 0090002A 1 0 1
202111 202111 NO 23590 STATE MEASURE 6 9869 0090002A 0 0 0
202112 202112 YES 23589 STATE MEASURE 6 9869 0090002B 0 0 0
202113 202113 NO 23590 STATE MEASURE 6 9869 0090002B 0 7 7
202114 202114 YES 23589 STATE MEASURE 6 9869 0090002C 0 0 0
202115 202115 NO 23590 STATE MEASURE 6 9869 0090002C 0 0 0
202116 202116 YES 23589 STATE MEASURE 6 9869 0090005C 0 0 0
202117 202117 NO 23590 STATE MEASURE 6 9869 0090005C 0 0 0
202118 202118 YES 23589 STATE MEASURE 6 9869 0090005G 0 1 1
202119 202119 NO 23590 STATE MEASURE 6 9869 0090005G 0 0 0
202120 202120 YES 23589 STATE MEASURE 6 9869 0090006A 4 8 12
202121 202121 NO 23590 STATE MEASURE 6 9869 0090006A 11 9 20
202122 202122 YES 23589 STATE MEASURE 6 9869 0090007C 0 0 0
202123 202123 NO 23590 STATE MEASURE 6 9869 0090007C 0 1 1
202124 202124 YES 23589 STATE MEASURE 6 9869 0090009A 0 0 0
202125 202125 NO 23590 STATE MEASURE 6 9869 0090009A 0 0 0
202126 202126 YES 23589 STATE MEASURE 6 9869 0090010A 0 0 0
202127 202127 NO 23590 STATE MEASURE 6 9869 0090010A 0 0 0
202128 202128 YES 23589 STATE MEASURE 6 9869 0090011B 1 6 7
202129 202129 NO 23590 STATE MEASURE 6 9869 0090011B 3 8 11
202130 202130 YES 23589 STATE MEASURE 6 9869 0090012A 0 0 0
202131 202131 NO 23590 STATE MEASURE 6 9869 0090012A 1 7 8
202132 202132 YES 23589 STATE MEASURE 6 9869 0090017A 0 0 0
202133 202133 NO 23590 STATE MEASURE 6 9869 0090017A 0 0 0
202134 202134 YES 23589 STATE MEASURE 6 9869 0090019A 0 0 0
202135 202135 NO 23590 STATE MEASURE 6 9869 0090019A 0 0 0
202136 202136 YES 23589 STATE MEASURE 6 9869 0090021A 0 0 0
202137 202137 NO 23590 STATE MEASURE 6 9869 0090021A 0 0 0
202138 202138 YES 23589 STATE MEASURE 6 9869 0090023A 0 0 0
202139 202139 NO 23590 STATE MEASURE 6 9869 0090023A 0 0 0
202140 202140 YES 23589 STATE MEASURE 6 9869 0090025A 0 4 4
202141 202141 NO 23590 STATE MEASURE 6 9869 0090025A 0 0 0
202142 202142 YES 23589 STATE MEASURE 6 9869 0090025B 0 0 0
202143 202143 NO 23590 STATE MEASURE 6 9869 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]);