names

11 rows where place_id = 604676

✎ 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
3658876 1913032 1913032 defendant Beyn Christopher husbandman 604676 604676 Beyn, Christopher, of Cottyngley, husbandman 0
4008855 2027932 2027932 plaintiff Morvell John (legal representative) 604676 604676 Morvell, John, of Cottyngley, executor of 0
4010552 2028547 2028547 defendant Moberley Lawrence husbandman 604676 604676 Moberley, Lawrence, of Cottyngley, husbandman 0
4027703 2034557 2034557 defendant Paslowe William gent 604676 604676 Paslowe, William, of Cottyngley, gent 0
4027712 2034560 2034560 defendant Paslowe William gent 604676 604676 Paslowe, William, of Cottyngley, gent 0
4033520 2036645 2036645 defendant Baylye John, junior yeoman 604676 604676 Baylye, John, junior, of Cottyngley, yeoman 6
4033531 2036646 2036646 defendant Baylye John, junior yeoman 604676 604676 Baylye, John, junior, of Cottyngley, yeoman 6
4040894 2039233 2039233 plaintiff Morvell Stephen   604676 604676 Morvell, Stephen, of Cottyngley 0
4126627 2069809 2069809 defendant Hill Edward laborer 604676 604676 Hill, Edward, of Cottyngley, laborer 0
4126628 2069809 2069809 defendant Hill Ellen widow 604676 604676 Hill, Ellen, of Cottyngley, widow 1
4210156 2099111 2099111 defendant Clapham "Gressam" gent 604676 604676 Clapham, "Gressam", of Cottyngley, gent 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);