names

13 rows where case_id = 2284726

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4763975 2284726 2284726 plaintiff Hamond John     Hamond, John 0
4763976 2284726 2284726 defendant Potter Robert clerk 798810 798810 Potter, Robert, of Bergh by Norwich, clerk 0
4763977 2284726 2284726 defendant Godeale John yeoman 586938 586938 Godeale, John, of Thornham, yeoman 1
4763978 2284726 2284726 defendant Stevenesson John butcher 755389 755389 Stevenesson, John, of Bishop's Lenn, butcher 2
4763979 2284726 2284726 defendant Taylour Geoffrey yeoman 640089 640089 Taylour, Geoffrey, of Tilney, yeoman 3
4763980 2284726 2284726 defendant Knyght Stephen yeoman 755389 755389 Knyght, Stephen, of Bishop's Lenn, yeoman 4
4763981 2284726 2284726 defendant Austyn Roger yeoman 772207 772207 Austyn, Roger, of Cleye next the sea, yeoman 5
4763982 2284726 2284726 defendant Pakenham Andrew (legal representative)   Pakenham, Andrew, administrator of 6
4763983 2284726 2284726 defendant Banham William   798811 798811 Banham, William, of Wybeye, formerly of Howeton 7
4763984 2284726 2284726 defendant Gardener Robert (legal representative) 586231 586231 Gardener, Robert, of Wygenhale, executors of 8
4763985 2284726 2284726 defendant Gardener Agnes widow, formerly wife of Robert   (Gardener, Agnes, widow, formerly wife of Robert 9
4763986 2284726 2284726 defendant Hardewyk Thomas yeoman 586231 586231 Hardewyk, Thomas, of Wygenhale, yeoman 10
4763987 2284726 2284726 defendant Stegge John   586231 586231 Stegge, John, of Wygenhale 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);