2017-18 State/Federal Special Election Results & Swings (UPDATED)

[Adam Griffin]

2017 SPECIAL ELECTIONS:
(see next post for 2018 specials)

Average congressional swing, 2017: D+15.9
Average state legislative swing, 2017: D+9.1

Congressional:
 

Type	State	Dist	Date	Runoff	'16 Mar	'16 P Mar	Special Mar	Swing (Avg)
House	CA	34	4/4/17	6/6/17	(D vs D)	D+73	D+901	D+17
House	KS	4	4/11/17		R+31	R+27	R+7	D+22
House	MT	A-L	5/25/17		R+16	R+20	R+6	D+12
House	GA	6	4/18/17	6/20/17	R+23	R+2	R+4	D+9
House	SC	5	6/20/17		R+21	R+19	R+3	D+17
House	UT	3	11/7/17		R+47	R+24	R+32	D+4
Senate	AL	A-L	12/12/17		R+28	R+28	D+2	D+30

 
State Legislative
 

Type	State	Dist	Date	Runoff	'16 Mar	'16 P Mar	Special Mar	Swing (Avg)
House	AL	79	11/29/16		N/A	R+9	No Oppo	N/A
Senate	GA	54	12/13/16	1/10/17	N/A	R+58	R+31	D+27
Senate	IA	45	12/27/17		D+644	D+16	D+48	D+8
Senate	VA	9	1/10/17		N/A	D+48	D+83	D+35
Senate	VA	22	1/10/17		N/A	R+15	R+14	D+1
House	VA	85	1/10/17		N/A	R+1	R+6	R+5
House	IA	89	1/31/17		N/A	D+11	D+45	D+34
House	VA	71	2/7/17		D+78	D+75	D+80	D+3
House	MN	32B	2/14/17		R+123	R+29	R+7	D+14
Senate	DE	10	2/14/17		R+24	D+13	D+17	D+11
Senate	CT	2	2/28/17		D+67	D+69	D+49	R+19
Senate	CT	32	2/28/17		R+36	R+18	R+10	D+17
House	CT	115	2/28/17		D+38	D+22	D+28	R+2
House	PA	197	3/21/17		N/A	D+92	D+77	R+15
House	LA	8	3/25/17	4/29/17	N/A	R+447	(R vs R)	N/A
House	LA	42	3/25/17	4/29/17	N/A	R+517	(R vs R)	N/A
House	LA	92	3/25/17	4/29/17	N/A	D+27	R+745	R+76
Senate	GA	32	4/18/17	5/16/17	N/A	R+13	R+14	R+1
House	AL	67	4/18/17		N/A	D+34	D+906	D+56
House	CT	7	4/25/17		N/A	D+83	(D vs D)	N/A
House	CT	68	4/25/17		N/A	R+33	R+56	R+23
Senate	LA	2	4/29/17	5/27/17	(D vs D)	D+237	(D vs D)	N/A
House	OK	28	5/9/17		R+34	R+50	R+2	D+40
Senate	NY	30	5/23/17		D+91	D+90	D+89	R+2
House	NY	9	5/23/17		R+23	R+37	D+16	D+46
House	AL	58	5/23/17		N/A		No Oppo	N/A
House	NH	CRL 6	5/23/17		R+14	R+7	D+4	D+15
House	NH	HLB 44	5/23/17		R+16	R+9	R+10	D+3
Senate	SC	3	5/30/17		N/A	R+48	No Oppo*	N/A
House	SC	84	5/30/17		N/A	R+34	R+21	D+13
House	TN	95	6/15/17		N/A	R+39	R+27	D+12
House	SC	48	6/20/17		N/A	R+24	R+22	D+2
House	SC	70	6/20/17		N/A	D+43	D+56	D+13
Senate	OK	44	7/11/17		R+104	R+19	D+9	D+24
House	OK	75	7/11/17		R+19	R+22	D+5	D+26
House	NH	MCK 18	7/18/17		D+12	D+21	D+56	D+39
Senate	NH	16	7/25/17		D+2	D+0	D+10	D+9
Senate	MA	MDL 4	7/25/17		N/A	D+29	D+768	D+47
House	MS	108	7/25/17		R+544	R+75	R+609	D+5
Senate	WA	45	8/1/17	11/7/17	R+54	D+37	D+92	R+72
House	IA	82	8/8/17		N/A	R+21	D+10	D+31
Senate	MO	28	8/8/17		N/A	R+52	R+40	D+12
House	MO	50	8/8/17		N/A	R+21	R+4	D+17
Senate	RI	13	8/22/17		D+104	D+36	D+20	R+3
House	OK	46	9/12/17		R+20	R+10	D+21	D+36
Senate	FL	40	9/26/17		R+10	D+18	D+4	0
House	FL	116	9/26/17		R+24	D+4	R+32	R+22
House	NH	RCK 4	9/26/17		R+40	R+23	D+2	D+33
House	SC	31	9/26/17		D+54	D+48	D+82	D+31
House	FL	44	10/10/17		N/A	D+6	R+11	R+17
House	LA	58	10/14/17		D+100	D+43	D+100	D+27
House	LA	77	10/14/17		N/A	R+58	R+100	R+21
Senate	MA	BR/NF	10/17/17		N/A	D+11	D+4	R+7
House	NH	STR 13	10/24/17		N/A	D+41	D+64	D+23
House	GA	4	11/7/17		N/A	R+30	R+72	R+42
House	GA	26	11/7/17		N/A	R+59	R+58	R+1
House	GA	42	11/7/17		D+46	D+42	N/A	N/A
House	GA	60	11/7/17		D+83	D+83	(D vs D)	N/A
House	GA	89	11/7/17		N/A	D+54	(D vs D)	N/A
House	GA	117	11/7/17		N/A	R+3	D+6	D+9
House	GA	119	11/7/17		N/A	R+7	D+14	D+21
Senate	GA	6	11/7/17		R+4	D+16	(D vs D)	N/A
Senate	GA	39	11/7/17		N/A	D+73	(D vs D)	N/A
House	ME	56	11/7/17		R+16	R+22	R+15	D+4
House	MA	BER 1	11/7/17		N/A	D+36	D+52	D+16
House	MA	ESS 3	11/7/17		N/A	D+15	D+7	R+8
House	MI	1	11/7/17		D+34	D+52	D+47	D+4
House	MI	109	11/7/17		D+28	R+4	D+15	D+3
Senate	MO	8	11/7/17		N/A	R+21	R+8	D+13
House	MO	23	11/7/17		N/A	D+81	D+79	R+2
House	MO	151	11/7/17		N/A	R+69	R+43	D+26
Senate	MS	10	11/7/17		N/A		N/A	N/A
House	MS	38	11/7/17		N/A		N/A	N/A
House	MS	54	11/7/17		N/A		N/A	N/A
Senate	NY	26	11/7/17		N/A	D+73	D+47	R+26
House	NY	27	11/7/17		N/A	D+34	No Oppo	N/A
House	NY	71	11/7/17		D+85	D+87	No Oppo	N/A
House	NH	HLB 15	11/7/17		D+8	R+10	D+1	D+2
House	NH	SUL 1	11/7/17		D+18	D+22	D+32	D+12
House	SC	113	11/7/17		N/A	D+39	D+62	D+23
Senate	WA	7	11/7/17		N/A	R+34	R+36	R+2
Senate	WA	31	11/7/17		R+60	R+9	R+15	D+20
Senate	WA	37	11/7/17		D+80	D+81	No Oppo	N/A
Senate	WA	45	11/7/17		R+6	D+37	D+10	R+6
Senate	WA	48	11/7/17		D+30	D+43	D+386	D+1
House	WA	7	11/7/17		N/A	R+34	R+35	R+1
House	WA	31	11/7/17		R+22	R+9	R+15	D+1
House	WA	48	11/7/17		D+40	D+43	D+48	D+6
Senate	OK	37	11/14/17		R+15	R+40	D+1	D+27
Senate	OK	45	11/14/17		N/A	R+40	R+14	D+26
House	OK	76	11/14/17		R+36	R+35	R+36	0
House	CA	51	12/5/17		D+73	D+74	N/A	N/A
Senate	MA	WOR/MDL	12/5/17		N/A	D+8	R+4	R+12
House	PA	133	12/5/17		D+17	D+10	D+38	D+25
Senate	IA	3	12/12/17		N/A	R+41	R+9	D+32
House	FL	58	12/19/17		R+17	D+10	R+21	R+17
Senate	MS	49	12/19/17		N/A		N/A	N/A
Senate	TN	17	12/19/17		N/A	R+48	R+3	D+45

