# The London Stage Database: Theatrical Corpus
This corpus provides a subset of the Text Creation Partnership's P4 XML files 
in their original, accompanied
by metadata derived from those XML files. 

## Corpora
* `/Plays` - A corpus of texts known to be individual plays, masques, or operas.
* `/Collections` - A corpus of texts known to be collections of plays. 
Additional processing will be required to determine which
play corresponds to each subsection of the text.

## Structure
* `/XML` - A folder of XML files in `[TCPId].P4.xml` form.
* `[corpus_name]-tcp-metadata.csv` - A metadata file with one
file per row.

## Data Dictionary
Each metadata file contains information derived from EEBO-TCP XML files related to 
performances in the database, one file per row. 
All fields except the ShortTitle and ShortTitleClean columns are derived 
from the TEI-P4 XML headers of each file. 

The ShortTitle and ShortTitleClean columns were extracted from the [English Short Title Catalogue (ESTC)](https://datb.cerl.org/estc) for purposes of providing an accepted short 
title for web interfaces. 

| Column Name | Type  | Constraints  | Description | Example |
|------------|-------|-------------|--------------------------|----------------|
| TCPId | varchar(11)   | PRIMARY KEY, NOT NULL | TCP project identifier | `K131816.000` |
| Phase  | varchar(16)   | NULL | TCP project phase (EEBO Phase 1, EEBO Phase 2, or ECCO) | `ECCO` |
| File | varchar(18)   | NOT NULL  | P4 XML filepath | `K131816.000.P4.xml`|
| Title | varchar(493)  | NULL | full title |`Three weeks after marriage: a comedy, in two acts, as performed at the Theatre-Royal in Covent Garden.` |
| AltTitle  | varchar(270)  | NULL | alternative title (if any) |`What we must all come to` |
| Author | varchar(344)  | NULL | author(s) and dates flourished semicolon-separated | `Murphy, Arthur, 1727-1805.` |
| CleanDate            | int(4)        | NULL | RawDate in YYYY form | `1775` |
| RawDate              | varchar(29)   | NULL | Publication date, sometimes attributed | `[1775?]` |
| Publisher            | varchar(198)  | NULL | Publisher's name, from PublicationStatement |  `printed for E. Johnson,`|
| PublicationStatement | varchar(225)  | NULL  | The full publication statement of the printed work   | `London :printed for E. Johnson,[1775?]`              |
| PublicationPlace     | varchar(23)   | NULL                  | City or country of publication, from PublicationStatement  | `London :` |
| XMLNotes | varchar(1805) | NULL | Miscellaneous notes on the source text and its microfilm counterpart | `Anonymous. By Arthur Murphy.; Originally performed and published in 1764 as 'What we must all come to'.; Reproduction of original from the British Library.; English Short Title Catalog, ESTC T224568.; Electronic data. Farmington Hills, Mich. : Thomson Gale, 2003. Page image (PNG). Digitized image of the microfilm version produced in Woodbridge, CT by Research Publications, 1982-2002 (later known as Primary Source Microfilm, an imprint of the Gale Group).`  |
| ESTC   | varchar(7)    | NULL   |  *English Short Title Catalogue* (1473-1800) identifier | `T224568` |
| STC  | varchar(11)   | NULL  | *Short Title Catalogue* (1475-1640) identifier  | `10854`  |
| Wing   | varchar(20)   | NULL  | Wing's *Short-Title Catalogue* (1641-1700) identifier  |  `B1581` |
| EEBOMarc | varchar(8) | NULL | Proquest [MARC identifier](https://proquest.libguides.com/eebopqp) (EEBO only) | `12491932` |
| GaleDocNo | varchar(12)   | NULL  | Gale identifier (ECCO only)  | `CW3307696075`|
| DocNo | varchar(11)   | NULL  | Gale document identifier (ECCO only) | `CW107696075` |
| ShortTitle | varchar(389)  | NOT NULL | ESTC short title | `Three weeks after marriage;` |
| ShortTitleClean | varchar(388)  | NOT NULL | ShortTitle with end punctuation stripped | `Three weeks after marriage` |
