Florida Voter File – Churn

Florida Voter File – Churn

Some weekend projects start with a simple question, this past weekend was no different.

“How much churn is there in Florida’s voter file?”

We wanted to get a sense of how much churn was in the voter file leading up to the 2020 election. We took the voterfile from Jan 2019 and compared it to the voterfile in December of 2019. (We went county by county using the R library CRAN compareDF) For the period of 2019, we wanted to explore how many records changed, how many were added, and how many were removed.

In the aggregate, it would appear there isn’t much churn or turnover in the voterfile. The number of registered voters grew about 2% for the year. However, that masks the story.

On average, 7% of the voters had changes in their data (this can be anything from switching parties, address changes, having the precinct number change, etc), 7% were additions, and 5% were removed during that time.

In 2020, Florida added 979,146 voters and removed 741,312 voters.

But my take away is this – remember there are differences in macro- behavior and micro-behavior – and macro level changes maybe masking much larger micro-shifts.

Below are the county breakdowns, some of the counties that exhibit high percentages of change were shifting / changing precinct numbers.

[table id=13 /]

Florida GOP is Winning the Voter Registration Battle

Florida GOP is Winning the Voter Registration Battle

Statewide elections in Florida are among the most competitive and hotly contested elections in the United States. Since 2012, six statewide elections have been decided by less than 1.2% while three have been won by fewer than 35,000 votes. Once you realize there are 13 million registered voters in Florida, these results are jarring.

Florida Democrats are Losing the Registration Game

Since 2012, only one Democrat (Nikki Fried) has won a statewide election in Florida – a result decided by just 6,500 votes. Clearly, Florida Democrats have a ‘winning’ problem.

In the age of Trump, politicos anticipated a better performance by Florida Democrats in 2016 and then again in 2018 amid the supposed “blue wave.” Rather than riding the blue wave, Florida voters fought the current and elected a Trump-endorsed Republican governor and fired an 18-year incumbent Democratic Senator. Why? How?

Florida GOP is Closing the Registration Gap

Many reasons could explain the poor performance by Florida Democrats but one major data point stands out – voter registration. As of late, Republicans have been beating Democrats at their own game. Plain and simple. 

Although the Republican Party is currently home to one of the most unfavorable presidents in American history, Florida Democrats hold the smallest lead over Republicans in voter party registration since Florida began recording the statistic in 1972.

Compare that to just ten years ago when Florida Democrats had a 700,000 registration lead over Republicans, setting the stage for Obama’s sweeping victory in 2008. Since then, Republicans shaved the Democratic lead down to just 250,000 – a reduction of roughly 450,000 registered voters.

Florida Department of State Division of Elections, “Voter Registration – By Party Affiliation Archive,” August 4, 2019

Can Florida Turn Blue in 2020?

Anything is possible. But fifteen months from election day, Republican registration is on track for a Trump victory in Florida. Bar a Trump campaign catastrophe, an economic collapse, or Joe Biden forgetting that he is running for president – again, anything is possible – historical election data reveals that Democrats need a 500,000 lead in voter registration for a solid chance at winning Florida in 2020.

Unfortunately for Republicans, it is not unprecedented for Democrats to grow their registration lead in the year leading up to a presidential election (see graph from 2007-2008). On top of that, Democrats identified the need to register Florida voters as evidenced by Andrew Gillum’s plan to register 1 million voters before the 2020 election. All Gillum has to do is follow through and turn down Hamilton tickets.

Only time will tell if Florida Democrats rise to the occasion.

I will check in with updates as we countdown to election day 2020.


Quick Question:  Is there a correlation between primary turnout and general election turnout in Florida?

Quick Question: Is there a correlation between primary turnout and general election turnout in Florida?

Great question via twitter this morning – is there a correlation between primary election turnout and general election turnout?

My first guess was “no, it is more a function of competitive races on the ballot, and historically one party will have incumbency.”

BUT – let’s goto the data for a quick explore.

Lucky for us, Florida has a historical archive.

https://dos.myflorida.com/elections/data-statistics/elections-data/voter-turnout/

I cleaned it up a little and added a binary variable to explore POTUS v midterms.

flturnout (excel sheet)

