About: Every week during the NFL season, Bill Simmons,
(aka the Sports Guy) picks every NFL game against the point spread. kevinpaulconnor.com
has collected crucial information about these picks (2006-2008) into a database.
From this page, you can query the database to find out how he has done.
"I want you to watch me query this database, watch me click this menu and choose
an option, watch...
You think that wasn't a big database search?"
Instructions: Use the drop down menus and text box to form your query and hit the button.
For specific information about particular options, please click a menu label
to open a new window with usage instructions.
"Simmons Result" response string included a piece of the SQL query; Fixed.
"Week" response string was ungrammatical when combined with "Year". Fixed.
Seahawks option mapped to steelers, steelers option missing. Fixed.
Fixed database problem: 'Lines' column in db accepted ints rather
than floats, so half-point lines were being truncated. Changed "Lines" to accept
Missing Picks: I couldn't find Simmons picks for the following games:
2007 week 9, 2007 week 12 weekend games, 2007 week 13 thursday games, and
2008 week 13 weekend games, so those games are not in the database. Either these
are no longer publicly available, or I'm dumb. If the latter, please send me
the link and I'll add them.
There are no playoff picks in the database. I might add them in the future,
especially if someone gives me a compelling reason.
I didn't realize when I started that Simmons started making picks before 2006.
When I feel like doing a lot of data entry, I'll go back and add those.
There are something like 725 entries in the database, all of which
I entered myself. There are almost certainly a few data entry errors; if you find
one please let me know.
I'd love to hear from you about the Picks Machine. Contact me at