names

27 rows where place_id = 593961

✎ 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
3613954 1872020 1872020 defendant Yate Richard gent 593961 593961 Yate, Richard, of Arlyngham, gent 1
3622362 1874530 1874530 defendant Yate Richard gent 593961 593961 Yate, Richard, of Arlyngham, gent 1
3785880 1953375 1953375 defendant Robardys Robert husbandman 593961 593961 Robardys, Robert, of Arlyngham, husbandman 0
3785881 1953375 1953375 defendant Horne Robert husbandman 593961 593961 Horne, Robert, of Arlyngham, husbandman 1
3785882 1953375 1953375 defendant Longney Walter husbandman 593961 593961 Longney, Walter, of Arlyngham, husbandman 2
3785883 1953375 1953375 defendant Webbe Richard husbandman 593961 593961 Webbe, Richard, of Arlyngham, husbandman 3
3826143 1966019 1966019 plaintiff ap Guillam Thomas gent 593961 593961 ap Guillam, Thomas, of Arlyngham, gent 0
3826145 1966020 1966020 plaintiff ap Guillam Thomas gent 593961 593961 ap Guillam, Thomas, of Arlyngham, gent 0
3915856 1995681 1995681 defendant Arnold William laborer or weaver 593961 593961 Arnold, William, of Arlyngham, laborer or weaver 0
4006675 2027167 2027167 defendant Clyfford John gent 593961 593961 Clyfford, John, of Arlyngham, gent 0
4039015 2038575 2038575 defendant Clyfford John husbandman 593961 593961 Clyfford, John, of Arlyngham, husbandman 0
4141790 2075291 2075291 defendant Taylor alias Hithe John husbandman 593961 593961 Taylor alias Hithe, John, of Arlyngham, husbandman 0
4184022 2089910 2089910 defendant Wootton John tailor 593961 593961 Wootton, John, of Arlyngham, tailor 0
4184023 2089910 2089910 defendant Webbe Walter yeoman 593961 593961 Webbe, Walter, of Arlyngham, yeoman 1
4213954 2100401 2100401 defendant Eyers John yeoman 593961 593961 Eyers, John, of Arlyngham, yeoman 3
4223642 2103756 2103756 defendant Gyers or Eyers John yeoman 593961 593961 Gyers or Eyers, John, of Arlyngham, yeoman 3
4238524 2109087 2109087 defendant Fryar Walter husbandman 593961 593961 Fryar, Walter, of Arlyngham, husbandman 0
4310925 2133969 2133969 defendant Yate Christopher gent 593961 593961 Yate, Christopher, of Arlyngham, gent 1
4310978 2133985 2133985 defendant Carter Walter husbandman 593961 593961 Carter, Walter, of Arlyngham, husbandman 0
4310979 2133985 2133985 defendant Kynge alias Blake William husbandman 593961 593961 Kynge alias Blake, William, of Arlyngham, husbandman 1
4314108 2135042 2135042 defendant Webb Richard husbandman 593961 593961 Webb, Richard, of Arlyngham, husbandman 2
4315338 2135476 2135476 defendant Wootton John yeoman 593961 593961 Wootton, John, of Arlyngham, yeoman 0
4315339 2135476 2135476 defendant Hithe alias Taylor John yeoman 593961 593961 Hithe alias Taylor, John, of Arlyngham, yeoman 1
4383659 2159246 2159246 defendant Yate Christopher gent 593961 593961 Yate, Christopher, of Arlyngham, gent 0
4402663 2165477 2165477 defendant Yate Christopher gent 593961 593961 Yate, Christopher, of Arlyngham, gent 0
5364590 2464586 2464586 defendant Hickys Thomas husbandman 593961 593961 Hickys, Thomas, of Arlyngham, husbandman 0
5421429 2481345 2481345 defendant Rollys Richard husbandman 593961 593961 Rollys, Richard, of Arlyngham, husbandman 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);