names

23 rows where case_id = 2235208

✎ 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
4613354 2235208 2235208 plaintiff Dalyngreg Alice formerly wife of John Dalyngreg, knight   Dalyngreg, Alice, formerly wife of John Dalyngreg, knight 0
4613355 2235208 2235208 defendant Parsfay John     Parsfay, John 0
4613356 2235208 2235208 defendant Wellys William     together with Wellys, William 1
4613357 2235208 2235208 defendant Pocok John     Pocok, John 2
4613358 2235208 2235208 defendant Chaury Thomas   588829 588829 Chaury, Thomas, of Ukfeld 3
4613359 2235208 2235208 defendant atte Stone John   588829 588829 atte Stone, John, of Ukfeld 4
4613360 2235208 2235208 defendant Cok Thomas     Cok, Thomas 5
4613361 2235208 2235208 defendant Carde John of Isefeld     Carde, John of Isefeld 6
4613362 2235208 2235208 defendant atte Stone Richard   758963 758963 atte Stone, Richard, of Isefeld 7
4613363 2235208 2235208 defendant Couper Richard   588829 588829 Couper, Richard, of Ukfeld 8
4613364 2235208 2235208 defendant Stretend William     Stretend, William 9
4613365 2235208 2235208 defendant Lucas Thomas   588829 588829 Lucas, Thomas, of Ukfeld 10
4613366 2235208 2235208 defendant Stapulee William   774545 774545 Stapulee, William, of Bokestede 11
4613367 2235208 2235208 defendant Chaury Richard     Chaury, Richard 12
4613368 2235208 2235208 defendant Knot William     Knot, William 13
4613369 2235208 2235208 defendant Couper John   588259 588259 Couper, John, of Flecchyng 14
4613370 2235208 2235208 defendant Heghland John     Heghland, John 15
4613371 2235208 2235208 defendant Heghland Robert     Heghland, Robert 16
4613372 2235208 2235208 defendant Threle William     Threle, William 17
4613373 2235208 2235208 defendant atte Smyth John     atte Smyth, John 18
4613374 2235208 2235208 defendant Hereward Richard   585989 585989 Hereward, Richard, of Framfeld 19
4613375 2235208 2235208 defendant Rounger John   774546 774546 Rounger, John, of Ukfield 20
4613376 2235208 2235208 defendant Page John   774545 774545 Page, John, of Bokestede, son of 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);