Assignments for May 13

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s