names

15 rows where case_id = 2395396

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5130471 2395396 2395396 plaintiff Eure Ralph esq   Eure, Ralph, esq 0
5130472 2395396 2395396 defendant Hastynges Edmund esq 849676 849676 Hastynges, Edmund, of Ronsceby in Pykeryng Lith, esq 0
5130473 2395396 2395396 defendant Hastinges Ralph gent 849677 849677 Hastinges, Ralph, of Rousteby, gent 1
5130474 2395396 2395396 defendant West Willia forester 756244 756244 West, Willia, of Pikering, forester 2
5130475 2395396 2395396 defendant Kemp John forester 849678 849678 Kemp, John, of Kynthorp in Pykeryng Lith, forester 3
5130476 2395396 2395396 defendant Body John laborer 587259 587259 Body, John, of Thornton, laborer 4
5130477 2395396 2395396 defendant Pays John   849677 849677 Pays, John, of Rousteby, servant 5
5130478 2395396 2395396 defendant Heppell Richard laborer   Heppell, Richard, laborer 6
5130479 2395396 2395396 defendant Archur William laborer 587259 587259 Archur, William, of Thornton, laborer 7
5130480 2395396 2395396 defendant Hoggesson George   849677 849677 Hoggesson, George, of Rousteby, groom 8
5130481 2395396 2395396 defendant Gybbs John yeoman 849677 849677 Gybbs, John, of Rousteby, yeoman 9
5130482 2395396 2395396 defendant Walker Henry walker 587259 587259 Walker, Henry, of Thornton, walker 10
5130483 2395396 2395396 defendant Broune George laborer 587259 587259 Broune, George, of Thornton, laborer 11
5130484 2395396 2395396 defendant Harleshay John milner 849681 849681 Harleshay, John, of Fermanby, milner 12
5130485 2395396 2395396 defendant Farmory William yeoman 849677 849677 Farmory, William, of Rousteby, yeoman 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);