names

16 rows where case_id = 2193431

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4476881 2193431 2193431 plaintiff (not given)   abbot of Glaston   Glaston, abbot of 0
4476882 2193431 2193431 defendant Hamme Walter chaplain   Hamme, Walter, chaplain 0
4476883 2193431 2193431 defendant Sawyere William   617273 617273 Sawyere, William, of Woky 1
4476884 2193431 2193431 defendant tourne William     tourne, William 2
4476885 2193431 2193431 defendant Short John   617273 617273 Short, John, of Woky 3
4476886 2193431 2193431 defendant Beke John   617273 617273 Beke, John, of Woky 4
4476887 2193431 2193431 defendant Luyde John     Luyde, John 5
4476888 2193431 2193431 defendant Hort Walter     Hort, Walter 6
4476889 2193431 2193431 defendant Redde John     Redde, John 7
4476890 2193431 2193431 defendant Bdkere John     Bdkere, John 8
4476891 2193431 2193431 defendant Counseil Thomas     Counseil, Thomas 9
4476892 2193431 2193431 defendant Whydy Jhn     Whydy, Jhn 10
4476893 2193431 2193431 defendant Selcoke John. Mody John   Selcoke, John. Mody, John 11
4476894 2193431 2193431 defendant Mund Edmund     Mund, Edmund 12
4476895 2193431 2193431 defendant Chafyn Richard     Chafyn, Richard 13
4476896 2193431 2193431 defendant Hamme Miles Walter-servant     Hamme, Miles Walter-servant 14

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