names

36 rows where place_id = 593031

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610134 1870833 1870833 defendant Johnson Geoffrey yeoman 593031 593031 Johnson, Geoffrey, of Magna Totnes, yeoman 0
3610264 1870868 1870868 defendant Cosby Walter merchant 593031 593031 Cosby, Walter, of Magna Totnes, merchant 0
3610305 1870878 1870878 defendant William John   593031 593031 William, John, of Magna Totnes, "helyer" 0
3610774 1871034 1871034 defendant Prendergest Thomas goldsmith 593031 593031 Prendergest, Thomas, of Magna Totnes, goldsmith 0
3612890 1871680 1871680 defendant Passemer Thomas yeoman 593031 593031 Passemer, Thomas, of Magna Totnes, yeoman 0
3615801 1872583 1872583 defendant Peleton Richard merchant 593031 593031 Peleton, Richard, of Magna Totnes, merchant 0
3618780 1873490 1873490 defendant Spycer William merchant 593031 593031 Spycer, William, of Magna Totnes, merchant 0
3625605 1875541 1875541 defendant Laure John yeoman 593031 593031 Laure, John, of Magna Totnes, yeoman 0
3625606 1875541 1875541 defendant Ferres John yeoman 593031 593031 Ferres, John, of Magna Totnes, yeoman 1
3625759 1875595 1875595 defendant Pomerey Agnes widow 593031 593031 Pomerey, Agnes, of Magna Totnes, widow 0
3644222 1908624 1908624 defendant Freynd John yeoman 593031 593031 Freynd, John, of Magna Totnes, yeoman 0
3644228 1908626 1908626 defendant Freynd John yeoman 593031 593031 Freynd, John, of Magna Totnes, yeoman 0
3675307 1918319 1918319 defendant Voysy alias Vayse John merchant 593031 593031 Voysy alias Vayse, John, of Magna Totnes, merchant 0
3683609 1921004 1921004 defendant Prendergest John gent 593031 593031 Prendergest, John, of Magna Totnes, gent 2
3705778 1928088 1928088 defendant Veyse John merchant 593031 593031 Veyse, John, of Magna Totnes, merchant 2
3708768 1929038 1929038 defendant Garlond Blanche widow 593031 593031 Garlond, Blanche, of Magna Totnes, widow 1
3781693 1952017 1952017 defendant Voyse John mercer 593031 593031 Voyse, John, of Magna Totnes, mercer 1
3872633 1981062 1981062 defendant Sevar Thomas merchant 593031 593031 Sevar, Thomas,of Magna Totnes, merchant 0
3945359 2005461 2005461 defendant Nosworthy Nicholas merchant 593031 593031 Nosworthy, Nicholas, of Magna Totnes, merchant 0
4002343 2025613 2025613 defendant Harrye peter husbandman 593031 593031 Harrye, peter, of Magna Totnes, or of Ratterye, Devon, husbandman 1
5106969 2388469 2388469 defendant Monlyssh or Moulyssh Richard tailor 593031 593031 Monlyssh or Moulyssh, Richard, of Magna Totnes, tailor 4
5297273 2444194 2444194 defendant Holman John merchant 593031 593031 Holman, John, of Magna Totnes, merchant 0
5312396 2448740 2448740 defendant Shilston John gent 593031 593031 Shilston, John, of Magna Totnes, gent 0
5326994 2453152 2453152 defendant Shilston John gent 593031 593031 Shilston, John, of Magna Totnes, gent 0
5479539 2498891 2498891 defendant Hokemore William mercer 593031 593031 Hokemore, William, of Magna Totnes, mercer 0
5479541 2498891 2498891 defendant Cosby Walter mercer 593031 593031 Cosby, Walter, of Magna Totnes, mercer 2
5479542 2498891 2498891 defendant Lamborne John yeoman 593031 593031 Lamborne, John, of Magna Totnes, yeoman 3
5490301 2501986 2501986 defendant Colyngton William, junior husbandman 593031 593031 Colyngton, William, junior, of Magna Totnes, husbandman 0
5495143 2503445 2503445 defendant Cole John yeoman 593031 593031 Cole, John, of Magna Totnes, yeoman 0
5521889 2511660 2511660 defendant Peleton alias Pelyngton Richard yeoman or merchant 593031 593031 Peleton alias Pelyngton, Richard, of Magna Totnes, yeoman or merchant 0
5522101 2511728 2511728 defendant Holman John, junior merchant 593031 593031 Holman, John, junior, of Magna Totnes, merchant 0
5533890 2515142 2515142 defendant Pomerey Agnes widow 593031 593031 Pomerey, Agnes, of Magna Totnes, widow 0
5550562 2520186 2520186 defendant Vyn John laborer 593031 593031 Vyn, John, of Magna Totnes, laborer 5
5575459 2527415 2527415 defendant John John gent 593031 593031 John, John, of Magna Totnes, gent 0
5580700 2529044 2529044 defendant Shute John weaver 593031 593031 Shute, John, of Magna Totnes, weaver 0
5580701 2529044 2529044 defendant Shute Joan widow 593031 593031 Shute, Joan, of Magna Totnes, widow 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);