shakespeare_work.sql

insert into shakespeare.work (id, title, long_title, year, genre_type, notes, source, total_words, total_paragraphs)
values  ('12night', 'Twelfth Night', 'Twelfth Night, Or What You Will', 1599, 'c', null, 'Moby', 19837, 1031),
        ('allswell', 'All''s Well That Ends Well', 'All''s Well That Ends Well', 1602, 'c', null, 'Moby', 22997, 1025),
        ('antonycleo', 'Antony and Cleopatra', 'Antony and Cleopatra', 1606, 't', null, 'Moby', 24905, 1344),
        ('asyoulikeit', 'As You Like It', 'As You Like It', 1599, 'c', null, 'Gutenberg', 21690, 872),
        ('comedyerrors', 'Comedy of Errors', 'The Comedy of Errors', 1589, 'c', null, 'Moby', 14692, 661),
        ('coriolanus', 'Coriolanus', 'Coriolanus', 1607, 't', null, 'Moby', 27577, 1226),
        ('cymbeline', 'Cymbeline', 'Cymbeline, King of Britain', 1609, 'h', null, 'Moby', 27565, 971),
        ('hamlet', 'Hamlet', 'Tragedy of Hamlet, Prince of Denmark, The', 1600, 't', null, 'Gutenberg', 30558, 1275),
        ('henry4p1', 'Henry IV, Part I', 'History of Henry IV, Part I', 1597, 'h', null, 'Moby', 24579, 884),
        ('henry4p2', 'Henry IV, Part II', 'History of Henry IV, Part II', 1597, 'h', null, 'Gutenberg', 25692, 1013),
        ('henry5', 'Henry V', 'History of Henry V', 1598, 'h', null, 'Moby', 26119, 846),
        ('henry6p1', 'Henry VI, Part I', 'History of Henry VI, Part I', 1591, 'h', null, 'Moby', 21575, 772),
        ('henry6p2', 'Henry VI, Part II', 'History of Henry VI, Part II', 1590, 'h', null, 'Moby', 25411, 904),
        ('henry6p3', 'Henry VI, Part III', 'History of Henry VI, Part III', 1590, 'h', null, 'Moby', 24284, 935),
        ('henry8', 'Henry VIII', 'History of Henry VIII', 1612, 'h', null, 'Moby', 24629, 779),
        ('juliuscaesar', 'Julius Caesar', 'The Tragedy of Julius Caesar', 1599, 't', null, 'Moby', 19703, 888),
        ('kingjohn', 'King John', 'History of King John', 1596, 'h', null, 'Moby', 20760, 615),
        ('kinglear', 'King Lear', 'The Tragedy of King Lear', 1605, 't', null, 'Gutenberg', 26119, 1177),
        ('loverscomplaint', 'Lover''s Complaint', 'A Lover''s Complaint', 1609, 'p', null, 'Moby', 2559, 47),
        ('loveslabours', 'Love''s Labour''s Lost', 'Love''s Labour''s Lost', 1594, 'c', null, 'Moby', 21450, 1120),
        ('macbeth', 'Macbeth', 'The Tragedy of Macbeth', 1605, 't', null, 'Moby', 17121, 758),
        ('measure', 'Measure for Measure', 'Measure for Measure', 1604, 'c', null, 'Moby', 21773, 980),
        ('merchantvenice', 'Merchant of Venice', 'Merchant of Venice, The', 1596, 'c', null, 'Moby', 21291, 718),
        ('merrywives', 'Merry Wives of Windsor', 'Merry Wives of Windsor, The', 1600, 'c', null, 'Moby', 21845, 1161),
        ('midsummer', 'Midsummer Night''s Dream', 'A Midsummer Night''s Dream', 1595, 'c', null, 'Moby', 16511, 603),
        ('muchado', 'Much Ado about Nothing', 'Much Ado about Nothing', 1598, 'c', null, 'Moby', 21157, 1059),
        ('othello', 'Othello', 'The Tragedy of Othello, Moor of Venice', 1604, 't', null, 'Moby', 26450, 1308),
        ('passionatepilgrim', 'Passionate Pilgrim', 'The Passionate Pilgrim', 1598, 'p', null, 'Moby', 3124, 43),
        ('pericles', 'Pericles', 'Pericles, Prince of Tyre', 1608, 'h', null, 'Moby', 18529, 748),
        ('phoenixturtle', 'Phoenix and the Turtle', 'The Phoenix and the Turtle', 1601, 'p', null, 'Moby', 353, 19),
        ('rapelucrece', 'Rape of Lucrece', 'The Rape of Lucrece', 1594, 'p', null, 'Moby', 15003, 269),
        ('richard2', 'Richard II', 'History of Richard II', 1595, 'h', null, 'Moby', 22411, 628),
        ('richard3', 'Richard III', 'History of Richard III', 1592, 'h', null, 'Moby', 29278, 1210),
        ('romeojuliet', 'Romeo and Juliet', 'The Tragedy of Romeo and Juliet', 1594, 't', null, 'Moby', 24553, 989),
        ('sonnets', 'Sonnets', 'Sonnets', 1609, 's', null, 'Moby', 17515, 154),
        ('tamingshrew', 'Taming of the Shrew', 'The Taming of the Shrew', 1593, 'c', null, 'Gutenberg', 21055, 965),
        ('tempest', 'Tempest', 'The Tempest', 1611, 'c', null, 'Moby', 16628, 698),
        ('timonathens', 'Timon of Athens', 'The Tragedy of Timon of Athens', 1607, 't', null, 'Moby', 18206, 865),
        ('titus', 'Titus Andronicus', 'Titus Andronicus', 1593, 't', null, 'Moby', 20710, 654),
        ('troilus', 'Troilus and Cressida', 'Troilus and Cressida', 1601, 't', null, 'Moby', 26089, 1295),
        ('twogents', 'Two Gentlemen of Verona', 'Two Gentlemen of Verona', 1594, 'c', null, 'Moby', 17129, 943),
        ('venusadonis', 'Venus and Adonis', 'Venus and Adonis', 1593, 'p', null, 'Moby', 9870, 201),
        ('winterstale', 'The Winter''s Tale', 'The Winter''s Tale', 1610, 'c', null, 'Moby', 24914, 812);