names

41 rows where place_id = 588117

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593430 1865578 1865578 defendant Pye John yeoman 588117 588117 Pye, John, of Wrentham, Suff, yeoman 0
3622710 1874631 1874631 defendant Lee John yeoman 588117 588117 Lee, John, of Wrentham, Suff, yeoman 1
3655976 1912120 1912120 defendant Burman John yeoman 588117 588117 Burman, John, of Wrentham, Suff, yeoman 0
3664338 1914795 1914795 plaintiff Robynson Cecily (legal representative) 588117 588117 Robynson, Cecily, of Wrentham, Suff, widow, executor of 0
3664340 1914795 1914795 defendant Burman John yeoman 588117 588117 Burman, John, of Wrentham, Suff, yeoman 0
3758987 1944800 1944800 defendant Jekell Thomas husbandman or thatcher 588117 588117 Jekell, Thomas, of Wrentham, Suff, husbandman or thatcher 0
3759003 1944802 1944802 defendant Graunte John husbandman 588117 588117 (Graunte, John, of Wrentham, Suff, husbandman 4
3772660 1949140 1949140 defendant Chowt William gent 588117 588117 Chowt, William, of Wrentham, Suff, gent 2
3794396 1956125 1956125 defendant Thewys John husbandman 588117 588117 Thewys, John, of Wrentham, Suff, husbandman 0
3829802 1967213 1967213 defendant Manby Thomas husbandman 588117 588117 Manby, Thomas, of Wrentham, Suff, husbandman 0
3871602 1980742 1980742 defendant Chowt William gent 588117 588117 Chowt, William, of Wrentham, Suff, gent 1
3895276 1988628 1988628 defendant Smyth Henry yeoman 588117 588117 Smyth, Henry, of Wrentham, Suff, yeoman 1
3903594 1991431 1991431 defendant Canon Robert yeoman 588117 588117 Canon, Robert, of Wrentham, Suff, yeoman 0
3903596 1991432 1991432 defendant Canon Robert yeoman 588117 588117 Canon, Robert, of Wrentham, Suff, yeoman 0
3903606 1991437 1991437 defendant Smyth Henry yeoman 588117 588117 Smyth, Henry, of Wrentham, Suff, yeoman 0
3903608 1991438 1991438 defendant Smyth Henry yeoman 588117 588117 Smyth, Henry, of Wrentham, Suff, yeoman 0
3928706 1999937 1999937 defendant York Edward yeoman 588117 588117 York, Edward, of Wrentham, Suff, yeoman 0
3938950 2003360 2003360 defendant Smyth Robert husbandman 588117 588117 Smyth, Robert, of Wrentham, Suff, husbandman 2
3950816 2007354 2007354 defendant Gardiner Robert gent 588117 588117 Gardiner, Robert, of Wrentham, Suff, gent 2
3982652 2018564 2018564 defendant Bolyant Edward yeoman 588117 588117 Bolyant, Edward, of Wrentham, Suff, yeoman 2
3997626 2023903 2023903 plaintiff Edmund William gent 588117 588117 Edmund, William, of Wrentham, Suff, gent 0
4050363 2042561 2042561 defendant Cannon alias Iresh Richard husbandman 588117 588117 Cannon alias Iresh, Richard, of Wrentham, Suff, husbandman 0
4050366 2042562 2042562 defendant Cannon alias Iresh Richard husbandman 588117 588117 Cannon alias Iresh, Richard, of Wrentham, Suff, husbandman 0
4061742 2046600 2046600 defendant Gardiner Robert gent 588117 588117 Gardiner, Robert, of Wrentham, Suff, gent 1
4075832 2051655 2051655 defendant Gardyner Robert gent 588117 588117 Gardyner, Robert, of Wrentham, Suff, gent 1
4128215 2070375 2070375 defendant Butt Thomas husbandman 588117 588117 Butt, Thomas, of Wrentham, Suff, husbandman 1
4132051 2071776 2071776 defendant Gardener Robert gent 588117 588117 Gardener, Robert, of Wrentham, Suff, gent 0
4132055 2071777 2071777 defendant Gardener Robert gent 588117 588117 Gardener, Robert, of Wrentham, Suff, gent 0
4162443 2082425 2082425 defendant Gardener Timothy gent 588117 588117 Gardener, Timothy, of Wrentham, Suff, gent 0
4162445 2082426 2082426 defendant Gardyner Robert gent 588117 588117 Gardyner, Robert, of Wrentham, Suff, gent 0
4163023 2082603 2082603 defendant Gardyner Robert yeoman 588117 588117 Gardyner, Robert, of Wrentham, Suff, yeoman 3
4176089 2087114 2087114 defendant Butt Thomas husbandman 588117 588117 Butt, Thomas, of Wrentham, Suff, husbandman 0
4325294 2138839 2138839 defendant Tebold Thomas yeoman 588117 588117 Tebold, Thomas, of Wrentham, Suff, yeoman 3
4357892 2150001 2150001 defendant Bell or Bett Anthony butcher 588117 588117 Bell or Bett, Anthony, of Wrentham, Suff, butcher 2
4801401 2296624 2296624 defendant Berde Robert husbandman 588117 588117 Berde, Robert, of Wrentham, Suff, husbandman 0
4801427 2296627 2296627 defendant Berde Robert husbandman 588117 588117 Berde, Robert, of Wrentham, Suff, husbandman 0
5391120 2472532 2472532 defendant Wylde Robert husbandman 588117 588117 Wylde, Robert, of Wrentham, Suff, husbandman 2
5434403 2485229 2485229 defendant Wylde Robert husbandman 588117 588117 Wylde, Robert, of Wrentham, Suff, husbandman 3
5434408 2485230 2485230 defendant Wylde Robert husbandman 588117 588117 Wylde, Robert, of Wrentham, Suff, husbandman 3
5605466 2536590 2536590 defendant Multon John yeoman 588117 588117 Multon, John, of Wrentham, Suff, yeoman 0
5605468 2536591 2536591 defendant Multon John yeoman 588117 588117 Multon, John, of Wrentham, Suff, yeoman 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);