1. Find the names of candidates who ran for an office ending with '23A'. CANDIDATE_NAME -------------------------------------------- MIKE BIDWELL TERRY MORROW WRITE-IN** 2. Provide an alphabetical list of the parties' full names. PARTY_NAME -------------------------- Better Life Constitution Democratic-Farmer-Labor Green IVOTEMN.net Independence Independent Libertarian Moderate Independent Party Nonpartisan Republican Socialist Workers Write-In 3. Find the candidates who ran for the office of 'US SENATOR'. For each, list the candidate's and party's full names. CANDIDATE_NAME PARTY_NAME -------------------------------------------- -------------------------- DEAN BARKLEY Independence NORM COLEMAN Republican AL FRANKEN Democratic-Farmer-Labor CHARLES ALDRICH Libertarian JAMES NIEMACKL Constitution JACK SHEPARD** Write-In ANTHONY KEITH PRICE** Write-In JOHN H. EVAN** Write-In MICHAEL CAVLAN** Write-In WRITE-IN** Write-In 4. Find a list of candidates' names for those candidates who received a majority of the votes in at least one precinct in 'NICOLLET' county. You should take into account the results for State House, US House, US President, and US Senate. CANDIDATE_NAME -------------------------------------------- BARACK OBAMA AND JOE BIDEN TERRY MORROW NORM COLEMAN AL FRANKEN MIKE BIDWELL TIM WALZ JOHN MCCAIN AND SARAH PALIN KATHY BRYNAERT 5. In which precinct (or precincts) did 'TERRY MORROW' receive his largest vote count? Give your answer as a precinct name (or names, if there is a tie). PRECINCT_NAME ------------------------------------ ST PETER W-2 P-1 6. In what cities did 'TERRY MORROW' have election results? A city is a Minor Civil Division (MCD) with a name that starts with 'City of'. MCD_NAME ----------------------------------------------- City of Mankato City of North Mankato City of Courtland City of Gaylord City of Gibbon City of Lafayette City of St. Peter City of Winthrop City of Nicollet 7. The MCD numbers are supposed to be unique statewide. It is worth checking whether this is the case. Find all cases where the same MCD number is associated with more than one MCD name. In each case, list the MCD number and the two MCD names. Don't list each pair in two different orders. For context, also include the two county names. MCD_ID MCD_NAME COUNTY_NAME MCD_NAME COUNTY_NAME ------ ----------------------------------------------- ----------------- ----------------------------------------------- ----------------- 15277 Bass Lake Unorganized Itasca Deer Lake Unorganized Itasca 8. In how many precincts did 'TERRY MORROW' have results? PRECINCTS ---------------------- 45 9. In how many precincts did 'TERRY MORROW' receive a majority of the votes? PRECINCTS ---------------------- 40 10. How many precincts are there, totaled over all counties? PRECINCTS ---------------------- 4130 11. If you concatenate together the county and precinct numbers for each US Senate result, how many combinations are there, counting each one only once? PRECINCTS ---------------------- 4131 12. Find any rows of the US Senate results that contain a county number not present in the table of counties. STATE COUNTY_ID PRECINCT_NUMBER OFFICE_ID OFFICE_NAME DISTRICT CANDIDATE_ID CANDIDATE_NAME PARTY_ID PRECINCTS_REPORTING PRECINCTS_IN_COUNTY VOTES PERCENTAGE TOTAL_VOTES ----- --------- --------------- --------- ----------- -------- ------------ --------------------- -------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- MN 89 0005 0103 US SENATOR 0201 DEAN BARKLEY IP 1 1 101 11.2723 896 MN 89 0005 0103 US SENATOR 0301 NORM COLEMAN R 1 1 305 34.0402 896 MN 89 0005 0103 US SENATOR 0401 AL FRANKEN DFL 1 1 481 53.683 896 MN 89 0005 0103 US SENATOR 0901 CHARLES ALDRICH LIB 1 1 7 0.7813 896 MN 89 0005 0103 US SENATOR 1001 JAMES NIEMACKL CP 1 1 2 0.2232 896 MN 89 0005 0103 US SENATOR 9901 WRITE-IN** WI 1 1 0 0 896 MN 89 0005 0103 US SENATOR 9902 MICHAEL CAVLAN** WI 1 1 0 0 896 MN 89 0005 0103 US SENATOR 9903 JOHN H. EVAN** WI 1 1 0 0 896 MN 89 0005 0103 US SENATOR 9904 ANTHONY KEITH PRICE** WI 1 1 0 0 896 MN 89 0005 0103 US SENATOR 9905 JACK SHEPARD** WI 1 1 0 0 896 13. Produce a table of state-wide votes for the US Senate race, showing in each row the candidate's name and the corresponding number of votes. The table should be in descending order of votes. CANDIDATE TOTAL VOTES --------------------- ---------------------- AL FRANKEN 1212431 NORM COLEMAN 1212206 DEAN BARKLEY 437505 CHARLES ALDRICH 13923 JAMES NIEMACKL 8907 WRITE-IN** 2340 MICHAEL CAVLAN** 13 ANTHONY KEITH PRICE** 12 JOHN H. EVAN** 0 JACK SHEPARD** 0 14. Produce a second table of state-wide votes for the US Senate race, showing in each row the candidate's name and the corresponding number of votes. The table should again be in descending order of votes. This time, exclude any results that don't have a corresponding entry in the table of counties. CANDIDATE TOTAL VOTES --------------------- ---------------------- AL FRANKEN 1211950 NORM COLEMAN 1211901 DEAN BARKLEY 437404 CHARLES ALDRICH 13916 JAMES NIEMACKL 8905 WRITE-IN** 2340 MICHAEL CAVLAN** 13 ANTHONY KEITH PRICE** 12 JOHN H. EVAN** 0 JACK SHEPARD** 0 15. What percentage of the votes for his office did 'TERRY MORROW' receive in each county where he had results? List the county names with their percentages (which should be labeled as such). COUNTY PERCENTAGE ----------------- ---------------------- SIBLEY 58.20379965457685664939550949913644214162 NICOLLET 64.6049896049896049896049896049896049896