names

13 rows where case_id = 2309086

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4842158 2309086 2309086 plaintiff Laurence Robert knight   Laurence, Robert, knight 0
4842159 2309086 2309086 defendant Neuton Mathew de gent 592147 592147 Neuton, Mathew de, of Neuton, gent 0
4842160 2309086 2309086 defendant Neuton Thomas gent 803629 803629 Neuton, Thomas, of Whityngton, Lancs, gent 1
4842161 2309086 2309086 defendant Banes Richard yeoman 587039 587039 Banes, Richard, of Whityngton, yeoman 2
4842162 2309086 2309086 defendant Diconson Tomson John, of Neuton, yeoman   Diconson, Tomson, John, of Neuton, yeoman 3
4842163 2309086 2309086 defendant Harlyng John yeoman 592147 592147 Harlyng, John, of Neuton, yeoman 4
4842164 2309086 2309086 defendant Kyng John yeoman 592147 592147 Kyng, John, of Neuton, yeoman 5
4842165 2309086 2309086 defendant Williamson Oliver laborer 593142 593142 Williamson, Oliver, of Tunstall, laborer 6
4842166 2309086 2309086 defendant Harlyng John miller 592147 592147 Harlyng, John, of Neuton, miller 7
4842167 2309086 2309086 defendant Thornton Thomas son of William, of Neuton, yeoman   Thornton, Thomas, son of William, of Neuton, yeoman 8
4842168 2309086 2309086 defendant Redemane Roger yeoman   Redemane, Roger, yeoman 9
4842169 2309086 2309086 defendant Thornton Gilbert son of William, yeoman   Thornton, Gilbert, son of William, yeoman 10
4842170 2309086 2309086 defendant Neuton William de yeoman 592147 592147 Neuton, William de, of Neuton, yeoman 11

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);