names

13 rows where case_id = 2283656

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4760573 2283656 2283656 plaintiff Culwen Christopher knight   Culwen, Christopher, knight 0
4760574 2283656 2283656 defendant Blount Richard yeoman 760887 760887 Blount, Richard, of Gillesland, yeoman 0
4760575 2283656 2283656 defendant Bryden William yeoman 792882 792882 Bryden, William, of Gyllesland, yeoman 1
4760576 2283656 2283656 defendant Jonesson Thomas yeoman 760887 760887 Jonesson, Thomas, of Gillesland, yeoman 2
4760577 2283656 2283656 defendant Aleynesson William yeoman 642667 642667 Aleynesson, William, of Walle, yeoman 3
4760578 2283656 2283656 defendant Chartere Thomas yeoman 760887 760887 together with Chartere, Thomas, of Gillesland, yeoman 4
4760579 2283656 2283656 defendant Walton John yeoman 760887 760887 Walton, John, of Gillesland, yeoman 5
4760580 2283656 2283656 defendant Laundere John yeoman 597715 597715 Laundere, John, of Wygton, yeoman 6
4760581 2283656 2283656 defendant Hare John yeoman 597715 597715 Hare, John, of Wygton, yeoman 7
4760582 2283656 2283656 defendant Bampton Robert clerk 792497 792497 Bampton, Robert, of Ayketon, clerk 8
4760583 2283656 2283656 defendant Robbesson John yeoman 798206 798206 Robbesson, John, of Wode in Gillesland, yeoman 9
4760584 2283656 2283656 defendant Heveryngton William yeoman 760887 760887 Heveryngton, William, of Gillesland, yeoman 10
4760585 2283656 2283656 defendant Robbesson John yeoman 589127 589127 Robbesson, John, of Walton, yeoman 11

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