names

17 rows where case_id = 2208323

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4525571 2208323 2208323 plaintiff John duke of Lancaster (legal representative)   John, duke of Lancaster, executors of 0
4525572 2208323 2208323 plaintiff (not given) Ralph bishop of Salisbury   (Salisbury, Ralph, bishop of 1
4525573 2208323 2208323 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
4525574 2208323 2208323 plaintiff Westmorland Ralph Earl of, & son of John   Westmorland, Ralph, Earl of, & son of John 3
4525575 2208323 2208323 plaintiff Blount Walter knight   Blount, Walter, knight 4
4525576 2208323 2208323 plaintiff Par William knight   Par, William, knight 5
4525577 2208323 2208323 plaintiff Dabruggecourt John knight   Dabruggecourt, John, knight 6
4525578 2208323 2208323 plaintiff Waterton Hugh knight   Waterton, Hugh, knight 7
4525579 2208323 2208323 plaintiff Skelton Thomas knight   Skelton, Thomas, knight 8
4525580 2208323 2208323 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
4525581 2208323 2208323 plaintiff Whitby Robert formerly attorney general for John   Whitby, Robert, formerly attorney general for John 10
4525582 2208323 2208323 plaintiff Keteryng William     Keteryng, William 11
4525583 2208323 2208323 plaintiff Haytfeld Robert formerly comptroller of the household of John   Haytfeld, Robert, formerly comptroller of the household of John 12
4525584 2208323 2208323 plaintiff Legburn John formerly receiver general for John   Legburn, John, formerly receiver general for John 13
4525585 2208323 2208323 plaintiff Melbourn Peter     Melbourn, Peter 14
4525586 2208323 2208323 plaintiff Longeley Thomas clerk   Longeley, Thomas, clerk 15
4525587 2208323 2208323 defendant Goldsmyth Robert   594218 594218 Goldsmyth, Robert, of St Neots 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);