names

28 rows where place_id = 603196

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3653822 1911456 1911456 plaintiff Yong Brian clerk 603196 603196 Yong, Brian, of Stokesley, clerk 0
3674295 1918005 1918005 defendant Cowper Robert yeoman 603196 603196 Cowper, Robert, of Stokesley, yeoman 1
3840968 1970745 1970745 plaintiff Baker John yeoman 603196 603196 Baker, John, of Stokesley, yeoman 0
3971712 2014667 2014667 defendant Ponnyman Robert yeoman 603196 603196 Ponnyman, Robert, of Stokesley, yeoman 0
3983473 2018865 2018865 defendant Pennyman Robert yeoman 603196 603196 Pennyman, Robert, of Stokesley, yeoman 0
4222274 2103281 2103281 defendant Harperley or Harpley Thomas yeoman 603196 603196 Harperley or Harpley, Thomas, of Stokesley, yeoman 0
4222275 2103281 2103281 defendant Harperley or Harpleye Robert yeoman 603196 603196 Harperley or Harpleye, Robert, of Stokesley, yeoman 1
4272939 2120511 2120511 defendant Wilson Robert yeoman 603196 603196 Wilson, Robert, of Stokesley, yeoman 0
4395224 2162988 2162988 defendant Harryson George chapman 603196 603196 Harryson, George, of Stokesley, chapman 3
4531598 2210150 2210150 defendant Mowebray Edmund   603196 603196 Mowebray, Edmund, of Stokesley 6
4673528 2257351 2257351 defendant Kirkeby Thomas de clerk 603196 603196 Kirkeby, Thomas de, of Stokesley, clerk 0
4673529 2257351 2257351 defendant Chamberleyn William yeoman 603196 603196 Chamberleyn, William, of Stokesley, yeoman 1
4673530 2257351 2257351 defendant Bolton Robert yeoman 603196 603196 Bolton, Robert, of Stokesley, yeoman 2
4673531 2257351 2257351 defendant Walker John   603196 603196 Walker, John, of Stokesley, & brother of Henry Walker 3
4719977 2271594 2271594 defendant Hyll William tanner 603196 603196 Hyll, William, of Stokesley, tanner 1
4753664 2281519 2281519 defendant Walker John walker 603196 603196 Walker, John, of Stokesley, walker 0
4841195 2308784 2308784 defendant Edmondson William yeoman 603196 603196 Edmondson, William, of Stokesley, yeoman 0
4900448 2326786 2326786 defendant de Laton Robert gent 603196 603196 de Laton, Robert, of Stokesley, gent 0
4999940 2356859 2356859 defendant Stokesley Henry husbandman 603196 603196 Stokesley, Henry, of Stokesley, husbandman 0
4999942 2356860 2356860 defendant Stokesley Henry husbandman 603196 603196 Stokesley, Henry, of Stokesley, husbandman 0
5054242 2372858 2372858 defendant Soureby Richard saddler 603196 603196 Soureby, Richard, of Stokesley, saddler 0
5130501 2395401 2395401 defendant Everard Thomas   603196 603196 Everard, Thomas, of Stokesley, minstrel 0
5133138 2396176 2396176 defendant Everard Thomas   603196 603196 Everard, Thomas, of Stokesley, minstrel 0
5133150 2396177 2396177 defendant Everard Thomas   603196 603196 Everard, Thomas, of Stokesley, minstrel 0
5340162 2457130 2457130 defendant Hunter John thatcher 603196 603196 Hunter, John, of Stokesley, thatcher 0
5535540 2515644 2515644 defendant Hunter Robert yeoman 603196 603196 Hunter, Robert, of Stokesley, yeoman 0
5552434 2520766 2520766 defendant Conyers Katherine widow 603196 603196 Conyers, Katherine, of Stokesley, widow 0
5633163 2554374 2554374 defendant Wath John yeoman 603196 603196 Wath, John, of Stokesley, yeoman 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);