Election Night Results FTP Description

Basic Layout of the FTP Site
The Secretary of State FTP site is organized into the "current" election cycle.   Basically there are two file formats to choose from: Database or Comma Separated (CSV).  Database format was designed to provide quick manipulation of the numbers by the user.  CSV format is being provided as a fixed spreadsheet format.  Also available on the Secretary of State Web site is a Browsing Page to allow the user to quickly view the Latest Statistics for any given Race.  Please take the time to visit us at http://www.sos.state.az.us for more information and informational tools.

The nice thing about working with FTP is the speed and the reliability.  The FTP site can be accessed by either FTP software (many shareware versions available on the Internet) or by using a Standard Internet Browser (like Netscape or MS Internet Explorer).
•	Using FTP software allows you to conveniently choose the file(s) you wish to download (repeatedly) without having to click on each file, and even set the time interval to re-initiate your download.  
•	A standard Internet Browser can simply download the files by clicking on each file(s) you need.
 The SOS FTP site is setup for anonymous logins, typically anonymous for username and your email address for the password.  It would be well worth your time to investigate FTP software available off the Internet.

Results on election night will be seen in the CANDIDATE table and CANDIDATEDISTRICTVOTES table; the other tables are just the static information for creating the relationships.

Files are organized on the FTP site in the following manner:
ftp://ftp.sosaz.com
	/dbelec
		Warning.txt                  If you see this file READ IT, it contains IMPORTANT CHANGES
		WhatsNew.txt	What’s new about this site
		Tables.txt	Table Format Description
		Readme.rtf	This document
		County.txt	Counties Table
		Parties.txt	Parties Table
		Office.txt	Offices/Races Table
		Candidate.txt	Current Candidate/Votes Table
	    CandidateDistrictVotes.txt	Current Candidate/Votes by District Table
		Results.csv	Election Results in Comma Separated Format (CSV)
		/history	
			/db	Old Votes Table files stored in YYYYMMDDHHMMSS 
				19980908200145.txt	Votes File from Sept 9, 1998 at 20:01:45 (8:01:45 PM)
			/csv	Old CSV  files stored in YYYYMMDDHHMMSS 
				19980908200247.csv	CSV File from Sept 9, 1998 at 20:02:47 (8:02:47 PM)