names

38 rows where case_id = 2349645

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4975520 2349645 2349645 plaintiff Neville Richard Earl of Salisbury   Neville, Richard, Earl of Salisbury 0
4975521 2349645 2349645 defendant Trolhop Leonard gent 829504 829504 Trolhop, Leonard, of West Leynton, gent 0
4975522 2349645 2349645 defendant James Robert yeoman 829504 829504 James, Robert, of West Leynton, yeoman 1
4975523 2349645 2349645 defendant James William yeoman 829504 829504 James, William, of West Leynton, yeoman 2
4975524 2349645 2349645 defendant James John yeoman 829504 829504 James, John, of West Leynton, yeoman 3
4975525 2349645 2349645 defendant Robson William yeoman 829504 829504 Robson, William, of West Leynton, yeoman 4
4975526 2349645 2349645 defendant Lower William yeoman 829504 829504 Lower, William, of West Leynton, yeoman 5
4975527 2349645 2349645 defendant Geffreyson John yeoman 829504 829504 Geffreyson, John, of West Leynton, yeoman 6
4975528 2349645 2349645 defendant del Sandes Christopher yeoman 829504 829504 del Sandes, Christopher, of West Leynton, yeoman 7
4975529 2349645 2349645 defendant Nikson Thomas yeoman 829504 829504 Nikson, Thomas, of West Leynton, yeoman 8
4975530 2349645 2349645 defendant Swan Robert yeoman 829504 829504 Swan, Robert, of West Leynton, yeoman 9
4975531 2349645 2349645 defendant Whynfell Alice widow 829504 829504 Whynfell, Alice, of West Leynton, widow 10
4975532 2349645 2349645 defendant Lamblee John yeoman 603237 603237 Lamblee, John, of Astenby, yeoman 11
4975533 2349645 2349645 defendant Lamblee Richard yeoman 603237 603237 Lamblee, Richard, of Astenby, yeoman 12
4975534 2349645 2349645 defendant Rayleton William yeoman 603237 603237 Rayleton, William, of Astenby, yeoman 13
4975535 2349645 2349645 defendant Neweton Thomas yeoman 603237 603237 Neweton, Thomas, of Astenby, yeoman 14
4975536 2349645 2349645 defendant Stagge John yeoman 783178 783178 Stagge, John, of Ricardby, yeoman 15
4975537 2349645 2349645 defendant Alanson James yeoman 783178 783178 Alanson, James, of Ricardby, yeoman 16
4975538 2349645 2349645 defendant Laton John gent 776392 776392 Laton, John, of Lynstok, gent 17
4975539 2349645 2349645 defendant Blakelok Robert yeoman 776392 776392 Blakelok, Robert, of Lynstok, yeoman 18
4975540 2349645 2349645 defendant Blakelok John yeoman 776392 776392 Blakelok, John, of Lynstok, yeoman 19
4975541 2349645 2349645 defendant Blakelok Paton yeoman 776392 776392 Blakelok, Paton, of Lynstok, yeoman 20
4975542 2349645 2349645 defendant Richardson Richard yeoman 776392 776392 Richardson, Richard, of Lynstok, yeoman 21
4975543 2349645 2349645 defendant Nicolson Robert yeoman 776392 776392 Nicolson, Robert, of Lynstok, yeoman 22
4975544 2349645 2349645 defendant Tomson Thomas yeoman 784570 784570 Tomson, Thomas, of Artreth, yeoman 23
4975545 2349645 2349645 defendant Tomson Roland yeoman 784570 784570 Tomson, Roland, of Artreth, yeoman 24
4975546 2349645 2349645 defendant Kaa Adam yeoman 784570 784570 Kaa, Adam, of Artreth, yeoman 25
4975547 2349645 2349645 defendant Milner John yeoman 784570 784570 Milner, John, of Artreth, yeoman 26
4975548 2349645 2349645 defendant Milner Thomas yeoman 784570 784570 Milner, Thomas, of Artreth, yeoman 27
4975549 2349645 2349645 defendant Milner James yeoman 784570 784570 Milner, James, of Artreth, yeoman 28
4975550 2349645 2349645 defendant Pereson Roger yeoman 784570 784570 Pereson, Roger, of Artreth, yeoman 29
4975551 2349645 2349645 defendant Tomson Nicholas yeoman 784570 784570 Tomson, Nicholas, of Artreth, yeoman 30
4975552 2349645 2349645 defendant Stagge Richard yeoman 784570 784570 Stagge, Richard, of Artreth, yeoman 31
4975553 2349645 2349645 defendant Sourell Robert yeoman 784570 784570 Sourell, Robert, of Artreth, yeoman 32
4975554 2349645 2349645 defendant Shawe John yeoman 784570 784570 Shawe, John, of Artreth, yeoman 33
4975555 2349645 2349645 defendant Robson John yeoman 784570 784570 Robson, John, of Artreth, yeoman 34
4975556 2349645 2349645 defendant Stagge John yeoman 784570 784570 Stagge, John, of Artreth, yeoman 35
4975557 2349645 2349645 defendant Carre Thomas yeoman 784570 784570 Carre, Thomas, of Artreth, yeoman 36

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