names

17 rows where case_id = 2324320

✎ 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
4892255 2324320 2324320 plaintiff Vicars Thomas     Vicars, Thomas 0
4892256 2324320 2324320 defendant Redele John gent 818204 818204 Redele, John, of Wallitton, gent 0
4892257 2324320 2324320 defendant Dalston Henry gent 779936 779936 Dalston, Henry, of Melkenthorp, Westmor, gent 1
4892258 2324320 2324320 defendant Drury William yeoman 817686 817686 Drury, William, of Yanwyth, Westmor, yeoman 2
4892259 2324320 2324320 defendant Homeledod William yeoman 816482 816482 Homeledod, William, of Glassenby, yeoman 3
4892260 2324320 2324320 defendant Wylkynson John yeoman 818205 818205 Wylkynson, John, of Gamelsby, yeoman 4
4892261 2324320 2324320 defendant Smyth William yeoman 816482 816482 Smyth, William, of Glassenby, yeoman 5
4892262 2324320 2324320 defendant Blakwod Cuthbert yeoman 796604 796604 Blakwod, Cuthbert, of Melmorby, yeoman 6
4892263 2324320 2324320 defendant Lee William, senior yeoman 818206 818206 Lee, William, senior, of Aldeston More, yeoman 7
4892264 2324320 2324320 defendant Milner John yeoman 818207 818207 Milner, John, of Litel Salkeld, yeoman 8
4892265 2324320 2324320 defendant Bokyll John yeoman 818208 818208 Bokyll, John, of Skyswyth, yeoman 9
4892266 2324320 2324320 defendant Soureby John yeoman 809906 809906 Soureby, John, of Blenkarn, yeoman 10
4892267 2324320 2324320 defendant Hogeson William yeoman 796604 796604 Hogeson, William, of Melmorby, yeoman 11
4892268 2324320 2324320 defendant Colyn John yeoman 818205 818205 Colyn, John, of Gamelsby, yeoman 12
4892269 2324320 2324320 defendant Wilkynson Thomas yeoman 818205 818205 Wilkynson, Thomas, of Gamelsby, yeoman 13
4892270 2324320 2324320 defendant Russell John oc Blencarn, yeoman   Russell, John, oc Blencarn, yeoman 14
4892271 2324320 2324320 defendant Forest John yeoman 809906 809906 Forest, John, of Blenkarn, yeoman 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);