names

13 rows where case_id = 2475534

✎ 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
5401633 2475534 2475534 plaintiff Hert William gent 585869 585869 Hert, William, of London, gent 0
5401634 2475534 2475534 defendant Berdefeld John Colchestre hith, fuller   Berdefeld, John, Colchestre hith, fuller 0
5401635 2475534 2475534 defendant Bouke John husbandman 883563 883563 Bouke, John, of Byrchdanger, husbandman 1
5401636 2475534 2475534 defendant Herde John husbandman 591820 591820 Herde, John, of Harlowe, husbandman 2
5401637 2475534 2475534 defendant Whyte John clothier 879080 879080 Whyte, John, of Great Coksale, clothier 3
5401638 2475534 2475534 defendant Elyot Robert yeoman 879080 879080 Elyot, Robert, of Great Coksale, yeoman 4
5401639 2475534 2475534 defendant Bonde Richard carrier 879081 879081 Bonde, Richard, of Great Coksale or Coggeshall, carrier 5
5401640 2475534 2475534 defendant Smyth William husbandman 631127 631127 Smyth, William, of Frenton, husbandman 6
5401641 2475534 2475534 defendant Inewe Thomas chapman 823920 823920 Inewe, Thomas, of Brankere, chapman 7
5401642 2475534 2475534 defendant Symond Richard pulter 611962 611962 Symond, Richard, of Rydon, pulter 8
5401643 2475534 2475534 defendant Herny John butcher 593169 593169 Herny, John, of Haveryng at Boure, butcher 9
5401644 2475534 2475534 defendant Perte William gent 591721 591721 Perte, William, of Alvetheley, gent 10
5401645 2475534 2475534 defendant Ketylton William butcher 587871 587871 Ketylton, William, of Waltham Holy Cross, butcher 11

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