names

21 rows where case_id = 2208324

✎ 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
4525588 2208324 2208324 plaintiff John duke of Lancaster (legal representative)   John, duke of Lancaster, executors of 0
4525589 2208324 2208324 plaintiff (not given) Ralph bishop of Salisbury   (Salisbury, Ralph, bishop of 1
4525590 2208324 2208324 plaintiff Worcester Thomas earl of, & formerly steward of the hospice of Richard, late king of England   Worcester, Thomas, earl of, & formerly steward of the hospice of Richard, late king of England 2
4525591 2208324 2208324 plaintiff Westmorland Ralph Earl of, & son of John   Westmorland, Ralph, Earl of, & son of John 3
4525592 2208324 2208324 plaintiff Blount Walter knight   Blount, Walter, knight 4
4525593 2208324 2208324 plaintiff Par William knight   Par, William, knight 5
4525594 2208324 2208324 plaintiff Dabruggecourt John knight   Dabruggecourt, John, knight 6
4525595 2208324 2208324 plaintiff Waterton Hugh knight   Waterton, Hugh, knight 7
4525596 2208324 2208324 plaintiff Skelton Thomas knight   Skelton, Thomas, knight 8
4525597 2208324 2208324 plaintiff Cokayn John formerly chief of the land & poseession of John, Duke of Lancaster   Cokayn, John, formerly chief of the land & poseession of John, Duke of Lancaster 9
4525598 2208324 2208324 plaintiff Whitby Robert formerly attorney general for John   Whitby, Robert, formerly attorney general for John 10
4525599 2208324 2208324 plaintiff Keteryng William     Keteryng, William 11
4525600 2208324 2208324 plaintiff Haytfeld Robert formerly comptroller of the household of John   Haytfeld, Robert, formerly comptroller of the household of John 12
4525601 2208324 2208324 plaintiff Legburn John formerly receiver general for John   Legburn, John, formerly receiver general for John 13
4525602 2208324 2208324 plaintiff Melbourn Peter     Melbourn, Peter 14
4525603 2208324 2208324 plaintiff Longeley Thomas clerk   Longeley, Thomas, clerk 15
4525604 2208324 2208324 defendant Mauleverer Robert     Mauleverer, Robert 0
4525605 2208324 2208324 defendant Wolman Henry merchant 586067 586067 Wolman, Henry, of York, merchant 1
4525606 2208324 2208324 defendant Furnasse John merchant 586067 586067 Furnasse, John, of York, merchant 2
4525607 2208324 2208324 defendant Apylton John   587727 587727 Apylton, John, of Pykeryng 3
4525608 2208324 2208324 defendant Gerstan Robert   587727 587727 Gerstan, Robert, of Pykeryng 4

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