Office of the Minnesota Secretary of State (OSS) 2017 Municipal and School General 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 10/11/2017 ---------------------------------------------------- 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 U.S. Representative, State Senate, State Representative, and County Commissioner districts; District Court; school district numbers; municipal FIPS codes; soil and water conservation district codes, and hospital district codes. The District field is not used for statewide offices (U.S. President, U.S. Senate, Governor, Secretary of State, State Auditor, Attorney General, Supreme Court, Court of Appeals), county-wide offices, or city wards. **Note: All local candidates are non-partisan, although some Minneapolis candidates may identify with a party on the ballot. See "Minneapolis Candidates and Parties" at the bottom of this file for details. ---------------------------------------------------- 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 Note: All local candidates are non-partisan, although some Minneapolis candidates may identify with a party on the ballot. See "Minneapolis Candidates and Parties" at the bottom of this file for details. ---------------------------------------------------- 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) ---------------------------------------------------- Local Candidates in the Election (LocalCandTbl.txt, mediafileid 3) Candidate ID (thirteen characters) Candidate Name (First/Last/Suffix all in one field) Office ID Office Title County ID (home county if multi-county race) MCD FIPS Code, if applicable School District Number, if applicable Note: All local candidates are non-partisan, although some Minneapolis candidates may identify with a party on the ballot. See "Minneapolis Candidates and Parties" at the bottom of this file for details. ---------------------------------------------------- Local Candidates - Address Information (LocalCandDetails.txt, mediafileid 12) Candidate ID (thirteen characters) Candidate Name (First/Last/Suffix all in one field) Office ID Office Title County ID (home county if multi-county race) MCD FIPS Code, if applicable School District Number, if applicable Residence Street Address Residence City Residence State Residence Zip Campaign Address Campaign City Campaign State Campaign Zip Campaign Phone Campaign Website Campaign Email Note: Semicolons in address fields have been replaced with the caret (^) character Note: All local candidates are non-partisan, although some Minneapolis candidates may identify with a party on the ballot. See "Minneapolis Candidates and Parties" at the bottom of this file for details. ---------------------------------------------------- Ballot Questions (BallotQuestions.txt, mediafileid 11) County ID Office ID MCD FIPS Code, if applicable School District Number, if applicable Question Number Question Title Question Body ---------------------------------------------------- School Districts (SchoolDistTbl.txt, mediafileid 18) School District Number School District Name County ID County Name ---------------------------------------------------- Municipalities (mcdtbl.txt, mediafileid 87) County ID County Name MCD FIPS Code Municipality Name ---------------------------------------------------- Minneapolis Candidates and Parties ---------------------------------------------------- Candidate ID;Candidate Name;Office Title;Party Name 4300020019001;Nekima Levy-Pounds;Mayor (Minneapolis);Democratic-Farmer-Labor 4300020019002;Jacob Frey;Mayor (Minneapolis);Democratic-Farmer-Labor 4300020019003;Gregg A. Iverson;Mayor (Minneapolis);Democratic-Farmer-Labor 4300020019004;Betsy Hodges;Mayor (Minneapolis);Democratic-Farmer-Labor 4300020019005;Charlie Gers;Mayor (Minneapolis);Libertarian Party 4300020019006;David Rosenfeld;Mayor (Minneapolis);Socialist Workers Party 4300020019007;Ian Simpson;Mayor (Minneapolis);The Idea Party 4300020019008;Captain Jack Sparrow;Mayor (Minneapolis);Basic Income Guarantee 4300020019009;Troy Benjegerdes;Mayor (Minneapolis);Farmer Labor 4300020019010;Aswar Rahman;Mayor (Minneapolis);Democratic-Farmer-Labor 4300020019011;Al Flowers;Mayor (Minneapolis);Democratic-Farmer-Labor 4300020019012;Raymond Dehn;Mayor (Minneapolis);Democratic-Farmer-Labor 4300020019013;Tom Hoch;Mayor (Minneapolis);Democratic-Farmer-Labor 4300020019014;David John Wilson;Mayor (Minneapolis);Rainbows Butterflies Unicorns 4300020019015;Ronald Lischeid;Mayor (Minneapolis);People Over Politics 4300020019016;L.A. Nik;Mayor (Minneapolis);Independent 4300021019001;Jillia Pessenda;Council Member Ward 1 (Minneapolis);Democratic-Farmer-Labor 4300021019002;Kevin Reich;Council Member Ward 1 (Minneapolis);Democratic-Farmer-Labor 4300021019003;John Hayden;Council Member Ward 1 (Minneapolis);Independent 4300021119001;Cam Gordon;Council Member Ward 2 (Minneapolis);Green Party 4300021219001;Ginger Jentzen;Council Member Ward 3 (Minneapolis);Socialist Alternative 4300021219002;Samantha Pree-Stinson;Council Member Ward 3 (Minneapolis);Green Party Endorsed 4300021219003;Steve Fletcher;Council Member Ward 3 (Minneapolis);Democratic-Farmer-Labor 4300021219004;Tim Bildsoe;Council Member Ward 3 (Minneapolis);Democratic-Farmer-Labor 4300021319001;Barbara A. "Barb" Johnson;Council Member Ward 4 (Minneapolis);Democratic-Farmer-Labor 4300021319002;Dana Hansen;Council Member Ward 4 (Minneapolis);Libertarian Party 4300021319003;Stephanie Gasca;Council Member Ward 4 (Minneapolis);Democratic-Farmer-Labor 4300021319004;Phillipe M. Cunningham;Council Member Ward 4 (Minneapolis);Democratic-Farmer-Labor 4300021419001;Blong Yang;Council Member Ward 5 (Minneapolis);Democratic-Farmer-Labor 4300021419002;Cathy Spann;Council Member Ward 5 (Minneapolis);Democratic-Farmer-Labor 4300021419003;Jeremiah Ellison;Council Member Ward 5 (Minneapolis);Democratic-Farmer-Labor 4300021419004;Raeisha (RA) Williams;Council Member Ward 5 (Minneapolis);Democratic Party 4300021519001;Abdi Warsame;Council Member Ward 6 (Minneapolis);Democratic-Farmer-Labor 4300021519002;Mohamud Noor;Council Member Ward 6 (Minneapolis);Democratic-Farmer-Labor 4300021519003;Fadumo Yusuf;Council Member Ward 6 (Minneapolis);Republican 4300021619001;Joe Kovacs;Council Member Ward 7 (Minneapolis);Republican 4300021619002;Teqen Zéa-Aida;Council Member Ward 7 (Minneapolis);Democratic-Farmer-Labor 4300021619003;Lisa Goodman;Council Member Ward 7 (Minneapolis);Democratic-Farmer-Labor 4300021619004;Janne Flisrand;Council Member Ward 7 (Minneapolis);Democratic-Farmer-Labor 4300021719001;Andrea Jenkins;Council Member Ward 8 (Minneapolis);Democratic-Farmer-Labor 4300021719002;Terry White;Council Member Ward 8 (Minneapolis);Green Party 4300021719003;David Holsinger;Council Member Ward 8 (Minneapolis);Libertarian Party 4300021719004;April Kane;Council Member Ward 8 (Minneapolis);Democratic-Farmer-Labor 4300021819001;Alondra Cano;Council Member Ward 9 (Minneapolis);Democratic-Farmer-Labor 4300021819002;Ronald W. Peterson;Council Member Ward 9 (Minneapolis);Republican 4300021819003;Mohamed Farah;Council Member Ward 9 (Minneapolis);Democratic-Farmer-Labor 4300021819004;Gary Schiff;Council Member Ward 9 (Minneapolis);Democratic-Farmer-Labor 4300021919001;Bruce Lundeen;Council Member Ward 10 (Minneapolis);Republican 4300021919002;Lisa Bender;Council Member Ward 10 (Minneapolis);Democratic-Farmer-Labor 4300021919003;David Schorn;Council Member Ward 10 (Minneapolis);Democratic-Farmer-Labor 4300021919004;Saralyn Romanishan;Council Member Ward 10 (Minneapolis);Democratic-Farmer-Labor 4300022019001;John Quincy;Council Member Ward 11 (Minneapolis);Democratic-Farmer-Labor 4300022019002;Jeremy Schroeder;Council Member Ward 11 (Minneapolis);Democratic-Farmer-Labor 4300022019003;Erica Mauter;Council Member Ward 11 (Minneapolis);Democratic-Farmer-Labor 4300022119001;Andrew Johnson;Council Member Ward 12 (Minneapolis);Democratic-Farmer-Labor 4300022119002;Harrison Bullard;Council Member Ward 12 (Minneapolis);Independent Health Labor 4300022119003;Will Jaeger;Council Member Ward 12 (Minneapolis);Independent 4300022219001;Linea Palmisano;Council Member Ward 13 (Minneapolis);Democratic-Farmer-Labor 4300022219002;Bob Reuer;Council Member Ward 13 (Minneapolis);Independent