names

12 rows where case_id = 2365330

✎ 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
5028918 2365330 2365330 plaintiff Neville Richard Earl of Salisbury   Neville, Richard, Earl of Salisbury 0
5028919 2365330 2365330 defendant Lancastre Roger gent 837040 837040 Lancastre, Roger, of Parva Staynton, gent 0
5028920 2365330 2365330 defendant Jonson Thomas yeoman 827693 827693 Jonson, Thomas, of Dacre, yeoman 1
5028921 2365330 2365330 defendant Gilbank Alexander yeoman 827693 827693 Gilbank, Alexander, of Dacre, yeoman 2
5028922 2365330 2365330 defendant Daweson William yeoman 837037 837037 Daweson, William, of Byrkhowe, yeoman 3
5028923 2365330 2365330 defendant Lancastre Thomas gent 827693 827693 Lancastre, Thomas, of Dacre, gent 4
5028924 2365330 2365330 defendant Louther Thomas chaplain 598898 598898 Louther, Thomas, of Addyngham, chaplain 5
5028925 2365330 2365330 defendant Moresby Christopher gent 837038 837038 Moresby, Christopher, of Wynanderwath, Westmor, gent 6
5028926 2365330 2365330 defendant Moresby John gent 837039 837039 Moresby, John, of Wynanderwath, gent 7
5028927 2365330 2365330 defendant Hoton Henry gent 809219 809219 together with Hoton, Henry, of Hoton John, gent 8
5028928 2365330 2365330 defendant Dayncourt John chaplain 827693 827693 Dayncourt, John, of Dacre, chaplain 9
5028929 2365330 2365330 defendant Strykland Walter gent 837041 837041 Strykland, Walter, of Seyser, Westmor, gent 10

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);