names

13 rows where case_id = 2365329

✎ 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
5028905 2365329 2365329 plaintiff Neville Richard Earl of Salisbury   Neville, Richard, Earl of Salisbury 0
5028906 2365329 2365329 defendant Hoton Henry gent 809219 809219 Hoton, Henry, of Hoton John, gent 0
5028907 2365329 2365329 defendant Dayncourt John chaplain 827693 827693 Dayncourt, John, of Dacre, chaplain 1
5028908 2365329 2365329 defendant Strykland Walter gent 837035 837035 Strykland, Walter, of Seyfer, Westmor, gent 2
5028909 2365329 2365329 defendant Lancastre Roger gent 837036 837036 together with Lancastre, Roger, of Oarva Staynton, Cumber, gent 3
5028910 2365329 2365329 defendant Jonson Thomas gent 827693 827693 Jonson, Thomas, of Dacre, gent 4
5028911 2365329 2365329 defendant Louther Thomas chaplain 598898 598898 Louther, Thomas, of Addyngham, chaplain 5
5028912 2365329 2365329 defendant Gilbank Alexander     Gilbank, Alexander 6
5028913 2365329 2365329 defendant of Dacre   yeoman   of Dacre, yeoman 7
5028914 2365329 2365329 defendant Daweson William yeoman 837037 837037 Daweson, William, of Byrkhowe, yeoman 8
5028915 2365329 2365329 defendant Lancastre Thomas gent 827693 827693 Lancastre, Thomas, of Dacre, gent 9
5028916 2365329 2365329 defendant Moresby Christopher gent 837038 837038 Moresby, Christopher, of Wynanderwath, Westmor, gent 10
5028917 2365329 2365329 defendant Moresby John gent 837039 837039 Moresby, John, of Wynanderwath, gent 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);