names

15 rows where case_id = 2206007

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4517985 2206007 2206007 plaintiff (not given)   prior of Daventry   Daventry, prior of 0
4517986 2206007 2206007 defendant Starton Simon     Starton, Simon 0
4517987 2206007 2206007 defendant Haddon Thomas butcher   Haddon, Thomas, butcher 1
4517988 2206007 2206007 defendant Kylcheth Richard     Kylcheth, Richard 2
4517989 2206007 2206007 defendant Scoter John butcher   Scoter, John, butcher 3
4517990 2206007 2206007 defendant Newebold John butcher   Newebold, John, butcher 4
4517991 2206007 2206007 defendant Pountfrett William servant of William Pountfrett, of Daventry   Pountfrett, William, servant of William Pountfrett, of Daventry 5
4517992 2206007 2206007 defendant Curteys John   604469 604469 Curteys, John, of Daventry 6
4517993 2206007 2206007 defendant Curteys Henry   604469 604469 Curteys, Henry, of Daventry 7
4517994 2206007 2206007 defendant Mistayll John     Mistayll, John 8
4517995 2206007 2206007 defendant Wyresdale Richard     Wyresdale, Richard 9
4517996 2206007 2206007 defendant Webbe Robert   604469 604469 Webbe, Robert, of Daventry 10
4517997 2206007 2206007 defendant Fyssher Thomas   604469 604469 Fyssher, Thomas, of Daventry 11
4517998 2206007 2206007 defendant Wodeward Henry   604469 604469 Wodeward, Henry, of Daventry 12
4517999 2206007 2206007 defendant Boteler Henry   604469 604469 Boteler, Henry, of Daventry 13

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