names

21 rows where case_id = 2227765

✎ 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
4588456 2227765 2227765 plaintiff (not given)   prior of Kirkham   Kirkham, prior of 0
4588457 2227765 2227765 defendant (not given) Richard abbot of Rievall   Rievall, Richard, abbot, of 0
4588458 2227765 2227765 defendant Kirkeham Lawrence another brother in the same abbey   Kirkeham, Lawrence, another brother in the same abbey 1
4588459 2227765 2227765 defendant Lyon John     Lyon, John 2
4588460 2227765 2227765 defendant Dogeson John     Dogeson, John 3
4588461 2227765 2227765 defendant Henryson Robert     Henryson, Robert 4
4588462 2227765 2227765 defendant Par William de     Par, William de 5
4588463 2227765 2227765 defendant Langwath Thomas     Langwath, Thomas 6
4588464 2227765 2227765 defendant Gretehede William     Gretehede, William 7
4588465 2227765 2227765 defendant Colson William     Colson, William 8
4588466 2227765 2227765 defendant Cort William     Cort, William 9
4588467 2227765 2227765 defendant Langwath John     Langwath, John 10
4588468 2227765 2227765 defendant Langwath Roger     Langwath, Roger 11
4588469 2227765 2227765 defendant Hoton Alice formerly wife of Nicholas   Hoton, Alice, formerly wife of Nicholas 12
4588470 2227765 2227765 defendant Yowehird John son of Roger   Yowehird, John, son of Roger 13
4588471 2227765 2227765 defendant Addyson John     Addyson, John 14
4588472 2227765 2227765 defendant Westerdale Alice     Westerdale, Alice 15
4588473 2227765 2227765 defendant Malom John     Malom, John 16
4588474 2227765 2227765 defendant Garbotman Thomas     Garbotman, Thomas 17
4588475 2227765 2227765 defendant Williamson John   772397 772397 Williamson, John, of the Holme 18
4588476 2227765 2227765 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);