Update: There are fact checking sources that claim the anomalies within the NYT Edison data is due to a rounding issue based on the decimal format of the vote counts. I do not personally know enough about it to conclude if they are correct. Please keep this in mind as I do not want to spread false information. Thanks.
New York Times Data
Imported directly from New York Times JSON data into Excel.(timeseries data)
I have added a FLAG formula to identify all instances where votes reduce in size. This makes identifying irregularities simple.
Arizona XLSX Data - Arizona - NYT Source Link - Arizona (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 0 (Updated - Formerly 551 - Formula issue with the AP EEVP entry)
California XLSX Data - California - NYT Source Link - California (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 10,989
Florida XLSX Data - Florida - NYT Source Link - Florida (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 12,634 (Updated - Formerly 13,316 - Formula issue with the AP EEVP entry)
Georgia XLSX Data - Georgia - NYT Source Link - Georgia (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 38,348
Illinois XLSX Data - Illinois - NYT Source Link - Illinois (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/30/2020)
Total Vote Reduction: 57,736 (Updated - Formerly 59,148 - Formula issue with the AP EEVP entry)
Indiana XLSX Data - Indiana - NYT Source Link - Indiana (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/30/2020)
Total Vote Reduction: 2,447
Michigan XLSX Data - Michigan - NYT Source Link - Michigan (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 28,189 (Updated - Formerly 31,288 - Formula issue with the AP EEVP entry)
Minnesota XLSX Data - Minnesota - NYT Source Link - Minnesota (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/30/2020)
Total Vote Reduction: 199,965 (Updated - Formerly 201,480 - Formula issue with the AP EEVP entry)
Nevada XLSX Data - Nevada - NYT Source Link - Nevada (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 0
New Mexico XLSX Data - New Mexico - NYT Source Link - New Mexico (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 4,623
North Carolina XLSX Data - North Carolina - NYT Source Link - North Carolina (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 1,417 (Updated - Formerly 14,731 - Formula issue with the AP EEVP entry)
Ohio XLSX Data - Ohio - NYT Source Link - Ohio (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/30/2020)
Total Vote Reduction: 13,765 (Updated - Formerly 21,373 - Formula issue with the AP EEVP entry)
Pensylvania XLSX Data - Pensylvania - NYT Source Link - Pensylvania (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 976,705 (Updated - Formerly 976,833 - Formula issue with the AP EEVP entry)
Texas XLSX Data - Texas - NYT Source Link - Texas (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/30/2020)
Total Vote Reduction: 37,553 (Updated - Formerly 53,861 - Formula issue with the AP EEVP entry)
Virginia XLSX Data - Virginia - NYT Source Link - Virginia (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 826,946
Wisconsin XLSX Data - Wisconsin - NYT Source Link - Wisconsin (NYT JSON data link)
(JSON NYT Data pulled into Excel on 11/29/2020)
Total Vote Reduction: 4,519
Formulas for each column
- FLAG - =IF(C2>C3,"Flag","Normal")
- Difference - =IF(AND([@FLAG] = "Flag",C4 <>0, E4<>"ap"),[@votes]-C4,"na")
Rumble Video Link: This video shows you how this data is pulled into excel.