names

15 rows where place_id = 664737

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3974035 2015490 2015490 plaintiff Hardyng William clothworker 664737 664737 Hardyng, William, of Lonfon, clothworker 0
3974038 2015491 2015491 plaintiff Hardyng William clothworker 664737 664737 Hardyng, William, of Lonfon, clothworker 0
4027330 2034423 2034423 defendant Tee Alexander gent 664737 664737 Tee, Alexander, of Lonfon, gent 1
4035716 2037449 2037449 defendant Whittenstall Richard yeoman 664737 664737 Whittenstall, Richard, of Lonfon, yeoman 0
4046284 2041114 2041114 defendant Halle Michael clothier 664737 664737 Halle, Michael, of Lonfon, or of Hadley, Suff, clothier 0
4057009 2044891 2044891 defendant Bowes George   664737 664737 Bowes, George, of Lonfon, or of Streitlam, Durham, knight 0
4058835 2045554 2045554 defendant Hardwicke James esq 664737 664737 Hardwicke, James, of Lonfon, or of Hardwicke, Derbs, esq 0
4137790 2073876 2073876 defendant Lane Humphrey yeoman 664737 664737 Lane, Humphrey, of Lonfon, or of Thocke, yeoman 0
4227123 2104962 2104962 defendant Meysey John gent 664737 664737 Meysey, John, of Lonfon, gent 0
4273842 2120797 2120797 defendant Wood Henry merchant tailor 664737 664737 Wood, Henry, of Lonfon, merchant tailor 1
4928616 2335379 2335379 defendant West John pinner 664737 664737 West, John, of Lonfon, pinner 0
4977093 2350103 2350103 defendant Rygeley Robert grocer 664737 664737 Rygeley, Robert, of Lonfon, grocer 0
4980168 2351018 2351018 plaintiff Irwilham William mercer 664737 664737 Irwilham, William, of Lonfon, mercer 2
5064024 2375773 2375773 defendant Trenowithe John esq 664737 664737 Trenowithe, John, of Lonfon, esq 0
5581835 2529397 2529397 defendant Balse William merchant tailor 664737 664737 Balse, William, of Lonfon, merchant tailor 4

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