¹ Jungle primary margin between all combined Dem and all combined GOP candidates; runoff is Dem vs. Dem
² Indicates runoff has not yet occurred; final result undetermined
³ Special was called because 2016 GOP candidate was ruled at the last-minute to be ineligible; using 2014 results for comparison
⁴ No regular election in 2016; using 2014 results for comparison
⁵ Democratic candidate on ballot but dropped out of race
⁶ Election was Dem versus independent
⁷ ED vote only; state does not record EV by precinct
⁸ Election was Dem versus Green
⁹ Election was GOP versus independent

CONTINUED BELOW

[Adam Griffin]

2018 SPECIAL ELECTIONS:

Average congressional swing, 2018: D+17.5
Average state legislative swing, 2018: D+11.0

Congressional:
 

Type	State	Dist	Date	Runoff	'16 Mar	'16 P Mar	Special Mar	Swing (Avg)
House	PA	18	3/13/18		N/A	R+20	D+0	D+20
House	AZ	8	4/24/18		R+37	R+21	R+5	D+24
House	TX	27	6/30/18		R+23	R+24	R+21	D+3
House	OH	12	8/7/18		R+37	R+11	R+1	D+23

State Legislative
 

Type	State	Dist	Date	Runoff	'16 Mar	'16 P Mar	Special Mar	Swing (Avg)
House	SC	56	1/2/18		N/A	R+32	No Oppo	N/A
House	CT	15	1/9/18		N/A	D+65	D vs D	N/A
Senate	GA	17	1/9/18		R+19	R+15	R+32	R+15
House	GA	111	1/9/18		R+3	D+3	R+14	R+14
House	IA	6	1/16/18		R+31	R+30	R+11	D+20
House	SC	28	1/16/18		N/A	R+30	No Oppo	N/A
House	SC	99	1/16/18		N/A	R+23	R+13	D+10
Senate	WI	10	1/16/18		R+26	R+17	D+10	D+32
House	WI	58	1/16/18		N/A	R+38	R+13	D+25
House	WI	66	1/16/18		D+62	D+42	No Oppo	N/A
House	PA	35	1/23/18		D+25	D+17	D+46	D+25
House	MO	39	2/6/18		N/A	R+46	R+29	D+17
House	MO	97	2/6/18		N/A	R+28	D+3	D+31
House	MO	129	2/6/18		R+779	R+64	R+38	D+33
House	MO	144	2/6/18		N/A	R+59	R+5	D+54
Senate	MN	54	2/12/18		D+6	R+1	D+4	D+2
House	MN	23B	2/12/18		R+34	R+27	R+19	D+12
House	FL	72	2/13/18		R+16	R+5	D+7	D+17
House	GA	175	2/13/18		N/A	R+25	R+53	R+28
Senate	OK	27	2/13/18		N/A	R+73	R+36	D+37
House	LA	86	2/17/18	3/24/18	N/A	R+50	(R vs R)	N/A
House	KY	49	2/20/18		R+1	R+49	D+37	D+62
House	MS	60	2/20/18	3/13/18	N/A		N/A	N/A
House	CT	120	2/27/18		D+25	D+2	D+2	R+12
House	KY	89	2/27/18		N/A	R+62	R+34	D+28
House	NH	BEL 3	2/27/18		R+8	R+12	D+7	D+17
Senate	MA	ESS 3	3/6/18		N/A	D+25	N/A	N/A
House	OK	51	3/6/18		R+56	R+65	R+44	D+17
Senate	TN	14	3/13/18		R+49	R+44	R+43	D+4
House	LA	93	3/24/18		N/A	D+75	(D vs D)	N/A
House	AL	21	3/27/18		R+35	R+22	R+6	D+23
House	MA	BR 2	4/3/18		N/A	D+9	D+4	R+5
Senate	RI	8	4/3/18		(D vs D)	D+31	D+45	D+14
Senate	FL	31	4/10/18		(D vs D)	D+25	D+50	D+25
Senate	IA	25	4/10/18		N/A	R+26	R+12	D+14
Senate	NY	32	4/24/18		D+94	D+87	D+86	R+5
Senate	NY	37	4/24/18		D+11	D+22	D+15	R+2
House	NY	5	4/24/18		R+29	R+24	R+26	D+1
House	NY	10	4/24/18		R+18	D+8	D+18	D+23
House	NY	17	4/24/18		R+25	R+19	R+27	R+5
House	NY	39	4/24/18		N/A	D+67	No Oppo	N/A
House	NY	74	4/24/18		D+67	D+74	D+86	D+17
House	NY	80	4/24/18		D+74	D+66	D+63	R+7
House	NY	102	4/24/18		N/A	R+23	R+1	D+22
House	NY	107	4/24/18		N/A	R+4	R+2	D+2
House	NY	142	4/24/18		N/A	R+6	R+5	D+1
House	FL	39	5/1/18		R+24	R+19	R+20	D+2
House	FL	114	5/1/18		D+2	D+14	D+4	R+4
Senate	MA	SUF 1	5/1/18		N/A	D+65	D+726	D+7
House	SC	69	5/1/18		N/A	R+31	No Oppo	N/A
House	TX	13	5/5/18		R+57	R+57	R+60	R+3
Senate	AL	26	5/15/18		N/A
House	AL	4	5/15/18		N/A
House	PA	48	5/15/18		N/A	R+15	R+11	D+4
House	PA	178	5/15/18		R+22	R+3	D+1	D+14
Senate	AR	16	5/22/18		N/A
Senate	AR	29	5/22/18		N/A
House	AR	83	5/22/18		N/A
House	CT	4	6/4/18		D+74	D+79	D+88	D+12
House	CA	39	6/5/18		D vs D	D+55	D+42	R+13
House	CA	45	6/5/18		D+33	D+40	D+32	R+5
House	CA	54	6/5/18		D+63	D+75	D+77	D+8
Senate	MO	17	6/5/18		R+23	R+4	D+20	D+34
Senate	WI	1	6/12/18		R+234	R+18	D+3	D+24
House	WI	42	6/12/18		R+17	R+14	R+8	D+8
House	MS	77	7/10/18		N/A		N/A	N/A
Senate	TX	19	7/31/18	9/19/18	D+15	D+12
Senate	CA	32	8/7/18		D+54	D+39	D+5	R+17
Senate	AR	8	8/14/18		N/A		R vs L	N/A
Senate	TX	19	9/18/18		D+15	D+12	R+6	R+20

