names

13 rows where case_id = 2405634

✎ 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
5165420 2405634 2405634 plaintiff Bewes William fishmonger 585869 585869 Bewes, William, of London, fishmonger 0
5165421 2405634 2405634 defendant Fornfeld Walter yeoman 585936 585936 Fornfeld, Walter, of Norwich, yeoman 0
5165422 2405634 2405634 defendant Hard Richard yeoman 585936 585936 Hard, Richard, of Norwich, yeoman 1
5165423 2405634 2405634 defendant Anyell Richard mercer 585936 585936 Anyell, Richard, of Norwich, mercer 2
5165424 2405634 2405634 defendant Bokenham Thomas jun, of Norwich, tallow chandler   Bokenham, Thomas, jun, of Norwich, tallow chandler 3
5165425 2405634 2405634 defendant Davy John weaver 585936 585936 Davy, John, of Norwich, weaver 4
5165426 2405634 2405634 defendant Sexteyn John   585936 585936 Sexteyn, John, of Norwich, card maker 5
5165427 2405634 2405634 defendant Broun John shoemaker 585936 585936 Broun, John, of Norwich, shoemaker 6
5165428 2405634 2405634 defendant Sekan John   634256 634256 Sekan, John, of Norwich, bladesmith 7
5165429 2405634 2405634 defendant Sherman John brewer 585936 585936 Sherman, John, of Norwich, brewer 8
5165430 2405634 2405634 defendant Elger John   585936 585936 Elger, John, of Norwich, gold smith 9
5165431 2405634 2405634 defendant Chirch Simon   585936 585936 Chirch, Simon, of norwich, spice man 10
5165432 2405634 2405634 defendant Hoo Robert hosier 585936 585936 Hoo, Robert, of Norwich, hosier 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);