names

24 rows where case_id = 2525207

✎ 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
5568030 2525207 2525207 plaintiff Ernley John     Ernley, John 0
5568031 2525207 2525207 defendant Lecheford Henry yeoman 649872 649872 Lecheford, Henry, of Cherlewod, Surrey, yeoman 0
5568032 2525207 2525207 defendant Saunders John gent 598715 598715 Saunders, John, of Cherlewode, gent 1
5568033 2525207 2525207 defendant White Thomas yeoman 900987 900987 White, Thomas, of Chrlewod, yeoman 2
5568034 2525207 2525207 defendant Wody John gent 655325 655325 Wody, John, of Ifeld, Sussex, gent 3
5568035 2525207 2525207 defendant Pilston John esq 900988 900988 Pilston, John, of Northwall, esq 4
5568036 2525207 2525207 defendant A Wode John yeoman 586487 586487 A Wode, John, of Suthwerk, yeoman 5
5568037 2525207 2525207 defendant Robson Cuthbert saddler 588567 588567 Robson, Cuthbert, of Suthwerk St Margaret, saddler 6
5568038 2525207 2525207 defendant Brown John tailor 900989 900989 Brown, John, of Suthwerk St Thomas, tailor 7
5568039 2525207 2525207 defendant Chiltern John gent 900990 900990 Chiltern, John, of Suthwerk St Thomas Martyr, gent 8
5568040 2525207 2525207 defendant Cornwall Richard   900991 900991 Cornwall, Richard, of Leymster, Herefs, esq, son of Cornwall, Thomas, knight 9
5568041 2525207 2525207 defendant Taillor John yeoman 678434 678434 Taillor, John, of Blakesley, Nhants, yeoman, son of Taillor, John, of Blakesley, yeoman 10
5568042 2525207 2525207 defendant Pynde Thomas (legal representative) 585869 585869 Pynde, Thomas, of London, draper, executor of 11
5568043 2525207 2525207 defendant Aylmer Lawrence alderman 585869 585869 Aylmer, Lawrence, of London, alderman 12
5568044 2525207 2525207 defendant Sheffeld Robert   585869 585869 Sheffeld, Robert, of London, knight 13
5568045 2525207 2525207 defendant Sheffeld Ellen kinswoman of Babyngton, John, knight   Ellen his wife, kinswoman of Babyngton, John, knight 14
5568046 2525207 2525207 defendant Penny John Bishop of Bangor   Penny, John, Bishop of Bangor 15
5568047 2525207 2525207 defendant Babyngton Thomas gent 585869 585869 Babyngton, Thomas, of London, gent 16
5568048 2525207 2525207 defendant Donneham John esq 900993 900993 Donneham, John, of Kirtelington, Notts, esq 17
5568049 2525207 2525207 defendant Leeke Thomas esq 900994 900994 Leeke, Thomas, of Skrayton, Notts, esq 18
5568050 2525207 2525207 defendant Seynt Andrew John esq 796330 796330 Seynt Andrew, John, of Goteham, Notts, esq 19
5568051 2525207 2525207 defendant Dawson John rector of Shirland, Derbs   Dawson, John, rector of Shirland, Derbs 20
5568052 2525207 2525207 defendant Babyngton John knight   Babyngton, John, knight, executor of 21
5568053 2525207 2525207 defendant Pulffen John yeoman 585869 585869 Pulffen, John, of London, yeoman 22

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