names

39 rows where place_id = 590608

✎ 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
3601778 1868214 1868214 defendant Bendish Thomas gent 590608 590608 Bendish, Thomas, of Toppesfeld, gent 0
3601782 1868215 1868215 defendant Bendysh Thomas gent 590608 590608 Bendysh, Thomas, of Toppesfeld, gent 0
3601786 1868216 1868216 defendant Bendysh Thomas gent 590608 590608 Bendysh, Thomas, of Toppesfeld, gent 0
3690128 1923071 1923071 defendant Pollard Robert husbandman 590608 590608 Pollard, Robert, of Toppesfeld, husbandman 3
3785931 1953395 1953395 defendant Roo William husbandman 590608 590608 Roo, William, of Toppesfeld, husbandman 0
3848291 1973036 1973036 defendant Purcas William husbandman 590608 590608 Purcas, William, of Toppesfeld, husbandman 0
3851948 1974200 1974200 defendant Smyth Thomas laboter 590608 590608 Smyth, Thomas, of Toppesfeld, laboter 1
4028381 2034803 2034803 defendant Gridley Thomas yeoman 590608 590608 Gridley, Thomas, of Toppesfeld, yeoman 1
4033018 2036457 2036457 defendant Cornell Thomas husbandman 590608 590608 Cornell, Thomas, of Toppesfeld, husbandman 1
4266849 2118554 2118554 defendant Cracherode Thomas gent 590608 590608 Cracherode, Thomas, of Toppesfeld, gent 0
4274981 2121202 2121202 defendant Cracherood Thomas, senior gent 590608 590608 Cracherood, Thomas, senior, of Toppesfeld, gent 0
4460141 2188232 2188232 defendant Custee William   590608 590608 Custee, William, of Toppesfeld 1
4512906 2204470 2204470 defendant Reve William butcher 590608 590608 Reve, William, of Toppesfeld, butcher 0
4665865 2250799 2250799 defendant Byat William husbandman 590608 590608 Byat, William, of Toppesfeld, husbandman 4
4728314 2274100 2274100 defendant Thurston John   590608 590608 Thurston, John, of Toppesfeld 4
4728330 2274101 2274101 defendant Thurston John   590608 590608 Thurston, John, of Toppesfeld 4
4831764 2305956 2305956 plaintiff Symond John   590608 590608 Symond, John, of Toppesfeld 4
4863026 2315413 2315413 defendant Toppesfeld William gent 590608 590608 Toppesfeld, William, of Toppesfeld, gent 0
4969314 2347782 2347782 defendant Rys Leonard husbandman 590608 590608 Rys, Leonard, of Toppesfeld, husbandman 1
4979788 2350910 2350910 defendant Ryse Leonard husbandman 590608 590608 Ryse, Leonard, of Toppesfeld, husbandman 4
4993062 2354810 2354810 defendant Pury John husbandman 590608 590608 Pury, John, of Toppesfeld, husbandman 0
4995436 2355478 2355478 defendant Pottevile William yeoman 590608 590608 Pottevile, William, of Toppesfeld, yeoman 0
4999982 2356875 2356875 defendant Menant Joh clerk 590608 590608 Menant, Joh, of Toppesfeld, clerk 0
4999983 2356875 2356875 defendant Petevyle John   590608 590608 Petevyle, John, of Toppesfeld, vicar 1
4999984 2356875 2356875 defendant atte Wode Robert chaplain 590608 590608 atte Wode, Robert, of Toppesfeld, chaplain 2
4999985 2356875 2356875 defendant Symond Alice   590608 590608 Symond, Alice, of Toppesfeld, widow, formerly wife of William 3
5020130 2362776 2362776 defendant Botulffe Robert yeoman 590608 590608 Botulffe, Robert, of Toppesfeld, yeoman 0
5197719 2415077 2415077 defendant Tye Thomas yeoman 590608 590608 Tye, Thomas, of Toppesfeld, yeoman 0
5197720 2415077 2415077 defendant Sterlyng John laborer 590608 590608 Sterlyng, John, of Toppesfeld, laborer 1
5315088 2449567 2449567 defendant Horell John yeoman 590608 590608 Horell, John, of Toppesfeld, yeoman 0
5315090 2449568 2449568 defendant Horell John yeoman 590608 590608 Horell, John, of Toppesfeld, yeoman 0
5329173 2453803 2453803 defendant Parker William clerk 590608 590608 Parker, William, of Toppesfeld, clerk 1
5329178 2453804 2453804 defendant Parker William clerk 590608 590608 Parker, William, of Toppesfeld, clerk 0
5352579 2460903 2460903 defendant Pery John, senior husbandman 590608 590608 Pery, John, senior, of Toppesfeld, husbandman 1
5352584 2460904 2460904 defendant Pery John, senior husbandman 590608 590608 Pery, John, senior, of Toppesfeld, husbandman 1
5358226 2462630 2462630 defendant Mortymer John husbandman 590608 590608 Mortymer, John, of Toppesfeld, husbandman 0
5362628 2463960 2463960 plaintiff Tye Thomas   590608 590608 Tye, Thomas, of Toppesfeld 0
5406058 2476807 2476807 defendant Thurston William husbandman 590608 590608 Thurston, William, of Toppesfeld, husbandman 0
5497631 2504235 2504235 defendant Hegecok Thomas husbandman 590608 590608 Hegecok, Thomas, of Toppesfeld, husbandman 3

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);