names

14 rows where case_id = 2487955

✎ 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
5443449 2487955 2487955 plaintiff Bysshop John gent 585936 585936 Bysshop, John, of Norwich, gent, on his own account 0
5443450 2487955 2487955 defendant Eston Robert gent 589752 589752 Eston, Robert, of Eston, Suff, gent 0
5443451 2487955 2487955 defendant Willys William yeoman 603616 603616 Willys, William, of Cley next the sea, yeoman 1
5443452 2487955 2487955 defendant Corne William   585936 585936 Corne, William, of Norwich, inn holder 2
5443453 2487955 2487955 defendant Moine Thomas husbandman 888071 888071 Moine, Thomas, of Banburgh, Norf, husbandman 3
5443454 2487955 2487955 defendant Noteman John husbandman 888072 888072 Noteman, John, of Burnham St Andrew, Norf, husbandman 4
5443455 2487955 2487955 defendant Grogon Walter husbandman 888073 888073 Grogon, Walter, of Burnham Ulph, Norf, husbandman 5
5443456 2487955 2487955 defendant (illegible) Henry husbandman 604028 604028 _, Henry, of Acle, Norf, husbandman 6
5443457 2487955 2487955 defendant Lenot John yeoman 585936 585936 Lenot, John, of Norwich, yeoman 7
5443458 2487955 2487955 defendant Thwayte Richard husbandman 888074 888074 Thwayte, Richard, of Stanynghale, Norf, husbandman 8
5443459 2487955 2487955 defendant Hille John husbandman 800511 800511 Hille, John, of Todyngton, Norf, husbandman 9
5443460 2487955 2487955 defendant Galt John husbandman 589674 589674 Galt, John, of Aylesham, Norf, husbandman 10
5443461 2487955 2487955 defendant Braffeld Richard husbandman 587294 587294 Braffeld, Richard, of Todyngton, husbandman 11
5443462 2487955 2487955 defendant Elyot John husbandman 768418 768418 Elyot, John, of Burgh by Aylesham, husbandman 12

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