results

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

7,976 rows where contest_id = 9872

✎ 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
131118 131118 YES 23597 STATE MEASURE 34 9872 0050002B 20 0 20
131119 131119 NO 23598 STATE MEASURE 34 9872 0050002B 17 1 18
131120 131120 YES 23597 STATE MEASURE 34 9872 0050002G 0 0 0
131121 131121 NO 23598 STATE MEASURE 34 9872 0050002G 1 0 1
131122 131122 YES 23597 STATE MEASURE 34 9872 0050003A 293 390 683
131123 131123 NO 23598 STATE MEASURE 34 9872 0050003A 189 292 481
131124 131124 YES 23597 STATE MEASURE 34 9872 0050005A 574 799 1373
131125 131125 NO 23598 STATE MEASURE 34 9872 0050005A 448 661 1109
131126 131126 YES 23597 STATE MEASURE 34 9872 0050007B 0 0 0
131127 131127 NO 23598 STATE MEASURE 34 9872 0050007B 0 0 0
131128 131128 YES 23597 STATE MEASURE 34 9872 0050010A 2 1 3
131129 131129 NO 23598 STATE MEASURE 34 9872 0050010A 0 0 0
131130 131130 YES 23597 STATE MEASURE 34 9872 0050014A 85 143 228
131131 131131 NO 23598 STATE MEASURE 34 9872 0050014A 83 171 254
131132 131132 YES 23597 STATE MEASURE 34 9872 0050015A 0 0 0
131133 131133 NO 23598 STATE MEASURE 34 9872 0050015A 1 0 1
131134 131134 YES 23597 STATE MEASURE 34 9872 0050022D 0 2 2
131135 131135 NO 23598 STATE MEASURE 34 9872 0050022D 0 0 0
131136 131136 YES 23597 STATE MEASURE 34 9872 0050023D 0 0 0
131137 131137 NO 23598 STATE MEASURE 34 9872 0050023D 0 0 0
131138 131138 YES 23597 STATE MEASURE 34 9872 0050025H 0 0 0
131139 131139 NO 23598 STATE MEASURE 34 9872 0050025H 0 0 0
131140 131140 YES 23597 STATE MEASURE 34 9872 0050027A 0 0 0
131141 131141 NO 23598 STATE MEASURE 34 9872 0050027A 1 0 1
131142 131142 YES 23597 STATE MEASURE 34 9872 0050029A 0 0 0
131143 131143 NO 23598 STATE MEASURE 34 9872 0050029A 0 0 0
131144 131144 YES 23597 STATE MEASURE 34 9872 0050037A 0 0 0
131145 131145 NO 23598 STATE MEASURE 34 9872 0050037A 0 0 0
131146 131146 YES 23597 STATE MEASURE 34 9872 0050042A 1 0 1
131147 131147 NO 23598 STATE MEASURE 34 9872 0050042A 0 2 2
131148 131148 YES 23597 STATE MEASURE 34 9872 0050055A 0 0 0
131149 131149 NO 23598 STATE MEASURE 34 9872 0050055A 0 0 0
131150 131150 YES 23597 STATE MEASURE 34 9872 0050066A 0 0 0
131151 131151 NO 23598 STATE MEASURE 34 9872 0050066A 0 0 0
131152 131152 YES 23597 STATE MEASURE 34 9872 0070001A 115 247 362
131153 131153 NO 23598 STATE MEASURE 34 9872 0070001A 68 243 311
131154 131154 YES 23597 STATE MEASURE 34 9872 0070002A 9 16 25
131155 131155 NO 23598 STATE MEASURE 34 9872 0070002A 4 27 31
131156 131156 YES 23597 STATE MEASURE 34 9872 0070005A 135 409 544
131157 131157 NO 23598 STATE MEASURE 34 9872 0070005A 106 340 446
131158 131158 YES 23597 STATE MEASURE 34 9872 0070005B 2 2 4
131159 131159 NO 23598 STATE MEASURE 34 9872 0070005B 2 4 6
131160 131160 YES 23597 STATE MEASURE 34 9872 0070006A 168 383 551
131161 131161 NO 23598 STATE MEASURE 34 9872 0070006A 159 477 636
131162 131162 YES 23597 STATE MEASURE 34 9872 0070027A 0 0 0
131163 131163 NO 23598 STATE MEASURE 34 9872 0070027A 0 0 0
131164 131164 YES 23597 STATE MEASURE 34 9872 0070027B 0 1 1
131165 131165 NO 23598 STATE MEASURE 34 9872 0070027B 2 0 2
131166 131166 YES 23597 STATE MEASURE 34 9872 0070027C 0 0 0
131167 131167 NO 23598 STATE MEASURE 34 9872 0070027C 0 0 0
131168 131168 YES 23597 STATE MEASURE 34 9872 0070041B 25 42 67
131169 131169 NO 23598 STATE MEASURE 34 9872 0070041B 16 52 68
131170 131170 YES 23597 STATE MEASURE 34 9872 0070041F 5 10 15
131171 131171 NO 23598 STATE MEASURE 34 9872 0070041F 5 3 8
131172 131172 YES 23597 STATE MEASURE 34 9872 0070207A 3 11 14
131173 131173 NO 23598 STATE MEASURE 34 9872 0070207A 3 19 22
131174 131174 YES 23597 STATE MEASURE 34 9872 0080004A 216 590 806
131175 131175 NO 23598 STATE MEASURE 34 9872 0080004A 156 767 923
131176 131176 YES 23597 STATE MEASURE 34 9872 0080007A 334 917 1251
131177 131177 NO 23598 STATE MEASURE 34 9872 0080007A 258 1086 1344
131178 131178 YES 23597 STATE MEASURE 34 9872 0080050A 425 1106 1531
131179 131179 NO 23598 STATE MEASURE 34 9872 0080050A 333 1256 1589
131180 131180 YES 23597 STATE MEASURE 34 9872 0080054A 166 398 564
131181 131181 NO 23598 STATE MEASURE 34 9872 0080054A 137 445 582
131182 131182 YES 23597 STATE MEASURE 34 9872 0080070A 253 799 1052
131183 131183 NO 23598 STATE MEASURE 34 9872 0080070A 216 986 1202
131184 131184 YES 23597 STATE MEASURE 34 9872 0090002A 1 0 1
131185 131185 NO 23598 STATE MEASURE 34 9872 0090002A 0 0 0
131186 131186 YES 23597 STATE MEASURE 34 9872 0090002B 0 2 2
131187 131187 NO 23598 STATE MEASURE 34 9872 0090002B 0 5 5
131188 131188 YES 23597 STATE MEASURE 34 9872 0090002C 0 0 0
131189 131189 NO 23598 STATE MEASURE 34 9872 0090002C 0 0 0
131190 131190 YES 23597 STATE MEASURE 34 9872 0090005C 0 0 0
131191 131191 NO 23598 STATE MEASURE 34 9872 0090005C 0 0 0
131192 131192 YES 23597 STATE MEASURE 34 9872 0090005G 0 0 0
131193 131193 NO 23598 STATE MEASURE 34 9872 0090005G 0 1 1
131194 131194 YES 23597 STATE MEASURE 34 9872 0090006A 4 9 13
131195 131195 NO 23598 STATE MEASURE 34 9872 0090006A 10 9 19
131196 131196 YES 23597 STATE MEASURE 34 9872 0090007C 0 1 1
131197 131197 NO 23598 STATE MEASURE 34 9872 0090007C 0 0 0
131198 131198 YES 23597 STATE MEASURE 34 9872 0090009A 0 0 0
131199 131199 NO 23598 STATE MEASURE 34 9872 0090009A 0 0 0
131200 131200 YES 23597 STATE MEASURE 34 9872 0090010A 0 0 0
131201 131201 NO 23598 STATE MEASURE 34 9872 0090010A 0 0 0
131202 131202 YES 23597 STATE MEASURE 34 9872 0090011B 3 5 8
131203 131203 NO 23598 STATE MEASURE 34 9872 0090011B 2 8 10
131204 131204 YES 23597 STATE MEASURE 34 9872 0090012A 1 5 6
131205 131205 NO 23598 STATE MEASURE 34 9872 0090012A 0 2 2
131206 131206 YES 23597 STATE MEASURE 34 9872 0090017A 0 0 0
131207 131207 NO 23598 STATE MEASURE 34 9872 0090017A 0 0 0
131208 131208 YES 23597 STATE MEASURE 34 9872 0090019A 0 0 0
131209 131209 NO 23598 STATE MEASURE 34 9872 0090019A 0 0 0
131210 131210 YES 23597 STATE MEASURE 34 9872 0090021A 0 0 0
131211 131211 NO 23598 STATE MEASURE 34 9872 0090021A 0 0 0
131212 131212 YES 23597 STATE MEASURE 34 9872 0090023A 0 0 0
131213 131213 NO 23598 STATE MEASURE 34 9872 0090023A 0 0 0
131214 131214 YES 23597 STATE MEASURE 34 9872 0090025A 0 3 3
131215 131215 NO 23598 STATE MEASURE 34 9872 0090025A 0 1 1
131216 131216 YES 23597 STATE MEASURE 34 9872 0090025B 0 0 0
131217 131217 NO 23598 STATE MEASURE 34 9872 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]);