names

34 rows where place_id = 610254

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3682696 1920691 1920691 defendant Sayvell John gent 610254 610254 Sayvell, John, of Newhall, gent 1
3682712 1920695 1920695 defendant Sayvell John gent 610254 610254 Sayvell, John, of Newhall, gent 1
3711221 1929814 1929814 defendant Dethyke Thomas esq 610254 610254 Dethyke, Thomas, of Newhall, esq 0
3717359 1931712 1931712 plaintiff Dethyk Thomas   610254 610254 Dethyk, Thomas, of Newhall 0
3725884 1934371 1934371 defendant Dethyke Thomas esq 610254 610254 Dethyke, Thomas, of Newhall, esq 0
3733079 1936570 1936570 plaintiff Dethyk Thomas   610254 610254 Dethyk, Thomas, of Newhall 0
3741431 1939186 1939186 defendant Dethyke Thomas   610254 610254 Dethyke, Thomas, of Newhall 0
3756679 1944066 1944066 defendant Chapman Edward husbandman 610254 610254 Chapman, Edward, of Newhall, husbandman 7
3894375 1988335 1988335 defendant Sale John husbandman 610254 610254 Sale, John, of Newhall, husbandman 4
3895600 1988732 1988732 defendant Keythley Thomas gent 610254 610254 Keythley, Thomas, of Newhall, gent 11
3897824 1989475 1989475 defendant Sayvell Nicholas gent 610254 610254 Sayvell, Nicholas, of Newhall, gent 0
3903946 1991558 1991558 defendant Sayvell Nicholas gent 610254 610254 Sayvell, Nicholas, of Newhall, gent 0
4062212 2046774 2046774 defendant Pawson Robert husbandman or "gresman" 610254 610254 Pawson, Robert, of Newhall, husbandman or "gresman" 1
4108872 2063426 2063426 defendant Savyle John esq 610254 610254 Savyle, John, of Newhall, esq 0
4121416 2067952 2067952 defendant Savile John esq 610254 610254 Savile, John, of Newhall, esq 0
4121509 2067987 2067987 defendant Baildon Peter yeoman 610254 610254 Baildon, Peter, of Newhall, yeoman, son of James Baildon, of Newhall, yeoman 0
4121511 2067988 2067988 defendant Baildon Peter yeoman 610254 610254 Baildon, Peter, of Newhall, yeoman, son of James Baildon, of Newhall, yeoman 0
4183851 2089845 2089845 defendant Bosvile Gervase esq 610254 610254 Bosvile, Gervase, of Newhall, esq 0
4183858 2089846 2089846 defendant Bosvile Gervase esq 610254 610254 Bosvile, Gervase, of Newhall, esq 0
4207587 2098212 2098212 defendant Bosvile Gervase esq 610254 610254 Bosvile, Gervase, of Newhall, esq 0
4208497 2098524 2098524 defendant Bossevyle Jervase esq 610254 610254 Bossevyle, Jervase, of Newhall, esq 0
4244743 2111226 2111226 defendant Savyle John gent 610254 610254 Savyle, John, of Newhall, gent 0
4264359 2117725 2117725 defendant Bosvile Thomas esq 610254 610254 Bosvile, Thomas, of Newhall, esq 0
4267092 2118632 2118632 defendant Cheswys John gent 610254 610254 Cheswys, John, of Newhall, or of Mickley, Cheshire, gent 0
4268686 2119117 2119117 defendant Savile John gent 610254 610254 Savile, John, of Newhall, gent 0
4282837 2123896 2123896 defendant Savile John gent 610254 610254 Savile, John, of Newhall, gent 1
4284415 2124476 2124476 defendant Bosvile Thomas esq 610254 610254 Bosvile, Thomas, of Newhall, esq 0
4301830 2130763 2130763 defendant Bosvile Thomas esq 610254 610254 Bosvile, Thomas, of Newhall, esq 0
4310745 2133902 2133902 defendant Bosvyle Thomas esq 610254 610254 Bosvyle, Thomas, of Newhall, esq 0
4320225 2137174 2137174 defendant Bosvyle Thomas esq 610254 610254 Bosvyle, Thomas, of Newhall, esq 1
4322054 2137793 2137793 defendant Savile John gent 610254 610254 Savile, John, of Newhall, gent 1
4323010 2138109 2138109 defendant Bosvile Thomas esq 610254 610254 Bosvile, Thomas, of Newhall, esq 0
4362182 2151520 2151520 defendant Balden Peter yeoman 610254 610254 Balden, Peter, of Newhall, yeoman 0
5586672 2530868 2530868 defendant Dethyk Thomas gent 610254 610254 Dethyk, Thomas, of Newhall, gent 1

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