names

15 rows where case_id = 2405822

✎ 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
5166081 2405822 2405822 plaintiff Brounflete Henry knight   Brounflete, Henry, knight 0
5166082 2405822 2405822 defendant Haunserd Richard esq 702669 702669 Haunserd, Richard, of Sheryf Hoton, esq 0
5166083 2405822 2405822 defendant Acclom John esq 855310 855310 Acclom, John, of Cathwhatte, by Sutton on Derwent, esq 1
5166084 2405822 2405822 defendant Acclom Ralph esq 675092 675092 Acclom, Ralph, of West Harlesay, esq 2
5166085 2405822 2405822 defendant Laweton William gent 655323 655323 Laweton, William, of Howeden, gent 3
5166086 2405822 2405822 defendant Constable Robert esq 637924 637924 Constable, Robert, of Barnby Bossall, esq 4
5166087 2405822 2405822 defendant Laton John esq 852845 852845 Laton, John, of Sproxeton, esq 5
5166088 2405822 2405822 defendant Morley Robert yeoman 852846 852846 Morley, Robert, of Rykcall, yeoman 6
5166089 2405822 2405822 defendant Lee Hugh esq 588374 588374 Lee, Hugh, of Howedon, esq 7
5166090 2405822 2405822 defendant Thorp Thomas yeoman 655323 655323 Thorp, Thomas, of Howeden, yeoman 8
5166091 2405822 2405822 defendant Ibotson Thomas yeoman 852847 852847 Ibotson, Thomas, of Aremyn, yeoman 9
5166092 2405822 2405822 defendant Smyth John yeoman 852848 852848 Smyth, John, of Goule, in Snayth, yeoman 10
5166093 2405822 2405822 defendant Hoby John yeoman 702669 702669 Hoby, John, of Sheryf Hoton, yeoman 11
5166094 2405822 2405822 defendant Syngelton Richard yeoman 855311 855311 Syngelton, Richard, of Babthorp, Hemmyng Burgh, yeoman 12
5166095 2405822 2405822 defendant Westerby Richard gent 587101 587101 together with Westerby, Richard, of Snayth, gent 13

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