names

21 rows where case_id = 2205744

✎ 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
4517070 2205744 2205744 plaintiff Courtenay Peter knight   Courtenay, Peter, knight 0
4517071 2205744 2205744 plaintiff Berkele John knight   Berkele, John, knight 1
4517072 2205744 2205744 plaintiff Chitterne John clerk   Chitterne, John, clerk 2
4517073 2205744 2205744 plaintiff Stourton William     Stourton, William 3
4517074 2205744 2205744 plaintiff Gowayn John     Gowayn, John 4
4517075 2205744 2205744 plaintiff Bonham Thomas     Bonham, Thomas 5
4517076 2205744 2205744 plaintiff Brerdyng Thomas     Brerdyng, Thomas 6
4517077 2205744 2205744 defendant atte Cherche Stephen     atte Cherche, Stephen 0
4517078 2205744 2205744 defendant Seymour Richard     Seymour, Richard 1
4517079 2205744 2205744 defendant Hayne Robert     Hayne, Robert 2
4517080 2205744 2205744 defendant Dagwolf William     Dagwolf, William 3
4517081 2205744 2205744 defendant Kepe Richard jun   Kepe, Richard, jun 4
4517082 2205744 2205744 defendant Knyght William     Knyght, William 5
4517083 2205744 2205744 defendant Snell John   765431 765431 Snell, John, of Wyppyngham 6
4517084 2205744 2205744 defendant Neweman John     Neweman, John 7
4517085 2205744 2205744 defendant Skynnere John   589309 589309 Skynnere, John, of Neuport 8
4517086 2205744 2205744 defendant Webbe William   589309 589309 Webbe, William, of Neuport 9
4517087 2205744 2205744 defendant Kent John     Kent, John 10
4517088 2205744 2205744 defendant Grym William     Grym, William 11
4517089 2205744 2205744 defendant White William     White, William 12
4517090 2205744 2205744 defendant Wylyer William     Wylyer, William 13

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