special-elections/special-elections

200 rows

View and edit SQL

Link rowid Date State Race Median Household Income % Bachelor's Degree or Higher Clinton Margin Improvement Over Obama 2017-2018 Dem Margin Improvement Over Partisan Lean
101 11/7/17 Virginia HD-84 $72,439 29.60% -4% 2%
102 11/7/17 Virginia HD-26 $44,910 30.90% 4% 2%
103 11/7/17 Virginia HD-08 $57,077 32.20% -4% 2%
104 11/7/17 Virginia HD-09 $41,015 16.50% -15% 2%
105 11/7/17 New Jersey SD-11 $69,007 36.80% -4% 2%
106 11/7/17 New York SD-26 $76,767 57.40% 8% 2%
107 11/7/17 Georgia SD-39 $46,328 42.80% 5% 2%
108 11/7/17 New Jersey Governor $73,702 37.50% -4% 2%
109 11/7/17 New Jersey SD-12 $92,738 37.00% -11% 2%
110 11/7/17 New Jersey SD-15 $69,704 39.60% 3% 2%
111 11/7/17 New Jersey SD-39 $112,306 53.30% 5% 1%
112 11/7/17 Virginia HD-73 $60,308 42.60% 14% 1%
113 11/7/17 Virginia HD-51 $111,208 45.50% 5% 1%
114 11/7/17 Virginia HD-96 $77,882 43.50% 5% 1%
115 11/7/17 Virginia HD-65 $81,509 40.60% 4% 1%
116 11/7/17 Virginia HD-82 $68,442 45.30% 3% 1%
117 11/7/17 Virginia HD-91 $69,874 36.60% 0% 1%
118 11/7/17 New Jersey SD-17 $78,064 43.80% -1% 1%
119 11/7/17 Virginia HD-23 $51,544 36.90% 1% 1%
120 11/7/17 Virginia HD-59 $50,804 20.90% -9% 0%
121 11/7/17 Virginia HD-88 $83,642 35.70% -2% 0%
122 11/7/17 New Jersey SD-25 $103,290 51.60% 9% 0%
123 11/7/17 Virginia HD-29 $61,152 28.90% -7% 0%
124 11/7/17 Virginia HD-30 $61,322 23.80% -11% 0%
125 11/7/17 Virginia HD-98 $57,800 22.00% -10% 0%
126 11/7/17 Washington HD-07, Position 1 $49,503 21.50% -10% 0%
127 11/7/17 New Jersey SD-26 $102,247 49.30% 1% 0%
128 11/7/17 Virginia HD-18 $79,868 31.20% -7% -1%
129 11/7/17 Virginia HD-66 $75,357 33.90% 3% -1%
130 11/7/17 Missouri HD-23 $20,915 9.20% -7% -1%
131 11/7/17 Virginia HD-64 $64,885 25.10% -7% -1%
132 11/7/17 Virginia HD-50 $90,511 36.10% 5% -2%
133 11/7/17 New Jersey SD-40 $107,455 51.80% 5% -2%
134 11/7/17 Virginia HD-68 $84,020 62.90% 22% -2%
135 11/7/17 Washington SD-07 $49,503 21.50% -10% -2%
136 11/7/17 Virginia HD-07 $50,962 24.50% -9% -2%
137 11/7/17 New Jersey SD-09 $64,135 25.50% -17% -2%
138 11/7/17 Virginia HD-97 $75,115 29.50% 0% -3%
139 11/7/17 Michigan HD-01 $41,708 25.20% -1% -3%
140 11/7/17 Virginia HD-94 $61,099 31.60% 0% -3%
141 11/7/17 Virginia HD-13 $86,591 38.10% 4% -4%
142 11/7/17 Virginia HD-54 $82,300 31.00% -4% -4%
143 11/7/17 New Jersey SD-23 $90,110 42.80% 0% -4%
144 11/7/17 Virginia HD-67 $132,382 66.00% 18% -4%
145 11/7/17 Virginia HD-83 $63,501 35.10% -1% -4%
146 11/7/17 Virginia HD-58 $66,793 33.90% 1% -5%
147 11/7/17 Virginia HD-40 $133,910 62.20% 15% -5%
148 11/7/17 Washington SD-31 $74,079 24.50% -6% -5%
149 11/7/17 Virginia HD-99 $59,420 26.20% -8% -5%
150 11/7/17 New Jersey SD-08 $80,151 35.50% -5% -6%
151 11/7/17 Washington HD-31, Position 2 $74,079 24.50% -6% -6%
152 11/7/17 Virginia HD-100 $41,343 20.40% -8% -6%
153 11/7/17 Massachusetts 3rd Essex HD $57,139 25.00% -3% -7%
154 11/7/17 Georgia SD-06 $67,687 61.10% 23% -9%
155 11/7/17 Virginia HD-60 $38,126 17.00% -10% -10%
156 11/7/17 New Jersey SD-16 $110,138 57.90% 7% -11%
157 11/7/17 New Jersey SD-21 $120,556 60.80% 15% -13%
158 11/7/17 New Jersey SD-02 $53,312 25.70% -9% -18%
159 11/7/17 Washington SD-45 $114,762 61.60% 18% -19%
160 11/7/17 Georgia HD-04 $37,945 13.50% 4% -37%
161 10/24/17 New Hampshire Strafford HD-13 $51,139 46.60% 1% 26%
162 10/17/17 Massachusetts Bristol & Norfolk SD $93,175 46.60% 9% -3%
163 9/26/17 South Carolina HD-31 $26,265 11.90% -11% 34%
164 9/26/17 New Hampshire Rockingham HD-04 $104,216 36.00% -2% 27%
165 9/26/17 Florida SD-40 $56,773 31.30% 8% -10%
166 9/26/17 Florida HD-116 $50,344 32.70% 15% -30%
167 9/12/17 Oklahoma HD-46 $61,346 45.30% 9% 36%
168 9/12/17 New Hampshire Belknap HD-09     -17% 26%
169 9/5/17 New Hampshire Grafton HD-09 $51,188 25.10% -17% 9%
170 8/22/17 Rhode Island SD-13 $70,110 54.00% 4% -7%
171 8/8/17 Iowa HD-82 $46,740 24.80% -23% 27%
172 8/8/17 Missouri HD-50 $63,174 43.20% 2% 20%
173 8/8/17 Missouri SD-28 $38,210 14.80% -19% 18%
174 7/25/17 New Hampshire SD-16 $74,821 41.10% 1% 13%
175 7/18/17 New Hampshire Merrimack HD-18 $36,818 28.50% -2% 36%
176 7/11/17 Oklahoma SD-44 $41,433 13.70% 3% 31%
177 7/11/17 Oklahoma HD-75 $49,132 23.60% 5% 30%
178 6/20/17 South Carolina 5th CD $46,062 22.20% -7% 16%
179 6/20/17 South Carolina HD-70 $38,535 17.60% -6% 14%
180 6/20/17 South Carolina HD-48 $66,923 41.90% 3% 6%
181 6/20/17 Georgia 6th CD $82,390 59.10% 22% 6%
182 6/15/17 Tennessee HD-95 $116,023 58.80% 13% 18%
183 5/30/17 South Carolina HD-84 $42,572 14.80% -5% 15%
184 5/25/17 Montana At-Large CD $48,380 29.90% -7% 16%
185 5/23/17 New York AD-09 $103,602 36.90% -11% 38%
186 5/23/17 New Hampshire Carroll HD-06 $51,051 41.40% 6% 15%
187 5/23/17 New York SD-30 $40,552 41.10% -2% 0%
188 5/23/17 New Hampshire Hillsborough HD-44     -6% -1%
189 5/16/17 Georgia SD-32 $98,416 62.00% 21% 8%
190 5/9/17 Oklahoma HD-28 $41,272 14.30% -12% 47%
191 4/29/17 Louisiana SD-02 $44,926 16.40% -5% 61%
192 4/25/17 Connecticut HD-68 $76,970 31.60% -11% -23%
193 4/11/17 Kansas 4th CD $51,260 28.20% -2% 23%
194 4/4/17 California 34th CD $37,136 24.20% 4% 18%
195 2/28/17 Connecticut SD-32 $84,965 41.40% -6% 10%
196 2/28/17 Connecticut HD-115 $49,576 20.10% -21% 7%
197 2/28/17 Connecticut SD-02 $49,211 27.70% -2% -20%
198 2/25/17 Delaware SD-10 $93,482 41.70% -5% 5%
199 2/14/17 Minnesota HD-32B $74,908 23.80% -17% 21%
200 1/31/17 Iowa HD-89 $50,810 25.90% -16% 32%

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "special-elections/special-elections" (
"Date" TEXT,
  "State" TEXT,
  "Race" TEXT,
  "Median Household Income" TEXT,
  "% Bachelor's Degree or Higher" TEXT,
  "Clinton Margin Improvement Over Obama" TEXT,
  "2017-2018 Dem Margin Improvement Over Partisan Lean" TEXT
);
Powered by Datasette · Query took 5.627ms