names

28 rows where place_id = 838055

✎ 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
5037363 2367800 2367800 defendant atte Fenne John husbandman 838055 838055 atte Fenne, John, of Wylton juxta Salisbury, husbandman 0
5069116 2377255 2377255 defendant Kayser William   838055 838055 Kayser, William, of Wylton juxta Salisbury, franklin 0
5069118 2377256 2377256 defendant Mundy John chapman 838055 838055 Mundy, John, of Wylton juxta Salisbury, chapman 0
5069119 2377256 2377256 defendant Wastell William weaver 838055 838055 Wastell, William, of Wylton juxta Salisbury, weaver 1
5086307 2382386 2382386 defendant Wever alias Norman James weaver 838055 838055 Wever alias Norman, James, of Wylton juxta Salisbury, weaver 3
5087457 2382708 2382708 defendant Lambard Richard gent 838055 838055 together with Lambard, Richard, of Wylton juxta Salisbury, gent 2
5087461 2382709 2382709 defendant Lambard Richard gent 838055 838055 together with Lambard, Richard, of Wylton juxta Salisbury, gent 2
5087463 2382710 2382710 defendant Lambard Richard gent 838055 838055 Lambard, Richard, of Wylton juxta Salisbury, gent 0
5091202 2383827 2383827 defendant Jocy Robert butcher 838055 838055 Jocy, Robert, of Wylton juxta Salisbury, butcher 0
5114370 2390598 2390598 defendant Wateler William smith 838055 838055 Wateler, William, of Wylton juxta Salisbury, smith 0
5123007 2393158 2393158 defendant Blyke John fuller 838055 838055 Blyke, John, of Wylton juxta Salisbury, fuller 0
5220046 2421572 2421572 defendant Fawekon William dyer 838055 838055 Fawekon, William, of Wylton juxta Salisbury, dyer 3
5220946 2421822 2421822 defendant Blyke John tucker 838055 838055 Blyke, John, of Wylton juxta Salisbury, tucker 0
5229349 2424195 2424195 defendant Lyme John weaver 838055 838055 Lyme, John, of Wylton juxta Salisbury, weaver 2
5252473 2430884 2430884 defendant Crede Roger tucker 838055 838055 Crede, Roger, of Wylton juxta Salisbury, tucker 0
5257187 2432380 2432380 defendant Assheman William yeoman 838055 838055 Assheman, William, of Wylton juxta Salisbury, yeoman 5
5257196 2432381 2432381 defendant Playcer or Playter John skinner 838055 838055 Playcer or Playter, John, of Wylton juxta Salisbury, skinner 2
5260097 2433280 2433280 defendant Crede Roger fuller 838055 838055 Crede, Roger, of Wylton juxta Salisbury, fuller 0
5260098 2433280 2433280 defendant Crede Ralph fuller 838055 838055 Crede, Ralph, of Wylton juxta Salisbury, fuller 1
5262240 2433938 2433938 defendant Mayne Roger gent 838055 838055 Mayne, Roger, of Wylton juxta Salisbury, gent 1
5265508 2434974 2434974 defendant Pevesey or Penesey or Peuesey William   838055 838055 Pevesey or Penesey or Peuesey, William, of Wylton juxta Salisbury, court holder 0
5265509 2434974 2434974 defendant Wymbold John, senior tucker 838055 838055 Wymbold, John, senior, of Wylton juxta Salisbury, tucker 1
5280331 2439327 2439327 defendant Thressher Stephen yeoman 838055 838055 Thressher, Stephen, of Wylton juxta Salisbury, yeoman 0
5290673 2442273 2442273 defendant Thressher Stephen yeoman 838055 838055 Thressher, Stephen, of Wylton juxta Salisbury, yeoman 0
5328069 2453464 2453464 defendant Free William clothier 838055 838055 Free, William, of Wylton juxta Salisbury, clothier 2
5501686 2505458 2505458 defendant Touke or Tonke John gent 838055 838055 Touke or Tonke, John, of Wylton juxta Salisbury, gent 0
5501687 2505458 2505458 defendant Touke or Tonke William gent 838055 838055 Touke or Tonke, William, of Wylton juxta Salisbury, gent 1
5514843 2509488 2509488 defendant Wythy Andrew yeoman 838055 838055 Wythy, Andrew, of Wylton juxta Salisbury, yeoman 0

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