names

16 rows where case_id = 2362830

✎ 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
5020312 2362830 2362830 plaintiff Duffeld Richard     Duffeld, Richard 0
5020313 2362830 2362830 defendant Edon Hugh merchant 593113 593113 Edon, Hugh, of Grymesby, merchant 0
5020314 2362830 2362830 defendant Smyth Robert clerk 836011 836011 Smyth, Robert, of Long Luthford, clerk 1
5020315 2362830 2362830 defendant Duffeld William gent 593113 593113 Duffeld, William, of Grymesby, gent 2
5020316 2362830 2362830 defendant Spenser John gent 620728 620728 Spenser, John, of Grymolby, gent 3
5020317 2362830 2362830 defendant Buste William husbandman 597124 597124 Buste, William, of Waynflete, husbandman 4
5020318 2362830 2362830 defendant Godhand Andrew gent 589855 589855 Godhand, Andrew, of Walesby, gent 5
5020319 2362830 2362830 defendant atte Halle Robert vicar of Ryby   atte Halle, Robert, vicar of Ryby 6
5020320 2362830 2362830 defendant Wrangyll Robert husbandman 588806 588806 Wrangyll, Robert, of Saxilby, husbandman 7
5020321 2362830 2362830 defendant Wrangill John husbandman 588806 588806 Wrangill, John, of Saxilby, husbandman 8
5020322 2362830 2362830 defendant Greme William laborer 596711 596711 Greme, William, of Gaynesburgh, laborer 9
5020323 2362830 2362830 defendant Ormesby Thomas mariner 593113 593113 Ormesby, Thomas, of Grymesby, mariner 10
5020324 2362830 2362830 defendant Lyolf William miller 829764 829764 Lyolf, William, of Chery Burton, Yorks, miller 11
5020325 2362830 2362830 defendant Gowesyll John husbandman 631736 631736 Gowesyll, John, of Haburgh, husbandman 12
5020326 2362830 2362830 defendant Nutsale Thomas miller 593113 593113 Nutsale, Thomas, of Grymesby, miller 13
5020327 2362830 2362830 defendant Scotte Richard husbandman 599201 599201 Scotte, Richard, of Croston, husbandman 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);