names

17 rows where case_id = 2023019

✎ 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
3995164 2023019 2023019 plaintiff Corser William Watkin (legal representative) 654721 654721 Corser, William Watkin, of Abergevenny, executors of 0
3995165 2023019 2023019 plaintiff Tanner John William     (Tanner, John William 1
3995166 2023019 2023019 plaintiff ap Rosser James     ap Rosser, James 2
3995167 2023019 2023019 plaintiff Lewys Roger     Lewys, Roger 3
3995168 2023019 2023019 defendant ap Jevan Roger David yeoman 669972 669972 ap Jevan, Roger David, of Llanveyr Kylgedyn, yeoman 0
3995169 2023019 2023019 defendant ao Ivan William David yeoman 669972 669972 ao Ivan, William David, of llanveyr Kylgedyn, yeoman 1
3995170 2023019 2023019 defendant Yoroth Philip Gillim   669973 669973 Yoroth, Philip Gillim, of Llanveyr, yemoan 2
3995171 2023019 2023019 defendant Corser David Howell shoemaker 650537 650537 Corser, David Howell, of Bergevenny, shoemaker 3
3995172 2023019 2023019 defendant ap Jenkyn John gent 650537 650537 ap Jenkyn, John, of Bergevenny, gent 4
3995173 2023019 2023019 defendant Thomas John laborer 669974 669974 Thomas, John, of Moncktowne, Bergevenny, laborer 5
3995174 2023019 2023019 defendant Ivan John shoemaker 650537 650537 Ivan, John, of Bergevenny, shoemaker 6
3995175 2023019 2023019 defendant ap Jenkyn Lewis ap John gent 650537 650537 ap Jenkyn, Lewis ap John, of Bergevenny, gent 7
3995176 2023019 2023019 defendant Lewys Jenkin yeoman 650537 650537 Lewys, Jenkin, of Bergevenny, yeoman 8
3995177 2023019 2023019 defendant Fletcher Griffin fletcher 650537 650537 Fletcher, Griffin, of Bergevenny, fletcher 9
3995178 2023019 2023019 defendant Powell Thomas glover 650537 650537 Powell, Thomas, of Bergevenny, glover 10
3995179 2023019 2023019 defendant Thomas David yeoman 669975 669975 Thomas, David, of Llanvertheryn, yeoman 11
3995180 2023019 2023019 defendant ap Ivan Philip husbandman 668229 668229 ap Ivan, Philip, of Llanellen, husbandman 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);