names

26 rows where case_id = 2518091

✎ 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
5543532 2518091 2518091 plaintiff Penny John abbot of Leicester Abbey   Penny, John, abbot of Leicester Abbey 0
5543533 2518091 2518091 defendant Horton Thomas yeoman 588658 588658 Horton, Thomas, of Boresworth, yeoman 0
5543534 2518091 2518091 defendant Wednalle Henry husbandman 588658 588658 Wednalle, Henry, of Boresworth, husbandman 1
5543535 2518091 2518091 defendant Wednalle Richard husbandman 588658 588658 Wednalle, Richard, of Boresworth, husbandman 2
5543536 2518091 2518091 defendant Wednalle John     Wednalle, John 3
5543537 2518091 2518091 defendant Parkyne John     Parkyne, John 4
5543538 2518091 2518091 defendant Smyth Richard     Smyth, Richard 5
5543539 2518091 2518091 defendant Pakman Thomas     Pakman, Thomas 6
5543540 2518091 2518091 defendant Clerke William     Clerke, William 7
5543541 2518091 2518091 defendant Meyall William     Meyall, William 8
5543542 2518091 2518091 defendant Chapman Thomas     Chapman, Thomas 9
5543543 2518091 2518091 defendant Hawford William     Hawford, William 10
5543544 2518091 2518091 defendant White Richard     White, Richard 11
5543545 2518091 2518091 defendant White John     White, John 12
5543546 2518091 2518091 defendant Burbage Richard     Burbage, Richard 13
5543547 2518091 2518091 defendant Gosey John     Gosey, John 14
5543548 2518091 2518091 defendant Bryan Thomas     Bryan, Thomas 15
5543549 2518091 2518091 defendant Vyallys William     Vyallys, William 16
5543550 2518091 2518091 defendant Palmer Richard     Palmer, Richard 17
5543551 2518091 2518091 defendant Warde William     Warde, William 18
5543552 2518091 2518091 defendant Warde John     Warde, John 19
5543553 2518091 2518091 defendant Chapman John, senior     Chapman, John, senior 20
5543554 2518091 2518091 defendant Chapman John, junior     Chapman, John, junior 21
5543555 2518091 2518091 defendant Dawefeld Thomas     Dawefeld, Thomas 22
5543556 2518091 2518091 defendant Smyth Roger     Smyth, Roger 23
5543557 2518091 2518091 defendant Bromley Thomas     Bromley, Thomas 24

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