names

11 rows where case_id = 2248880

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4659670 2248880 2248880 plaintiff de Horneby Margaret     de Horneby, Margaret 0
4659671 2248880 2248880 defendant Watson John yeoman 774652 774652 Watson, John, of Newebyggyng, yeoman 0
4659672 2248880 2248880 defendant Richardson John yeoman 774652 774652 Richardson, John, of Newebyggyng, yeoman 1
4659673 2248880 2248880 defendant Yonson William yeoman 774652 774652 Yonson, William, of Newebyggyng, yeoman 2
4659674 2248880 2248880 defendant de Farlaine or de Farlame Thomas yeoman 774652 774652 de Farlaine or de Farlame, Thomas, of Newebyggyng, yeoman 3
4659675 2248880 2248880 defendant Studhird Hugh yeoman 640545 640545 Studhird, Hugh, of Cumrewe, yeoman 4
4659676 2248880 2248880 defendant Studhird Adam yeoman 640545 640545 Studhird, Adam, of Cumrewe, yeoman 5
4659677 2248880 2248880 defendant Mill William yeoman 640545 640545 Mill, William, of Cumrewe, yeoman 6
4659678 2248880 2248880 defendant Raynoldson Hugh yeoman 640545 640545 Raynoldson, Hugh, of Cumrewe, yeoman 7
4659679 2248880 2248880 defendant Studhird John yeoman 640545 640545 Studhird, John, of Cumrewe, yeoman 8
4659680 2248880 2248880 defendant Lambe John yeoman 640545 640545 Lambe, John, of Cumrewe, yeoman 9

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