names

14 rows where case_id = 2306373

✎ 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
4833102 2306373 2306373 plaintiff Chedder Richard     Chedder, Richard 0
4833103 2306373 2306373 defendant (not given) Peter prior of Worspryng   Worspryng, Peter, prior of 0
4833104 2306373 2306373 defendant Thomas_ John gent 592997 592997 Thomas_, John, of Wedmore, gent 1
4833105 2306373 2306373 defendant Yevan John tanner 747269 747269 Yevan, John, of Axebridge, tanner 2
4833106 2306373 2306373 defendant Tredoke John gent 597364 597364 Tredoke, John, of Cosyngton, gent 3
4833107 2306373 2306373 defendant Selewode Thomas baker 756657 756657 Selewode, Thomas, of Banewell, baker 4
4833108 2306373 2306373 defendant Kyngton John shoemaker 764902 764902 Kyngton, John, of Axebrigge, shoemaker 5
4833109 2306373 2306373 defendant Purbreg John laborer 770562 770562 Purbreg, John, of Bandwell, laborer 6
4833110 2306373 2306373 defendant Saunford Maud widow 586580 586580 Saunford, Maud, of Mylverton, widow 7
4833111 2306373 2306373 defendant Saunford William gent 722899 722899 Saunford, William, of Milberton, gent 8
4833112 2306373 2306373 defendant Gurdeler Thomas clerk 606190 606190 Gurdeler, Thomas, of Bath, clerk 9
4833113 2306373 2306373 defendant Darche John husbandman 809680 809680 Darche, John, of _alkesburgh Everard, husbandman 10
4833114 2306373 2306373 defendant Seyly Maud widow 809681 809681 Seyly, Maud, of Wyneford, widow 11
4833115 2306373 2306373 defendant Seyby John yeoman 809681 809681 Seyby, John, of Wyneford, 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);