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 |