names

20 rows where case_id = 2471229

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5386576 2471229 2471229 plaintiff Crouche William     Crouche, William, on his own account 0
5386577 2471229 2471229 defendant Gloys John yeoman 602634 602634 Gloys, John, of Wyghton, Norf, yeoman 0
5386578 2471229 2471229 defendant Packe George yeoman 681683 681683 Packe, George, of Bedyngfeld, Suff, yeoman 1
5386579 2471229 2471229 defendant Clerk John husbandman 591336 591336 Clerk, John, of Asshefeld, husbandman 2
5386580 2471229 2471229 defendant Bert Thomas yeoman 881456 881456 Bert, Thomas, of Wattlisfeld, yeoman 3
5386581 2471229 2471229 defendant Dey John weaver 586912 586912 Dey, John, of Melford, weaver 4
5386582 2471229 2471229 defendant Teryngton Robert yeoman 586587 586587 Teryngton, Robert, of Rekynghale inferior, yeoman 5
5386583 2471229 2471229 defendant Umfrey George yeoman 610081 610081 Umfrey, George, of Ratlisden, yeoman 6
5386584 2471229 2471229 defendant Caudeler John butcher 590853 590853 Caudeler, John, of Ratlesden, butcher 7
5386585 2471229 2471229 defendant Sesull John husbandman 610081 610081 Sesull, John, of Ratlisden, husbandman 8
5386586 2471229 2471229 defendant Cursum Philip draper 585936 585936 Cursum, Philip, of Norwich, draper 9
5386587 2471229 2471229 defendant Revell Thomas smith 597809 597809 Revell, Thomas, of Wolpet, smith 10
5386588 2471229 2471229 defendant Darlee John yeoman 598937 598937 Darlee, John, of Leyham, yeoman 11
5386589 2471229 2471229 defendant Wymbyll John yeoman 586346 586346 Wymbyll, John, of Langham, yeoman 12
5386590 2471229 2471229 defendant Laurens John yeoman 881457 881457 Laurens, John, of Runburgh, yeoman 13
5386591 2471229 2471229 defendant Vyncent Robert chaplain 586308 586308 Vyncent, Robert, of Walsham, chaplain 14
5386592 2471229 2471229 defendant Tompell John pedder 592596 592596 Tompell, John, of Kentford, pedder 15
5386593 2471229 2471229 defendant Dyer William dyer 586180 586180 Dyer, William, of Bury St Edmunds, dyer 16
5386594 2471229 2471229 defendant Baret William yeoman 586180 586180 Baret, William, of Bury St Edmunds, yeoman 17
5386595 2471229 2471229 defendant Skeet William husbandman 585947 585947 Skeet, William, of Hadley, 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);