names

13 rows where case_id = 2055884

✎ 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
4087660 2055884 2055884 plaintiff Burton Nicholas gent   Burton, Nicholas, gent 0
4087661 2055884 2055884 defendant Markynfeld William yeoman 690962 690962 Markynfeld, William, of Markyngton, yeoman 0
4087662 2055884 2055884 defendant Atkynson Thomas yeoman 690962 690962 Atkynson, Thomas, of Markyngton, yeoman 1
4087663 2055884 2055884 defendant Bowland Marmaduke yeoman 690962 690962 Bowland, Marmaduke, of Markyngton, yeoman 2
4087664 2055884 2055884 defendant Smythe James yeoman 690962 690962 Smythe, James, of Markyngton, yeoman 3
4087665 2055884 2055884 defendant Kettelsyn alias Atkynson Richard yeoman 690963 690963 Kettelsyn alias Atkynson, Richard, of Wallerthwayt, yeoman 4
4087666 2055884 2055884 defendant Atkynson John yeoman 690962 690962 Atkynson, John, of Markyngton, yeoman 5
4087667 2055884 2055884 defendant Hallydaye Simon yeoman 690962 690962 Hallydaye, Simon, of Markyngton, yeoman 6
4087668 2055884 2055884 defendant Yates Thomas yeoman 690962 690962 Yates, Thomas, of Markyngton, yeoman 7
4087669 2055884 2055884 defendant Kettelsyne Gilbert yeoman 690962 690962 Kettelsyne, Gilbert, of Markyngton, yeoman 8
4087670 2055884 2055884 defendant Hallyday William yeoman 690962 690962 Hallyday, William, of Markyngton, yeoman 9
4087671 2055884 2055884 defendant Wraye William yeoman 690962 690962 Wraye, William, of Markyngton, yeoman 10
4087672 2055884 2055884 defendant Hessell William yeoman 690962 690962 Hessell, William, of Markyngton, 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);