names

14 rows where case_id = 1999708

✎ 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
3928012 1999708 1999708 plaintiff Bastard Francis     Bastard, Francis 0
3928013 1999708 1999708 defendant Drewery Geoffrey yeoman 653301 653301 Drewery, Geoffrey, of Dersingham, yeoman 0
3928014 1999708 1999708 defendant Chamberleyn Edward esq 585869 585869 Chamberleyn, Edward, of London, esq 1
3928015 1999708 1999708 defendant Jerves Robert merchant 603202 603202 Jerves, Robert, of King's Lynn, merchant 2
3928016 1999708 1999708 defendant Walden Silvester merchant 603202 603202 Walden, Silvester, of King's Lynn, merchant 3
3928017 1999708 1999708 defendant Wodam William butcher 603202 603202 Wodam, William, of King's Lynn, butcher 4
3928018 1999708 1999708 defendant Style Henry carpenter 610445 610445 Style, Henry, of Asshehyll, carpenter 5
3928019 1999708 1999708 defendant Cougham Robert yeoman 653302 653302 Cougham, Robert, of Cougeham, yeoman 6
3928020 1999708 1999708 defendant Bontyng Robert yeoman 644667 644667 Bontyng, Robert, of Snettysham, yeoman 7
3928021 1999708 1999708 defendant Hovell Robert yeoman 598426 598426 Hovell, Robert, of Wendlyng, yeoman 8
3928022 1999708 1999708 defendant Neckton William gent 585936 585936 Neckton, William, of Norwich, gent 9
3928023 1999708 1999708 defendant Barrett John yeoman 631033 631033 Barrett, John, of East Dereham, yeoman 10
3928024 1999708 1999708 defendant Palmer John husbandman 587709 587709 Palmer, John, of Gayton, husbandman 11
3928025 1999708 1999708 defendant Hovest John yeoman 602141 602141 Hovest, John, of Banyngham, yeoman 12

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