¹ Jungle primary margin between all combined Dem and all combined GOP candidates; runoff is Dem vs. Dem
² Indicates runoff has not yet occurred; final result undetermined
³ Special was called because 2016 GOP candidate was ruled at the last-minute to be ineligible; using 2014 results for comparison
⁴ No regular election in 2016; using 2014 results for comparison
⁵ Democratic candidate on ballot but dropped out of race
⁶ Election was Dem versus independent
⁷ ED vote only; state does not record EV by precinct
⁸ Election was Dem versus Green
⁹ Election with Rep versus independent

[🦀🎂🦀🎂]

why is everybody in Oklahoma resigning?

[Adam Griffin]

why is everybody in Oklahoma resigning?

From Maxwell:

You must be logged in to read this quote.

I'm honestly more intrigued by why these all have such varying dates for their respective special elections.

[The Other Castro]

State Legislative Special Elections:

November 29, 2016: Alabama House of Representatives District 79
-Republican  Joe Lovvorn won unopposed.

January 10, 2017: Virginia State Senate Districts 9 and 22, House of Delegates District 85
-Senate 9:
Democrat Jennifer McClellan - 91.3%
Libertarian   Corey Maurice Fauconier - 8.1%

-Senate 22:
Republican Mark Peake - 53.1%
Democrat Ryant Washington - 39.6%
Independent Joe Hines - 7.3%

