names

27 rows where place_id = 609336

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3678004 1919163 1919163 defendant Bungey Matilda widow 609336 609336 Bungey, Matilda, of Hallesworth, Suff, widow 3
3734823 1937135 1937135 defendant Clerk Robert chapman 609336 609336 Clerk, Robert, of Hallesworth, Suff, chapman 4
3781648 1951998 1951998 defendant Fyske John mercer 609336 609336 Fyske, John, of Hallesworth, Suff, mercer 0
3833050 1968260 1968260 defendant Crystemas John butcher 609336 609336 Crystemas, John, of Hallesworth, Suff, butcher 0
3870026 1980220 1980220 defendant Basset Robert chapman 609336 609336 Basset, Robert, of Hallesworth, Suff, chapman 0
3870031 1980221 1980221 defendant Bassett Robert chapman 609336 609336 Bassett, Robert, of Hallesworth, Suff, chapman 0
3878672 1983115 1983115 defendant Baker Valentine tanner 609336 609336 Baker, Valentine, of Hallesworth, Suff, tanner 0
3881954 1984222 1984222 defendant Pek Thomas yeoman 609336 609336 Pek, Thomas, of Hallesworth, Suff, yeoman 0
3937672 2002929 2002929 defendant Baly Thomas yeoman 609336 609336 Baly, Thomas, of Hallesworth, Suff, yeoman 2
3951883 2007720 2007720 defendant Payne John butcher 609336 609336 Payne, John, of Hallesworth, Suff, butcher 0
3959754 2010503 2010503 defendant Smythe William singleman 609336 609336 Smythe, William, of Hallesworth, Suff, yeoman, singleman 0
3974219 2015549 2015549 defendant Dawson John chapman 609336 609336 Dawson, John, of Hallesworth, Suff, chapman 0
3982647 2018563 2018563 defendant Pylpott William clerk 609336 609336 Pylpott, William, of Hallesworth, Suff, clerk 2
3984286 2019144 2019144 defendant Kelsonne John tailor 609336 609336 Kelsonne, John, of Hallesworth, Suff, tailor 1
4029847 2035318 2035318 defendant Hanson Robert   609336 609336 Hanson, Robert, of Hallesworth, Suff, physician 0
4032052 2036131 2036131 defendant Bennett Roger tanner 609336 609336 Bennett, Roger, of Hallesworth, Suff, tanner 1
4032056 2036132 2036132 defendant Bennett Roger tanner 609336 609336 Bennett, Roger, of Hallesworth, Suff, tanner 1
4825352 2303973 2303973 defendant Barker Roger husbandman 609336 609336 Barker, Roger, of Hallesworth, Suff, husbandman 0
5002583 2357667 2357667 defendant Randolf Robert chapman 609336 609336 Randolf, Robert, of Hallesworth, Suff, chapman 3
5002588 2357668 2357668 defendant Randolf Robert chapman 609336 609336 Randolf, Robert, of Hallesworth, Suff, chapman 2
5139984 2398173 2398173 defendant Broke Richard chapman 609336 609336 Broke, Richard, of Hallesworth, Suff, chapman 2
5175574 2408540 2408540 defendant Broke Richard chapman 609336 609336 Broke, Richard, of Hallesworth, Suff, chapman 2
5196884 2414838 2414838 defendant Broke Richard chapman 609336 609336 Broke, Richard, of Hallesworth, Suff, chapman 2
5237260 2426482 2426482 defendant Broke Richard yeoman 609336 609336 Broke, Richard, of Hallesworth, Suff, yeoman 0
5288415 2441631 2441631 defendant Brook John chapman 609336 609336 Brook, John, of Hallesworth, Suff, chapman 0
5293768 2443139 2443139 defendant Roo William merchant 609336 609336 Roo, William, of Hallesworth, Suff, merchant 2
5445841 2488645 2488645 defendant Skynner Richard draper 609336 609336 Skynner, Richard, of Hallesworth, Suff, draper 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);