Open-Source-Shakespeare

A MySQL database of the complete works of William Shakespeare

This project presents the complete works of William Shakespeare as a MySQL database.

[![Flattr this git repo](http://api.flattr.com/button/flattr-badge-large.png)](https://flattr.com/submit/auto?user_id=edent42&url=https://github.com/edent/Open-Source-Shakespeare&title=Open-Source-Shakespeare&language=&tags=github&category=software)

Project Info: http://shkspr.mobi/blog/index.php/2012/04/open-source-shakespeare-in-mysql
Forked from: http://www.opensourceshakespeare.org/

There are four tables

Paragraphs

This is where the main body of text is. A typical row will look like this

    WorkID: hamlet
    ParagraphID: 639015
    ParagraphNum: 3427
    CharID: hamlet
    PlainText: Has this fellow no feeling of his business, that he sings at\ngrave-making?
    Act: 5
    Scene: 1

Works

This is what translates the “WorkID” into something human readable – plus some extra metadata

    WorkID: hamlet
    Title: Hamlet
    LongTitle: Tragedy of Hamlet, Prince of Denmark, The
    Date: 1600
    GenreType: Tragedy

Character

This is what translates the CharID into a human readable name and description

    charID: hamlet
    CharName: Hamlet
    Abbrev: Ham
    Works: Tragedy of Hamlet, Prince of Denmark, The
    Description: son of the former king and nephew to the present king

Chapters

This gives the setting for each Act and Scene.

    WorkID: hamlet
    ChapterID: 18893
    Act: 5
    Scene: 1
    Description: Elsinore. A churchyard.