names

32 rows where place_id = 610825

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3685413 1921590 1921590 defendant Holme Robert chaplain 610825 610825 Holme, Robert, of Mysterton, chaplain 0
3723726 1933696 1933696 defendant Pulteney Thomas   610825 610825 Pulteney, Thomas, of Mysterton, knight 0
3739559 1938583 1938583 defendant Pultney Thomas   610825 610825 Pultney, Thomas, of Mysterton, knight 0
3741730 1939276 1939276 defendant Portale John laborer 610825 610825 Portale, John, of Mysterton, laborer 4
3771180 1948675 1948675 defendant Baxenden Robert husbandman 610825 610825 Baxenden, Robert, of Mysterton, husbandman 0
3824099 1965410 1965410 defendant Wryght Richard husbandman 610825 610825 Wryght, Richard, of Mysterton, husbandman 1
3824100 1965410 1965410 defendant Ruston William husbandman 610825 610825 Ruston, William, of Mysterton, husbandman 2
3903334 1991337 1991337 defendant Shypton John   610825 610825 Shypton, John, of Mysterton, wheelwright 0
4002518 2025666 2025666 defendant Pount John gent 610825 610825 Pount, John, of Mysterton, gent 3
4041610 2039492 2039492 plaintiff Norfolke Robert yeoman 610825 610825 Norfolke, Robert, of Mysterton, yeoman 0
4041612 2039493 2039493 plaintiff Norfolke Robert yeoman 610825 610825 Norfolke, Robert, of Mysterton, yeoman 0
4079107 2052829 2052829 defendant Wood Robert husbandman 610825 610825 Wood, Robert, of Mysterton, husbandman 0
4092178 2057501 2057501 defendant Snell or Suell John blacksmith 610825 610825 Snell or Suell, John, of Mysterton, blacksmith 0
4092179 2057501 2057501 defendant Hurste George laborer 610825 610825 Hurste, George, of Mysterton, laborer 1
4206941 2097970 2097970 defendant Bysshoppe John carpenter 610825 610825 Bysshoppe, John, of Mysterton, carpenter 0
4281598 2123470 2123470 defendant Dawson Richard husbandman 610825 610825 Dawson, Richard, of Mysterton, husbandman 0
4284211 2124402 2124402 defendant Tomkinson Roger husbandman 610825 610825 Tomkinson, Roger, of Mysterton, husbandman 0
4284213 2124403 2124403 defendant Tomkynson Roger husbandman 610825 610825 Tomkynson, Roger, of Mysterton, husbandman 0
4380334 2158072 2158072 defendant Sharlocke William baker 610825 610825 Sharlocke, William, of Mysterton, baker 0
4488203 2197025 2197025 defendant Selby William   610825 610825 Selby, William, of Mysterton, son of Walter Selby 0
4720380 2271709 2271709 defendant Sencler William yeoman 610825 610825 Sencler, William, of Mysterton, yeoman 6
5016732 2361786 2361786 defendant Gryme William husbandman 610825 610825 Gryme, William, of Mysterton, husbandman 0
5091139 2383806 2383806 defendant Fernham Thomas husbandman 610825 610825 Fernham, Thomas, of Mysterton, husbandman 0
5095742 2385177 2385177 defendant Stormworth Thomas husbandman 610825 610825 Stormworth, Thomas, of Mysterton, husbandman 0
5279104 2438997 2438997 defendant Pulteney Thomas gent 610825 610825 Pulteney, Thomas, of Mysterton, gent 0
5279105 2438997 2438997 defendant Wyndell William yeoman 610825 610825 Wyndell, William, of Mysterton, yeoman 1
5484002 2500150 2500150 defendant Payne Edmund chaplain 610825 610825 Payne, Edmund, of Mysterton, chaplain 0
5531192 2514271 2514271 defendant Grey Henry yeoman 610825 610825 Grey, Henry, of Mysterton, yeoman 0
5575604 2527459 2527459 defendant Pulteney Thomas (legal representative) 610825 610825 Pulteney, Thomas, of Mysterton, knight, executors of 0
5575607 2527459 2527459 defendant Button William clerk 610825 610825 Button, William, of Mysterton, clerk 3
5575608 2527459 2527459 defendant Cates Adam gent 610825 610825 Cates, Adam, of Mysterton, gent 4
5575609 2527459 2527459 defendant Helcote Robert gent 610825 610825 Helcote, Robert, of Mysterton, gent 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);