names

20 rows where case_id = 2208640

✎ 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
4526726 2208640 2208640 plaintiff (not given) William prior of Lanthony by Gloucester   Lanthony by Gloucester, William, prior of 0
4526727 2208640 2208640 defendant Wotton Richard     Wotton, Richard 0
4526728 2208640 2208640 defendant Sherston Thomas     Sherston, Thomas 1
4526729 2208640 2208640 defendant Tyderynton Walter     Tyderynton, Walter 2
4526730 2208640 2208640 defendant Mattesdoune Thomas     Mattesdoune, Thomas 3
4526731 2208640 2208640 defendant Smart John, sen     Smart, John, sen 4
4526732 2208640 2208640 defendant Smart William tiler   Smart, William, tiler 5
4526733 2208640 2208640 defendant Semes Henry tiler   Semes, Henry, tiler 6
4526734 2208640 2208640 defendant Clerk John   588402 588402 Clerk, John, of Brokworth 7
4526735 2208640 2208640 defendant Nasshe Walter     Nasshe, Walter 8
4526736 2208640 2208640 defendant Hunte Walter     Hunte, Walter 9
4526737 2208640 2208640 defendant Gernon William jun   Gernon, William, jun 10
4526738 2208640 2208640 defendant Smyth John   588402 588402 Smyth, John, of Brokworth 11
4526739 2208640 2208640 defendant Droys William     Droys, William 12
4526740 2208640 2208640 defendant Droys Walter     Droys, Walter 13
4526741 2208640 2208640 defendant Colpek Walter     Colpek, Walter 14
4526742 2208640 2208640 defendant Walker John   588402 588402 Walker, John, of Brokworth 15
4526743 2208640 2208640 defendant Smart John jun   Smart, John, jun 16
4526744 2208640 2208640 defendant Walssh John     Walssh, John 17
4526745 2208640 2208640 defendant Hatherley John     Hatherley, John 18

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