SQLite: Continuing with the senate voting database, write SQL to answer the following questions. You will need to study the fields in your tables. Send me both your queries and your sqlite data file.
1. How many votes were decided by less than 10 votes?
2. How many votes on nominations were confirmed?
3. Which Republican has voted most often with the Democratic majority position and how many times?
4. What is the greatest number of Democratic No votes on a nomination confirmation vote?
5. Which Democrat has voted No the most on passage of a bill votes?
Find Your Data: Please take some time this week to identify a source of information (it may already be in data form, or not) that you’d like to work with over the next few weeks. Preferably it should be government-related, but if you can make a good case for something else, I’ll entertain it (give me a heads-up before class if this is the case). If you’re searching for possible ideas, try the Census Bureau or FedStats or Data.gov.
Reading: This Toronto Star piece on racial profiling. Also check out the related content, including background information, interactives and data.