names

9 rows where case_id = 2265446

✎ 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
4700075 2265446 2265446 plaintiff England Joan queen of   England, Joan, queen of 0
4700076 2265446 2265446 defendant Whytfeld John gent   Whytfeld, John, gent 0
4700077 2265446 2265446 defendant Sampson John husbandman 781248 781248 Sampson, John, of Chirchehill, husbandman 1
4700078 2265446 2265446 defendant Shepherd Robert husbandman 786935 786935 Shepherd, Robert, of Chadlynglyngton, husbandman 2
4700079 2265446 2265446 defendant Shepherd Simon husbandman 634554 634554 Shepherd, Simon, of Chadlyngton, husbandman 3
4700080 2265446 2265446 defendant Martyn John husbandman 634554 634554 Martyn, John, of Chadlyngton, husbandman 4
4700081 2265446 2265446 defendant Conbrugge William husbandman 634554 634554 Conbrugge, William, of Chadlyngton, husbandman 5
4700082 2265446 2265446 defendant Mery John   786936 786936 Mery, John, of Cherchehill, husb 6
4700083 2265446 2265446 defendant Whytyng John   641786 641786 Whytyng, John, of Shepton, husb 7

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