This dashboard consists of two datasets. The first set are the election results from the 2022 general election. The second set of results are the bookclosing statistics for the general election. Bookclosing is a report of the number of registered voters who are eligible to vote in a particular election. In this case, we are only looking at those who can vote in the 2022 general election.

How to collect the data depends on which state, county, or city that you need to gather the data from. In the case of the election results, the data was downloaded through the Pinellas County Supervisor of Elections (since the dashboard looks at Pinellas Count). The election results also break down the overall results by voting method (Vote-by-Mail, Early Voting, Election Day). For the bookclosing statistics, the data was downloaded from the Florida Division of Elections. 

If multiple counties/cities are gathered, quite of bit of data cleaning might need to be done. In many cases, cleaning the data to be uniformed would be conducted in Excel (because the data isn’t necessarily large), but unions through SQL works if data cleaning is done on each individual sheet.

Once the data is cleaned, then a number of formulas are put into the spreadsheet to determine percentages, as well as calculating standard deviations, which then creates confidence intervals for the likelihood of maximum votes are a particular party. Here is a link the the final Excel spreadsheet that will be uploaded into the dashboard.