names

28 rows where place_id = 590656

✎ 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
3601905 1868251 1868251 defendant Monmoweth Thomas husbandman 590656 590656 Monmoweth, Thomas, of Tenbury, husbandman 0
3618477 1873404 1873404 defendant Maylard Roger tailor 590656 590656 Maylard, Roger, of Tenbury, tailor 2
3652762 1911184 1911184 defendant Mathewe John laborer 590656 590656 Mathewe, John, of Tenbury, laborer 1
3652766 1911185 1911185 defendant Mathewe Thomas laborer 590656 590656 Mathewe, Thomas, of Tenbury, laborer 1
3680511 1919986 1919986 defendant Norton John husbandman 590656 590656 Norton, John, of Tenbury, husbandman 1
3702783 1927144 1927144 defendant Mathewes John fuller 590656 590656 Mathewes, John, of Tenbury, fuller 0
3720572 1932715 1932715 defendant Benwyn David cordwainer 590656 590656 Benwyn, David, of Tenbury, cordwainer 1
3973685 2015369 2015369 defendant Cooke Richard yeoman 590656 590656 Cooke, Richard, of Tenbury, or of Boraston, Salop, yeoman 0
3973800 2015406 2015406 defendant Lane William yeoman 590656 590656 Lane, William, of Tenbury, yeoman 1
3973801 2015406 2015406 defendant Hyll Richard yeoman 590656 590656 Hyll, Richard, of Tenbury, yeoman 2
4037492 2038071 2038071 plaintiff Kerrye Richard weaver 590656 590656 Kerrye, Richard, of Tenbury, weaver 0
4053355 2043576 2043576 defendant Mapp Edward husbandman 590656 590656 Mapp, Edward, of Tenbury, husbandman 0
4053356 2043576 2043576 defendant Mapp Kenelm husbandman 590656 590656 Mapp, Kenelm, of Tenbury, husbandman 1
4053357 2043576 2043576 defendant Hall Thomas tailor 590656 590656 Hall, Thomas, of Tenbury, tailor 2
4069845 2049499 2049499 defendant Lane Thomas husbandman 590656 590656 Lane, Thomas, of Tenbury, husbandman 0
4074188 2051067 2051067 defendant Lane Thomas   590656 590656 Lane, Thomas, of Tenbury, of husbandman 0
4089056 2056380 2056380 defendant Coungley Henry husbandman 590656 590656 Coungley, Henry, of Tenbury, husbandman 1
4089057 2056380 2056380 defendant Taylor Richard husbandman 590656 590656 Taylor, Richard, of Tenbury, husbandman 2
4096547 2059094 2059094 defendant Launde James husbandman 590656 590656 Launde, James, of Tenbury, husbandman 1
4096548 2059094 2059094 defendant Blackwaye Richard husbandman 590656 590656 Blackwaye, Richard, of Tenbury, husbandman 2
4143374 2075846 2075846 defendant Tonerton or Toverton Edmund yeoman 590656 590656 Tonerton or Toverton, Edmund, of Tenbury, yeoman 1
4164253 2083021 2083021 defendant Hoult or Holte Roger yeoman 590656 590656 Hoult or Holte, Roger, of Tenbury, yeoman 1
4165031 2083276 2083276 defendant Holte Roger yeoman 590656 590656 Holte, Roger, of Tenbury, yeoman 0
4189002 2091638 2091638 defendant Holte Roger yeoman 590656 590656 Holte, Roger, of Tenbury, yeoman 2
4850405 2311584 2311584 defendant Balle John laborer 590656 590656 Balle, John, of Tenbury, son of Walter, laborer 0
4919781 2332692 2332692 defendant Dyke John husbandman 590656 590656 Dyke, John, of Tenbury, husbandman 2
5092291 2384125 2384125 defendant Leche John yeoman 590656 590656 Leche, John, of Tenbury, yeoman 2
5137224 2397402 2397402 defendant White Roger corser 590656 590656 White, Roger, of Tenbury, corser 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);