ud_elect

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ case_number suffix election_date cunion description_election expedited unit date_election_held type_election no_elig v_votes for_prop agn_prop chall void cout control date_election_certified stage method mail_ballot cross_pet_region cross_pet_type cross_pet_docket cross_pet_suffix rerun_runoff_number impounded
1 1 01-UD-000190 A 1983-10-27 1061 1 0 A 1983-10-27 S 67 59 19 39 1 0 0 0 1983-11-07 2 3 0            
2 2 01-UD-000192 A 1984-04-17 2451 1 0 A 1984-04-17 S 23 22 12 10 0 0 1 0 1984-09-13 2 4 0            
3 3 01-UD-000196 A 1984-11-01 1141 1 0 A 1984-11-01 S 140 135 53 79 3 0 0 0 1987-08-28 2 3 0           0
4 4 01-UD-000196 K 1987-08-20 1141 3 0 A 1987-08-20 S 125 101 12 89 0 0 0 0 1987-08-28 2 3 0         1 0
5 5 01-UD-000197 A 1984-10-19 5000 1 0 A 1984-10-19 S 42 35 25 10 0 0 1 0 1984-10-30 1 4 0           0
6 6 01-UD-000198 A 1985-01-03 1031 1 0 A 1985-01-03 S 114 96 31 65 0 0 0   1985-01-14 1 3 0            
7 7 01-UD-000200 A 1985-03-27 1187 1 0 A 1985-03-27 S 23 23 11 12 0 0 0 0 1985-04-05 1 3 0           0
8 8 01-UD-000201 A 1985-04-17 1132 1 0 A 1985-04-17 R 17 16 4 12 0 0 0 0 1985-04-26 7 4 0           0
9 9 01-UD-000203 A 1986-02-27 1141 1 0 A 1986-02-27 R 55 30 30 0 0 0 1 0 1986-03-10 7 4 0           0
10 10 01-UD-000205 A 1986-04-22 4233 1 0 A 1986-04-22 R 8 8 6 2 0 0 1 0 1986-08-11 3 4 0           0
11 11 01-UD-000210 A 1987-01-07 1187 1 0 A 1987-01-07 C 210 180 78 102 0 0 0 0 1987-01-16 1 3 0           0
12 12 01-UD-000214 A 1987-04-23 1132 1 0 A 1987-04-23 R 16 16 16 0 0 0 0 0 1987-05-01 7 4 0           0
13 13 01-UD-000215 A 1987-06-10 4233 1 0 C 1987-06-10 S 4 4 3 1 0 0 1 0 1987-06-18 1 4 0           0
14 14 01-UD-000216 A 1987-12-10 1241 1 0 A 1987-12-10 S 40 35 19 16 0 0 1 0 1988-12-14 X 3 0           0
15 15 01-UD-000218 A 1988-04-28 1061 1 0 A 1988-04-28 R 18 18 4 14 0 0 0 0 1988-05-09 7 3 0           0
16 16 01-UD-000219 A 1988-07-21 1015 1 0 A 1988-07-21 R 149 120 85 35 0 0 1 0 1988-07-29 7 4 0           0
17 17 01-UD-000222 A 1988-11-16   1 0 A 1988-11-16 R 2 2 2 0 0 0 1 0 1988-11-28 3 4 0           0
18 18 01-UD-000225 A 1989-09-15 1061 1 0 D 1989-09-15 R 4 4 4 0 0 0 1 0 1989-09-27 7 4 0           0
19 19 01-UD-000228 A 1990-03-16 2463 1 0 A 1990-03-16 S 11 11 6 5 0 0 1 0 1990-06-14 X 4 0           0
20 20 01-UD-000229 A 1990-04-19   1 0 A 1990-04-19 S 17 17 9 8 0 0 1 0 1990-04-30 1 4 0           0
21 21 01-UD-000231 A 1990-09-13 4233 1 0 A 1990-09-13 R 72 68 10 47 11 0 0 0 1990-09-24 7 3 0           0
22 22 01-UD-000232 A 1990-11-06 4233 1 0 A 1990-11-06 S 79 64 41 23 0 0 1 0 1990-12-18 X 4 0           0
23 23 01-UD-000233 A 1991-02-21   1 0 A 1991-02-21 S 78 70 29 41 0 0 0 0 1991-03-04 1 3 0           0
24 24 01-UD-000234 A 1991-03-28 2463 1 0 D 1991-03-28 S 6 6 3 3 0 0 0 0 1991-04-08 1 3 0           0
25 25 01-UD-000235 A 1991-04-04   1 0 W 1991-04-04 S 39 36 28 8 0 0 1 0 1991-04-15 1 4 0           0
26 26 01-UD-000236 A 1991-10-31 4233 1 0 A 1991-10-31 S 37 37 14 23 0 0 0 0 1991-11-20 1 3 0           0
27 27 01-UD-000237 A 1992-01-10   1 0 W 1992-01-10 S 2 2 2 0 0 0 1 0 1992-01-22 1 4 0           0
28 28 01-UD-000239 A 1992-11-24   1 0 D 1992-11-24 S 9 9 3 6 0 0 0 0 1992-12-04 1 3 0           0
29 29 01-UD-000241 A 1992-10-23 2583 1 0 W 1992-10-23 R 2 2 2 0 0 0 1 0 1992-11-03 7 4 0           0
30 30 01-UD-000242 A 1993-04-02   1 0 D 1993-04-02 S 12 12 11 1 0 0 1 0 1993-04-13 1 4 0           0
31 31 01-UD-000248 A 1996-07-25 2303 1 0 A 1996-07-25 S 52 50 13 37 0 0 0 0 1996-08-07 1 3 0           0
32 32 02-UD-000281 A 1984-02-08 5000 1 0 G 1984-02-08 R 98 85 48 37 0 0 0 0 1984-02-16 7 4 0            
33 33 02-UD-000283 A 1986-02-28 1105 1 0 A 1986-02-28 S 213 121 111 4 6 1 1 0 1986-03-14 2 4 0           0
34 34 02-UD-000286 A 1986-06-26 2583 1 0 A 1986-06-26 S 78 61 34 27 0 0 1 0 1987-09-10 X 4 0           0
35 35 02-UD-000287 A 1986-10-23 2665 1 0 A 1986-10-23 S 18 16 13 3 0 0 1 0 1986-10-31 1 4 0           0
36 36 02-UD-000292 A 1988-07-25 1105 1 0 A 1988-07-25 S 12 7 6 1 0 0 1 0 1988-10-06 X 4 0           0
37 37 02-UD-000294 A 1988-10-13 4233 1 0 T 1988-10-13 S 13 7 6 1 0 0 1 0 1988-12-08 X 4 0           0
38 38 02-UD-000294 B 1988-12-08 4233 A 0 T 1988-10-13 S 11 7 6 1 0 0 1 0 1988-12-08 X 4 0           0
39 39 02-UD-000295 A 1988-10-13 4233 1 0 T 1988-10-13 S 26 24 22 2 0 0 1 0 1988-10-21 1 4 0           0
40 40 02-UD-000296 A 1988-12-16 1023 1 0 A 1988-12-16 R 49 46 43 3 0 0 1 0 1988-12-27 7 4 0           0
41 41 02-UD-000309 A 1993-01-27 no 1 0 A 1993-01-27 S 65 39 20 17 2 0 0 0 1993-02-04 1 3 0           0
42 42 02-UD-000310 A 1993-03-04 2303 1 0 A 1993-03-04 S 41 27 22 5 0 0 1 0 1993-03-12 1 4 0           0
43 43 02-UD-000312 A 1992-09-18 4233 1 0 T 1992-09-18 S 23 20 5 13 2 0 0 0 1992-09-28 1 3 0           0
44 44 02-UD-000315 A 1993-06-22 5000 1 0 A 1993-06-22 R 153 117 77 40 0 0 1 0 1993-10-28 X 4 0           0
45 45 02-UD-000317 A 1994-02-25 N 1 0 A 1994-02-25 S 16 15 4 11 0 0 0 0 1994-02-25 1 4 0           0
46 46 02-UD-000325 A 1996-09-25   1 0 A 1996-09-25 S 135 128 33 88 7 1 0 0 1996-10-03 1 3 0           0
47 47 02-UD-000327 A 1998-06-02   1 0 A 1998-06-02 S 73 64 63 1 0 0 1 0 1998-07-28 1 4 0           0
48 48 02-UD-000331 A 1998-12-10   1 0 A 1998-12-10 R 2 1 0 1 0 0 0 0 1998-12-18 7 4 0           0
49 49 02-UD-000332 A 1999-05-06   1 0 A 1999-05-06 R 24 2 1 1 0 0 0 0 1999-05-14 7 4 0           0
50 50 02-UD-000333 A 1999-05-21   1 0 A 1999-05-21 S 45 34 30 1 3 0 1 0 1999-06-01 1 4 0           0
51 51 03-UD-000118 A 1983-04-12 1245 1 0 A 1983-04-12 S 189 163 90 73 0 1 0 0 1983-10-19 X 4 0           0
52 52 03-UD-000118 P 1983-10-11 5000 4 0 A 1983-10-11 S 177 162 95 67 0 2 1 0 1983-10-19 X 4 0           0
53 53 03-UD-000119 A 1983-10-20 1148 1 0 A 1983-10-20 S 35 34 10 24 0 0 0 0 1983-10-28 X 4 0           0
54 54 03-UD-000120 A 1983-09-29 1141 1 0 A 1983-09-29 S 23 23 3 20 0 0 0 0 1983-10-07 X 4 0           0
55 55 03-UD-000122 A 1984-02-23 1241 1 0 A 1984-02-23 S 6 5 4 1 0 0 1 0 1984-03-08 X 4 0           0
56 56 03-UD-000123 A 1984-04-04 1023 1 1 A 1984-04-04 E 115 98 25 73 0 0 0 0 1984-04-12 3 3 0           0
57 57 03-UD-000124 A 1985-08-30 2583 1 0 A 1985-08-30 S 26 22 20 2 0 0 1 0 1985-09-13 1 4 0           0
58 58 03-UD-000125 A 1984-04-18 4233 1 0 P 1984-04-18 S 21 19 11 8 0 0 1 0 1984-04-26 X 4 0           0
59 59 03-UD-000126 A 1984-09-19 1088 1 0 A 1984-09-19 S 23 22 20 2 0 0 1 0 1984-09-27 X 4 0           0
60 60 03-UD-000129 A 1985-08-23 1088 1 0 A 1985-08-23 C 85 73 29 44 0 0 1 0 1985-09-03 1 4 0           0
61 61 03-UD-000130 A 1985-11-06 1031 1 0 A 1985-11-06 S 7 6 4 1 1 0 1 0 1985-11-15 1 4 0           0
62 62 03-UD-000133 A 1986-03-14 1245 1 0 C 1986-03-14 S 25 22 18 4 0 0 1 0 1986-03-24 X 4 0           0
63 63 03-UD-000134 A 1987-09-18 1105 1 0 A 1987-09-18 S 409 322 275 33 14 1 1 0 1987-12-09 X 4 0           0
64 64 03-UD-000136 A 1987-11-30 2303 1 1 A 1987-11-30 E 12 10 5 5 0 0 0 0 1987-12-07 1 4 0           0
65 65 03-UD-000137 A 1988-04-22 1241 1 0 A 1988-04-22 R 37 30 23 7 0 0 1 0 1988-05-02 7 4 0           0
66 66 03-UD-000138 A 1988-06-10 4233 1 0 T 1988-06-10 S 77 64 22 42 0 0 0 0 1989-02-06 X 4 0           0
67 67 03-UD-000140 A 1988-11-04 5000 1 0 A 1988-11-04 R 180 87 53 34 0 0 1 0 1988-11-25 3 3 0           1
68 68 03-UD-000141 A 1989-01-13 4541 1 0 A 1989-01-13 R 49 35 21 14 0 0 0 0 1989-01-23 3 4 0           0
69 69 03-UD-000149 A 1989-03-17 4233 1 0 T 1989-03-17 R 75 66 23 43 0 0 0 0 1989-03-27 7 4 0           0
70 70 03-UD-000150 A 1989-11-21 1023 1 0 A 1989-11-21 R 4 4 2 1 1 0 0 0 1990-01-10 7 4 0           1
71 71 03-UD-000152 A 1989-08-18 4233 1 0 A 1989-08-18 S 27 16 14 2 0 1 1 0 1989-08-28 1 4 0           0
72 72 03-UD-000154 A 1989-11-16 1141 1 0 A 1989-11-16 S 23 22 18 4 0 0 1 0 1989-11-29 1 4 0           0
73 73 03-UD-000155 A 1991-01-17 1105 1 0 A 1991-01-17 S 22 21 11 10 0 1 0 0 1991-03-25 X 3 0           0
74 74 03-UD-000155 K 1991-03-14 1105 3 0 A 1991-03-14 S 26 22 9 13 0 0 0 0 1991-03-25 X 3 0         1 0
75 75 03-UD-000163 A 1992-12-04 2583 1 0 A 1992-12-04 S 12 11 11 0 0 0 1 0 1992-12-15 1 4 0           0
76 76 03-UD-000164 A 1993-03-24 1021 1 0 A 1993-03-24 S 36 33 10 23 0 0 0 0 1993-04-05 1 4 0           0
77 77 03-UD-000165 A 1993-03-23 4233 1 0 A 1993-03-23 S 8 7 3 4 0 0 0 0 1993-06-16 1 4 0           0
78 78 03-UD-000165 K 1993-06-08 4233 3 0 A 1993-06-08 S 6 6 6 0 0 0 1 0 1993-06-16 1 4 0         1 0
79 79 03-UD-000169 A 1996-06-15 4233 1 0 T 1996-06-15 S 23 19 8 6 5 0 0 0 1996-10-11 1 4 0           0
80 80 03-UD-000169 B 1996-07-17 2323 A 0 A 1996-06-15 S 23 19 11 8 0 0 0 0 1996-10-11 1 4 0           0
81 81 03-UD-000170 A 1995-03-24 2323 1 0 A 1995-03-24 S 9 8 6 2 0 0 1 0 1995-04-05 1 4 0           0
82 82 03-UD-000174 A A 1995-07-28 5000 1 0 A 1995-07-28 S 150 144 35 109 0 0 0 0 1995-07-28 1 3 0           0
83 83 03-UD-000180 A 1996-09-04 1031 1 0 A 1996-09-04 S 13 13 10 3 0 0 1 0 1996-09-12 1 4 0           0
84 84 03-UD-000181 A 1996-10-22 1031 1 0 A 1996-10-22 S 4 4 3 1 0 0 1 0 1996-10-30 1 4 0           0
85 85 03-UD-000182 A 1997-07-31 1213 1 0 A 1997-07-31 S 22 22 21 1 0 0 1 0 1997-08-21 1 4 0           0
86 86 03-UD-000183 A 1997-05-08 1141 1 0 A 1997-05-08 S 9 9 6 3 0 0 1 0 1997-05-21 1 3 0           0
87 87 03-UD-000184 A 1998-02-06 1105 1 0 A 1998-02-06 S 141 105 65 35 5 0 0 0 1998-12-31 1 4 0           0
88 88 03-UD-000184 F 1998-12-10 1105 2 0 A 1998-12-10 S 132 103 24 78 1 0 0 0 1998-12-31 1 4 0         1 0
89 89 03-UD-000185 A 1998-06-01 2323 1 0 A 1998-06-01 R 37 24 10 14 0 0 0 0 1998-06-09 7 4 0           0
90 90 04-UD-000219 A 1984-01-26 1166 1 0 A 1984-01-26 R 78 75 48 25 2 0 0 0 1984-02-06 3 3 0           0
91 91 04-UD-000221 A 1983-11-03 4233 1 0 T 1983-11-03 R 117 113 53 59 1 0 0 0 1983-11-14 7 4 0           0
92 92 04-UD-000222 A 1983-12-16 5000 1 0 A 1983-12-16 R 352 301 246 54 1 1 1 0 1983-12-27 3 4 0            
93 93 04-UD-000223 A 1984-01-20 4977 1 0 A 1984-01-20 R 34 32 20 12 0 0 1 0 1984-01-30 3 4 0            
94 94 04-UD-000224 A 1984-02-17 5000 1 0 A 1984-02-17 S 5 4 0 4 0 0 1 0 1984-02-29 2 4 0           0
95 95 04-UD-000225 A 1984-03-29 1241 1 0 A 1984-03-29 R 11 9 6 3 0 0 1 0 1984-04-06 3 4 0           0
96 96 04-UD-000227 A 1984-04-19 1187 1 0 A 1984-04-19 C 21 17 11 6 0 0 1 0 1984-05-01 1 4 0            
97 97 04-UD-000228 A 1984-05-04 1130 1 0 A 1984-05-04 R 118 51 27 24 4 0 0 0 1984-05-15 3 3 0            
98 98 04-UD-000230 A 1984-08-03 1084 1 0 A 1984-08-03 S 65 42 18 13 11 2 0 0       0            
99 99 04-UD-000231 A 1984-07-25 1121 1 0 D 1984-07-25 R 14 14 7 4 3 0 0 0 1984-09-26 3 4 0            
100 100 04-UD-000231 B 1984-09-17 1121 A 0 D 1984-07-25 R 14 14 8 4 2 0 1 0 1984-09-26 3 4 0            

Next page

CREATE TABLE "ud_elect" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [suffix] TEXT,
   [election_date] TEXT,
   [cunion] TEXT,
   [description_election] TEXT,
   [expedited] INTEGER,
   [unit] TEXT,
   [date_election_held] TEXT,
   [type_election] TEXT,
   [no_elig] INTEGER,
   [v_votes] INTEGER,
   [for_prop] INTEGER,
   [agn_prop] INTEGER,
   [chall] INTEGER,
   [void] INTEGER,
   [cout] INTEGER,
   [control] INTEGER,
   [date_election_certified] TEXT,
   [stage] TEXT,
   [method] TEXT,
   [mail_ballot] INTEGER,
   [cross_pet_region] TEXT,
   [cross_pet_type] TEXT,
   [cross_pet_docket] TEXT,
   [cross_pet_suffix] TEXT,
   [rerun_runoff_number] TEXT,
   [impounded] INTEGER
);