Office of the Secretary of State -------------------------------- Last update: 10-15-2004 by Ted Lautzenheiser, Director of Information Technology Ted.Lautzenheiser@state.mn.us The files on this web and ftp sites contain ASCII text, separated by semicolons. Note that the candidate codes, races, registered voter information, etc are subject to change up until election day. -------------------------------------------- The Election Result files contain the following data: State County ID Precinct Number (when applicable) Office ID Office Name District (when applicable) Candidate ID Candidate Name (do not have it divided by First/Last/Suffix, All one field) Suffix (not used) Incumbent Code (not used) Party ID Precincts reporting Total number of Precincts in State/County/Race (Whichever is applicable) Votes for Candidate Percentage of votes for Candidate by Office Total number of Votes for Office -------------------------------------------- The Federal, State and County Candidate file (CandTbl.txt) contains the following data: Candidate ID Candidate Name Office ID (first four characters of Candidate ID) Office Title County ID (88 = statewide race or multi-county race) Party ID Party Abbreviation -------------------------------------------- The Local Candidate file (LocalCandTbl.txt) contains the following data: Candidate ID Candidate Name Office ID (first four characters of Candidate ID) Office Title County ID (88 = statewide race or multi-county race) MCD code (using FIPS statewide unique codes, not county MCDs) School District Note: Party is omitted since all local candidates are non-partisan. -------------------------------------------- The County table (CntyTbl.txt) contains: County ID County Name Number of precincts -------------------------------------------- The Precinct table contains: County ID Precinct ID Precinct Name Congressional District Legislative District County Commissioner District Judicial District Soil and Water District MCD code (using FIPS statewide unique codes, not county MCDs) -------------------------------------------- The Party table (PartyTbl.txt) contains: Party Abbreviation Party Name Party ID