The relationship between primary turnout and general election turnout in Florida Elections (1954-2016)

Correlations
primary general
primary Pearson Correlation 1 .039
Sig. (2-tailed) .834
N 31 31
general Pearson Correlation .039 1
Sig. (2-tailed) .834
N 31 32

POTUS ONLY YEARS

 

Correlations
primary general
primary Pearson Correlation 1 .111
Sig. (2-tailed) .693
N 15 15
general Pearson Correlation .111 1
Sig. (2-tailed) .693
N 15 16

 

MIDTERMS ONLY YEARS

Correlations
primary general
primary Pearson Correlation 1 -.130
Sig. (2-tailed) .632
N 16 16
general Pearson Correlation -.130 1
Sig. (2-tailed) .632
N 16 16

 

Conclusion

There is no measurable relationship between the two variables; need to explore other potential variables that may predict general election turnout better – such as the number of competitive races.

2014 Florida Governors Race Results by DMA

2014 Florida Governors Race Results by DMA

Thinking about 2018 with a potential matchup of Rick Scott v Senator Bill Nelson, I was messing around with scripts to combine data sets and came up with vote totals for the 2014 campaign for Florida Governor featuring Rick Scott v Charlie Crist by Florida DMA (Television Markets).

Here you go…..I may write later on what this possibly means for 2018, but for now, it is provided as is for your enjoyment.

 

How divided is Florida?

How divided is Florida?

I went to bed last night thinking about about DecisionDeskHQ’s attempt to make a nationwide precinct map.  It is a challenging and cool project.

Thinking about this as I slumbered, I awoke wondering just ‘how divided are we in Florida at the precinct level’?  

Thanks to the great state of Florida, we have precinct level results, and over morning coffee, I found my answer.

The answer:  Pretty damn divided.  

If you consider a precinct “competitive” if separated by 10% or less, then few Floridians live in precincts that are competitive – the median difference in the 2016 POTUS election is 28% in Florida.    

Only 18% of Florida’s precincts had Clinton and Trump within 10% of each other.

OR

Almost half (46%) of Florida’s precincts resulted in the difference between Donald Trump and Hillary Clinton being greater than or equal to 30%.

P.S.  The data is below, and now you know what nerds do on Saturday mornings before their kids wake up.

DATA

This is a histogram of the absolute value of the difference between the Clinton% and Trump% of the vote total.

Note:  (I dropped the random precincts that are less than .01 and greater than .99)

Here are the summary statistics:

Cases
Valid Missing
N Percent N
5688 100.00% 0
Descriptives
Statistic Std. Error
Mean 0.32285 0.003074
95% Confidence Interval for Mean Lower Bound 0.316824
Upper Bound 0.328876
5% Trimmed Mean 0.309017
Median   0.277699
Variance 0.054
Std. Deviation 0.231816
Minimum 0
Maximum 0.982301
Range 0.982301
Interquartile Range 0.315587
Skewness   0.804 0.032
Kurtosis -0.083 0.065

Precinct by category

Frequency Percent Cumulative Percent
0-10% 1010 17.8 17.8
10-20 1033 18.2 35.9
20-30 1035 18.2 54.1
30-40 849 14.9 69
40-50 568 10 79
50-60 399 7 86
60-70 286 5 91.1
70-80 210 3.7 94.8
80-90 194 3.4 98.2
90-100 104 1.8 100
Total 5688 100

 

Sum of Votes cast by Precinct Category

Category VotesCast % of total
0-10% 1739609 19%
10-20 1732374 19%
20-30 1920034 21%
30-40 1454646 16%
40-50 909401 10%
50-60 578875 6%
60-70 367632 4%
70-80 225290 2%
80-90 228293 2%
90-100 121634 1%
Total 9277788 100%

You can download my cleaned data at: gitHub or at data.world.

How divided is Florida?

TV DMAs by County

I was looking for a data-set this morning for a GIS project, and I thought the data would be relatively easy to find.  It wasn’t.

I did find what I wanted in one case, but someone was charging $199 for the data.

So, I spent a couple of hours researching, compiling and cleaning data.

I offer it to you for free and in the name of political analysis.  Enjoy!

Data Set: TV DMAs by Counties – USA.