names

21 rows where case_id = 2227759

✎ 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
4588416 2227759 2227759 plaintiff Kirkeham   successor to John Helmesley, sometime prior of Kirkeham   Kirkeham, prior of, successor to John Helmesley, sometime prior of Kirkeham 0
4588417 2227759 2227759 defendant (not given) Richard abbot of Rievall   Rievall, Richard, abbot of 0
4588418 2227759 2227759 defendant Kirkeham Lawrence another brother in the same abbey   Kirkeham, Lawrence, another brother in the same abbey 1
4588419 2227759 2227759 defendant Lyon John     Lyon, John 2
4588420 2227759 2227759 defendant Dogeston John     Dogeston, John 3
4588421 2227759 2227759 defendant Henrison Robert     Henrison, Robert 4
4588422 2227759 2227759 defendant Par William de     Par, William de 5
4588423 2227759 2227759 defendant Langwath Thomas     Langwath, Thomas 6
4588424 2227759 2227759 defendant Gretehed William     Gretehed, William 7
4588425 2227759 2227759 defendant Colson William     Colson, William 8
4588426 2227759 2227759 defendant Cort William     Cort, William 9
4588427 2227759 2227759 defendant Langwath John     Langwath, John 10
4588428 2227759 2227759 defendant Langwath Roger     Langwath, Roger 11
4588429 2227759 2227759 defendant Hoton Alice de formerly wife of Nicholas   Hoton, Alice de, formerly wife of Nicholas 12
4588430 2227759 2227759 defendant Yowehird John son of Roger   Yowehird, John, son of Roger 13
4588431 2227759 2227759 defendant Addyson John     Addyson, John 14
4588432 2227759 2227759 defendant Westerdale Alice     Westerdale, Alice 15
4588433 2227759 2227759 defendant Malom John     Malom, John 16
4588434 2227759 2227759 defendant Garbotman Thomas     Garbotman, Thomas 17
4588435 2227759 2227759 defendant Williamson John   772397 772397 Williamson, John, of the Holme 18
4588436 2227759 2227759 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);