names

14 rows where case_id = 2271960

✎ 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
4721188 2271960 2271960 plaintiff (not given) Henry archbishop of Canterbury   Canterbury, Henry, archbishop of 0
4721189 2271960 2271960 defendant Wyre Richard husbandman 764183 764183 Wyre, Richard, of Clyve by Lewes, husbandman 0
4721190 2271960 2271960 defendant Berkham John laborer 764183 764183 Berkham, John, of Clyve by Lewes, laborer 1
4721191 2271960 2271960 defendant Laurens William laborer   Laurens, William, laborer 2
4721192 2271960 2271960 defendant Degher Geoffrey dyer   Degher, Geoffrey, dyer 3
4721193 2271960 2271960 defendant Haycok Robert laborer   Haycok, Robert, laborer 4
4721194 2271960 2271960 defendant Degher William servant of Geffrey Degher, laborer   Degher, William, servant of Geffrey Degher, laborer 5
4721195 2271960 2271960 defendant Degher Thomas servant of Geffrey Degher, laborer   Degher, Thomas, servant of Geffrey Degher, laborer 6
4721196 2271960 2271960 defendant Larke Thomas husbandman   Larke, Thomas, husbandman 7
4721197 2271960 2271960 defendant (not given) Richard the servant of the vicar, laborer   Richard, the servant of the vicar, laborer 8
4721198 2271960 2271960 defendant Rolf John laborer 587374 587374 Rolf, John, of Lewes, laborer 9
4721199 2271960 2271960 defendant Courevyel Richard shoemaker 587374 587374 Courevyel, Richard, of Lewes, shoemaker 10
4721200 2271960 2271960 defendant Campe Robert tailor 587374 587374 Campe, Robert, of Lewes, tailor 11
4721201 2271960 2271960 defendant Cony Thomas husbandman 763822 763822 Cony, Thomas, of Ryngemere, husbandman 12

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