Table formats for primary and general election

NOTES:

ID numbers are used for internal database cross-reference only and are not in any way officially assigned ID numbers.

The files will be presented in TAB delimited format which is a universal format for transferring data tables and is readily loadable into most database and spreadsheet programs.

COUNTIES
COUNTYID	INTEGER	County ID	
DESCRIPTION	STRING	Name of County	

PARTIES
PARTYID	INTEGER	Party ID	
DESCRIPTION	STRING	Name of Party	

DISTRICTTYPE
DISTRICTTYPEID	INTEGER	District Type ID	
NAME	STRING	Name of District Type	

DISTRICT
DISTRICTID	INTEGER	District ID	
DISTRICTTYPEID	INTEGER	District Type (See DistrictType table)	
NAME	STRING	Name of District	

OFFICES
OFFICEID	INTEGER	Office ID	
NAME	STRING	Name of Race (i.e. Governor, , Secretary of State, etc.)	
SLOTS	INTEGER	# of positions to be filled	
SHORTNAME	STRING	Short Name for Office	
DISTRICTID	INTEGER	District ID (See District table)	
COUNTYID	INTEGER	County ID (See County Table) for group of votes	
PRECINCTS	INTEGER	# of Precincts involved in this race for this county	
REGISTRATION	INTEGER	Registration for the precincts involved in this race in this county	
REPORTING_ PRECINCTS	INTEGER	# of Precincts that have reported in this county for this race	

CANDIDATE
OFFICEID	INTEGER	Office ID	
CANDIDATEID	INTEGER	Candidate Identifier (These may or may not be unique to the Race)	
COUNTYID	INTEGER	County ID (See County table)	
PARTYID	INTEGER	Party ID (see parties table).  	
VOTES	INTEGER	Total Votes for this county for this candidate	
NAME	STRING	Candidate Name	

This information may be updated at any time, as requirements warrant.