1990 GENERAL ELECTION RESULTS RECORD LAYOUTS Note: in 1990, each ballot layout was assigned a “specimen number” (specnum) as an identifier. As I recall, numbers under 500 indicated paper ballots, 500 and over indicated Optech ballots. US SENATOR # Name Type Length 1 specnum INTEGER 2 town TEXT 25 characters 3 county TEXT 3 characters 4 cd TEXT 1 characters, congressional district 5 us1 INTEGER votes for candidate 1 6 us2 INTEGER votes for candidate 2 7 us3 INTEGER votes for candidate 3 8 usot INTEGER votes for “other” candidates (write-ins) 9 usname1 TEXT 10 characters, last name candidate 1 10 usname2 TEXT 10 characters, last name candidate 2 11 usname3 TEXT 10 characters, last name candidate 3 GOVERNOR # Name Type Length 1 specnum INTEGER 2 town TEXT 25 characters 3 county TEXT 3 characters 4 cd TEXT 1 characters, congressional district 5 gv1 INTEGER votes for candidate 1 6 gv2 INTEGER votes for candidate 2 7 gv3 INTEGER votes for candidate 3 8 gvot INTEGER votes for “other” candidates (write-ins) 9 gvname1 TEXT 10 characters, last name candidate 1 10 gvname2 TEXT 10 characters, last name candidate 2 11 gvname3 TEXT 10 characters, last name candidate 3 US REPRESENTATIVE # Name Type Length 1 specnum INTEGER 2 town TEXT 25 characters 3 county TEXT 3 characters 4 cd TEXT 1 characters, congressional district 5 cg1 INTEGER votes for candidate 1 6 cg2 INTEGER votes for candidate 2 7 cg3 INTEGER votes for candidate 3 8 cgot INTEGER votes for “other” candidates (write-ins) 9 cgname1 TEXT 10 characters, last name candidate 1 10 cgname2 TEXT 10 characters, last name candidate 2 11 cgname3 TEXT 10 characters, last name candidate 3 STATE SENATOR # Name Type Length 1 specnum INTEGER 2 town TEXT 25 characters 3 county TEXT 3 characters 4 cd TEXT 1 characters, congressional district 5 ssdist TEXT 3 characters, state senate district 6 ss1 INTEGER votes for candidate 1 7 ss2 INTEGER votes for candidate 2 8 ss3 INTEGER votes for candidate 3 9 ssot INTEGER votes for “other” candidates (write-ins) 10 party1 TEXT 1 characters, party candidate 1 11 name1 TEXT 60 characters, full name candidate 1 12 party2 TEXT 1 characters, party candidate 2 13 name2 TEXT 60 characters, full name candidate 2 14 party3 TEXT 1 characters, party candidate 3 15 name3 TEXT 60 characters, full name candidate 3 State Representative (SR) 1 specnum INTEGER specimen ballot number 2 town TEXT 25 characters 3 county TEXT 3 characters 4 cd TEXT 1 characters congressional district 5 srdist TEXT 3 characters state representative district 6 sr1 INTEGER # of votes Candidate #1 7 sr2 INTEGER # of votes Candidate #2 8 sr3 INTEGER # of votes Candidate #3 9 srot INTEGER # of WRITE-IN votes 10 party1 TEXT 1 characters party of Candidate #1 11 name1 TEXT 45 characters name of Candidate #1 12 party2 TEXT 1 characters party of Candidate #2 13 name2 TEXT 45 characters name of Candidate #2 14 party3 TEXT 1 characters party of Candidate #3 15 name3 TEXT 45 characters name of Candidate #3