names

20 rows where case_id = 2322959

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4887588 2322959 2322959 plaintiff Pekerd Thomas     Pekerd, Thomas 0
4887589 2322959 2322959 defendant Gren Richard ostler 628252 628252 Gren, Richard, of Otlay, ostler 0
4887590 2322959 2322959 defendant Gren John husbandman 628252 628252 Gren, John, of Otlay, husbandman 1
4887591 2322959 2322959 defendant Gren Walter yeoman 628252 628252 Gren, Walter, of Otlay, yeoman 2
4887592 2322959 2322959 defendant Gren Robert chaplain 628252 628252 Gren, Robert, of Otlay, chaplain 3
4887593 2322959 2322959 defendant Gren William   628252 628252 Gren, William, of Otlay, servant 4
4887594 2322959 2322959 defendant Gren Thomas laborer 628252 628252 Gren, Thomas, of Otlay, laborer 5
4887595 2322959 2322959 defendant Chapman James clerk 628252 628252 Chapman, James, of Otlay, clerk 6
4887596 2322959 2322959 defendant Hogeson William laborer 628252 628252 Hogeson, William, of Otlay, laborer 7
4887597 2322959 2322959 defendant Tercar John weaver 628252 628252 Tercar, John, of Otlay, weaver 8
4887598 2322959 2322959 defendant Yercar Thomas, junior weaver 628252 628252 Yercar, Thomas, junior, of Otlay, weaver 9
4887599 2322959 2322959 defendant Smyth John smith 765616 765616 Smyth, John, of Bynglay, smith 10
4887600 2322959 2322959 defendant Smyth Thomas yeoman 765616 765616 Smyth, Thomas, of Bynglay, yeoman 11
4887601 2322959 2322959 defendant Whithede Robert laborer 765616 765616 Whithede, Robert, of Bynglay, laborer 12
4887602 2322959 2322959 defendant Lynghous Robert laborer 765616 765616 Lynghous, Robert, of Bynglay, laborer 13
4887603 2322959 2322959 defendant de Kyghlay Lawrence gent 780415 780415 de Kyghlay, Lawrence, of Kyghlay, gent 14
4887604 2322959 2322959 defendant de Gill Richard laborer 780415 780415 de Gill, Richard, of Kyghlay, laborer 15
4887605 2322959 2322959 defendant Cote Robert laborer 817587 817587 Cote, Robert, of Kildewyk, laborer 16
4887606 2322959 2322959 defendant Scawra Henry   596384 596384 Scawra, Henry, of Newehall, franklin 17
4887607 2322959 2322959 defendant Cote John husbandman 817587 817587 Cote, John, of Kildewyk, husbandman 18

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