names

15 rows where place_id = 618556

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3725255 1934186 1934186 defendant Lawter Godfrey yeoman 618556 618556 Lawter, Godfrey, of Sylton, yeoman 1
3781733 1952033 1952033 defendant Dyte William husbandman 618556 618556 (Dyte, William, of Sylton, husbandman 1
3785248 1953170 1953170 defendant Dyte William husbandman 618556 618556 (Dyte, William, of Sylton, husbandman 1
3797695 1957177 1957177 defendant Willoughby William gent 618556 618556 Willoughby, William, of Sylton, gent 0
4061137 2046392 2046392 defendant Wayer Christopher yeoman 618556 618556 Wayer, Christopher, of Sylton, yeoman 0
4080441 2053315 2053315 plaintiff Ware Christopher (legal representative) 618556 618556 Ware, Christopher, of Sylton, yeoman, executor of 0
4080442 2053315 2053315 plaintiff Ware Christopher yeoman 618556 618556 Ware, Christopher, of Sylton, yeoman 1
4377840 2157143 2157143 defendant Hill Humphrey gent 618556 618556 Hill, Humphrey, of Sylton, gent 0
4382535 2158866 2158866 defendant Jefferis John yeoman 618556 618556 Jefferis, John, of Sylton, yeoman 1
4414485 2169431 2169431 plaintiff Diggeby Elizabeth de   618556 618556 Diggeby, Elizabeth de, of Sylton, formerly wife of Ja_ 0
4560284 2219162 2219162 defendant del Hall Peter   618556 618556 del Hall, Peter, of Sylton 10
4560285 2219162 2219162 defendant Bulmer Walter   618556 618556 Bulmer, Walter, of Sylton 11
4560286 2219162 2219162 defendant Bulmer John   618556 618556 Bulmer, John, of Sylton 12
4653090 2246900 2246900 defendant Maltby Thomas gent 618556 618556 Maltby, Thomas, of Sylton, gent 0
5588705 2531478 2531478 defendant Hopkens John husbandman 618556 618556 Hopkens, John, of Sylton, husbandman 0

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