-House 85:
Republican Rocky Holcomb - 52.8%
Democrat Cheryl Turpin - 47%

January 31, 2017: Iowa House of Representatives District 89
Democrat Monica Hosch Kurth - 72%
Republican Mike Gonzales - 27%

February 7, 2017: Virginia House of Delegates District 71
Democrat Jeff Bourne - 89.91%
Libertarian John Barclay - 6.62%
Independent Regie Ford - 3.27%

February 14, 2017: Minnesota House of Representatives District 32B
Republican Anne Neu - 53.2%
Democrat Laurie Warner - 46.7%

February 25, 2017: Delaware State Senate District 10
Democrat Stephanie Hansen - 58.1%
Republican John Marino - 40.8%
Libertarian Joseph Lanzendorfer - 1.1%

February 28, 2017: Connecticut State Senate Districts 2 and 32, State House District 115
-Senate 2:
Democrat Douglas McCrory - 74.1%
Republican Michael McDonald - 25.3%

-Senate 32:
Republican Eric C. Berthel - 53.9%
Democrat Greg Cava - 44.2%
Unaffiliated Dan Lynch - 1.9%

-House 115:
Democrat Dorinda Keenan Borer - 61%
Republican Edward Granfield - 39%

March 21, 2017: Pennsylvania House of Representatives District 197
Democrat Emilio Vazquez (Write-in) - 80.4%
Green Cheri Honkala (Write-in) - 11.5%
Republican Lucinda Little - 8.1%

