names

17 rows where case_id = 2504496

✎ 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
5498487 2504496 2504496 plaintiff Norton John knight   Norton, John, knight 0
5498488 2504496 2504496 defendant Daynell Thomas gent 589293 589293 Daynell, Thomas, of Bylton, gent 0
5498489 2504496 2504496 defendant Stokys Robert gent 793958 793958 Stokys, Robert, of Bekerton, gent 1
5498490 2504496 2504496 defendant Munkton William yeoman 793958 793958 Munkton, William, of Bekerton, yeoman 2
5498491 2504496 2504496 defendant Hall John weaver 595707 595707 Hall, John, of Salley juxta Rypon, weaver 3
5498492 2504496 2504496 defendant Lemyng William barker 595707 595707 Lemyng, William, of Salley juxta Rypon, barker 4
5498493 2504496 2504496 defendant Barhous William laborer 812153 812153 Barhous, William, of Salley, laborer 5
5498494 2504496 2504496 defendant Skypton John tailor 812153 812153 Skypton, John, of Salley, tailor 6
5498495 2504496 2504496 defendant Abbot John weaver 812153 812153 Abbot, John, of Salley, weaver 7
5498496 2504496 2504496 defendant Raskell George husbandman 812153 812153 Raskell, George, of Salley, husbandman 8
5498497 2504496 2504496 defendant Kyng William laborer 812153 812153 Kyng, William, of Salley, laborer 9
5498498 2504496 2504496 defendant Wilkynson William yeoman 812153 812153 Wilkynson, William, of Salley, yeoman 10
5498499 2504496 2504496 defendant Lax John husbandman 812153 812153 Lax, John, of Salley, husbandman 11
5498500 2504496 2504496 defendant Askwyth William yeoman 812153 812153 Askwyth, William, of Salley, yeoman 12
5498501 2504496 2504496 defendant Horsman John husbandman 812153 812153 Horsman, John, of Salley, husbandman 13
5498502 2504496 2504496 defendant Wardrop Edmund laborer 812153 812153 Wardrop, Edmund, of Salley, laborer 14
5498503 2504496 2504496 defendant Walker William laborer 812153 812153 Walker, William, of Salley, laborer 15

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