special-elections/special-elections: 42

This table contains the data behind the story Be Skeptical Of Anyone Who Tells You They Know How Democrats Can Win In November.

special-elections.csv contains data on all elections pitting at least one Democrat against at least one Republican between Jan. 20, 2017, and Mar. 27, 2018, including both state and federal special elections as well as regularly scheduled 2017 elections in New Jersey and Virginia (except for New Jersey General Assembly).

For each geography (district or state) the file contains:

Two districts in New Hampshire (Belknap HD-09 and Hillsborough HD-44) did not have Census data available. Florida House District 44 and Louisiana House District 92 were excluded. These were districts where the Democrats dropped out at the last minute but their names remained on the ballot. Iowa House District 22 and Pennsylvania House District 197 were also excluded. In both of these districts, Democrats were not on the ballot but waged write-in campaigns instead.

Ballotpedia was used to compile the list of elections between Jan. 20, 2017 and March 27, 2018. Income and education data comes from the American Community Survey's five-year estimates for 2012–2016. Presidential results by district were collected from Daily Kos Elections (Florida results are from Matthew Isbell).

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

This data as json

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
42 11/7/17 New Jersey SD-03 $67,035 24.10% -15% 20%
Powered by Datasette · Query took 1.061ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub