names

12 rows where case_id = 2501449

✎ 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
5488500 2501449 2501449 plaintiff Weston Thomas abbot of Pipwell Abbey   Weston, Thomas, abbot of Pipwell Abbey 0
5488501 2501449 2501449 defendant Hill John yeoman 588071 588071 Hill, John, of Multon, yeoman 0
5488502 2501449 2501449 defendant Baryngton Humphrey yeoman 588071 588071 Baryngton, Humphrey, of Multon, yeoman 1
5488503 2501449 2501449 defendant Baston Robert yeoman 588071 588071 Baston, Robert, of Multon, yeoman 2
5488504 2501449 2501449 defendant Shakshafte John yeoman 588071 588071 Shakshafte, John, of Multon, yeoman 3
5488505 2501449 2501449 defendant Filpot John yeoman 770325 770325 Filpot, John, of Qwaplode, yeoman 4
5488506 2501449 2501449 defendant Dymmok Hugh yeoman 770325 770325 Dymmok, Hugh, of Qwaplode, yeoman 5
5488507 2501449 2501449 defendant Stele John yeoman 588071 588071 Stele, John, of Multon, yeoman 6
5488508 2501449 2501449 defendant Clerke Robert yeoman 588071 588071 Clerke, Robert, of Multon, yeoman 7
5488509 2501449 2501449 defendant Martyn John yeoman 586751 586751 Martyn, John, of Holbech, yeoman 8
5488510 2501449 2501449 defendant Howell Robert yeoman 588071 588071 Howell, Robert, of Multon, yeoman 9
5488511 2501449 2501449 defendant Otred John yeoman 588071 588071 Otred, John, of Multon, yeoman 10

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