names

40 rows where place_id = 596046

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3622893 1874689 1874689 defendant Hempstede John husbandman 596046 596046 Hempstede, John, of Haverell, Suff, husbandman 0
3695617 1924857 1924857 defendant Turnour Henry gent 596046 596046 Turnour, Henry, of Haverell, Suff, gent 0
3695619 1924858 1924858 defendant Turnour Henry gent 596046 596046 Turnour, Henry, of Haverell, Suff, gent 0
3699666 1926123 1926123 defendant Subbyng Robert tanner 596046 596046 Subbyng, Robert, of Haverell, Suff, tanner 0
3724160 1933841 1933841 defendant Turnour Henry gent 596046 596046 Turnour, Henry, of Haverell, Suff, gent 0
3740369 1938851 1938851 defendant Melwen Nicholas smith 596046 596046 Melwen, Nicholas, of Haverell, Suff, smith 2
3743137 1939712 1939712 defendant Stubyn Richard husbandman 596046 596046 Stubyn, Richard, of Haverell, Suff, husbandman 0
3743139 1939713 1939713 defendant Stubyn Richard husbandman 596046 596046 Stubyn, Richard, of Haverell, Suff, husbandman 0
3762467 1945904 1945904 defendant Pyngell Thomas tailor 596046 596046 Pyngell, Thomas, of Haverell, Suff, tailor 0
3768391 1947759 1947759 defendant Mylyon Nicholas blacksmith 596046 596046 Mylyon, Nicholas, of Haverell, Suff, blacksmith 0
3790480 1954845 1954845 defendant Howell John shoemaker 596046 596046 Howell, John, of Haverell, Suff, shoemaker 1
3794221 1956065 1956065 defendant Vycars Henry miller 596046 596046 Vycars, Henry, of Haverell, Suff, miller 1
3794445 1956138 1956138 defendant Burton Leonard husbandman 596046 596046 Burton, Leonard, of Haverell, Suff, husbandman 0
3804677 1959403 1959403 defendant Reve John clothier 596046 596046 Reve, John, of Haverell, Suff, clothier 0
3913347 1994799 1994799 defendant Rust William tanner 596046 596046 Rust, William, of Haverell, Suff, tanner 0
3944144 2005060 2005060 defendant Stanton William yeoman 596046 596046 Stanton, William, of Haverell, Suff, yeoman 2
3947771 2006284 2006284 defendant Pellsatt Thomas tailor 596046 596046 (Pellsatt, Thomas, of Haverell, Suff, tailor 1
4005882 2026874 2026874 defendant Clarke Richard clothier 596046 596046 Clarke, Richard, of Haverell, Suff, clothier 0
4034160 2036880 2036880 defendant Newman Robert chapman 596046 596046 Newman, Robert, of Haverell, Suff, chapman 1
4034164 2036881 2036881 defendant Newman Robert chapman 596046 596046 Newman, Robert, of Haverell, Suff, chapman 1
4037873 2038197 2038197 defendant Parker William husbandman 596046 596046 Parker, William, of Haverell, Suff, husbandman 0
4037878 2038198 2038198 defendant Parker William husbandman 596046 596046 Parker, William, of Haverell, Suff, husbandman 0
4047005 2041379 2041379 defendant Newman Robert haberdasher 596046 596046 Newman, Robert, of Haverell, Suff, haberdasher 0
4047008 2041380 2041380 defendant Newman Robert haberdasher 596046 596046 Newman, Robert, of Haverell, Suff, haberdasher 0
4135093 2072871 2072871 defendant Reve Robert yeoman 596046 596046 Reve, Robert, of Haverell, Suff, yeoman 3
4267140 2118648 2118648 defendant Cowle Thomas yeoman 596046 596046 Cowle, Thomas, of Haverell, Suff, yeoman 0
4275284 2121290 2121290 defendant Mortlocke William vintner 596046 596046 Mortlocke, William, of Haverell, Suff, vintner 2
4353298 2148380 2148380 defendant Mortlocke or Moreclacke William chapman 596046 596046 Mortlocke or Moreclacke, William, of Haverell, Suff, chapman 0
4357843 2149983 2149983 defendant Briden Edward pewterer 596046 596046 Briden, Edward, of Haverell, Suff, pewterer 1
4377406 2156994 2156994 defendant Mortlocke alias Moreclarke William chapman 596046 596046 Mortlocke alias Moreclarke, William, of Haverell, Suff, chapman 0
4658220 2248451 2248451 defendant Gage Robert chapman 596046 596046 Gage, Robert, of Haverell, Suff, chapman 2
4952752 2342781 2342781 defendant Lane John barker 596046 596046 Lane, John, of Haverell, Suff, barker 0
5243929 2428415 2428415 defendant Smyth John tailor 596046 596046 Smyth, John, of Haverell, Suff, tailor 1
5381874 2469871 2469871 defendant Wythebawede John grocer 596046 596046 Wythebawede, John, of Haverell, Suff, grocer 1
5396144 2473983 2473983 defendant Sterne Thomas yeoman 596046 596046 Sterne, Thomas, of Haverell, Suff, yeoman 0
5402820 2475883 2475883 defendant Whithebawde John grocer 596046 596046 Whithebawde, John, of Haverell, Suff, grocer 0
5488436 2501432 2501432 defendant Lee John, junior husbandman 596046 596046 Lee, John, junior, of Haverell, Suff, husbandman 1
5488440 2501433 2501433 defendant Lee John, junior husbandman 596046 596046 Lee, John, junior, of Haverell, Suff, husbandman 0
5570118 2525835 2525835 defendant Cornewell Thomas gent 596046 596046 Cornewell, Thomas, of Haverell, Suff, gent 0
5570121 2525836 2525836 defendant Cornewall Thomas gent 596046 596046 Cornewall, Thomas, of Haverell, Suff, gent 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);