names

13 rows where case_id = 2328608

✎ 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
4906459 2328608 2328608 plaintiff Curteys William abbot of Bury St Edmunds Abbey   Curteys, William, abbot of Bury St Edmunds Abbey 0
4906460 2328608 2328608 defendant Fysshere Nicholas clerk 767749 767749 Fysshere, Nicholas, of Hemgrave, clerk 0
4906461 2328608 2328608 defendant Bacot Nicholas clerk 633201 633201 Bacot, Nicholas, of Ikelyngham, clerk 1
4906462 2328608 2328608 defendant Coket Walter clerk 594176 594176 Coket, Walter, of Magna Levermere, clerk 2
4906463 2328608 2328608 defendant Chaundeler John yeoman 586180 586180 Chaundeler, John, of Bury St Edmunds, yeoman 3
4906464 2328608 2328608 defendant Bocher Brice yeoman 586180 586180 Bocher, Brice, of Bury St Edmunds, yeoman 4
4906465 2328608 2328608 defendant Burgeys William yeoman 586180 586180 Burgeys, William, of Bury St Edmunds, yeoman 5
4906466 2328608 2328608 defendant Blankpayn John yeoman 586180 586180 Blankpayn, John, of Bury St Edmunds, yeoman 6
4906467 2328608 2328608 defendant Braksted Giles smith 586180 586180 Braksted, Giles, of Bury St Edmunds, smith 7
4906468 2328608 2328608 defendant Coket John yeoman 600529 600529 Coket, John, of Ampton, yeoman 8
4906469 2328608 2328608 defendant Coket Walter yeoman 586992 586992 Coket, Walter, of Ingham, yeoman 9
4906470 2328608 2328608 defendant Crosse John, senior butcher 586180 586180 Crosse, John, senior, of Bury St Edmunds, butcher 10
4906471 2328608 2328608 defendant Gatle Henry yeoman 596683 596683 Gatle, Henry, of Berton, yeoman 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);