results

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

7,976 rows where contest_id = 9867

✎ 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
86930 86930 YES 23584 STATE MEASURE 3 9867 0050002B 22 0 22
86931 86931 NO 23585 STATE MEASURE 3 9867 0050002B 18 1 19
86932 86932 YES 23584 STATE MEASURE 3 9867 0050002G 1 0 1
86933 86933 NO 23585 STATE MEASURE 3 9867 0050002G 0 0 0
86934 86934 YES 23584 STATE MEASURE 3 9867 0050003A 136 312 448
86935 86935 NO 23585 STATE MEASURE 3 9867 0050003A 354 381 735
86936 86936 YES 23584 STATE MEASURE 3 9867 0050005A 317 715 1032
86937 86937 NO 23585 STATE MEASURE 3 9867 0050005A 731 785 1516
86938 86938 YES 23584 STATE MEASURE 3 9867 0050007B 0 0 0
86939 86939 NO 23585 STATE MEASURE 3 9867 0050007B 0 0 0
86940 86940 YES 23584 STATE MEASURE 3 9867 0050010A 0 0 0
86941 86941 NO 23585 STATE MEASURE 3 9867 0050010A 2 0 2
86942 86942 YES 23584 STATE MEASURE 3 9867 0050014A 56 159 215
86943 86943 NO 23585 STATE MEASURE 3 9867 0050014A 120 172 292
86944 86944 YES 23584 STATE MEASURE 3 9867 0050015A 0 0 0
86945 86945 NO 23585 STATE MEASURE 3 9867 0050015A 1 0 1
86946 86946 YES 23584 STATE MEASURE 3 9867 0050022D 0 1 1
86947 86947 NO 23585 STATE MEASURE 3 9867 0050022D 0 1 1
86948 86948 YES 23584 STATE MEASURE 3 9867 0050023D 0 0 0
86949 86949 NO 23585 STATE MEASURE 3 9867 0050023D 0 0 0
86950 86950 YES 23584 STATE MEASURE 3 9867 0050025H 0 0 0
86951 86951 NO 23585 STATE MEASURE 3 9867 0050025H 0 0 0
86952 86952 YES 23584 STATE MEASURE 3 9867 0050027A 0 0 0
86953 86953 NO 23585 STATE MEASURE 3 9867 0050027A 1 0 1
86954 86954 YES 23584 STATE MEASURE 3 9867 0050029A 0 0 0
86955 86955 NO 23585 STATE MEASURE 3 9867 0050029A 0 0 0
86956 86956 YES 23584 STATE MEASURE 3 9867 0050037A 0 0 0
86957 86957 NO 23585 STATE MEASURE 3 9867 0050037A 0 0 0
86958 86958 YES 23584 STATE MEASURE 3 9867 0050042A 1 2 3
86959 86959 NO 23585 STATE MEASURE 3 9867 0050042A 0 0 0
86960 86960 YES 23584 STATE MEASURE 3 9867 0050055A 0 0 0
86961 86961 NO 23585 STATE MEASURE 3 9867 0050055A 0 0 0
86962 86962 YES 23584 STATE MEASURE 3 9867 0050066A 0 0 0
86963 86963 NO 23585 STATE MEASURE 3 9867 0050066A 0 0 0
86964 86964 YES 23584 STATE MEASURE 3 9867 0070001A 91 349 440
86965 86965 NO 23585 STATE MEASURE 3 9867 0070001A 95 162 257
86966 86966 YES 23584 STATE MEASURE 3 9867 0070002A 6 32 38
86967 86967 NO 23585 STATE MEASURE 3 9867 0070002A 7 18 25
86968 86968 YES 23584 STATE MEASURE 3 9867 0070005A 154 555 709
86969 86969 NO 23585 STATE MEASURE 3 9867 0070005A 100 242 342
86970 86970 YES 23584 STATE MEASURE 3 9867 0070005B 3 6 9
86971 86971 NO 23585 STATE MEASURE 3 9867 0070005B 2 0 2
86972 86972 YES 23584 STATE MEASURE 3 9867 0070006A 227 720 947
86973 86973 NO 23585 STATE MEASURE 3 9867 0070006A 116 201 317
86974 86974 YES 23584 STATE MEASURE 3 9867 0070027A 0 0 0
86975 86975 NO 23585 STATE MEASURE 3 9867 0070027A 0 0 0
86976 86976 YES 23584 STATE MEASURE 3 9867 0070027B 0 1 1
86977 86977 NO 23585 STATE MEASURE 3 9867 0070027B 2 0 2
86978 86978 YES 23584 STATE MEASURE 3 9867 0070027C 0 0 0
86979 86979 NO 23585 STATE MEASURE 3 9867 0070027C 0 0 0
86980 86980 YES 23584 STATE MEASURE 3 9867 0070041B 21 69 90
86981 86981 NO 23585 STATE MEASURE 3 9867 0070041B 18 29 47
86982 86982 YES 23584 STATE MEASURE 3 9867 0070041F 7 9 16
86983 86983 NO 23585 STATE MEASURE 3 9867 0070041F 3 4 7
86984 86984 YES 23584 STATE MEASURE 3 9867 0070207A 6 22 28
86985 86985 NO 23585 STATE MEASURE 3 9867 0070207A 0 9 9
86986 86986 YES 23584 STATE MEASURE 3 9867 0080004A 196 1110 1306
86987 86987 NO 23585 STATE MEASURE 3 9867 0080004A 190 319 509
86988 86988 YES 23584 STATE MEASURE 3 9867 0080007A 387 1603 1990
86989 86989 NO 23585 STATE MEASURE 3 9867 0080007A 222 507 729
86990 86990 YES 23584 STATE MEASURE 3 9867 0080050A 448 1755 2203
86991 86991 NO 23585 STATE MEASURE 3 9867 0080050A 348 720 1068
86992 86992 YES 23584 STATE MEASURE 3 9867 0080054A 183 617 800
86993 86993 NO 23585 STATE MEASURE 3 9867 0080054A 139 268 407
86994 86994 YES 23584 STATE MEASURE 3 9867 0080070A 283 1453 1736
86995 86995 NO 23585 STATE MEASURE 3 9867 0080070A 205 463 668
86996 86996 YES 23584 STATE MEASURE 3 9867 0090002A 1 0 1
86997 86997 NO 23585 STATE MEASURE 3 9867 0090002A 0 0 0
86998 86998 YES 23584 STATE MEASURE 3 9867 0090002B 0 1 1
86999 86999 NO 23585 STATE MEASURE 3 9867 0090002B 0 6 6
87000 87000 YES 23584 STATE MEASURE 3 9867 0090002C 0 0 0
87001 87001 NO 23585 STATE MEASURE 3 9867 0090002C 0 0 0
87002 87002 YES 23584 STATE MEASURE 3 9867 0090005C 0 0 0
87003 87003 NO 23585 STATE MEASURE 3 9867 0090005C 0 0 0
87004 87004 YES 23584 STATE MEASURE 3 9867 0090005G 0 0 0
87005 87005 NO 23585 STATE MEASURE 3 9867 0090005G 0 1 1
87006 87006 YES 23584 STATE MEASURE 3 9867 0090006A 5 15 20
87007 87007 NO 23585 STATE MEASURE 3 9867 0090006A 11 3 14
87008 87008 YES 23584 STATE MEASURE 3 9867 0090007C 0 1 1
87009 87009 NO 23585 STATE MEASURE 3 9867 0090007C 0 0 0
87010 87010 YES 23584 STATE MEASURE 3 9867 0090009A 0 0 0
87011 87011 NO 23585 STATE MEASURE 3 9867 0090009A 0 0 0
87012 87012 YES 23584 STATE MEASURE 3 9867 0090010A 0 0 0
87013 87013 NO 23585 STATE MEASURE 3 9867 0090010A 0 0 0
87014 87014 YES 23584 STATE MEASURE 3 9867 0090011B 1 5 6
87015 87015 NO 23585 STATE MEASURE 3 9867 0090011B 3 9 12
87016 87016 YES 23584 STATE MEASURE 3 9867 0090012A 1 1 2
87017 87017 NO 23585 STATE MEASURE 3 9867 0090012A 0 6 6
87018 87018 YES 23584 STATE MEASURE 3 9867 0090017A 0 0 0
87019 87019 NO 23585 STATE MEASURE 3 9867 0090017A 0 0 0
87020 87020 YES 23584 STATE MEASURE 3 9867 0090019A 0 0 0
87021 87021 NO 23585 STATE MEASURE 3 9867 0090019A 0 0 0
87022 87022 YES 23584 STATE MEASURE 3 9867 0090021A 0 0 0
87023 87023 NO 23585 STATE MEASURE 3 9867 0090021A 0 0 0
87024 87024 YES 23584 STATE MEASURE 3 9867 0090023A 0 0 0
87025 87025 NO 23585 STATE MEASURE 3 9867 0090023A 0 0 0
87026 87026 YES 23584 STATE MEASURE 3 9867 0090025A 1 4 5
87027 87027 NO 23585 STATE MEASURE 3 9867 0090025A 0 0 0
87028 87028 YES 23584 STATE MEASURE 3 9867 0090025B 0 0 0
87029 87029 NO 23585 STATE MEASURE 3 9867 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]);