names

14 rows where case_id = 2525200

✎ 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
5567962 2525200 2525200 plaintiff Ernley John     Ernley, John 0
5567963 2525200 2525200 defendant Heydon William gent 900964 900964 Heydon, William, of Haydon, Lancs, gent 0
5567964 2525200 2525200 defendant Huerst James yeoman 595161 595161 Huerst, James, of Bristowe, Surrey, yeoman 1
5567965 2525200 2525200 defendant Bristowe Nicholas yeoman 602554 602554 Bristowe, Nicholas, of Bristowe, yeoman 2
5567966 2525200 2525200 defendant Gylmyn Henry yeoman 602554 602554 Gylmyn, Henry, of Bristowe, yeoman 3
5567967 2525200 2525200 defendant White Michael merchant 586067 586067 White, Michael, of York, merchant 4
5567968 2525200 2525200 defendant Kyrke George merchant 586067 586067 Kyrke, George, of York, merchant 5
5567969 2525200 2525200 defendant White William merchant 586067 586067 White, William, of York, merchant 6
5567970 2525200 2525200 defendant Thwayte William gent 606678 606678 Thwayte, William, of Marston, Yorks, gent 7
5567971 2525200 2525200 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 8
5567972 2525200 2525200 defendant Kighley Henry   900965 900965 Kighley, Henry, of Iskip, Lancs, knight 9
5567973 2525200 2525200 defendant Sherbourne Richard   616112 616112 Sherbourne, Richard, of Aghton, Lancs, knight 10
5567974 2525200 2525200 defendant Bande Thomas   900967 900967 Bande, Thomas, of Haddon, Herts, knight 11
5567975 2525200 2525200 defendant Fulbourne Thomas gent 586487 586487 Fulbourne, Thomas, of Suthwerk, gent 12

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