names

74 rows where place_id = 587981

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593023 1865445 1865445 defendant Spycer John mercer 587981 587981 Spycer, John, of Tetbury, mercer 2
3595050 1866084 1866084 defendant Baker John weaver 587981 587981 Baker, John, of Tetbury, weaver 3
3605596 1869415 1869415 defendant Spycer John yeoman 587981 587981 (Spycer, John, of Tetbury, yeoman 1
3605597 1869415 1869415 defendant Ferrour Eleanor widow 587981 587981 Ferrour, Eleanor, of Tetbury, widow 2
3608400 1870286 1870286 defendant Hurne Thomas gent 587981 587981 Hurne, Thomas, of Tetbury, gent 0
3631625 1904706 1904706 defendant Saunders John laborer 587981 587981 Saunders, John, of Tetbury, laborer 0
3660002 1913389 1913389 defendant Somerby Richard hosier 587981 587981 Somerby, Richard, of Tetbury, hosier 0
3673414 1917704 1917704 defendant Heydon John yeoman 587981 587981 Heydon, John, of Tetbury, yeoman 0
3677415 1918988 1918988 defendant Hykkys Thomas clothier 587981 587981 Hykkys, Thomas, of Tetbury, clothier 0
3682599 1920661 1920661 defendant Halyday Thomas husbandman 587981 587981 Halyday, Thomas, of Tetbury, husbandman 1
3692133 1923709 1923709 plaintiff Hykkes Thomas clothier 587981 587981 Hykkes, Thomas, of Tetbury, clothier 0
3693918 1924301 1924301 defendant Dene Thomas Kendalman 587981 587981 Dene, Thomas, of Tetbury, yeoman, Kendalman 0
3706338 1928269 1928269 defendant Bowre Richard butcher 587981 587981 Bowre, Richard, of Tetbury, butcher 1
3707904 1928768 1928768 defendant Dene Thomas kendalman 587981 587981 Dene, Thomas, of Tetbury, yeoman, kendalman 0
3715099 1931019 1931019 defendant Lucas Thomas weaver 587981 587981 Lucas, Thomas, of Tetbury, weaver 3
3740676 1938946 1938946 defendant Hykkys Thomas clothier 587981 587981 Hykkys, Thomas, of Tetbury, clothier 0
3747144 1941024 1941024 defendant Hikke Thomas clothier 587981 587981 Hikke, Thomas, of Tetbury, clothier 0
3764547 1946570 1946570 defendant Estecourte Thomas gent 587981 587981 (Estecourte, Thomas, of Tetbury, gent 4
3768635 1947838 1947838 defendant Lane Thomas   587981 587981 Lane, Thomas, of Tetbury, wax chandler 0
3794865 1956262 1956262 defendant Hyckys Thomas clothier 587981 587981 Hyckys, Thomas, of Tetbury, clothier 0
3894767 1988456 1988456 plaintiff Savage John chapman 587981 587981 Savage, John, of Tetbury, chapman 0
3903422 1991369 1991369 defendant Darke Thomas husbandman 587981 587981 Darke, Thomas, of Tetbury, husbandman 0
3931682 2000897 2000897 defendant Grene Robert yeoman 587981 587981 Grene, Robert, of Tetbury, yeoman 0
3997188 2023764 2023764 defendant Godden William yeoman 587981 587981 Godden, William, of Tetbury, yeoman 0
4138367 2074086 2074086 defendant Brownynge William husbandman 587981 587981 Brownynge, William, of Tetbury, husbandman 0
4190188 2092074 2092074 defendant Webbe Walter clothman 587981 587981 Webbe, Walter, of Tetbury, clothman 1
4207717 2098260 2098260 defendant Evance John clerk 587981 587981 Evance, John, of Tetbury, clerk 0
4233958 2107401 2107401 defendant Sanforde John weaver 587981 587981 Sanforde, John, of Tetbury, weaver 0
4321075 2137466 2137466 defendant Seede John gent 587981 587981 Seede, John, of Tetbury, gent 1
4389225 2161025 2161025 defendant Tanner Walter yeoman 587981 587981 Tanner, Walter, of Tetbury, yeoman 0
4390073 2161300 2161300 defendant Tanner Walter yeoman 587981 587981 Tanner, Walter, of Tetbury, yeoman 0
4522597 2207406 2207406 defendant Baker Henry   587981 587981 Baker, Henry, of Tetbury 0
4701605 2265896 2265896 plaintiff Gilmyn Thomas   587981 587981 Gilmyn, Thomas, of Tetbury, ironmonger, burgess of Bristol 0
4803337 2297236 2297236 plaintiff Barnard Nicholas   587981 587981 Barnard, Nicholas, of Tetbury 0
4887071 2322798 2322798 defendant Redehode Thomas husbandman 587981 587981 Redehode, Thomas, of Tetbury, husbandman 1
4946714 2340974 2340974 defendant Harold Nicholas yeoman 587981 587981 Harold, Nicholas, of Tetbury, yeoman 0
4964009 2346148 2346148 defendant Onewyn William chapman 587981 587981 Onewyn, William, of Tetbury, chapman 0
5002010 2357488 2357488 defendant Stevenes Richard yeoman 587981 587981 Stevenes, Richard, of Tetbury, yeoman 0
5008620 2359418 2359418 defendant Unwyn William yeoman 587981 587981 Unwyn, William, of Tetbury, yeoman 0
5125650 2393991 2393991 defendant Carter John ostiller 587981 587981 Carter, John, of Tetbury, ostiller 0
5178995 2409581 2409581 defendant Carter John ostler 587981 587981 Carter, John, of Tetbury, ostler 0
5254002 2431372 2431372 defendant Mone Richard barber 587981 587981 Mone, Richard, of Tetbury, barber 1
5254003 2431372 2431372 defendant Burgeys Richard husbandman 587981 587981 Burgeys, Richard, of Tetbury, husbandman 2
5254004 2431372 2431372 defendant Mone Thomas husbandman 587981 587981 Mone, Thomas, of Tetbury, husbandman 3
5264794 2434749 2434749 defendant Baker Richard ostler 587981 587981 Baker, Richard, of Tetbury, ostler 0
5271669 2436812 2436812 defendant Redhode Thomas husbandman 587981 587981 Redhode, Thomas, of Tetbury, husbandman 0
5286235 2440984 2440984 defendant Reson William clerk 587981 587981 Reson, William, of Tetbury, clerk 2
5314467 2449354 2449354 defendant Wey John laborer 587981 587981 Wey, John, of Tetbury, mason: Wey, William, of Strode, laborer 1
5314471 2449355 2449355 defendant Wey John   587981 587981 Wey, John, of Tetbury, mason 1
5353534 2461179 2461179 defendant Hachell John yeoman 587981 587981 Hachell, John, of Tetbury, yeoman 5
5354518 2461488 2461488 defendant Tanner Henry draper 587981 587981 Tanner, Henry, of Tetbury, draper 1
5361168 2463521 2463521 defendant Tanner Henry tanner 587981 587981 Tanner, Henry, of Tetbury, tanner 0
5382207 2469967 2469967 defendant Willies or Halle Robert draper 587981 587981 Willies or Halle, Robert, of Tetbury, draper 0
5459583 2492780 2492780 plaintiff Herne Walter gent 587981 587981 Herne, Walter, of Tetbury, gent 0
5471307 2496356 2496356 plaintiff Herne Walter gent 587981 587981 Herne, Walter, of Tetbury, gent 0
5471309 2496357 2496357 plaintiff Herne Walter gent 587981 587981 Herne, Walter, of Tetbury, gent 0
5496277 2503787 2503787 defendant Hechyll John yeoman 587981 587981 Hechyll, John, of Tetbury, yeoman 1
5504505 2506330 2506330 defendant Combe John weaver 587981 587981 Combe, John, of Tetbury, weaver 0
5534833 2515434 2515434 defendant Davys George gent 587981 587981 Davys, George, of Tetbury, gent 0
5540878 2517274 2517274 defendant Wodell Thomas shoemaker 587981 587981 Wodell, Thomas, of Tetbury, shoemaker 0
5540879 2517274 2517274 defendant Hethfeld Leonard weaver 587981 587981 Hethfeld, Leonard, of Tetbury, weaver 1
5540881 2517274 2517274 defendant Sprotte William weaver 587981 587981 Sprotte, William, of Tetbury, weaver 3
5540882 2517274 2517274 defendant Hoper Thomas weaver 587981 587981 Hoper, Thomas, of Tetbury, weaver 4
5540885 2517275 2517275 defendant Wodell Thomas shoemaker 587981 587981 Wodell, Thomas, of Tetbury, shoemaker 0
5540886 2517275 2517275 defendant Hethfeld Leonard weaver 587981 587981 Hethfeld, Leonard, of Tetbury, weaver 1
5540888 2517275 2517275 defendant Sprotte William weaver 587981 587981 Sprotte, William, of Tetbury, weaver 3
5540889 2517275 2517275 defendant Hoper Thomas weaver 587981 587981 Hoper, Thomas, of Tetbury, weaver 4
5542522 2517784 2517784 defendant Hardyng John clothman 587981 587981 Hardyng, John, of Tetbury, clothman 0
5549988 2520033 2520033 defendant Spratte William yeoman 587981 587981 Spratte, William, of Tetbury, yeoman 0
5568572 2525360 2525360 defendant Savage John mercer 587981 587981 Savage, John, of Tetbury, mercer 0
5569592 2525673 2525673 defendant Payne John yeoman 587981 587981 Payne, John, of Tetbury, yeoman 0
5570299 2525878 2525878 defendant Sprote William weaver 587981 587981 Sprote, William, of Tetbury, weaver 0
5587037 2530974 2530974 defendant Adams Henry (legal representative) 587981 587981 Adams, Henry, of Tetbury, clothman, executors of 0
5587042 2530975 2530975 defendant Adams Henry (legal representative) 587981 587981 Adams, Henry, of Tetbury, clothman, executors of 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);