results

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

7,976 rows where contest_id = 9878

✎ 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
172802 172802 YES 23712 STATE MEASURE 2 9878 0050002B 31 0 31
172803 172803 NO 23713 STATE MEASURE 2 9878 0050002B 10 1 11
172804 172804 YES 23712 STATE MEASURE 2 9878 0050002G 1 0 1
172805 172805 NO 23713 STATE MEASURE 2 9878 0050002G 0 0 0
172806 172806 YES 23712 STATE MEASURE 2 9878 0050003A 116 211 327
172807 172807 NO 23713 STATE MEASURE 2 9878 0050003A 378 482 860
172808 172808 YES 23712 STATE MEASURE 2 9878 0050005A 267 509 776
172809 172809 NO 23713 STATE MEASURE 2 9878 0050005A 787 984 1771
172810 172810 YES 23712 STATE MEASURE 2 9878 0050007B 0 0 0
172811 172811 NO 23713 STATE MEASURE 2 9878 0050007B 0 0 0
172812 172812 YES 23712 STATE MEASURE 2 9878 0050010A 2 0 2
172813 172813 NO 23713 STATE MEASURE 2 9878 0050010A 0 1 1
172814 172814 YES 23712 STATE MEASURE 2 9878 0050014A 51 108 159
172815 172815 NO 23713 STATE MEASURE 2 9878 0050014A 127 223 350
172816 172816 YES 23712 STATE MEASURE 2 9878 0050015A 0 0 0
172817 172817 NO 23713 STATE MEASURE 2 9878 0050015A 1 0 1
172818 172818 YES 23712 STATE MEASURE 2 9878 0050022D 0 2 2
172819 172819 NO 23713 STATE MEASURE 2 9878 0050022D 0 0 0
172820 172820 YES 23712 STATE MEASURE 2 9878 0050023D 0 0 0
172821 172821 NO 23713 STATE MEASURE 2 9878 0050023D 0 0 0
172822 172822 YES 23712 STATE MEASURE 2 9878 0050025H 0 0 0
172823 172823 NO 23713 STATE MEASURE 2 9878 0050025H 0 0 0
172824 172824 YES 23712 STATE MEASURE 2 9878 0050027A 0 0 0
172825 172825 NO 23713 STATE MEASURE 2 9878 0050027A 1 0 1
172826 172826 YES 23712 STATE MEASURE 2 9878 0050029A 0 0 0
172827 172827 NO 23713 STATE MEASURE 2 9878 0050029A 0 0 0
172828 172828 YES 23712 STATE MEASURE 2 9878 0050037A 0 0 0
172829 172829 NO 23713 STATE MEASURE 2 9878 0050037A 0 0 0
172830 172830 YES 23712 STATE MEASURE 2 9878 0050042A 1 0 1
172831 172831 NO 23713 STATE MEASURE 2 9878 0050042A 0 2 2
172832 172832 YES 23712 STATE MEASURE 2 9878 0050055A 0 0 0
172833 172833 NO 23713 STATE MEASURE 2 9878 0050055A 0 0 0
172834 172834 YES 23712 STATE MEASURE 2 9878 0050066A 0 0 0
172835 172835 NO 23713 STATE MEASURE 2 9878 0050066A 0 0 0
172836 172836 YES 23712 STATE MEASURE 2 9878 0070001A 64 232 296
172837 172837 NO 23713 STATE MEASURE 2 9878 0070001A 129 280 409
172838 172838 YES 23712 STATE MEASURE 2 9878 0070002A 7 25 32
172839 172839 NO 23713 STATE MEASURE 2 9878 0070002A 8 23 31
172840 172840 YES 23712 STATE MEASURE 2 9878 0070005A 99 376 475
172841 172841 NO 23713 STATE MEASURE 2 9878 0070005A 154 415 569
172842 172842 YES 23712 STATE MEASURE 2 9878 0070005B 2 3 5
172843 172843 NO 23713 STATE MEASURE 2 9878 0070005B 3 5 8
172844 172844 YES 23712 STATE MEASURE 2 9878 0070006A 158 511 669
172845 172845 NO 23713 STATE MEASURE 2 9878 0070006A 180 389 569
172846 172846 YES 23712 STATE MEASURE 2 9878 0070027A 0 0 0
172847 172847 NO 23713 STATE MEASURE 2 9878 0070027A 0 0 0
172848 172848 YES 23712 STATE MEASURE 2 9878 0070027B 0 1 1
172849 172849 NO 23713 STATE MEASURE 2 9878 0070027B 2 0 2
172850 172850 YES 23712 STATE MEASURE 2 9878 0070027C 0 0 0
172851 172851 NO 23713 STATE MEASURE 2 9878 0070027C 0 0 0
172852 172852 YES 23712 STATE MEASURE 2 9878 0070041B 21 57 78
172853 172853 NO 23713 STATE MEASURE 2 9878 0070041B 21 45 66
172854 172854 YES 23712 STATE MEASURE 2 9878 0070041F 4 7 11
172855 172855 NO 23713 STATE MEASURE 2 9878 0070041F 6 6 12
172856 172856 YES 23712 STATE MEASURE 2 9878 0070207A 0 13 13
172857 172857 NO 23713 STATE MEASURE 2 9878 0070207A 6 18 24
172858 172858 YES 23712 STATE MEASURE 2 9878 0080004A 137 804 941
172859 172859 NO 23713 STATE MEASURE 2 9878 0080004A 252 626 878
172860 172860 YES 23712 STATE MEASURE 2 9878 0080007A 286 1185 1471
172861 172861 NO 23713 STATE MEASURE 2 9878 0080007A 322 925 1247
172862 172862 YES 23712 STATE MEASURE 2 9878 0080050A 371 1406 1777
172863 172863 NO 23713 STATE MEASURE 2 9878 0080050A 423 1056 1479
172864 172864 YES 23712 STATE MEASURE 2 9878 0080054A 140 468 608
172865 172865 NO 23713 STATE MEASURE 2 9878 0080054A 183 420 603
172866 172866 YES 23712 STATE MEASURE 2 9878 0080070A 193 1019 1212
172867 172867 NO 23713 STATE MEASURE 2 9878 0080070A 301 891 1192
172868 172868 YES 23712 STATE MEASURE 2 9878 0090002A 1 0 1
172869 172869 NO 23713 STATE MEASURE 2 9878 0090002A 0 0 0
172870 172870 YES 23712 STATE MEASURE 2 9878 0090002B 0 1 1
172871 172871 NO 23713 STATE MEASURE 2 9878 0090002B 0 6 6
172872 172872 YES 23712 STATE MEASURE 2 9878 0090002C 0 0 0
172873 172873 NO 23713 STATE MEASURE 2 9878 0090002C 0 0 0
172874 172874 YES 23712 STATE MEASURE 2 9878 0090005C 0 0 0
172875 172875 NO 23713 STATE MEASURE 2 9878 0090005C 0 0 0
172876 172876 YES 23712 STATE MEASURE 2 9878 0090005G 0 0 0
172877 172877 NO 23713 STATE MEASURE 2 9878 0090005G 0 1 1
172878 172878 YES 23712 STATE MEASURE 2 9878 0090006A 6 12 18
172879 172879 NO 23713 STATE MEASURE 2 9878 0090006A 9 5 14
172880 172880 YES 23712 STATE MEASURE 2 9878 0090007C 0 1 1
172881 172881 NO 23713 STATE MEASURE 2 9878 0090007C 0 0 0
172882 172882 YES 23712 STATE MEASURE 2 9878 0090009A 0 0 0
172883 172883 NO 23713 STATE MEASURE 2 9878 0090009A 0 0 0
172884 172884 YES 23712 STATE MEASURE 2 9878 0090010A 0 0 0
172885 172885 NO 23713 STATE MEASURE 2 9878 0090010A 0 0 0
172886 172886 YES 23712 STATE MEASURE 2 9878 0090011B 2 5 7
172887 172887 NO 23713 STATE MEASURE 2 9878 0090011B 2 9 11
172888 172888 YES 23712 STATE MEASURE 2 9878 0090012A 0 0 0
172889 172889 NO 23713 STATE MEASURE 2 9878 0090012A 1 7 8
172890 172890 YES 23712 STATE MEASURE 2 9878 0090017A 0 0 0
172891 172891 NO 23713 STATE MEASURE 2 9878 0090017A 0 0 0
172892 172892 YES 23712 STATE MEASURE 2 9878 0090019A 0 0 0
172893 172893 NO 23713 STATE MEASURE 2 9878 0090019A 0 0 0
172894 172894 YES 23712 STATE MEASURE 2 9878 0090021A 0 0 0
172895 172895 NO 23713 STATE MEASURE 2 9878 0090021A 0 0 0
172896 172896 YES 23712 STATE MEASURE 2 9878 0090023A 0 0 0
172897 172897 NO 23713 STATE MEASURE 2 9878 0090023A 0 0 0
172898 172898 YES 23712 STATE MEASURE 2 9878 0090025A 1 4 5
172899 172899 NO 23713 STATE MEASURE 2 9878 0090025A 0 0 0
172900 172900 YES 23712 STATE MEASURE 2 9878 0090025B 0 0 0
172901 172901 NO 23713 STATE MEASURE 2 9878 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]);