names

11 rows where case_id = 2208590

✎ 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
4526569 2208590 2208590 plaintiff Lancaster John son of the king of England & duke of   Lancaster, John, son of the king of England & duke of, executors of 0
4526570 2208590 2208590 plaintiff Worcester Thomas earl of, & senescall of the hospice of the former King Richard of England   (Worcester, Thomas, earl of, & senescall of the hospice of the former King Richard of England 1
4526571 2208590 2208590 plaintiff Westmorland Ralph Earl of, son of John, son of the King of England, formerly Duke of Lancaster   Westmorland, Ralph, Earl of, son of John, son of the King of England, formerly Duke of Lancaster 2
4526572 2208590 2208590 plaintiff Blount Walter knight   Blount, Walter, knight 3
4526573 2208590 2208590 plaintiff Par William knight   Par, William, knight 4
4526574 2208590 2208590 plaintiff Whitby Robert formerly attorney general for John, duke of Lancaster   Whitby, Robert, formerly attorney general for John, duke of Lancaster 5
4526575 2208590 2208590 plaintiff Keteryng William     Keteryng, William 6
4526576 2208590 2208590 plaintiff Haytfeld Robert controller of the hospice rolls for the late Duke of Lancaster   Haytfeld, Robert, controller of the hospice rolls for the late Duke of Lancaster 7
4526577 2208590 2208590 plaintiff Legburn John formerly receiver general for John, duke of Lancaster   Legburn, John, formerly receiver general for John, duke of Lancaster 8
4526578 2208590 2208590 plaintiff Longleley Thomas clerk   Longleley, Thomas, clerk 9
4526579 2208590 2208590 defendant Pyell Nicholas   598642 598642 Pyell, Nicholas, of Irtlyngburgh 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);