March 25/April 29, 2017: Louisiana House of Representatives District 8, 42, 92
-House 8: Republican Raymond Crews defeated another Republican Robbie Gatti Jr.
-House 42: Republican John Stefanski defeated another Republican Jay Suire
-House 92:
Republican Joe Stagni - 73.7%
Republican Gisela Chevalier - 13.3%
Democrat Chuck Toney - 13%

https://ballotpedia.org/State_legislative_special_elections,_2017

[Virginiá]

Griff, if you want to keep that fancy table updated, I'll sticky this for awhile.

[The Other Castro]

The rest of the legislative special elections:

April 18, 2017: Alabama House District 67
Democrat Prince Chestnut - 94.9%
Independent Toby Gorden - 5.1%

April 25, 2017: Connecticut House of Representatives Districts 7 and 68
-House 7:
Working Families Joshua Malik Hall - 41.1% (Caucuses as a Democrat)
Democrat Rickey Pinckney Sr. - 33.7%
Independent Kenneth P. Green - 24.1%

-House 68:
Republican Joe Polletta - 78.1%
Democrat Louis Esposito - 21.9%

April 29/May 27, 2017: Louisiana State Senate District 2 (Runoff yet to occur)
Democrat Warren Harang III (advanced to runoff) - 26.5%
Democrat Edward "Ed" Price (advanced to runoff) - 22.1%
Other Democrats Combined - 38.5%
Republican   Wayne Brigalia - 7%

May 23, 2017:
-Alabama House of Representatives District 58   
-New Hampshire House of Representatives Districts Carroll 6 and Hillsborough 44
-New York State Senate District 30 and State Assembly District 9

May 30, 2017: South Carolina State Senate District 3 and House District 84

June 15, 2017: Tennessee House of Representatives District 95

June 20, 2017: South Carolina House of Representatives Districts 48 and 70

July 18, 2017: New Hampshire House of Representatives District Merrimack 18

