The election result PDFs (1982-1994) lack data on whether a given candidate is an incumbent. This is could be solved by cross-referencing candidate names with the six-year summaries.
Also, the [last name], [first name] column should be converted to two columns (first name/last name), as in the newer Excel files.
We need to pick a convention for state names. Not sure whether the two-letter abbreviations or the full names are better.
We need to pick a convention for states that give the sum of all write-in candidates without specifying their individual names. In the name field, the old reports just have a blank; the new ones use the word "scattered."
Some ideas for cleaner and more complete data: