names

33 rows where place_id = 643256

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3872442 1981006 1981006 defendant Lyne Robert chaplain 643256 643256 Lyne, Robert, of Whaplode, Lincs, chaplain 0
3913030 1994689 1994689 defendant Baynbrygge Richard chaplain 643256 643256 Baynbrygge, Richard, of Whaplode, Lincs, chaplain 0
3940990 2003994 2003994 plaintiff Tasshe William (legal representative) 643256 643256 Tasshe, William, of Whaplode, Lincs, yeoman, executors of 0
3951679 2007641 2007641 defendant Allen Philip husbandman 643256 643256 Allen, Philip, of Whaplode, Lincs, husbandman 0
4059445 2045772 2045772 defendant Pulvertoft Robert gent 643256 643256 Pulvertoft, Robert, of Whaplode, Lincs, gent 0
4085295 2055021 2055021 defendant Pulvertofte or Pulverceste Robert gent 643256 643256 Pulvertofte or Pulverceste, Robert, of Whaplode, Lincs, gent 1
4124718 2069135 2069135 defendant Pulvertoft Robert gent 643256 643256 Pulvertoft, Robert, of Whaplode, Lincs, gent 0
4138462 2074122 2074122 defendant Pulvertoft Robert gent 643256 643256 Pulvertoft, Robert, of Whaplode, Lincs, gent 0
4186665 2090822 2090822 defendant Pulvertoft Robert gent 643256 643256 Pulvertoft, Robert, of Whaplode, Lincs, gent 0
4186667 2090823 2090823 defendant Pulvertoft Thomas gent 643256 643256 Pulvertoft, Thomas, of Whaplode, Lincs, gent 0
4186669 2090824 2090824 defendant Pulvertoft Thomas gent 643256 643256 Pulvertoft, Thomas, of Whaplode, Lincs, gent 0
4215733 2100999 2100999 defendant Smythe William yeoman 643256 643256 Smythe, William, of Whaplode, Lincs, yeoman 1
4215740 2101002 2101002 defendant Smythe William gent 643256 643256 Smythe, William, of Whaplode, Lincs, gent 0
4215743 2101003 2101003 defendant Stanhope William gent 643256 643256 Stanhope, William, of Whaplode, Lincs, gent 0
4669425 2256143 2256143 defendant Lyndesley John draper 643256 643256 Lyndesley, John, of Whaplode, Lincs, draper 4
4734698 2276007 2276007 defendant Hakebeche Robert   643256 643256 Hakebeche, Robert, of Whaplode, Lincs, knight 0
4734700 2276008 2276008 defendant Hakebeche Robert   643256 643256 Hakebeche, Robert, of Whaplode, Lincs, knight 0
4740497 2277734 2277734 defendant Augood or Angood William   643256 643256 Augood or Angood, William, of Whaplode, Lincs, vicar 1
4789743 2292861 2292861 defendant Wyveleseye or Wyneleseye William husbandman 643256 643256 Wyveleseye or Wyneleseye, William, of Whaplode, Lincs, husbandman 1
4841167 2308773 2308773 defendant Porter John gent 643256 643256 Porter, John, of Whaplode, Lincs, gent 0
4841181 2308779 2308779 defendant Porter John gent 643256 643256 Porter, John, of Whaplode, Lincs, gent 0
5061773 2375116 2375116 defendant Akke Simon husbandman 643256 643256 Akke, Simon, of Whaplode, Lincs, husbandman 0
5066612 2376539 2376539 defendant Coker John husbandman 643256 643256 Coker, John, of Whaplode, Lincs, husbandman 1
5088094 2382895 2382895 defendant Cawod Joan widow 643256 643256 (Cawod, Joan, of Whaplode, Lincs, widow 1
5108237 2388841 2388841 defendant Strottar John husbandman 643256 643256 Strottar, John, of Whaplode, Lincs, husbandman 0
5186942 2411920 2411920 defendant Shelford John fisherman 643256 643256 Shelford, John, of Whaplode, Lincs, fisherman 0
5212299 2419338 2419338 defendant Palfreyman John husbandman 643256 643256 Palfreyman, John, of Whaplode, Lincs, husbandman 0
5244699 2428627 2428627 defendant Storme John hsbandman 643256 643256 Storme, John, of Whaplode, Lincs, hsbandman 3
5259476 2433085 2433085 defendant Pynchebek Gilbert gent 643256 643256 Pynchebek, Gilbert, of Whaplode, Lincs, gent 0
5327115 2453186 2453186 defendant Fyssher Richard husbandman 643256 643256 Fyssher, Richard, of Whaplode, Lincs, husbandman 3
5563261 2523851 2523851 defendant Alen William butcher 643256 643256 Alen, William, of Whaplode, Lincs, butcher 0
5575220 2527340 2527340 defendant Skarlet Robert yeoman 643256 643256 Skarlet, Robert, of Whaplode, Lincs, yeoman 1
5625829 2552025 2552025 defendant Goodhosbond Gilbert   643256 643256 Goodhosbond, Gilbert, of Whaplode, Lincs, coverlet weaver 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);