names

31 rows where place_id = 610895

✎ 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
3685747 1921698 1921698 defendant Herne John merchant 610895 610895 Herne, John, of Barnestable, merchant 0
3701906 1926848 1926848 defendant Gynwyn Thomas husbandman 610895 610895 Gynwyn, Thomas, of Barnestable, husbandman 0
3701907 1926848 1926848 defendant Fynell William yeoman 610895 610895 Fynell, William, of Barnestable, yeoman 1
3701908 1926848 1926848 defendant Fynell Robert yeoman 610895 610895 Fynell, Robert, of Barnestable, yeoman 2
3730992 1935925 1935925 defendant Gunwyn Thomas husbandman 610895 610895 Gunwyn, Thomas, of Barnestable, husbandman 0
3730993 1935925 1935925 defendant Fynell William yeoman 610895 610895 Fynell, William, of Barnestable, yeoman 1
3730994 1935925 1935925 defendant Fynell Robert yeoman 610895 610895 Fynell, Robert, of Barnestable, yeoman 2
3745555 1940515 1940515 defendant Cockys James clerk 610895 610895 Cockys, James, of Barnestable, clerk 0
3745556 1940515 1940515 defendant Swayn John yeoman 610895 610895 Swayn, John, of Barnestable, yeoman 1
3745557 1940515 1940515 defendant Litell John currier 610895 610895 Litell, John, of Barnestable, currier 2
3930149 2000429 2000429 defendant Tasey John   610895 610895 Tasey, John, of Barnestable, shoe maker 0
3934223 2001740 2001740 defendant Mannyng John, junior merchant 610895 610895 Mannyng, John, junior, of Barnestable, merchant 0
3935513 2002186 2002186 defendant Mannyng John, junior merchant 610895 610895 Mannyng, John, junior, of Barnestable, merchant 1
3958910 2010200 2010200 plaintiff Sallysbery William (legal representative) 610895 610895 Sallysbery, William, of Barnestable, merchant, executors of 0
3974106 2015514 2015514 defendant Beare George yeoman 610895 610895 Beare, George, of Barnestable, yeoman 0
4029522 2035195 2035195 plaintiff Dart John merchant 610895 610895 Dart, John, of Barnestable, merchant 0
4034882 2037152 2037152 defendant Honye Richard, junior cordwainer 610895 610895 Honye, Richard, junior, of Barnestable, cordwainer 1
4079993 2053148 2053148 defendant Baker Robert yeoman 610895 610895 Baker, Robert, of Barnestable, yeoman 0
4102301 2061113 2061113 defendant Webbe Leticia widow 610895 610895 Webbe, Leticia, of Barnestable, widow 1
4123429 2068682 2068682 defendant Snydall John gent 610895 610895 Snydall, John, of Barnestable, gent 0
4159824 2081503 2081503 defendant Drewe Richard husbandman 610895 610895 Drewe, Richard, of Barnestable, husbandman 0
4181055 2088848 2088848 defendant Delbridge Roger mercer 610895 610895 Delbridge, Roger, of Barnestable, mercer 1
4184041 2089914 2089914 defendant Thorne John chapman 610895 610895 Thorne, John, of Barnestable, chapman 2
4207176 2098056 2098056 defendant Drewe Richard husbandman 610895 610895 Drewe, Richard, of Barnestable, husbandman 0
4255682 2114874 2114874 defendant Beaple Roger tanner 610895 610895 Beaple, Roger, of Barnestable, tanner 0
4255683 2114874 2114874 defendant Brasyer Hugh draper 610895 610895 Brasyer, Hugh, of Barnestable, draper 1
4255684 2114874 2114874 defendant Worthe Paul gent 610895 610895 Worthe, Paul, of Barnestable, gent 2
4280841 2123204 2123204 defendant Delbridge Roger chapman 610895 610895 Delbridge, Roger, of Barnestable, chapman 1
4280842 2123204 2123204 defendant Brasyer Hugh chapman 610895 610895 Brasyer, Hugh, of Barnestable, chapman 2
4280843 2123204 2123204 defendant Davye Thomas chapman 610895 610895 Davye, Thomas, of Barnestable, chapman 3
5468243 2495441 2495441 defendant Tourner John husbandman 610895 610895 Tourner, John, of Barnestable, husbandman 3

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