names

19 rows where place_id = 795603

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4599443 2231042 2231042 defendant Folcard Henry   795603 795603 Folcard, Henry, of Canston, Norf, bailiff 0
4746976 2279618 2279618 defendant Gloos Robert yeoman 795603 795603 Gloos, Robert, of Canston, Norf, yeoman 4
4751642 2280970 2280970 defendant Hollebek Simon skinner 795603 795603 Hollebek, Simon, of Canston, Norf, skinner 1
4929310 2335584 2335584 defendant Hull John yeoman 795603 795603 Hull, John, of Canston, Norf,yeoman 3
5156788 2403143 2403143 defendant Rysburgh William yeoman 795603 795603 Rysburgh, William, of Canston, Norf, yeoman 1
5270202 2436383 2436383 defendant Pury William yeoman 795603 795603 Pury, William, of Canston, Norf, yeoman 1
5398628 2474669 2474669 defendant Lombe Richard mercer 795603 795603 Lombe, Richard, of Canston, Norf, mercer 3
5426659 2482920 2482920 defendant Tuly Richard   795603 795603 Tuly, Richard, of Canston, Norf, husbandman, administrators of 0
5427537 2483187 2483187 defendant Fraunceys Thomas shoemaker 795603 795603 Fraunceys, Thomas, of Canston, Norf, shoemaker 1
5440775 2487152 2487152 defendant Brigge John, sen yeoman 795603 795603 Brigge, John, sen, of Canston, Norf, yeoman 1
5442572 2487694 2487694 defendant Gryffyth Owen yeoman 795603 795603 (Gryffyth, Owen, of Canston, Norf, yeoman 1
5444710 2488317 2488317 defendant Tuly Richard (legal representative) 795603 795603 Tuly, Richard, of Canston, Norf, husbandman, administrator of 0
5445279 2488483 2488483 defendant Fraunces Thomas shoemaker 795603 795603 Fraunces, Thomas, of Canston, Norf, shoemaker 1
5448405 2489417 2489417 defendant Skynner John husbandman 795603 795603 Skynner, John, of Canston, Norf, husbandman 3
5455280 2491497 2491497 defendant Gryffyth Owin yeoman 795603 795603 (Gryffyth, Owin, of Canston, Norf, yeoman 1
5455672 2491597 2491597 defendant Feyth John husbandman 795603 795603 Feyth, John, of Canston, Norf, husbandman 2
5457418 2492120 2492120 defendant Tuly Richard (legal representative) 795603 795603 Tuly, Richard, of Canston, Norf,husbandman, administrator of 0
5457986 2492288 2492288 defendant Braundeys Thomas shoemaker 795603 795603 Braundeys, Thomas, of Canston, Norf, shoemaker 1
5460729 2493156 2493156 defendant Skynner John husbandman 795603 795603 Skynner, John, of Canston, Norf, husbandman 3

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