Table formats for primary and general election

NOTES:

Notes and highlights are presented in this table to describe the changes for the 2000 primary election.  These notations were made on 9/9/2000, the tables have not changed since first release on 9/6/2000.

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.  Quotation marks are NOT used to identify strings, as some candidates may have quotation marks around nicknames.

COUNTY
COUNTYID	INTEGER	County ID	
DESCRIPTION	STRING	Name of County	

PARTY
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	

Used to have column registration, moved to DISTRICTCOUNTYPARTY.txt.  Changed the SHORTNAME for OFFICE, as they were inconsistent across the table.
Ex:  US Rep Dist. 1, St Rep Dist 4  and  St Sen DS 4
OFFICE
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	

CANDIDATEDISTRICTVOTES
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)	
DISTRICTID	INTEGER	District ID (see District table).  	
VOTES	INTEGER	Total Votes for this District for this candidate	

Removed ElectionID.  This is where the registration moved to.
DISTRICTCOUNTYPARTY
ELECTIONID	INTEGER	Election ID (internal)	
DISTRICTID	INTEGER	District ID (See District table)	
COUNTYID	INTEGER	County ID (See County table)	
PARTYID	INTEGER	Party ID (see party table).  	
REGISTRATION	INTEGER	Registration for the precincts involved in this race in this county	
BALLOTSCAST	INTEGER	Total Ballots cast  for this county 	
INACTIVE_REGISTRATION	INTEGER	Inactive Registration for the "district" 	

Removed ELECTIONID column.
DISTRICTCOUNTY
ELECTIONID	INTEGER	Election ID (internal)	
DISTRICTID	INTEGER	District ID (See District table)	
COUNTYID	INTEGER	County ID (See County table)	
PRECINCTS	INTEGER	Precincts in County	
REPORTING_PRECINCTS	INTEGER	Number of Precincts Reported	
BALLOTSCAST	INTEGER	Total Ballots cast  for this District 	

Is blank.  Does not relate to primary election.
This table is used for offices that are retained, rather than elected officials.
RETAINOFFICE
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)	
VOTETYPE	TEXT	YES/NO etc	
VOTES	INTEGER	Total Votes for this county for this candidate	
TITLE	STRING	Candidate Name	
LASTNAME	STRING	Candidate Name	
FIRSTNAME	STRING	Candidate Name	
SUFFIX	STRING	Candidate Name	

Is blank.  Does not relate to primary election.
This table is used for ballot measures.
BALLOTMEASURE
BALLOTMEASUREID	INTEGER	Ballot Measure ID	
COUNTYID	INTEGER	County ID (See County table)	
VOTETYPE	TEXT	YES/NO etc	
VOTES	INTEGER	Total Votes for this county for this candidate	
BMNUMBER	STRING	Ballot Measure Number	
SHORT_TITLE	STRING	Short Title	

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

table OFFICEDIST.txt was used for Presidential Primary Election and will not be used for primary or general election.  =-->
Note its output was typical of DISTRICT.TXT.