results

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

7,976 rows where contest_id = 9879

✎ 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
192168 192168 YES 23714 STATE MEASURE 4 9879 0050002B 29 0 29
192169 192169 NO 23715 STATE MEASURE 4 9879 0050002B 11 1 12
192170 192170 YES 23714 STATE MEASURE 4 9879 0050002G 1 0 1
192171 192171 NO 23715 STATE MEASURE 4 9879 0050002G 0 0 0
192172 192172 YES 23714 STATE MEASURE 4 9879 0050003A 96 219 315
192173 192173 NO 23715 STATE MEASURE 4 9879 0050003A 392 479 871
192174 192174 YES 23714 STATE MEASURE 4 9879 0050005A 245 531 776
192175 192175 NO 23715 STATE MEASURE 4 9879 0050005A 803 980 1783
192176 192176 YES 23714 STATE MEASURE 4 9879 0050007B 0 0 0
192177 192177 NO 23715 STATE MEASURE 4 9879 0050007B 0 0 0
192178 192178 YES 23714 STATE MEASURE 4 9879 0050010A 0 0 0
192179 192179 NO 23715 STATE MEASURE 4 9879 0050010A 2 1 3
192180 192180 YES 23714 STATE MEASURE 4 9879 0050014A 43 111 154
192181 192181 NO 23715 STATE MEASURE 4 9879 0050014A 133 218 351
192182 192182 YES 23714 STATE MEASURE 4 9879 0050015A 0 0 0
192183 192183 NO 23715 STATE MEASURE 4 9879 0050015A 1 0 1
192184 192184 YES 23714 STATE MEASURE 4 9879 0050022D 0 1 1
192185 192185 NO 23715 STATE MEASURE 4 9879 0050022D 0 1 1
192186 192186 YES 23714 STATE MEASURE 4 9879 0050023D 0 0 0
192187 192187 NO 23715 STATE MEASURE 4 9879 0050023D 0 0 0
192188 192188 YES 23714 STATE MEASURE 4 9879 0050025H 0 0 0
192189 192189 NO 23715 STATE MEASURE 4 9879 0050025H 0 0 0
192190 192190 YES 23714 STATE MEASURE 4 9879 0050027A 0 0 0
192191 192191 NO 23715 STATE MEASURE 4 9879 0050027A 1 0 1
192192 192192 YES 23714 STATE MEASURE 4 9879 0050029A 0 0 0
192193 192193 NO 23715 STATE MEASURE 4 9879 0050029A 0 0 0
192194 192194 YES 23714 STATE MEASURE 4 9879 0050037A 0 0 0
192195 192195 NO 23715 STATE MEASURE 4 9879 0050037A 0 0 0
192196 192196 YES 23714 STATE MEASURE 4 9879 0050042A 1 0 1
192197 192197 NO 23715 STATE MEASURE 4 9879 0050042A 0 2 2
192198 192198 YES 23714 STATE MEASURE 4 9879 0050055A 0 0 0
192199 192199 NO 23715 STATE MEASURE 4 9879 0050055A 0 0 0
192200 192200 YES 23714 STATE MEASURE 4 9879 0050066A 0 0 0
192201 192201 NO 23715 STATE MEASURE 4 9879 0050066A 0 0 0
192202 192202 YES 23714 STATE MEASURE 4 9879 0070001A 61 238 299
192203 192203 NO 23715 STATE MEASURE 4 9879 0070001A 135 281 416
192204 192204 YES 23714 STATE MEASURE 4 9879 0070002A 5 26 31
192205 192205 NO 23715 STATE MEASURE 4 9879 0070002A 9 26 35
192206 192206 YES 23714 STATE MEASURE 4 9879 0070005A 114 407 521
192207 192207 NO 23715 STATE MEASURE 4 9879 0070005A 137 389 526
192208 192208 YES 23714 STATE MEASURE 4 9879 0070005B 3 6 9
192209 192209 NO 23715 STATE MEASURE 4 9879 0070005B 2 1 3
192210 192210 YES 23714 STATE MEASURE 4 9879 0070006A 201 580 781
192211 192211 NO 23715 STATE MEASURE 4 9879 0070006A 151 331 482
192212 192212 YES 23714 STATE MEASURE 4 9879 0070027A 0 0 0
192213 192213 NO 23715 STATE MEASURE 4 9879 0070027A 0 0 0
192214 192214 YES 23714 STATE MEASURE 4 9879 0070027B 0 1 1
192215 192215 NO 23715 STATE MEASURE 4 9879 0070027B 2 0 2
192216 192216 YES 23714 STATE MEASURE 4 9879 0070027C 0 0 0
192217 192217 NO 23715 STATE MEASURE 4 9879 0070027C 0 0 0
192218 192218 YES 23714 STATE MEASURE 4 9879 0070041B 20 58 78
192219 192219 NO 23715 STATE MEASURE 4 9879 0070041B 23 47 70
192220 192220 YES 23714 STATE MEASURE 4 9879 0070041F 4 8 12
192221 192221 NO 23715 STATE MEASURE 4 9879 0070041F 6 5 11
192222 192222 YES 23714 STATE MEASURE 4 9879 0070207A 0 18 18
192223 192223 NO 23715 STATE MEASURE 4 9879 0070207A 6 15 21
192224 192224 YES 23714 STATE MEASURE 4 9879 0080004A 135 829 964
192225 192225 NO 23715 STATE MEASURE 4 9879 0080004A 253 604 857
192226 192226 YES 23714 STATE MEASURE 4 9879 0080007A 293 1263 1556
192227 192227 NO 23715 STATE MEASURE 4 9879 0080007A 326 852 1178
192228 192228 YES 23714 STATE MEASURE 4 9879 0080050A 361 1416 1777
192229 192229 NO 23715 STATE MEASURE 4 9879 0080050A 435 1065 1500
192230 192230 YES 23714 STATE MEASURE 4 9879 0080054A 148 502 650
192231 192231 NO 23715 STATE MEASURE 4 9879 0080054A 174 390 564
192232 192232 YES 23714 STATE MEASURE 4 9879 0080070A 200 1061 1261
192233 192233 NO 23715 STATE MEASURE 4 9879 0080070A 299 841 1140
192234 192234 YES 23714 STATE MEASURE 4 9879 0090002A 1 0 1
192235 192235 NO 23715 STATE MEASURE 4 9879 0090002A 0 0 0
192236 192236 YES 23714 STATE MEASURE 4 9879 0090002B 0 0 0
192237 192237 NO 23715 STATE MEASURE 4 9879 0090002B 0 7 7
192238 192238 YES 23714 STATE MEASURE 4 9879 0090002C 0 0 0
192239 192239 NO 23715 STATE MEASURE 4 9879 0090002C 0 0 0
192240 192240 YES 23714 STATE MEASURE 4 9879 0090005C 0 0 0
192241 192241 NO 23715 STATE MEASURE 4 9879 0090005C 0 0 0
192242 192242 YES 23714 STATE MEASURE 4 9879 0090005G 0 0 0
192243 192243 NO 23715 STATE MEASURE 4 9879 0090005G 0 1 1
192244 192244 YES 23714 STATE MEASURE 4 9879 0090006A 7 10 17
192245 192245 NO 23715 STATE MEASURE 4 9879 0090006A 8 8 16
192246 192246 YES 23714 STATE MEASURE 4 9879 0090007C 0 1 1
192247 192247 NO 23715 STATE MEASURE 4 9879 0090007C 0 0 0
192248 192248 YES 23714 STATE MEASURE 4 9879 0090009A 0 0 0
192249 192249 NO 23715 STATE MEASURE 4 9879 0090009A 0 0 0
192250 192250 YES 23714 STATE MEASURE 4 9879 0090010A 0 0 0
192251 192251 NO 23715 STATE MEASURE 4 9879 0090010A 0 0 0
192252 192252 YES 23714 STATE MEASURE 4 9879 0090011B 1 5 6
192253 192253 NO 23715 STATE MEASURE 4 9879 0090011B 3 9 12
192254 192254 YES 23714 STATE MEASURE 4 9879 0090012A 0 0 0
192255 192255 NO 23715 STATE MEASURE 4 9879 0090012A 1 7 8
192256 192256 YES 23714 STATE MEASURE 4 9879 0090017A 0 0 0
192257 192257 NO 23715 STATE MEASURE 4 9879 0090017A 0 0 0
192258 192258 YES 23714 STATE MEASURE 4 9879 0090019A 0 0 0
192259 192259 NO 23715 STATE MEASURE 4 9879 0090019A 0 0 0
192260 192260 YES 23714 STATE MEASURE 4 9879 0090021A 0 0 0
192261 192261 NO 23715 STATE MEASURE 4 9879 0090021A 0 0 0
192262 192262 YES 23714 STATE MEASURE 4 9879 0090023A 0 0 0
192263 192263 NO 23715 STATE MEASURE 4 9879 0090023A 0 0 0
192264 192264 YES 23714 STATE MEASURE 4 9879 0090025A 0 4 4
192265 192265 NO 23715 STATE MEASURE 4 9879 0090025A 0 0 0
192266 192266 YES 23714 STATE MEASURE 4 9879 0090025B 0 0 0
192267 192267 NO 23715 STATE MEASURE 4 9879 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]);