July 25, 2017:
-New Hampshire State Senate District 16
-Massachusetts State Senate Fourth Middlesex District

August 8, 2017: Missouri State Senate District 28 and House District 50

August 22, 2017: Rhode Island State Senate District 13

September 12, 2017: Oklahoma State Senate District 44

September 26, 2017: Florida State Senate District 40

November 7, 2017:
-Michigan House of Representatives District 1
-Washington State Senate Districts 31, 37, 45, 48 and House Districts 7, 31, 48

[Adam Griffin]

Wow, thanks! That certainly makes the process easier, though I imagine I'll be working for awhile on some of these. Looks like a lot of these special elections are non-events, though.

Griff, if you want to keep that fancy table updated, I'll sticky this for awhile.

OK, great!

[Adam Griffin]

With the exception of a few outstanding races, I've managed to get all of the data added for all specials that have occurred so far. I do still need to add many of the upcoming state legislative specials to the list when I get time. I'm worried that I'm going to hit the 11000-character limit pretty soon with all of this coding, though.

I'll also need to go back and correct a discrepancy between D vs D/R vs R races in CA/LA where there are runoffs; I opted to use the jungle primary in the case of CA but forgot to do so this morning when looking through Castro's info provided for LA.

[Adam Griffin]

OK, I've got all of those announced elections added finally...and I've already had to trim my code once to be under the character limit.

*sigh*

I may have to convert this to an image before long, especially as I add more 2016 results/color-code them. I wish I had thought to make an extra reply at the beginning.

[Virginiá]

OK, I've got all of those announced elections added finally...and I've already had to trim my code once to be under the character limit.

*sigh*

I may have to convert this to an image before long, especially as I add more 2016 results/color-code them. I wish I had thought to make an extra reply at the beginning.

If McGovernForPrez and MT Treasurer are ok with it, I (or they) could delete their 2 posts following your main post, and you could convert your 2nd post in this thread into a "2nd page" for your table?

[Adam Griffin]

OK, I've got all of those announced elections added finally...and I've already had to trim my code once to be under the character limit.

*sigh*

I may have to convert this to an image before long, especially as I add more 2016 results/color-code them. I wish I had thought to make an extra reply at the beginning.

If McGovernForPrez and MT Treasurer are ok with it, I (or they) could delete their 2 posts following your main post, and you could convert your 2nd post in this thread into a "2nd page" for your table?

That may be needed soon - I'm at 10700 characters right now so once I add colors for a few more results it'll be over the limit once again.

[Brittain33]

Aaugh, I know I've seen someone—possibly a Daily Kos affiliate—who is keeping a public spreadsheet of all special election results and the swing from Trump/Clinton. I have not been able to find it.

[The_Doctor]

Griffin - could we do a running average of the swing for both congressional / federal elections and the state elections? Enten has called them a good predictor of the possible swing in 2018.

[Adam Griffin]

Griffin - could we do a running average of the swing for both congressional / federal elections and the state elections? Enten has called them a good predictor of the possible swing in 2018.

Which elections specifically did you have in mind? I've been lucky thus far to find presidential margins for most of these districts already compiled, but it's a lot of work to crunch precinct-by-precinct for each district across multiple districts.

I had seen somewhere on 538 where they mentioned that an average of the past two presidential elections was the best determination of how a district would vote in a special.

[danny]

Aaugh, I know I've seen someone—possibly a Daily Kos affiliate—who is keeping a public spreadsheet of all special election results and the swing from Trump/Clinton. I have not been able to find it.

https://docs.google.com/spreadsheets/d/1C2MVeM2K7WgqmJw5RCQbWyTo2u73CX1pI8zw_G-7BJo/edit#gid=0

[Adam Griffin]

GA SD32 final results added.

[Holmes]

Democrats keeping their margins in suburban Sun Belt is good. Now they need to expand them.

[Sorenroy]

Awesome job Griffin! By the way, it looks like "Congressional:" and "State Legislative" are making the "Type" column much bigger than it needs to be while forcing other columns into spaces that are clearly too small ("Runoff" for the state legislative races, for example). If you removed them from the charts themselves it might ease up on the space.

