names

41 rows where place_id = 592110

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606600 1869737 1869737 defendant Welby Richard yeoman 592110 592110 Welby, Richard, of Fosdyke, yeoman 2
3691861 1923615 1923615 defendant Trees Thomas yeoman 592110 592110 Trees, Thomas, of Fosdyke, yeoman 1
3726659 1934599 1934599 defendant Felde Thomas yeoman 592110 592110 Felde, Thomas, of Fosdyke, yeoman 0
3761022 1945450 1945450 defendant Trees Thomas gent 592110 592110 Trees, Thomas, of Fosdyke, gent 0
3784279 1952872 1952872 defendant Herteley James husbandman 592110 592110 Herteley, James, of Fosdyke, husbandman 2
3870913 1980520 1980520 defendant Atkynson Thomas husbandman 592110 592110 Atkynson, Thomas, of Fosdyke, husbandman 1
3874893 1981825 1981825 defendant Hunt Thomas yeoman 592110 592110 Hunt, Thomas, of Fosdyke, yeoman 0
3881564 1984095 1984095 defendant Honnyng Thomas husbandman 592110 592110 Honnyng, Thomas, of Fosdyke, husbandman 0
3916804 1995985 1995985 defendant Atkynson Thomas husbandman 592110 592110 Atkynson, Thomas, of Fosdyke, husbandman 0
3953856 2008419 2008419 defendant Jolyson Robert husbandman 592110 592110 Jolyson, Robert, of Fosdyke, husbandman 0
3979210 2017313 2017313 defendant Stone Barnard miller 592110 592110 Stone, Barnard, of Fosdyke, miller 0
4001289 2025240 2025240 defendant Tollyng William clerk 592110 592110 Tollyng, William, of Fosdyke, clerk 1
4050715 2042689 2042689 plaintiff Welbye Thomas yeoman 592110 592110 Welbye, Thomas, of Fosdyke, yeoman 0
4171163 2085381 2085381 defendant Loughton John gent 592110 592110 Loughton, John, of Fosdyke, gent 3
4173944 2086343 2086343 defendant Hood Robert husbandman 592110 592110 Hood, Robert, of Fosdyke, husbandman 0
4296420 2128820 2128820 defendant Middlecott Thomas gent 592110 592110 Middlecott, Thomas, of Fosdyke, gent 0
4296422 2128821 2128821 defendant Middlecott Thomas gent 592110 592110 Middlecott, Thomas, of Fosdyke, gent 0
4377478 2157023 2157023 defendant Cooke Robert yeoman 592110 592110 Cooke, Robert, of Fosdyke, yeoman 0
4605040 2232734 2232734 plaintiff Alforth John chaplain 592110 592110 Alforth, John, of Fosdyke, chaplain 0
4879485 2320513 2320513 defendant Slye John husbandman 592110 592110 Slye, John, of Fosdyke, husbandman 2
4879486 2320513 2320513 defendant Slye Richard husbandman 592110 592110 Slye, Richard, of Fosdyke, husbandman 3
4929277 2335575 2335575 defendant Slye Richard chaplain 592110 592110 Slye, Richard, of Fosdyke, chaplain 0
4974566 2349357 2349357 defendant Pulvertoft Roger husbandman 592110 592110 Pulvertoft, Roger, of Fosdyke, husbandman 0
4974568 2349357 2349357 defendant Pulvertoft Robert husbandman 592110 592110 Pulvertoft, Robert, of Fosdyke, husbandman 2
5008477 2359374 2359374 defendant Welby Richard gent 592110 592110 Welby, Richard, of Fosdyke, gent 0
5075915 2379289 2379289 defendant Alworld William husbandman 592110 592110 Alworld, William, of Fosdyke, husbandman 2
5117125 2391434 2391434 plaintiff Pery John   592110 592110 Pery, John, of Fosdyke 0
5257512 2432469 2432469 plaintiff Robynson Nicholas   592110 592110 Robynson, Nicholas, of Fosdyke 4
5296440 2443948 2443948 defendant Sheperd Thomas husbandman 592110 592110 Sheperd, Thomas, of Fosdyke, husbandman 0
5301344 2445355 2445355 defendant Hougate Thomas   592110 592110 Hougate, Thomas, of Fosdyke, inn keeper 0
5301346 2445355 2445355 defendant Chaumbre John   592110 592110 Chaumbre, John, of Fosdyke, salt weller 2
5315932 2449839 2449839 defendant Caumbre John saltweller 592110 592110 Caumbre, John, of Fosdyke, saltweller 2
5434508 2485264 2485264 defendant Robynson Nicholas merchant 592110 592110 (Robynson, Nicholas, of Fosdyke, merchant 1
5441638 2487418 2487418 plaintiff Alynson Thomas   592110 592110 Alynson, Thomas, of fosdyke 0
5444240 2488182 2488182 defendant Tyrees Thomas yeoman 592110 592110 Tyrees, Thomas, of Fosdyke, yeoman 5
5449886 2489854 2489854 defendant Robynson Nicholas merchant 592110 592110 (Robynson, Nicholas, of Fosdyke, merchant 1
5454429 2491235 2491235 plaintiff Alynson Thomas   592110 592110 Alynson, Thomas, of Fosdyke 0
5462060 2493546 2493546 defendant Robynson Nicholas merchant 592110 592110 (Robynson, Nicholas, of Fosdyke, merchant 1
5466324 2494865 2494865 plaintiff Alynson Thomas   592110 592110 Alynson, Thomas, of Fosdyke 0
5492757 2502750 2502750 defendant Kyrton Thomas yeoman 592110 592110 Kyrton, Thomas, of Fosdyke, yeoman 0
5587144 2531007 2531007 defendant Richardson Robert husbandman 592110 592110 Richardson, Robert, of Fosdyke, husbandman 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);