names

16 rows where case_id = 2208329

✎ 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
4525667 2208329 2208329 plaintiff John duke of Lancaster (legal representative)   John, duke of Lancaster, executors of 0
4525668 2208329 2208329 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 1
4525669 2208329 2208329 plaintiff Westmorland Ralph Earl of, & son of John, the testator   Westmorland, Ralph, Earl of, & son of John, the testator 2
4525670 2208329 2208329 plaintiff Blount Walter knight   Blount, Walter, knight 3
4525671 2208329 2208329 plaintiff Par William knight   Par, William, knight 4
4525672 2208329 2208329 plaintiff Whitby Robert formerly attorney general for John, the testator   Whitby, Robert, formerly attorney general for John, the testator 5
4525673 2208329 2208329 plaintiff Keteryng William     Keteryng, William 6
4525674 2208329 2208329 plaintiff Haytfeld Robert formerly comptroller of the household of John, the testator   Haytfeld, Robert, formerly comptroller of the household of John, the testator 7
4525675 2208329 2208329 plaintiff Legburn John formerly receiver general for John, the testator   Legburn, John, formerly receiver general for John, the testator 8
4525676 2208329 2208329 plaintiff Longeley Thomas clerk   Longeley, Thomas, clerk 9
4525677 2208329 2208329 defendant Edward John   587422 587422 Edward, John, of Sandeherst 0
4525678 2208329 2208329 defendant Wormehull Roger de     Wormehull, Roger de 1
4525679 2208329 2208329 defendant Columbele John   766199 766199 Columbele, John, of Stancliff 2
4525680 2208329 2208329 defendant Niall Thomas     Niall, Thomas 3
4525681 2208329 2208329 defendant Wardelowe Nicholas de     Wardelowe, Nicholas de 4
4525682 2208329 2208329 defendant Gery Richard   592559 592559 Gery, Richard, of Testerton, parson 5

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