names

32 rows where place_id = 598726

✎ 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
3633787 1905382 1905382 defendant Wace Richard husbandman 598726 598726 Wace, Richard, of Wortham, Suff, husbandman 0
3704458 1927690 1927690 defendant Church Thomas cooper 598726 598726 Church, Thomas, of Wortham, Suff, cooper 1
3967535 2013277 2013277 defendant Whytewood Thomas yeoman 598726 598726 Whytewood, Thomas, of Wortham, Suff, yeoman 4
4052919 2043478 2043478 defendant Bettes George yeoman 598726 598726 Bettes, George, of Wortham, Suff, yeoman 0
4112584 2064758 2064758 defendant Bett George yeoman 598726 598726 Bett, George, of Wortham, Suff, yeoman 0
4223479 2103701 2103701 defendant Persley John clerk 598726 598726 Persley, John, of Wortham, Suff, clerk 2
4251232 2113385 2113385 defendant Fulcher Isaac tailor 598726 598726 Fulcher, Isaac, of Wortham, Suff, tailor 3
4270650 2119763 2119763 defendant Bett George yeoman 598726 598726 Bett, George, of Wortham, Suff, yeoman 0
4276780 2121812 2121812 defendant Bett George yeoman 598726 598726 Bett, George, of Wortham, Suff, yeoman 0
4276788 2121814 2121814 defendant Hawes Edmund husbandman 598726 598726 Hawes, Edmund, of Wortham, Suff, husbandman 1
4323503 2138281 2138281 defendant Parsley John clerk 598726 598726 Parsley, John, of Wortham, Suff, clerk 0
4334987 2141969 2141969 defendant Parsley John clerk 598726 598726 Parsley, John, of Wortham, Suff, clerk 0
4376617 2156707 2156707 defendant Maye Richard husbandman 598726 598726 Maye, Richard, of Wortham, Suff, husbandman 0
4389471 2161103 2161103 defendant Corbold Thomas gent 598726 598726 Corbold, Thomas, of Wortham, Suff, gent 2
4406578 2166765 2166765 defendant Morphewe John weaver 598726 598726 Morphewe, John, of Wortham, Suff, weaver 1
4659325 2248781 2248781 defendant Hulwode alias Bokenhamys John, senior yeoman 598726 598726 Hulwode alias Bokenhamys, John, senior, of Wortham, Suff, yeoman 0
4742241 2278220 2278220 defendant Sparwe John yeoman 598726 598726 Sparwe, John, of Wortham, Suff, yeoman 0
4901165 2326979 2326979 defendant Hervy John husbandman 598726 598726 Hervy, John, of Wortham, Suff, husbandman 9
5105667 2388105 2388105 defendant Sampson George esq 598726 598726 Sampson, George, of Wortham, Suff, esq 0
5114448 2390623 2390623 defendant Wright John yeoman 598726 598726 Wright, John, of Wortham, Suff, yeoman 2
5123368 2393276 2393276 defendant Scasse John barker 598726 598726 Scasse, John, of Wortham, Suff, barker 0
5230643 2424574 2424574 defendant Scace Richard baker 598726 598726 Scace, Richard, of Wortham, Suff, baker 4
5271468 2436749 2436749 defendant Weylond John yeoman 598726 598726 Weylond, John, of Wortham, Suff, yeoman 0
5274963 2437761 2437761 defendant Weyland John chaplain 598726 598726 Weyland, John, of Wortham, Suff, chaplain 0
5285339 2440733 2440733 defendant Weylond John yeoman 598726 598726 Weylond, John, of Wortham, Suff, yeoman 0
5292730 2442869 2442869 defendant Bokynham Simon, senior yeoman 598726 598726 Bokynham, Simon, senior, of Wortham, Suff, yeoman 0
5292732 2442870 2442870 defendant Crane Thomas yeoman 598726 598726 Crane, Thomas, of Wortham, Suff, yeoman 0
5292738 2442873 2442873 defendant Gentilman John chaplain 598726 598726 Gentilman, John, of Wortham, Suff, chaplain 0
5292740 2442874 2442874 defendant Hervy Thomas, senior yeoman 598726 598726 Hervy, Thomas, senior, of Wortham, Suff, yeoman 0
5292742 2442875 2442875 defendant Weylond John yeoman 598726 598726 Weylond, John, of Wortham, Suff, yeoman 0
5409983 2477956 2477956 defendant Hervy Thomas husbandman 598726 598726 Hervy, Thomas, of Wortham, Suff, husbandman 0
5505335 2506580 2506580 defendant Chas Thomas carpenter 598726 598726 Chas, Thomas, of Wortham, Suff, carpenter 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);