names

18 rows where place_id = 639357

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3848418 1973082 1973082 defendant Raynold John yeoman 639357 639357 Raynold, John, of Erethe, yeoman 0
4572684 2222997 2222997 defendant Barton John de esq 639357 639357 Barton, John de, of Erethe, esq 0
4572686 2222998 2222998 defendant Barton John esq 639357 639357 Barton, John, of Erethe, esq 0
4641259 2243538 2243538 defendant Skynner John   639357 639357 Skynner, John, of Erethe 0
4741333 2277961 2277961 plaintiff Bocher John   639357 639357 Bocher, John, of Erethe, on his own account 0
4897115 2325752 2325752 defendant Stutvile Robert husbandman 639357 639357 Stutvile, Robert, of Erethe, husbandman 0
4993355 2354882 2354882 defendant Abbot Richard husbandman 639357 639357 Abbot, Richard, of Erethe, husbandman 0
5015428 2361393 2361393 defendant Colle John   639357 639357 Colle, John, of Erethe, parish clerk 0
5042729 2369433 2369433 defendant Whitfoot Peter husbandman 639357 639357 Whitfoot, Peter, of Erethe, husbandman 0
5042730 2369433 2369433 defendant Abbot Richard   639357 639357 Abbot, Richard, of Erethe 1
5087710 2382791 2382791 defendant Lacy William   639357 639357 Lacy, William, of Erethe, servant 4
5087716 2382792 2382792 defendant Lacy William   639357 639357 Lacy, William, of Erethe, servant 4
5106342 2388294 2388294 defendant Jonson Thomas yeoman 639357 639357 Jonson, Thomas, of Erethe, yeoman 0
5116744 2391331 2391331 defendant Bocher Thomas butcher 639357 639357 Bocher, Thomas, of Erethe, butcher 2
5289703 2441990 2441990 defendant Hilder John (legal representative) 639357 639357 Hilder, John, of Erethe, yeoman, executors of 1
5512454 2508759 2508759 defendant Somenour alias Clerke Richard butcher 639357 639357 Somenour alias Clerke, Richard, of Erethe, butcher 1
5634202 2554680 2554680 plaintiff Trussebia Robert   639357 639357 Trussebia, Robert, of Erethe 0
5634205 2554681 2554681 plaintiff Trussebut Robert   639357 639357 Trussebut, Robert, of Erethe 0

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