names

14 rows where case_id = 2190542

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4467582 2190542 2190542 plaintiff Babbecary John     Babbecary, John 0
4467583 2190542 2190542 defendant Dalton William   632055 632055 Dalton, William, of Shirborn 0
4467584 2190542 2190542 defendant Dalton Thomas formerly servant of William Dalton   Dalton, Thomas, formerly servant of William Dalton 1
4467585 2190542 2190542 defendant Lymnour Thomas clerk   Lymnour, Thomas, clerk 2
4467586 2190542 2190542 defendant Glydeford John     Glydeford, John 3
4467587 2190542 2190542 defendant Pauter Henry     Pauter, Henry 4
4467588 2190542 2190542 defendant Scryveyn John     Scryveyn, John 5
4467589 2190542 2190542 defendant Kendale Thomas     Kendale, Thomas 6
4467590 2190542 2190542 defendant Peverell John weaver   Peverell, John, weaver 7
4467591 2190542 2190542 defendant Porter John glasier   Porter, John, glasier 8
4467592 2190542 2190542 defendant Thurlewynde John     Thurlewynde, John 9
4467593 2190542 2190542 defendant Bouklond John     Bouklond, John 10
4467594 2190542 2190542 defendant Smyth Hugh     Smyth, Hugh 11
4467595 2190542 2190542 defendant Parchementmaker John   632055 632055 Parchementmaker, John, of Shirborn 12

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