names

16 rows where case_id = 1904148

✎ 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
3629710 1904148 1904148 plaintiff de Vere John Earl of Oxford, seneschal of Bury St Edmunds Abbey   de Vere, John, Earl of Oxford, seneschal of Bury St Edmunds Abbey, executors of 0
3629711 1904148 1904148 plaintiff de Vere Elizabeth Countess of Oxford   (de Vere, Elizabeth, Countess of Oxford 1
3629712 1904148 1904148 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 2
3629713 1904148 1904148 plaintiff Drury Robert knight   Drury, Robert, knight 3
3629714 1904148 1904148 plaintiff Walgrave William knight   Walgrave, William, knight 4
3629715 1904148 1904148 plaintiff Hobart James knight   Hobart, James, knight 5
3629716 1904148 1904148 plaintiff Lovell Robert     Lovell, Robert 6
3629717 1904148 1904148 plaintiff Ver John esq   Ver, John, esq 7
3629718 1904148 1904148 plaintiff Cock William clerk   Cock, William, clerk 8
3629719 1904148 1904148 plaintiff Wyngfeld Humphrey     Wyngfeld, Humphrey 9
3629720 1904148 1904148 plaintiff Josselyn John esq   Josselyn, John, esq 10
3629721 1904148 1904148 plaintiff Danyell John gent   Danyell, John, gent 11
3629722 1904148 1904148 plaintiff Ocley William     Ocley, William 12
3629723 1904148 1904148 defendant Westbrome Geoffrey husbandman 590340 590340 Westbrome, Geoffrey, of Wetherden, husbandman 0
3629724 1904148 1904148 defendant Wryght John miller 590420 590420 Wryght, John, of Rougham, miller 1
3629725 1904148 1904148 defendant Nunne Robert husbandman 590420 590420 Nunne, Robert, of Rougham, husbandman 2

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