names

21 rows where case_id = 1904043

✎ 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
3629358 1904043 1904043 plaintiff Cressener John knight   Cressener, John, knight 0
3629359 1904043 1904043 plaintiff Tounesend Roger esq   Tounesend, Roger, esq 1
3629360 1904043 1904043 plaintiff Wotton William     Wotton, William 2
3629361 1904043 1904043 defendant Blakeney John gent 587283 587283 Blakeney, John, of Honyngham, gent 0
3629362 1904043 1904043 defendant Hille Robert yeoman 587283 587283 Hille, Robert, of Honyngham, yeoman 1
3629363 1904043 1904043 defendant Haille Richard yeoman 587283 587283 Haille, Richard, of Honyngham, yeoman 2
3629364 1904043 1904043 defendant Illyngworth Robert yeoman 587283 587283 Illyngworth, Robert, of Honyngham, yeoman 3
3629365 1904043 1904043 defendant Amys William laborer 587283 587283 Amys, William, of Honyngham, laborer 4
3629366 1904043 1904043 defendant Camplyn Thomas laborer 587283 587283 Camplyn, Thomas, of Honyngham, laborer 5
3629367 1904043 1904043 defendant Calie William laborer 587283 587283 Calie, William, of Honyngham, laborer 6
3629368 1904043 1904043 defendant Neve John laborer 587283 587283 Neve, John, of Honyngham, laborer 7
3629369 1904043 1904043 defendant Shenkwyn Henry yeoman 586386 586386 Shenkwyn, Henry, of Weston, yeoman 8
3629370 1904043 1904043 defendant Prekyll Thomas yeoman 586386 586386 Prekyll, Thomas, of Weston, yeoman 9
3629371 1904043 1904043 defendant Hesill John laborer 586386 586386 Hesill, John, of Weston, laborer 10
3629372 1904043 1904043 defendant Freer Robert laborer 586386 586386 Freer, Robert, of Weston, laborer 11
3629373 1904043 1904043 defendant Clemens John laborer 586386 586386 Clemens, John, of Weston, laborer 12
3629374 1904043 1904043 defendant Catfeld Robert laborer 597661 597661 Catfeld, Robert, of Swanyngton, laborer 13
3629375 1904043 1904043 defendant Marchaunt Robert yeoman 597662 597662 Marchaunt, Robert, of Bawbreth, yeoman 14
3629376 1904043 1904043 defendant Selers Richard laborer 586397 586397 Selers, Richard, of Morton, laborer 15
3629377 1904043 1904043 defendant Ayleff John laborer 597243 597243 Ayleff, John, of Matsale, laborer 16
3629378 1904043 1904043 defendant Pie Cornelius shoemaker 585936 585936 Pie, Cornelius, of Norwich, shoemaker 17

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