Assignments for August 4

Browse the Post’s Congressional Vote Database before class.


You should have narrowed down a question to answer or explore for your topic area, and be gathering and interviewing your data. Start keeping a log of your actions – it can be a Word file, or blog posts, whatever – and send me the log.


Using the imported vote data, write SQL queries to answer the following questions. They may require 1, 2 or 3 tables to answer, so please look at the fields/data carefully to see what you have. If you’re not sure what a field name means, let me know.

1. How many votes have all Republicans voting “No” and all Democrats voting “Yes”?
2. Which Democrat has voted “No” most often?
3. Which Republican has agreed with the republican majority position the most?
4. Which senator has missed the most votes (the position is “Not Voting”)?
5. How many votes have received 0 “No” votes?
6. Which senators have been the only person to vote “No” on a vote, and how many times have they done it?

Send both SQLite files, plus your SQL queries, to me by email.

Reading: How the Bristol (VA) Herald Courier won a Pulitzer using databases.


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s