Last Update: August 03, 2015

Vtrhstm Table

This table holds voting history for voters. Each row holds a voter's history in the 20 most-recent elections.

Certificate

Voter registration ID.

Election_Number

The "base" election number. All election numbers in this column are multiples of 20 + 1. For example, 241, 441, 461.

 

The columns Voted_Absentee_1 through Voted_Absentee_20 each holds a code indicating how the voter voted in each election beginning with the base election in Voted_Absentee_1 and for each subsequent election up to Voted_Absentee_20.

So, if the base election number is 21, then the elections referenced in the Voted_Absentee_n columns in that voter's row are:

Election 21 — Voted_Absentee_1

Election 22 — Voted_Absentee_2

Election 23 — Voted_Absentee_3

...

Election 40 —Voted_Absentee_20

Voted_Absentee_1

through

Voted_Absentee_20

The possible values in the Voted_Absentee_n columns are:

Y

Voted at the polls.

Z

Voted at the polls by provisional ballot (ballot was tabulated).

N

Did not vote.

A

Voted by mail (includes referred ballots that were tabulated).

B

Vote-by-mail ballot rejected by canvassing board (not tabulated).

P

Provisional ballot rejected by canvassing board (not tabulated).

X

Ineligible to vote in this election.

E

Voted early.

F

Voted early by provisional ballot (ballot was tabulated).,

blank

Not registered at the time of the election.

Note  For elections prior to 2006, the codes B, P, and E were not used. E and B were included in Y, and P was included in N.