names

21 rows where case_id = 2227758

✎ 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
4588395 2227758 2227758 plaintiff Kirkeham   successor of John Helmesley   Kirkeham, prior of, successor of John Helmesley 0
4588396 2227758 2227758 defendant (not given) Richard abbot of Rievall   Rievall, Richard, abbot, of 0
4588397 2227758 2227758 defendant Kirkeham Lawrence another brother in the same abbey   Kirkeham, Lawrence, another brother in the same abbey 1
4588398 2227758 2227758 defendant Lyon John     Lyon, John 2
4588399 2227758 2227758 defendant Dogeson John     Dogeson, John 3
4588400 2227758 2227758 defendant Henryson Robert     Henryson, Robert 4
4588401 2227758 2227758 defendant Par William de     Par, William de 5
4588402 2227758 2227758 defendant Langwath Thomas     Langwath, Thomas 6
4588403 2227758 2227758 defendant Gretehede William     Gretehede, William 7
4588404 2227758 2227758 defendant Colson William     Colson, William 8
4588405 2227758 2227758 defendant Cort William     Cort, William 9
4588406 2227758 2227758 defendant Langwath John     Langwath, John 10
4588407 2227758 2227758 defendant Langwath Roger     Langwath, Roger 11
4588408 2227758 2227758 defendant Hoton Alice formerly wife of Nicholas   Hoton, Alice, formerly wife of Nicholas 12
4588409 2227758 2227758 defendant Yowehird John son of Roger   Yowehird, John, son of Roger 13
4588410 2227758 2227758 defendant Addyson John     Addyson, John 14
4588411 2227758 2227758 defendant Westerdale Alice     Westerdale, Alice 15
4588412 2227758 2227758 defendant Malom John     Malom, John 16
4588413 2227758 2227758 defendant Garbotman Thomas     Garbotman, Thomas 17
4588414 2227758 2227758 defendant Williamson John   772397 772397 Williamson, John, of the Holme 18
4588415 2227758 2227758 defendant Garbot William     Garbot, William 19

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