Shakespeare in a database

To learn more about this page, read the blog post. Geek note: this is all happening in your web browser, thanks to clever work by others (credits at the bottom of the page).

There are four tables in the database: works, chapters, paragraphs and characters. Rather than list out the structure, just go ahead and issue DESCRIBE works or SELECT * FROM works, and so on. Read the example below: if you know SQL, you should get the idea. If you like, download the whole database.

Try and predict the results of these examples before you run the query:

Results will be displayed here