Included Voter Data

Below is a list of the data included with the purchase of a voter file:

Column Heading

Data Type

Description

lVoterUniqueID

Int

The County Voter ID Number

sAffNumber

Char(10)

The Affidavit of Registration Number for the voter in CA; Voter ID in IL, WA

sVoterTitle

Char(4)

Mr., Mrs., Ms., Miss

szNameLast

Char(26)

Voter Last Name

szNameFirst

Char(26)

Voter First Name

szNameMiddle

Char(26)

Voter Middle Name (often just an initial)

szNameSuffix

Char(4)

Jr., Sr., I, II, etc.

sGender

Char(1)

M/F (IL only)

szSitusAddress

Char(70)

All Residence address fields assembled for a Delivery Point Address line

szSitusCity

Char(30)

Residence City

szSitusState

Char(2)

Residence State

szSitusZip

Char(10)

Residence Zip; can contain zip +4 

sHouseNum

Char(10)

Parsed Residence House Number

sUnitAbbr

Char(8)

Parsed Residence Unit Abbreviation (ex. Apt, Ste, Spc)

sUnitNum

Char(8)

Parsed Residence Unit Number

szStreetName

Char(35)

Parsed Residence Street Name

szStreetSuffix

Char(10)

Parsed Residence Street Suffix

sPreDir

Char(2)

Parsed Residence Pre-Directional (N, S, E, W, NW, etc)

sPostDir

Char(2)

Parsed Residence Post-Directional (N, S, E, W, NW, etc)

szMailAddress1

Char(40)

Voter Mailing Address Line 1

(If no Mail Addr for Voter, Res Addr is placed in the first two Mail Address Lines.)

szMailAddress2

Char(40)

Voter Mailing Address Line 2 

szMailAddress3

Char(40)

Voter Mailing Address Line 3 

szMailAddress4

Char(40)

Voter Mailing Address Line 4 

szMailZip

Char(10)

Parsed Mailing Address Zip Code

szPhone

Char(14)

Voter phone number

szEmailAddress

Char(100)

Voter email

dtBirthDate

Char(10)

Voter Birth Date; MM/DD/YYYY

sBirthPlace

Char(4)

Voter Birth Place; state or country abbreviation

dtRegDate

Char(10)

Current Registration Date; MM/DD/YYYY

dtOrigRegDate

Char(10)

Original Registration Date for voter; MM/DD/YYYY

dtLastUpdate_dt

Char(10)

Date the Voter record was last Updated; MM/DD/YYYY

sStatusCode

Char(1)

Values: ‘A’ – Active, ‘I’ – Inactive, ‘C’ – Cancelled, ‘P’ – Local Pending

szStatusReasonDesc

Char(50)

Text indicating current ‘state’ of the voter.

sUserCode1

Char(4)

County defined code

sUserCode2

Char(4)

County defined code 

iDuplicateIDFlag

Char(5)

Indicator for voters sharing same Name/Birth date; Rare

szPartyName

Char(50)

Party choice made by voter (CA only)

szAVStatusAbbr

Char(10)

Vote by Mail Status Abbreviation; This field identifies voters participating in a specific Vote by Mail program.

szAVStatusDesc

Char(50)

Vote by Mail Status Full Description 

szPrecinctName

Char(20)

Regular Precinct Name

sPrecinctID

Char(10)

Regular Precinct Number 

sPrecinctPortion

Char(4)

Regular Precinct Portion (if applicable)

sDistrictID_0

Char(6)

District ID

iSubDistrict_0

smallint

District Sub/Ward

szDistrictName_0

Char(100)

District Name text

sDistrictID_1

Char(6)

District ID

iSubDistrict_1

smallint

District Sub/Ward

szDistrictName_1

Char(100)

District Name text

sDistrictID_2

Char(6)

District ID

iSubDistrict_2

smallint

District Sub/Ward

szDistrictName_2

Char(100)

District Name text

sDistrictID_3

Char(6)

District ID

iSubDistrict_3

smallint

District Sub/Ward

szDistrictName_3

Char(100)

District Name text

sDistrictID_4

Char(6)

District ID

iSubDistrict_4

smallint

District Sub/Ward

szDistrictName_4

Char(100)

District Name text

sDistrictID_5

Char(6)

District ID

iSubDistrict_5

smallint

District Sub/Ward

szDistrictName_5

Char(100)

District Name text

If voter history is included:

 

Column Heading

Data Type

Description

lVoterUniqueID

Int

The County Voter ID Number

sElecTypeDesc

Char(25)

Text identifying the type of election (General, Primary etc.)

sElectionAbbr

Char(10)

An abbreviated identifier for an election

szElectionDesc

Char(100)

The full legal name for an election

dtElectionDate

Char(10)

Date of the election

sVotingPrecinct

Char(10)

The Voting Precinct voter voted in for the election

szVotingMethod

Char(85)

Text description describing how the voter voted (Polling Place, Vote by Mail etc.)

sPartyAbbr

Char(4)

Party ballot that the voter voted

szPartyName

Char(50)

Full Party Name of the ballot voter voted

iCountedFlag

Char(3)

Ballot Counted Indicator; ‘Yes’ – ballot was counted, ‘No’ – ballot was Not counted