names

16 rows where case_id = 2436359

✎ 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
5270090 2436359 2436359 plaintiff Crome Nicholas     Crome, Nicholas, on his own account 0
5270091 2436359 2436359 defendant Hendy John yeoman 782951 782951 Hendy, John, of Monton or Mouton, yeoman 0
5270092 2436359 2436359 defendant Pyke John yeoman 601937 601937 Pyke, John, of Ersham, yeoman 1
5270093 2436359 2436359 defendant Reyner William yeoman 795875 795875 Reyner, William, of Honygham, yeoman 2
5270094 2436359 2436359 defendant Rechemond Robert yeoman 586714 586714 Rechemond, Robert, of Hempnale, yeoman 3
5270095 2436359 2436359 defendant Newelond William yeoman   Newelond, William, yeoman 4
5270096 2436359 2436359 defendant Gryme Simon yeoman   Gryme, Simon, yeoman 5
5270097 2436359 2436359 defendant Tayllour Thomas yeoman 586102 586102 Tayllour, Thomas, of Hengham, yeoman 6
5270098 2436359 2436359 defendant Wylhouse John   587414 587414 Wylhouse, John, of Thetford, inn keeper 7
5270099 2436359 2436359 defendant Holle William   585936 585936 Holle, William, of Norwich, bow maker 8
5270100 2436359 2436359 defendant Grene William yeoman 592202 592202 Grene, William, of Hapton, yeoman 9
5270101 2436359 2436359 defendant Wykes John yeoman 866575 866575 Wykes, John, of Great Elyngh--, yeoman 10
5270102 2436359 2436359 defendant Woley John yeoman 866576 866576 Woley, John, of Geystwheyth, yeoman 11
5270103 2436359 2436359 defendant Moor Thomas yeoman 586102 586102 Moor, Thomas, of Hengham, yeoman 12
5270104 2436359 2436359 defendant Heron William yeoman 585933 585933 Heron, William, of Great Yarmouth, yeoman 13
5270105 2436359 2436359 defendant Coteler Robert clerk 590858 590858 Coteler, Robert, of Mauteby, clerk 14

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