names

13 rows where case_id = 2303795

✎ 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
4824782 2303795 2303795 plaintiff Tillioll Peter knight   Tillioll, Peter, knight 0
4824783 2303795 2303795 defendant Smythmagh John yeoman 760567 760567 Smythmagh, John, of Calisle, yeoman 0
4824784 2303795 2303795 defendant Sanderson Richard yeoman 765096 765096 Sanderson, Richard, of Crosseby, yeoman 1
4824785 2303795 2303795 defendant Twedale Richard yeoman 760887 760887 Twedale, Richard, of Gillesland, yeoman 2
4824786 2303795 2303795 defendant Twedale Wiliam yeoman 760887 760887 Twedale, Wiliam, of Gillesland, yeoman 3
4824787 2303795 2303795 defendant Dovenby John de yeoman 787511 787511 Dovenby, John de, of Blencogowe, yeoman 4
4824788 2303795 2303795 defendant Boursted Hugh yeoman 808213 808213 Boursted, Hugh, of Brownskathe, yeoman 5
4824789 2303795 2303795 defendant Forster John yeoman 590660 590660 Forster, John, of Carlisle, yeoman 6
4824790 2303795 2303795 defendant White William yeoman 808213 808213 White, William, of Brownskathe, yeoman 7
4824791 2303795 2303795 defendant Clerk Richard yeoman 736781 736781 Clerk, Richard, of Westward, yeoman 8
4824792 2303795 2303795 defendant Stag Richard yeoman 759606 759606 Stag, Richard, of Cargowe, yeoman 9
4824793 2303795 2303795 defendant Stag John yeoman 808214 808214 Stag, John, of Arthurethe, yeoman 10
4824794 2303795 2303795 defendant Whynsell Henry yeoman 590660 590660 Whynsell, Henry, of Carlisle, 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);