names

13 rows where case_id = 2394105

✎ 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
5126052 2394105 2394105 plaintiff Bevys William fishmonger 585869 585869 Bevys, William, of London, fishmonger 0
5126053 2394105 2394105 defendant Fornfeld Walter yeoman 585936 585936 Fornfeld, Walter, of Norwich, yeoman 0
5126054 2394105 2394105 defendant Hard Richard yeoman 585936 585936 Hard, Richard, of Norwich, yeoman 1
5126055 2394105 2394105 defendant --yell Richard mercer 585936 585936 --yell, Richard, of Norwich, mercer 2
5126056 2394105 2394105 defendant Bokenham Thomas, junior   585936 585936 Bokenham, Thomas, junior, of Norwich, tallow chandler 3
5126057 2394105 2394105 defendant Davy John weaver 585936 585936 Davy, John, of Norwich, weaver 4
5126058 2394105 2394105 defendant Sexteyn John   585936 585936 Sexteyn, John, of Norwich, card maker 5
5126059 2394105 2394105 defendant Broun John shoemaker 585936 585936 Broun, John, of Norwich, shoemaker 6
5126060 2394105 2394105 defendant Swan (illegible)   634256 634256 Swan, ---, of Norwich, bladesmith 7
5126061 2394105 2394105 defendant Sherman John brewer 585936 585936 Sherman, John, of Norwich, brewer 8
5126062 2394105 2394105 defendant Elger John goldsmith 585936 585936 Elger, John, of Norwich, goldsmith 9
5126063 2394105 2394105 defendant Churche Simon spicer 585936 585936 Churche, Simon, of Norwich, spicer 10
5126064 2394105 2394105 defendant Hoo Robert   585936 585936 Hoo, Robert, of Norwich 11

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