names

21 rows where place_id = 610531

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3684027 1921137 1921137 defendant Conyers William gent 610531 610531 Conyers, William, of Marske, gent 0
3699202 1925964 1925964 defendant Conyers William gent 610531 610531 Conyers, William, of Marske, gent 0
3707646 1928691 1928691 defendant Baxster Thomas husbandman 610531 610531 Baxster, Thomas, of Marske, husbandman 0
3881542 1984087 1984087 defendant Conyars William esq 610531 610531 Conyars, William, of Marske, esq 0
3928218 1999774 1999774 defendant Taylour John yeoman 610531 610531 Taylour, John, of Marske, yeoman, of Clapgate within Marske, yeoman 1
4085138 2054967 2054967 defendant Becke Richard yeoman 610531 610531 Becke, Richard, of Marske, yeoman 0
4310406 2133796 2133796 defendant Becke Richard   610531 610531 Becke, Richard, of Marske, yeoman, administrators of 0
4315980 2135702 2135702 defendant Dowson John yeoman 610531 610531 Dowson, John, of Marske, yeoman 0
4394412 2162728 2162728 defendant Rokeby Ralph, junior gent 610531 610531 Rokeby, Ralph, junior, of Marske, gent 0
4395244 2162990 2162990 defendant Phillippes Thomas gent 610531 610531 Phillippes, Thomas, of Marske, gent 1
4398815 2164184 2164184 defendant Rokebie Robert esq 610531 610531 Rokebie, Robert, of Marske, esq 0
4398817 2164185 2164185 defendant Rokebie Ralph   610531 610531 Rokebie, Ralph, of Marske, gent, son of Robert 0
4985439 2352568 2352568 defendant Lightfote Adam yeoman 610531 610531 Lightfote, Adam, of Marske, yeoman 0
4991092 2354226 2354226 defendant Docheson Henry miller 610531 610531 Docheson, Henry, of Marske, miller 0
4991471 2354334 2354334 defendant Doweson John yeoman 610531 610531 Doweson, John, of Marske, yeoman 0
4991472 2354334 2354334 defendant Mason Richard yeoman 610531 610531 Mason, Richard, of Marske, yeoman 1
4991473 2354334 2354334 defendant Symson William husbandman 610531 610531 Symson, William, of Marske, husbandman 2
4991474 2354334 2354334 defendant Symson John husbandman 610531 610531 Symson, John, of Marske, husbandman 3
4991475 2354334 2354334 defendant Brampton Richard husbandman 610531 610531 Brampton, Richard, of Marske, husbandman 4
4991476 2354334 2354334 defendant Henryson John husbandman 610531 610531 Henryson, John, of Marske, husbandman 5
4991477 2354334 2354334 defendant Hope William husbandman 610531 610531 Hope, William, of Marske, husbandman 6

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