Office of the Minnesota Secretary of State (OSS)

2019 Senate District 11 Special Election Results
----------------------------------------------------

 - The filenames given below are used on the ftp site, and the mediafileids are part of the URLs on the Election Night Reporting website. 
 - The files on OSS web and ftp sites contain ASCII text, separated by semicolons. 
 - Information in the supporting files is subject to correction and change up until election day.
 - Election results may change after being reported initially on election night.
 - For questions, contact OSS Elections Division at elections.dept@state.mn.us

Last revised 1/16/2019

----------------------------------------------------
Election Results Files
----------------------------------------------------

Results are formatted in flat files which have one row for each candidate and question response in each geographic area 
(statewide, county, district, or precinct, depending on the file).

Election Results (various names and mediafileids)

	State
	County ID (if applicable)
	Precinct name (if applicable)
	Office ID
	Office Name 
	District* 
	Candidate Order Code
	Candidate Name (First/Last/Suffix all in one field)
	Suffix (not used)
	Incumbent Code (not used)
	Party Abbreviation**
	Number of Precincts reporting
	Total number of precincts voting for the office
	Votes for Candidate
	Percentage of Votes for Candidate out of Total Votes for Office
	Total number of votes for Office in area

*Note: The District field is used for State Senate districts.

----------------------------------------------------

Precinct Voting Statistics (pctstats.txt, mediafileid 93)

	State
	County ID
	Precinct ID
	Precinct Name 
	Has Reported Statistics (1 = yes, 0 = no) 
	Number of Voters Registered as of 7:00 a.m. Election Day
	Number of Voters that Registered on Election Day 
	Number of Signatures on the Polling Place Roster
	Number of Regular, Military, and Overseas Absentee Ballots 
	Number of Federal-Only Absentee Ballots
	Number of President-Only Absentee Ballots 
	Total Number Voted

----------------------------------------------------
Supporting Tables for Election
----------------------------------------------------

Parties (PartyTbl.txt, mediafileid 5)

	Party Abbreviation
	Party Name 
	Party ID 
	
----------------------------------------------------
	
Counties (CntyTbl.txt, mediafileid 6)

	County ID
	County Name
	Number of precincts

----------------------------------------------------

Precincts (PrctTbl.txt, mediafileid 4)

	County ID
	Precinct ID 
	Precinct Name
	Congressional District 
	Legislative District 
	County Commissioner District 
	Judicial District 
	Soil and Water Conservation District 
	MCD FIPS code
	School District number (not used in statewide elections)	

----------------------------------------------------
  
Federal, State, and County Candidates in the Election (cand.txt, mediafileid 82)

	Candidate ID (eight characters)
	Candidate Name (First/Last/Suffix all in one field)
	Office ID
	Office Title
	County ID (88 = statewide race or multi-county race)
	Party ID
	Party Abbreviation

----------------------------------------------------

Federal, State, and County Candidates - Address Information (CandTbl.txt, mediafileid 49)

	Candidate ID (eight characters) 
	Candidate Name (First/Last/Suffix all in one field)
	Office ID
	Office Title 
	County ID (88 = statewide or multi-county race)
	Party ID
	Party Abbreviation
	Residence Street Address
	Residence City
	Residence State
	Residence Zip
	Campaign Address 
	Campaign City
	Campaign State
	Campaign Zip	
	Campaign Phone
	Campaign Website
	Campaign Email
	Running Mate Website
	Running Mate Email
	Running Mate Phone
	
Note: Semicolons in address fields have been replaced with the caret (^) character

----------------------------------------------------

Municipalities (mcdtbl.txt, mediafileid 87)

	County ID
	County Name
	MCD FIPS Code
	Municipality Name