names

23 rows where case_id = 2235210

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4613380 2235210 2235210 plaintiff Dalyngreg Alice formerly wife of John Dalyngreg, knight   Dalyngreg, Alice, formerly wife of John Dalyngreg, knight 0
4613381 2235210 2235210 defendant Wellys William     Wellys, William 0
4613382 2235210 2235210 defendant Pocok John     Pocok, John 1
4613383 2235210 2235210 defendant Chaury Thomas   588829 588829 Chaury, Thomas, of Ukfeld 2
4613384 2235210 2235210 defendant atte Stone John   588829 588829 atte Stone, John, of Ukfeld 3
4613385 2235210 2235210 defendant Cok Thomas     Cok, Thomas 4
4613386 2235210 2235210 defendant Carde John of Isefeld     Carde, John of Isefeld 5
4613387 2235210 2235210 defendant atte Stone Richard   758963 758963 atte Stone, Richard, of Isefeld 6
4613388 2235210 2235210 defendant Couper Richard   588829 588829 Couper, Richard, of Ukfeld 7
4613389 2235210 2235210 defendant Stretend William     Stretend, William 8
4613390 2235210 2235210 defendant Lucas Thomas   588829 588829 Lucas, Thomas, of Ukfeld 9
4613391 2235210 2235210 defendant Stapulee William   774545 774545 Stapulee, William, of Bokestede 10
4613392 2235210 2235210 defendant Chaury Richard     Chaury, Richard 11
4613393 2235210 2235210 defendant Knot William     Knot, William 12
4613394 2235210 2235210 defendant Couper John   588259 588259 Couper, John, of Flecchyng 13
4613395 2235210 2235210 defendant Heghland John     Heghland, John 14
4613396 2235210 2235210 defendant Heghland Robert     Heghland, Robert 15
4613397 2235210 2235210 defendant Threle William     Threle, William 16
4613398 2235210 2235210 defendant atte Smyth John     atte Smyth, John 17
4613399 2235210 2235210 defendant Hereward Richard   585989 585989 Hereward, Richard, of Framfeld 18
4613400 2235210 2235210 defendant Rounger John   588829 588829 Rounger, John, of Ukfeld 19
4613401 2235210 2235210 defendant Page John   774545 774545 Page, John, of Bokestede, son of John 20
4613402 2235210 2235210 defendant Parsfay John     together with Parsfay, John 21

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