results

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

42 rows where contest_id = 8968

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
32008 32008 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550001A 68 330 398
32009 32009 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550001A 105 281 386
32010 32010 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550003A 56 149 205
32011 32011 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550003A 50 207 257
32012 32012 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550009A 20 76 96
32013 32013 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550009A 21 56 77
32014 32014 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550009D 38 140 178
32015 32015 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550009D 32 165 197
32016 32016 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550011B 47 167 214
32017 32017 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550011B 46 179 225
32018 32018 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550012B 68 226 294
32019 32019 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550012B 104 270 374
32020 32020 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550016A 59 184 243
32021 32021 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550016A 58 187 245
32022 32022 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550018E 46 176 222
32023 32023 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550018E 55 251 306
32024 32024 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550019B 58 198 256
32025 32025 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550019B 59 193 252
32026 32026 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550020A 46 192 238
32027 32027 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550020A 63 213 276
32028 32028 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550021B 51 186 237
32029 32029 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550021B 82 188 270
32030 32030 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550026A 50 193 243
32031 32031 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550026A 64 227 291
32032 32032 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550029A 59 207 266
32033 32033 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550029A 52 219 271
32034 32034 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550032A 52 223 275
32035 32035 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550032A 57 277 334
32036 32036 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550033A 37 225 262
32037 32037 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550033A 57 241 298
32038 32038 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550036A 51 192 243
32039 32039 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550036A 60 229 289
32040 32040 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550050A 55 284 339
32041 32041 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550050A 88 326 414
32042 32042 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550052A 67 280 347
32043 32043 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550052A 101 332 433
32044 32044 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550061A 33 134 167
32045 32045 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550061A 66 172 238
32046 32046 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550064A 52 223 275
32047 32047 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550064A 80 260 340
32048 32048 YES 21360 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550073A 6 42 48
32049 32049 NO 21361 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION - MEASURE PD 8968 6550073A 5 31 36

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