names

19 rows where case_id = 2227754

✎ 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
4588368 2227754 2227754 plaintiff (not given)   prior of Kirkeham   Kirkeham, prior of 0
4588369 2227754 2227754 defendant Lyon John     Lyon, John 0
4588370 2227754 2227754 defendant Dogeson John     Dogeson, John 1
4588371 2227754 2227754 defendant Henryson Robert     Henryson, Robert 2
4588372 2227754 2227754 defendant Par William de     Par, William de 3
4588373 2227754 2227754 defendant Langwath Thomas     Langwath, Thomas 4
4588374 2227754 2227754 defendant Gretehede William     Gretehede, William 5
4588375 2227754 2227754 defendant Cobson William     Cobson, William 6
4588376 2227754 2227754 defendant Cort William     Cort, William 7
4588377 2227754 2227754 defendant Langwath John     Langwath, John 8
4588378 2227754 2227754 defendant Langwath Robert Hoton, Alice, formerly wife of Nicholas de Hoton   Langwath, Robert, Hoton, Alice, formerly wife of Nicholas de Hoton 9
4588379 2227754 2227754 defendant Yowehird John son of Roger   Yowehird, John, son of Roger 10
4588380 2227754 2227754 defendant Addyson John   602245 602245 Addyson, John, of Westerdale 11
4588381 2227754 2227754 defendant Malom John     Malom, John 12
4588382 2227754 2227754 defendant Garboteman Thomas     Garboteman, Thomas 13
4588383 2227754 2227754 defendant Holme John of the son of William   Holme, John of the, son of William 14
4588384 2227754 2227754 defendant Garbot William     Garbot, William 15
4588385 2227754 2227754 defendant Rievall Richard abbot   together with Rievall, Richard, abbot 16
4588386 2227754 2227754 defendant Kirkeham Lawrence another brother in the same abbey   Kirkeham, Lawrence, another brother in the same abbey 17

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