names

13 rows where case_id = 2522791

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5559675 2522791 2522791 plaintiff Sandys William knight   Sandys, William, knight 0
5559676 2522791 2522791 defendant Martyn Geoffrey yeoman 593694 593694 Martyn, Geoffrey, of Andever, yeoman 0
5559677 2522791 2522791 defendant Jenet Thomas tailor 593694 593694 Jenet, Thomas, of Andever, tailor 1
5559678 2522791 2522791 defendant Leverson William tailor 593694 593694 Leverson, William, of Andever, tailor 2
5559679 2522791 2522791 defendant Bott John yeoman 595004 595004 Bott, John, of Chute, yeoman 3
5559680 2522791 2522791 defendant Glover William yeoman 593694 593694 Glover, William, of Andever, yeoman 4
5559681 2522791 2522791 defendant Hobert John yeoman 593694 593694 Hobert, John, of Andever, yeoman 5
5559682 2522791 2522791 defendant Wynter James yeoman 593694 593694 Wynter, James, of Andever, yeoman 6
5559683 2522791 2522791 defendant Smyth John yeoman 593694 593694 Smyth, John, of Andever, yeoman 7
5559684 2522791 2522791 defendant Baker John yeoman 593694 593694 Baker, John, of Andever, yeoman 8
5559685 2522791 2522791 defendant Bayly John yeoman 593694 593694 Bayly, John, of Andever, yeoman 9
5559686 2522791 2522791 defendant Swynerton John yeoman 595004 595004 Swynerton, John, of Chute, yeoman 10
5559687 2522791 2522791 defendant Tayllour Nicholas yeoman 593694 593694 Tayllour, Nicholas, of Andever, yeoman 11

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