names

24 rows where case_id = 2395395

✎ 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
5130447 2395395 2395395 plaintiff Eure Ralph esq   Eure, Ralph, esq 0
5130448 2395395 2395395 defendant Dalton Thomas esq 830005 830005 Dalton, Thomas, of Kyrkeby Mysperton, esq 0
5130449 2395395 2395395 defendant Dalton John tiler 850282 850282 Dalton, John, of Kirkeby Mysperton, tiler 1
5130450 2395395 2395395 defendant Clerk Thomas   850282 850282 Clerk, Thomas, of Kirkeby Mysperton, parish clerk 2
5130451 2395395 2395395 defendant Clerk John   850282 850282 Clerk, John, of Kirkeby Mysperton 3
5130452 2395395 2395395 defendant Bark William yeoman 591382 591382 Bark, William, of New Malton, yeoman 4
5130453 2395395 2395395 defendant Parot John smith 591382 591382 Parot, John, of New Malton, smith 5
5130454 2395395 2395395 defendant Hunt Philip panyer man 591382 591382 Hunt, Philip, of New Malton, panyer man 6
5130455 2395395 2395395 defendant Mason Edmund tailor 593427 593427 Mason, Edmund, of Old Malton, tailor 7
5130456 2395395 2395395 defendant Warde John yeoman   Warde, John, yeoman 8
5130457 2395395 2395395 defendant Hall John shoe maker   Hall, John, shoe maker 9
5130458 2395395 2395395 defendant West William     West, William 10
5130459 2395395 2395395 defendant Colt John sawyer   Colt, John, sawyer 11
5130460 2395395 2395395 defendant Dodmor Henry laborer   Dodmor, Henry, laborer 12
5130461 2395395 2395395 defendant Semer Thomas tailor   Semer, Thomas, tailor 13
5130462 2395395 2395395 defendant Wode Henry milner   Wode, Henry, milner 14
5130463 2395395 2395395 defendant Wode John milner   Wode, John, milner 15
5130464 2395395 2395395 defendant Fyssher Richard panyer man   Fyssher, Richard, panyer man 16
5130465 2395395 2395395 defendant Tayllour John tailor   Tayllour, John, tailor 17
5130466 2395395 2395395 defendant Taillour William     Taillour, William 18
5130467 2395395 2395395 defendant Danson Lawrence laborer   Danson, Lawrence, laborer 19
5130468 2395395 2395395 defendant Day Thomas     Day, Thomas 20
5130469 2395395 2395395 defendant Kirkeby John yeoman 850284 850284 Kirkeby, John, of Thornton in Pickering, yeoman 21
5130470 2395395 2395395 defendant Boteler Alexander weaver 587259 587259 Boteler, Alexander, of Thornton, weaver 22

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