names

29 rows where case_id = 2350433

✎ 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
4978185 2350433 2350433 plaintiff Vampage John     Vampage, John 0
4978186 2350433 2350433 defendant Langelegh Walter gent 709207 709207 Langelegh, Walter, of Ilfardecombe, gent 0
4978187 2350433 2350433 defendant Cadlyng John butcher 709207 709207 Cadlyng, John, of Ilfardecombe, butcher 1
4978188 2350433 2350433 defendant Blake Thomas merchant 709207 709207 Blake, Thomas, of Ilfardecombe, merchant 2
4978189 2350433 2350433 defendant Wyke Ancel seaman 709207 709207 Wyke, Ancel, of Ilfardecombe, seaman 3
4978190 2350433 2350433 defendant Penryse Richard gent 709207 709207 Penryse, Richard, of Ilfardecombe, gent 4
4978191 2350433 2350433 defendant Dyer Thomas yeoman 709207 709207 Dyer, Thomas, of Ilfardecombe, yeoman 5
4978192 2350433 2350433 defendant Bealle Robert laborer 709207 709207 Bealle, Robert, of Ilfardecombe, laborer 6
4978193 2350433 2350433 defendant Bydde Walter seaman 709207 709207 Bydde, Walter, of Ilfardecombe, seaman 7
4978194 2350433 2350433 defendant Gubbe John, junior seaman 709207 709207 Gubbe, John, junior, of Ilfardecombe, seaman 8
4978195 2350433 2350433 defendant Dyryke John shipman 709207 709207 Dyryke, John, of Ilfardecombe, shipman 9
4978196 2350433 2350433 defendant Gedelyng John butcher 709207 709207 Gedelyng, John, of Ilfardecombe, butcher 10
4978197 2350433 2350433 defendant Fosse Richard husbandman 709207 709207 Fosse, Richard, of Ilfardecombe, husbandman 11
4978198 2350433 2350433 defendant Bounte Richard seaman 709207 709207 Bounte, Richard, of Ilfardecombe, seaman 12
4978199 2350433 2350433 defendant Hoper John seaman 709207 709207 Hoper, John, of Ilfardecombe, seaman 13
4978200 2350433 2350433 defendant Frensheman Adam   709207 709207 Frensheman, Adam, of Ilfardecombe, groom 14
4978201 2350433 2350433 defendant Auncell Thomas seaman 709207 709207 Auncell, Thomas, of Ilfardecombe, seaman 15
4978202 2350433 2350433 defendant Bawle John husbandman 709207 709207 Bawle, John, of Ilfardecombe, husbandman 16
4978203 2350433 2350433 defendant Bawle Thomas husbandman 709207 709207 Bawle, Thomas, of Ilfardecombe, husbandman 17
4978204 2350433 2350433 defendant Bayne John weaver 709207 709207 Bayne, John, of Ilfardecombe, weaver 18
4978205 2350433 2350433 defendant Rowe Thomas shipman 709207 709207 Rowe, Thomas, of Ilfardecombe, shipman 19
4978206 2350433 2350433 defendant Rokeleare John butcher 709207 709207 Rokeleare, John, of Ilfardecombe, butcher 20
4978207 2350433 2350433 defendant Pytman Henry weaver 709207 709207 Pytman, Henry, of Ilfardecombe, weaver 21
4978208 2350433 2350433 defendant Dyer John husbandman 709207 709207 Dyer, John, of Ilfardecombe, husbandman 22
4978209 2350433 2350433 defendant Colyford John, senior husbandman 709207 709207 Colyford, John, senior, of Ilfardecombe, husbandman 23
4978210 2350433 2350433 defendant Duke Thomas weaver 709207 709207 Duke, Thomas, of Ilfardecombe, weaver 24
4978211 2350433 2350433 defendant Robert Richard, junior laborer 709207 709207 Robert, Richard, junior, of Ilfardecombe, laborer 25
4978212 2350433 2350433 defendant Edward John hooper 709207 709207 Edward, John, of Ilfardecombe, hooper 26
4978213 2350433 2350433 defendant Wyther William laborer 709207 709207 Wyther, William, of Ilfardecombe, laborer 27

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