names

19 rows where place_id = 686047

✎ 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
4065052 2047787 2047787 defendant Wythes Edward gent 686047 686047 Wythes, Edward, of Westwicke, gent 0
4078461 2052595 2052595 defendant Wythes Edward yeoman 686047 686047 Wythes, Edward, of Westwicke, yeoman 0
4094518 2058376 2058376 defendant Skottowe John husbandman 686047 686047 Skottowe, John, of Westwicke, husbandman 3
4096122 2058940 2058940 defendant Withes Edward gent 686047 686047 Withes, Edward, of Westwicke, gent 0
4096124 2058941 2058941 defendant Wythes Edward gent 686047 686047 Wythes, Edward, of Westwicke, gent 0
4127139 2069994 2069994 defendant Ruste Edward clerk 686047 686047 Ruste, Edward, of Westwicke, clerk 0
4143602 2075920 2075920 defendant Galtye George yeoman 686047 686047 Galtye, George, of Westwicke, yeoman 0
4165310 2083373 2083373 defendant Pawdan Andrew tailor 686047 686047 Pawdan, Andrew, of Westwicke, tailor 0
4188913 2091602 2091602 defendant Gawltye George, junior yeoman 686047 686047 Gawltye, George, junior, of Westwicke, yeoman 0
4188915 2091603 2091603 defendant Gawltye George, senior yeoman 686047 686047 Gawltye, George, senior, of Westwicke, yeoman 0
4251950 2113642 2113642 defendant Halfhead William yeoman 686047 686047 Halfhead, William, of Westwicke, yeoman 0
4254584 2114522 2114522 defendant Halfead or Haufhead William gent 686047 686047 Halfead or Haufhead, William, of Westwicke, gent 0
4254585 2114522 2114522 defendant Caverley William gent 686047 686047 Caverley, William, of Westwicke, gent 1
4285779 2124967 2124967 defendant Elligood William husbandman 686047 686047 Elligood, William, of Westwicke, husbandman 0
4332019 2141006 2141006 defendant Weddes William yeoman 686047 686047 Weddes, William, of Westwicke, yeoman 1
4346597 2146063 2146063 defendant Lynsted William gent 686047 686047 Lynsted, William, of Westwicke, gent 0
4346598 2146063 2146063 defendant Hoddes Joan spinster 686047 686047 Hoddes, Joan, of Westwicke, spinster 1
4346599 2146063 2146063 defendant Ingland Alice widow 686047 686047 Ingland, Alice, of Westwicke, widow 2
4387380 2160424 2160424 defendant Haynes William husbandman 686047 686047 Haynes, William, of Westwicke, husbandman 2

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