In case you want to recreate our findings, you can use the following SQLite code. The author has included simplified step-by-step directions in his code, which you will see as all-caps text preceded by the “--” marks. 

-- SELECT ALL ROWS WITH NOT-ACCEPTED BALLOTS (CANCELLED, REJECTED, SPOILED, OR 
-- BLANK) 
-- ALSO SELECT ALL ROWS WITH UNRETURNED BALLOTS (A BLANK IN THE BALLOT RETURN 
-- DATE COLUMN)

-- THEN, EXCLUDE FROM THE LIST ALL VOTERS WHO WERE ABLE TO CAST A BALLOT AND 
-- HAVE IT ACCEPTED 
-- (THIS COULD INCLUDE PEOPLE WHO WERE REJECTED BY MAIL THEN CAST ANOTHER 
-- BALLOT AND ACCEPTED, OR PEOPLE WHO DID NOT TURN IN A MAIL BALLOT AND INSTEAD 
-- VOTED IN PERSON, ETC.)

SELECT voterregistrationnmb
FROM MASTERSTATEWIDE181105
	WHERE ballotstatus != 'A' OR ballotreturndate = ""
EXCEPT 
SELECT voterregistrationnmb
FROM MASTERSTATEWIDE181105
	WHERE ballotstatus = 'A';

-- FOR ballotreturndate = “”, WHOWHATWHY CHECKED TO MAKE SURE THERE WERE NO NULL
-- VALUES OR “ “ VALUES

-- THIS WILL PRODUCE A LIST OF ONLY VOTER REGISTRATION NUMBERS FOR PEOPLE WHO 
-- HAVE ATTEMPTED TO VOTE EARLY BUT HAVE NOT YET HAD A BALLOT ACCEPTED

-- SAVE AS A VIEW (HERE NAMED blltissudntvtd)

-- THEN JOIN THAT VIEW WITH THE MASTER ABSENTEE BALLOT FILE YOU DOWNLOADED FROM 
-- THE SECRETARY OF STATE’S WEBSITE.
-- MAKE THE JOIN ON VOTER REGISTRATION NUMBER 
-- ORDER BY COUNTY (COUNTIES WILL APPEAR IN ALPHABETICAL ORDER)

SELECT MASTERSTATEWIDE181105.VoterRegistrationNmb AS VoterRegNumber, MASTERSTATEWIDE181105.lastname AS LastName, 
	MASTERSTATEWIDE181105.firstname AS FirstName, MASTERSTATEWIDE181105.MiddleName AS MiddleName, 
	MASTERSTATEWIDE181105.county AS County
FROM MASTERSTATEWIDE181105
JOIN blltissudntvtd
ON MASTERSTATEWIDE181105.VoterRegistrationNmb = blltissudntvtd.VoterRegistrationNmb
ORDER BY MASTERSTATEWIDE181105.county ASC;

-- SAVE AS A VIEW
-- EXPORT TO CSV 

-- TEST TO MAKE SURE YOU DON'T HAVE ANY ACCEPTED BALLOTS

SELECT MASTERSTATEWIDE181105.BallotStatus, COUNT( MASTERSTATEWIDE181105.BallotStatus)
FROM MASTERSTATEWIDE181105
JOIN blltissudntvtdindivid
ON MASTERSTATEWIDE181105.VoterRegistrationNmb = blltissudntvtdindivid.VoterRegNumber
GROUP BY MASTERSTATEWIDE181105.BallotStatus;