results

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

54 rows where precinct_id = "1070021A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contest_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
19599 19599 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1070021A 227 461 688
19600 19600 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1070021A 2 2 4
19601 19601 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1070021A 174 798 972
19602 19602 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1070021A 4 8 12
19603 19603 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1070021A 1 1 2
19604 19604 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1070021A 6 15 21
43705 43705 DEREK TRAN 23480 UNITED STATES REPRESENTATIVE, 45th District 9546 1070021A 175 712 887
43706 43706 MICHELLE STEEL 23481 UNITED STATES REPRESENTATIVE, 45th District 9546 1070021A 216 510 726
51083 51083 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1070021A 222 514 736
51084 51084 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1070021A 162 720 882
59109 59109 YES 23601 STATE MEASURE 36 9874 1070021A 263 883 1146
59110 59110 NO 23602 STATE MEASURE 36 9874 1070021A 99 307 406
67818 67818 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1070021A 163 448 611
67819 67819 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1070021A 137 493 630
76126 76126 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1070021A 234 738 972
76127 76127 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1070021A 106 375 481
87680 87680 YES 23584 STATE MEASURE 3 9867 1070021A 169 637 806
87681 87681 NO 23585 STATE MEASURE 3 9867 1070021A 193 555 748
98254 98254 YES 23593 STATE MEASURE 33 9871 1070021A 137 426 563
98255 98255 NO 23594 STATE MEASURE 33 9871 1070021A 223 761 984
106740 106740 YES 23599 STATE MEASURE 35 9873 1070021A 224 752 976
106741 106741 NO 23600 STATE MEASURE 35 9873 1070021A 137 429 566
115376 115376 YES 23766 COUNTY MEASURE A 9880 1070021A 173 558 731
115377 115377 NO 23767 COUNTY MEASURE A 9880 1070021A 184 634 818
123456 123456 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1070021A 125 400 525
123457 123457 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1070021A 164 513 677
131868 131868 YES 23597 STATE MEASURE 34 9872 1070021A 201 583 784
131869 131869 NO 23598 STATE MEASURE 34 9872 1070021A 142 550 692
142090 142090 YES 23591 STATE MEASURE 32 9870 1070021A 162 531 693
142091 142091 NO 23592 STATE MEASURE 32 9870 1070021A 208 667 875
150992 150992 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1070021A 172 566 738
150993 150993 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1070021A 139 422 561
165452 165452 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1070021A 210 503 713
165453 165453 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1070021A 166 731 897
173552 173552 YES 23712 STATE MEASURE 2 9878 1070021A 197 606 803
173553 173553 NO 23713 STATE MEASURE 2 9878 1070021A 164 590 754
182260 182260 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1070021A 157 487 644
182261 182261 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1070021A 135 443 578
192918 192918 YES 23714 STATE MEASURE 4 9879 1070021A 186 621 807
192919 192919 NO 23715 STATE MEASURE 4 9879 1070021A 169 588 757
202794 202794 YES 23589 STATE MEASURE 6 9869 1070021A 140 512 652
202795 202795 NO 23590 STATE MEASURE 6 9869 1070021A 191 643 834
210770 210770 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1070021A 113 282 395
210771 210771 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1070021A 173 623 796
218766 218766 YES 23587 STATE MEASURE 5 9868 1070021A 139 442 581
218767 218767 NO 23588 STATE MEASURE 5 9868 1070021A 206 734 940
227249 227249 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1070021A 172 533 705
227250 227250 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1070021A 175 596 771
235798 235798 JUAN GARZA 23958 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 4 9847 1070021A 159 610 769
235799 235799 DORA SANDOVAL 24036 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 4 9847 1070021A 143 361 504
250649 250649 SHARON QUIRK-SILVA 23445 MEMBER OF THE STATE ASSEMBLY, 67th District 9528 1070021A 182 757 939
250650 250650 ELIZABETH "BETH" CULVER 23444 MEMBER OF THE STATE ASSEMBLY, 67th District 9528 1070021A 194 431 625
257996 257996 YES 24240 COUNTY MEASURE G 9961 1070021A 158 554 712
257997 257997 NO 24241 COUNTY MEASURE G 9961 1070021A 181 583 764

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