names

40 rows where place_id = 598067

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630985 1904511 1904511 defendant Tonge John husbandman 598067 598067 Tonge, John, of Holyngborne, husbandman 0
3692591 1923869 1923869 defendant Penneherst Thomas yeoman 598067 598067 Penneherst, Thomas, of Holyngborne, yeoman 0
3694990 1924645 1924645 defendant Reade William yeoman 598067 598067 Reade, William, of Holyngborne, yeoman 2
3708971 1929099 1929099 defendant Reade William yeoman 598067 598067 Reade, William, of Holyngborne, yeoman 1
3713808 1930618 1930618 defendant Pyx John husbandman 598067 598067 Pyx, John, of Holyngborne, husbandman 0
3746053 1940669 1940669 defendant Atwode Lawrence husbandman 598067 598067 Atwode, Lawrence, of Holyngborne, husbandman 0
3752748 1942788 1942788 defendant Mayne Robert husbandman 598067 598067 Mayne, Robert, of Holyngborne, husbandman 3
3753182 1942934 1942934 defendant Phelypp John collier 598067 598067 Phelypp, John, of Holyngborne, collier 2
3759153 1944850 1944850 defendant Atwode Lawrence husbandman 598067 598067 Atwode, Lawrence, of Holyngborne, husbandman 0
3763746 1946307 1946307 defendant Rede William husbandman 598067 598067 Rede, William, of Holyngborne, husbandman 0
3820026 1964144 1964144 defendant Rede William yeoman 598067 598067 Rede, William, of Holyngborne, yeoman 0
3891850 1987527 1987527 defendant Nott Richard weaver 598067 598067 Nott, Richard, of Holyngborne, weaver 1
3912774 1994605 1994605 defendant Fylcote John husbandman 598067 598067 Fylcote, John, of Holyngborne, husbandman 0
4570700 2222404 2222404 defendant Bromfeld William   598067 598067 Bromfeld, William, of Holyngborne 1
4654760 2247368 2247368 defendant Vannere Thomas husbandman 598067 598067 Vannere, Thomas, of Holyngborne, husbandman 1
4668131 2255740 2255740 defendant Byddesden Pater husbandman 598067 598067 Byddesden, Pater, of Holyngborne, husbandman 3
4668132 2255740 2255740 defendant Lambe Richard husbandman 598067 598067 Lambe, Richard, of Holyngborne, husbandman 4
4669192 2256069 2256069 defendant dygon Richard husbandman 598067 598067 dygon, Richard, of Holyngborne, husbandman 1
4849789 2311405 2311405 defendant Sawecer Richard husbandman 598067 598067 Sawecer, Richard, of Holyngborne, husbandman 0
5026248 2364568 2364568 defendant Clerke William husbandman 598067 598067 Clerke, William, of Holyngborne, husbandman 1
5026249 2364568 2364568 defendant Halden Thomas husbandman 598067 598067 Halden, Thomas, of Holyngborne, husbandman 2
5058184 2374003 2374003 defendant atte Wode Thomas carpenter 598067 598067 atte Wode, Thomas, of Holyngborne, carpenter 0
5058186 2374003 2374003 defendant Parke Thomas wheeler 598067 598067 Parke, Thomas, of Holyngborne, wheeler 2
5118450 2391833 2391833 defendant Stokelet William husbandman 598067 598067 Stokelet, William, of Holyngborne, husbandman 0
5416768 2479930 2479930 defendant Fyssher John yeoman 598067 598067 Fyssher, John, of Holyngborne, yeoman 0
5433699 2485042 2485042 defendant Fyssher John yeoman 598067 598067 Fyssher, John, of Holyngborne, yeoman 0
5433700 2485042 2485042 defendant Lyllyndon George fuller 598067 598067 Lyllyndon, George, of Holyngborne, fuller 1
5449410 2489711 2489711 defendant (illegible) John yeoman 598067 598067 _, John, of Holyngborne, yeoman 0
5449411 2489711 2489711 defendant Lullyngdon George   598067 598067 Lullyngdon, George, of Holyngborne, 1
5461494 2493389 2493389 defendant Fyssher John yeoman 598067 598067 Fyssher, John, of Holyngborne, yeoman 0
5461495 2493389 2493389 defendant Lullyngdon George fuller 598067 598067 Lullyngdon, George, of Holyngborne, fuller 1
5463305 2493936 2493936 defendant Water John shoemaker 598067 598067 Water, John, of Holyngborne, shoemaker 0
5473118 2496916 2496916 defendant Fyssher John yeoman 598067 598067 Fyssher, John, of Holyngborne, yeoman 0
5473119 2496916 2496916 defendant Lyllyngdon George fuller 598067 598067 Lyllyngdon, George, of Holyngborne, fuller 1
5500139 2504994 2504994 defendant Philipot Robert husbandman 598067 598067 Philipot, Robert, of Holyngborne, husbandman 1
5574845 2527214 2527214 defendant Wade William, junior husbandman 598067 598067 Wade, William, junior, of Holyngborne, husbandman 0
5582699 2529657 2529657 defendant Aphowell Lewis clerk 598067 598067 Aphowell, Lewis, of Holyngborne, clerk 0
5602199 2535587 2535587 defendant Edynden Thomas butcher 598067 598067 Edynden, Thomas, of Holyngborne, butcher 1
5602759 2535742 2535742 defendant Edynden Thomas butcher 598067 598067 Edynden, Thomas, of Holyngborne, butcher 2
5603657 2536011 2536011 defendant Edynden Thomas butcher 598067 598067 Edynden, Thomas, of Holyngborne, butcher 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);