names

14 rows where case_id = 2028564

✎ 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
4010586 2028564 2028564 plaintiff Parry John gent, attorney of the bench   Parry, John, gent, attorney of the bench 0
4010587 2028564 2028564 defendant ap Gwatkyn Rice gent 640753 640753 ap Gwatkyn, Rice, of Ewyas Harold, gent 0
4010588 2028564 2028564 defendant Blunt John gent 629099 629099 Blunt, John, of Byrche Morton, Worcs, gent 1
4010589 2028564 2028564 defendant Edmond David yeoman 673619 673619 Edmond, David, of Gryssemond, Monmouth, yeoman 2
4010590 2028564 2028564 defendant Scudamore John ap Richard yeoman 655905 655905 Scudamore, John ap Richard, of Clodock, yeoman 3
4010591 2028564 2028564 defendant Jenk Henry gent 604145 604145 Jenk, Henry, of Pembridge, gent 4
4010592 2028564 2028564 defendant Watkyn Rawling yeoman 673620 673620 Watkyn, Rawling, of Llandylopertholey , Monmouth, yeoman 5
4010593 2028564 2028564 defendant Davyes John yeoman 673621 673621 Davyes, John, of Bryerley, yeoman 6
4010594 2028564 2028564 defendant Perkes Richard yeoman 632111 632111 Perkes, Richard, of Droyton, yeoman 7
4010595 2028564 2028564 defendant Jones Jevan gent 642966 642966 Jones, Jevan, of Oswestre, Salop, gent 8
4010596 2028564 2028564 defendant Gryffyth William tailor 602061 602061 Gryffyth, William, of Leyghton, tailor 9
4010597 2028564 2028564 defendant Hugh Howell ap Richard yeoman 645070 645070 Hugh, Howell ap Richard, of Craswell, yeoman 10
4010598 2028564 2028564 defendant ap Howell Thomas yeoman 645070 645070 ap Howell, Thomas, of Craswell, yeoman 11
4010599 2028564 2028564 defendant ap Rychard John Thomas yeoman 655905 655905 ap Rychard, John Thomas, of Clodock, yeoman 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);