names

31 rows where place_id = 606488

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654945 1911808 1911808 plaintiff Beeley Henry   606488 606488 Beeley, Henry, of Tewkysbury, abbot of the Monastery of the Blessed Mary 0
3665392 1915129 1915129 defendant Merewyk David weaver 606488 606488 (Merewyk, David, of Tewkysbury, weaver 1
3674447 1918056 1918056 plaintiff Goodman Thomas   606488 606488 Goodman, Thomas, of Tewkysbury, Glos, escheator 0
3675936 1918509 1918509 defendant Townlay Thomas goldsmith 606488 606488 Townlay, Thomas, of Tewkysbury, goldsmith 4
3709126 1929152 1929152 defendant Balys William skinner 606488 606488 Balys, William, of Tewkysbury, skinner 2
3709127 1929152 1929152 defendant Hyttys John husbandman 606488 606488 Hyttys, John, of Tewkysbury, husbandman 3
3709128 1929152 1929152 defendant Chaundeler William butcher 606488 606488 Chaundeler, William, of Tewkysbury, butcher 4
3710413 1929576 1929576 defendant Taylour William fishmonger 606488 606488 Taylour, William, of Tewkysbury, fishmonger 2
3710416 1929576 1929576 defendant Hoggys Thomas yeoman 606488 606488 (Hoggys, Thomas, of Tewkysbury, yeoman 5
3713396 1930505 1930505 defendant Bydfeld Robert innholder 606488 606488 Bydfeld, Robert, of Tewkysbury, innholder 0
3715394 1931099 1931099 defendant Tayler John yeoman 606488 606488 Tayler, John, of Tewkysbury, yeoman 0
3715395 1931099 1931099 defendant Astlyn John tailor 606488 606488 Astlyn, John, of Tewkysbury, tailor 1
3717363 1931713 1931713 defendant Townley Thomas goldsmith 606488 606488 Townley, Thomas, of Tewkysbury, goldsmith 0
3752867 1942820 1942820 defendant Comyn Robert gent 606488 606488 Comyn, Robert, of Tewkysbury, gent 1
3772221 1948999 1948999 defendant Byttfeld Robert innholder 606488 606488 Byttfeld, Robert, of Tewkysbury, innholder 0
3800672 1958123 1958123 plaintiff Lyttelton Anthony gent 606488 606488 Lyttelton, Anthony, of Tewkysbury, gent 0
3809894 1960979 1960979 defendant Ordewey Robert butcher 606488 606488 Ordewey, Robert, of Tewkysbury, butcher 0
3819241 1963906 1963906 defendant Slaughter Christopher baker 606488 606488 Slaughter, Christopher, of Tewkysbury, baker 0
3866722 1979104 1979104 defendant Astlen John tailor 606488 606488 Astlen, John, of Tewkysbury, tailor 0
3868180 1979595 1979595 defendant Becke Henry butcher 606488 606488 Becke, Henry, of Tewkysbury, butcher 0
3893820 1988154 1988154 defendant Parkyns Thomas yeoman 606488 606488 Parkyns, Thomas, of Tewkysbury, yeoman 0
3922389 1997805 1997805 defendant Bodye Kenelm shoemaker 606488 606488 Bodye, Kenelm, of Tewkysbury, shoemaker 0
3947864 2006316 2006316 defendant Gase John yeoman 606488 606488 Gase, John, of Tewkysbury, yeoman 0
4633897 2241452 2241452 plaintiff Wey Richard   606488 606488 Wey, Richard, of Tewkysbury, 0
4650623 2246202 2246202 plaintiff Wy Richard   606488 606488 Wy, Richard, of Tewkysbury, bell maker 0
4951100 2342307 2342307 plaintiff Plommer John   606488 606488 Plommer, John, of Tewkysbury 0
5386827 2471298 2471298 defendant Avenaunt Richard yeoman 606488 606488 Avenaunt, Richard, of Tewkysbury, yeoman 0
5389822 2472152 2472152 defendant Broke William mercer 606488 606488 Broke, William, of Tewkysbury, mercer 0
5389824 2472152 2472152 defendant Glover William glover 606488 606488 Glover, William, of Tewkysbury, glover 2
5593004 2532803 2532803 plaintiff Wye William (legal representative) 606488 606488 Wye, William, of Tewkysbury, executor of 0
5593009 2532804 2532804 plaintiff Wye William (legal representative) 606488 606488 Wye, William, of Tewkysbury, executor 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);