names

23 rows where case_id = 2186381

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4454360 2186381 2186381 plaintiff Lymynour Henry     Lymynour, Henry 0
4454361 2186381 2186381 defendant Greyne Thomas   758492 758492 Greyne, Thomas, of Hacforth 0
4454362 2186381 2186381 defendant Koket William   758493 758493 Koket, William, of Swynesthorp 1
4454363 2186381 2186381 defendant atte Kychyn Robert   587166 587166 atte Kychyn, Robert, of Salle 2
4454364 2186381 2186381 defendant Berker Thomas   587059 587059 Berker, Thomas, of Stalham 3
4454365 2186381 2186381 defendant Lyngsted William de   603944 603944 Lyngsted, William de, of Dilham 4
4454366 2186381 2186381 defendant Sutton William de     Sutton, William de 5
4454367 2186381 2186381 defendant sutton John de     sutton, John de 6
4454368 2186381 2186381 defendant Arkeale John     Arkeale, John 7
4454369 2186381 2186381 defendant Smyth John   590255 590255 Smyth, John, of East Ryston 8
4454370 2186381 2186381 defendant Person Thomas   590255 590255 Person, Thomas, of East Ryston 9
4454371 2186381 2186381 defendant Jannes Richard   586819 586819 Jannes, Richard, of Worsted 10
4454372 2186381 2186381 defendant Pampyng John   586819 586819 Pampyng, John, of Worsted 11
4454373 2186381 2186381 defendant Bentelam William   758494 758494 Bentelam, William, of Crosqueyt 12
4454374 2186381 2186381 defendant Meryman John   588930 588930 Meryman, John, of Honyng 13
4454375 2186381 2186381 defendant Corkemay John   758495 758495 Corkemay, John, of Shoelham 14
4454376 2186381 2186381 defendant Reppes Thomas de     Reppes, Thomas de 15
4454377 2186381 2186381 defendant Pedham Henry de     Pedham, Henry de 16
4454378 2186381 2186381 defendant Metere William     Metere, William 17
4454379 2186381 2186381 defendant Upty John   590106 590106 Upty, John, of South Walsham 18
4454380 2186381 2186381 defendant Coker William   594283 594283 Coker, William, of Tunsted 19
4454381 2186381 2186381 defendant Cuffe Robert     Cuffe, Robert 20
4454382 2186381 2186381 defendant Cupper William     Cupper, William 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);