names

44 rows where place_id = 654518

✎ 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
3667430 1915754 1915754 defendant Banham or Baynham Richard   654518 654518 Banham or Baynham, Richard, of Tavistock, abbot of the Abbey of Saint Mary and Saint Rumon 0
3932703 2001237 2001237 plaintiff Fytz John esq 654518 654518 Fytz, John, of Tavistock, esq 0
4058269 2045342 2045342 plaintiff Cervington Agnes (legal representative) 654518 654518 Cervington, Agnes, of Tavistock, widow, administrator of 0
4058271 2045342 2045342 defendant Twygge Richard yeoman 654518 654518 Twygge, Richard, of Tavistock, yeoman 0
4058272 2045343 2045343 plaintiff Cervyngton John (legal representative) 654518 654518 Cervyngton, John, of Tavistock, esq, administrator of 0
4107309 2062904 2062904 defendant Hearle Humphrey husbandman 654518 654518 Hearle, Humphrey, of Tavistock, husbandman 2
4214844 2100693 2100693 defendant Kedlye Thomas   654518 654518 Kedlye, Thomas, of Tavistock, groom 2
4378405 2157349 2157349 defendant Mohun Charles gent 654518 654518 Mohun, Charles, of Tavistock, gent 0
4398172 2163968 2163968 defendant Raymonde William cutler 654518 654518 Raymonde, William, of Tavistock, or of Lyskerd, Cornw, cutler 0
4398173 2163968 2163968 defendant Raymonde John saddler 654518 654518 Raymonde, John, of Tavistock, saddler 1
4636757 2242315 2242315 defendant Coldewyll John plumber 654518 654518 Coldewyll, John, of Tavistock, plumber 0
4695970 2264226 2264226 defendant Hopkyn John skinner 654518 654518 Hopkyn, John, of Tavistock, skinner 0
4725687 2273321 2273321 defendant Honychurche Robert husbandman 654518 654518 Honychurche, Robert, of Tavistock, husbandman 0
4757137 2282602 2282602 defendant Bodyer William   654518 654518 Bodyer, William, of Tavistock 4
4772352 2287318 2287318 defendant Gerard Richard draper 654518 654518 Gerard, Richard, of Tavistock, draper 0
4772425 2287343 2287343 defendant Virge John merchant 654518 654518 Virge, John, of Tavistock, merchant 0
4772790 2287458 2287458 defendant Virgo John husbandman 654518 654518 Virgo, John, of Tavistock, husbandman 0
4772793 2287459 2287459 defendant Virgo John husbandman 654518 654518 Virgo, John, of Tavistock, husbandman 0
4843893 2309608 2309608 defendant Julkyn John gent 654518 654518 Julkyn, John, of Tavistock, gent 0
4844994 2309951 2309951 defendant Cadele John mercer 654518 654518 Cadele, John, of Tavistock, mercer 0
4851707 2311968 2311968 defendant Shepyn Richard butcher 654518 654518 Shepyn, Richard, of Tavistock, butcher 0
4991404 2354314 2354314 defendant fitz John gent 654518 654518 fitz, John, of Tavistock, gent 0
4992202 2354561 2354561 defendant Walshe John smith 654518 654518 Walshe, John, of Tavistock, smith 0
4992206 2354562 2354562 defendant Walshe John smith 654518 654518 Walshe, John, of Tavistock, smith 0
4993515 2354933 2354933 defendant Stacy John husbandman 654518 654518 Stacy, John, of Tavistock, husbandman 0
5145188 2399736 2399736 defendant Wotton John shoemaker 654518 654518 Wotton, John, of Tavistock, shoemaker 1
5152609 2401905 2401905 plaintiff Hill Richard shoemaker 654518 654518 Hill, Richard, of Tavistock, shoemaker 0
5152611 2401905 2401905 defendant Ayssheford William mercer 654518 654518 (Ayssheford, William, of Tavistock, mercer 1
5154973 2402610 2402610 defendant Wynter John husbandman 654518 654518 Wynter, John, of Tavistock, husbandman 0
5165746 2405726 2405726 defendant Wotton John shoemaker 654518 654518 Wotton, John, of Tavistock, shoemaker 1
5167491 2406222 2406222 defendant Drake Thomas yeoman 654518 654518 Drake, Thomas, of Tavistock, yeoman Hill, Richard, of Tavistock, yeoman 1
5168750 2406588 2406588 defendant Freyspound William merchant 654518 654518 Freyspound, William, of Tavistock, merchant 0
5178516 2409428 2409428 defendant Gylle Walter smith 654518 654518 Gylle, Walter, of Tavistock, smith 0
5182805 2410722 2410722 defendant Freyspond William merchant 654518 654518 Freyspond, William, of Tavistock, merchant 2
5183042 2410784 2410784 defendant Ware Nicholas shoemaker 654518 654518 (Ware, Nicholas, of Tavistock, shoemaker 4
5191168 2413157 2413157 defendant Lybbe Thomas tanner 654518 654518 Lybbe, Thomas, of Tavistock, tanner 2
5191303 2413194 2413194 defendant Soper William husbandman 654518 654518 Soper, William, of Tavistock, husbandman 0
5191304 2413194 2413194 defendant Fee Michael tanner 654518 654518 Fee, Michael, of Tavistock, tanner 1
5191305 2413194 2413194 defendant Lybbe Thomas   654518 654518 Lybbe, Thomas, of Tavistock 2
5203695 2416831 2416831 defendant Ware Nicholas shoemaker 654518 654518 (Ware, Nicholas, of Tavistock, shoemaker 2
5203700 2416832 2416832 defendant Ware Nicholas shoemaker 654518 654518 (Ware, Nicholas, of Tavistock, shoemaker 2
5210324 2418747 2418747 defendant Tayle John hosier 654518 654518 Tayle, John, of Tavistock, hosier 0
5210329 2418749 2418749 defendant Shynner John clerk 654518 654518 Shynner, John, of Tavistock, clerk 0
5432399 2484661 2484661 defendant Webbe William merchant 654518 654518 Webbe, William, of Tavistock, merchant 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);