Alternatively, I have seen several threads that were much wider than most. Even though I'm pretty sure it's an error, it could be helpful for making a better chart.

(Also, the first two comments are both yours. You don't have to worry about the character limit for a while.)

[Adam Griffin]

Awesome job Griffin! By the way, it looks like "Congressional:" and "State Legislative" are making the "Type" column much bigger than it needs to be while forcing other columns into spaces that are clearly too small ("Runoff" for the state legislative races, for example). If you removed them from the charts themselves it might ease up on the space.

Alternatively, I have seen several threads that were much wider than most. Even though I'm pretty sure it's an error, it could be helpful for making a better chart.

(Also, the first two comments are both yours. You don't have to worry about the character limit for a while.)

Thanks for the tip on that! Fixed.

As far as maximum width, the only way (to my knowledge) to stretch it beyond the normal parameters is to either a) use a large image (which squeezes a bit more room out of it) or b) pasting a very long link, which will stretch the page as long as the link is on one line.

[Adam Griffin]

Can't wait to update the thread with tonight's results! I'll have it sorted through in just a couple of hours when I'm done with my RL work.

[Sorenroy]

I red on Reddit that Dems were able to win one of the ones in NH for the first time in a long time. Also, one of the NY ones.

Also, just noticing now, why did the Democrat drop out of the race in LA-92?

[○∙◄☻¥tπ[╪AV┼cVê└]

I red on Reddit that Dems were able to win one of the ones in NH for the first time in a long time. Also, one of the NY ones.

Also, just noticing now, why did the Democrat drop out of the race in LA-92?

It sounds like at least part of that NY district might never had had a Democrat before. I know that Long Island was pretty Republican from about 1917-2001. The reason why it swung Republican in 1917 was Irish mad at Wilson for entering WW1 on the side of the UK.

[Sorenroy]

State Legislative

Type	State	Dist	Date	Runoff	'16 Mar	'16 P Mar	Special Mar	Swing (Avg)
Senate	NY	30	5/23/17		D+91	D+90	D+89
House	NY	9	5/23/17		R+23	R+37	D+16
House	AL	58	5/23/17				No Oppo
House	NH	CRL 6	5/23/17			R+7	D+4
House	NH	HLB 44	5/23/17				R+10

NY:
http://nyenr.elections.state.ny.us/home.aspx
https://ballotpedia.org/New_York_State_Senate_District_30
https://ballotpedia.org/New_York_State_Assembly_District_9
By the way, I used the combined numbers for each candidate. Apparently Christine Pellegrino appeared as a "DEM" and "WOR", while Thomas A. Gargiulo appeared as a "REP", "CON", and "IND". I don't know enough about NY voting to know how that worked out on the ballots.

AL:
https://ballotpedia.org/Alabama_House_of_Representatives_District_58
Apparently, because no other candidates ran, the winner of the Democratic primary, Rolanda Hollis, has already won the seat.

NH:
https://ballotpedia.org/New_Hampshire_House_of_Representatives_District_Carroll_6
https://ballotpedia.org/New_Hampshire_House_of_Representatives_District_Hillsborough_44
http://sos.nh.gov/201718SpecElect.aspx
It does not look like the NH SOS has their results up yet.
http://www.wmur.com/article/in-nh-house-special-elections-democrat-pulls-off-upset-in-wolfeboro-republican-wins-hillsborough-county-seat/9918480

Couldn't wait, hope this helps! I'll do more if I can. Not sure how you are doing swings. When I went up to see, I noticed that your swing for DE-11 is off. Also, I'm working off the assumption that "'16 P Mar" means 2016 Presidential Margin.

[Adam Griffin]

^^^ Thanks for the help! I went ahead and filled in the rest save for AL-58's presidential margin; I also fixed the DE Senate average.

BTW, what I do is simply round up for the average and then count the swing from there. So R+2 & D+13 = D+11; divided by 2 D+5.5 -> D+6.