names

18 rows where case_id = 2533119

✎ 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
5594017 2533119 2533119 plaintiff Bainbridge Christopher Archbishop of York   Bainbridge, Christopher, Archbishop of York 0
5594018 2533119 2533119 defendant Abbot William yeoman 589626 589626 Abbot, William, of Walkyngton, yeoman 0
5594019 2533119 2533119 defendant Bursey John, junior husbandman 589626 589626 Bursey, John, junior, of Walkyngton, husbandman 1
5594020 2533119 2533119 defendant Strik Ralph husbandman 589626 589626 Strik, Ralph, of Walkyngton, husbandman 2
5594021 2533119 2533119 defendant Bowrman John husbandman 589626 589626 Bowrman, John, of Walkyngton, husbandman 3
5594022 2533119 2533119 defendant Pardesay Richard tailor 903883 903883 Pardesay, Richard, of Ryrsby, tailor 4
5594023 2533119 2533119 defendant Hunte Robert yeoman 903883 903883 Hunte, Robert, of Ryrsby, yeoman 5
5594024 2533119 2533119 defendant Deykyn Richard husbandman 903883 903883 Deykyn, Richard, of Ryrsby, husbandman 6
5594025 2533119 2533119 defendant Bell John laborer 903883 903883 Bell, John, of Ryrsby, laborer 7
5594026 2533119 2533119 defendant Radclyff Thomas yeoman 609498 609498 Radclyff, Thomas, of Rowley, yeoman 8
5594027 2533119 2533119 defendant Webster John weaver 589274 589274 Webster, John, of Cotyngham, weaver 9
5594028 2533119 2533119 defendant Carres Stephen tanner 589274 589274 Carres, Stephen, of Cotyngham, tanner 10
5594029 2533119 2533119 defendant Sherwode Cuthbert laborer 903883 903883 Sherwode, Cuthbert, of Ryrsby, laborer 11
5594030 2533119 2533119 defendant Sernton Richard husbandman 763187 763187 Sernton, Richard, of Skydby, husbandman 12
5594031 2533119 2533119 defendant Mason William miller 903884 903884 Mason, William, of Risbe, miller 13
5594032 2533119 2533119 defendant Bolser Thomas laborer 635552 635552 Bolser, Thomas, of Bysshop Burton, laborer 14
5594033 2533119 2533119 defendant Hogeson Hugh yeoman 903884 903884 Hogeson, Hugh, of Risbe, yeoman 15
5594034 2533119 2533119 defendant Blomer John yeoman 635552 635552 Blomer, John, of Bysshop Burton, yeoman 16

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