names

48 rows where place_id = 590793

✎ 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
3602332 1868392 1868392 defendant Halffhyde John husbandman 590793 590793 Halffhyde, John, of Yardley, husbandman 1
3602333 1868392 1868392 defendant Shottbolte Edmund husbandman 590793 590793 Shottbolte, Edmund, of Yardley, husbandman 2
3602334 1868392 1868392 defendant Lane Thomas husbandman 590793 590793 Lane, Thomas, of Yardley, husbandman 3
3689226 1922796 1922796 defendant Prety John yeoman 590793 590793 Prety, John, of Yardley, yeoman 0
3696472 1925123 1925123 defendant Hawes John husbandman 590793 590793 Hawes, John, of Yardley, husbandman 0
3727720 1934939 1934939 defendant Hille Richard husbandman 590793 590793 Hille, Richard, of Yardley, husbandman 0
3727722 1934940 1934940 defendant Jeffrey Thomas tailor 590793 590793 Jeffrey, Thomas, of Yardley, tailor 0
3727723 1934940 1934940 defendant Jeffrey John yeoman 590793 590793 Jeffrey, John, of Yardley, yeoman 1
3801162 1958284 1958284 plaintiff Merston John   590793 590793 Merston, John, of Yardley, tile maker 0
3827211 1966375 1966375 defendant Thomas Griffin yeoman 590793 590793 Thomas, Griffin, of Yardley, yeoman 0
3831373 1967701 1967701 defendant Swyfte William husbandman 590793 590793 Swyfte, William, of Yardley, husbandman 1
3831374 1967701 1967701 defendant Lee William husbandman 590793 590793 Lee, William, of Yardley, husbandman 2
3886148 1985619 1985619 defendant Brymley William smith 590793 590793 Brymley, William, of Yardley, smith 0
3920718 1997277 1997277 defendant Knyght Humphrey husbandman 590793 590793 Knyght, Humphrey, of Yardley, husbandman 0
3926670 1999253 1999253 defendant Jeffreys John husbandman 590793 590793 Jeffreys, John, of Yardley, husbandman 0
3935112 2002054 2002054 defendant Est Edward gent 590793 590793 Est, Edward, of Yardley, gent 0
3973142 2015178 2015178 plaintiff Grave Thomas husbandman 590793 590793 Grave, Thomas, of Yardley, husbandman 0
4060177 2046039 2046039 defendant Hill William husbandman 590793 590793 Hill, William, of Yardley, husbandman 1
4086511 2055459 2055459 defendant Poynton Ralph yeoman 590793 590793 Poynton, Ralph, of Yardley, yeoman 0
4145751 2076667 2076667 defendant Halfehide Richard (legal representative) 590793 590793 Halfehide, Richard, of Yardley, yeoman, administratrix of 2
4145752 2076667 2076667 defendant Halfehide Margery widow 590793 590793 Halfehide, Margery, of Yardley, widow 3
4148479 2077597 2077597 defendant Wortham William yeoman 590793 590793 Wortham, William, of Yardley, yeoman 0
4156411 2080318 2080318 defendant Watton William yeoman 590793 590793 Watton, William, of Yardley, yeoman 0
4167132 2084010 2084010 defendant Swyfte Simon yeoman 590793 590793 Swyfte, Simon, of Yardley, yeoman 0
4172068 2085695 2085695 defendant Wortham William yeoman 590793 590793 Wortham, William, of Yardley, yeoman 0
4172069 2085695 2085695 defendant Downes Philip yeoman 590793 590793 Downes, Philip, of Yardley, yeoman 1
4185875 2090555 2090555 defendant Wortham William yeoman 590793 590793 Wortham, William, of Yardley, yeoman 1
4203729 2096860 2096860 defendant Watton William husbandman 590793 590793 Watton, William, of Yardley, husbandman 0
4214987 2100743 2100743 defendant Mylles Thomas carpenter 590793 590793 Mylles, Thomas, of Yardley, carpenter 1
4218762 2102061 2102061 defendant Barrowes Thomas husbandman 590793 590793 Barrowes, Thomas, of Yardley, husbandman 3
4218918 2102111 2102111 defendant Holmes Mathew yeoman 590793 590793 Holmes, Mathew, of Yardley, yeoman 0
4234631 2107659 2107659 defendant East Barnaby gent 590793 590793 East, Barnaby, of Yardley, gent 1
4241477 2110133 2110133 defendant Geast Barnaby gent 590793 590793 Geast, Barnaby, of Yardley, gent 0
4279076 2122612 2122612 defendant Miles Thomas carpenter 590793 590793 Miles, Thomas, of Yardley, carpenter 0
4279395 2122716 2122716 defendant Downes Philip yeoman 590793 590793 Downes, Philip, of Yardley, yeoman 0
4279808 2122855 2122855 defendant Myles Thomas yeoman 590793 590793 Myles, Thomas, of Yardley, yeoman 2
4293942 2127907 2127907 defendant Tattersall Robert clerk 590793 590793 Tattersall, Robert, of Yardley, clerk 0
4297926 2129360 2129360 defendant Holmes Thomas   590793 590793 Holmes, Thomas, of Yardley, yeoman, administrators of 0
4311963 2134320 2134320 defendant Tattersall Robert clerk 590793 590793 Tattersall, Robert, of Yardley, clerk 0
4365112 2152577 2152577 defendant Jeffreys William yeoman 590793 590793 Jeffreys, William, of Yardley, yeoman 0
4374022 2155779 2155779 defendant Stafford Thomas cooper 590793 590793 Stafford, Thomas, of Yardley, cooper 2
4409766 2167869 2167869 defendant Halfhed William maltman 590793 590793 Halfhed, William, of Yardley, maltman 1
4412642 2168817 2168817 defendant Shotbolt James, senior yeoman 590793 590793 Shotbolt, James, senior, of Yardley, yeoman 0
4412643 2168817 2168817 defendant Shotbolt Thomas   590793 590793 Shotbolt, Thomas, of Yardley, yeoman, singleman, his son 1
5133775 2396370 2396370 defendant Smyth John   590793 590793 Smyth, John, of Yardley 0
5335805 2455773 2455773 defendant Paryes Thomas yeoman 590793 590793 Paryes, Thomas, of Yardley, yeoman 1
5447325 2489091 2489091 plaintiff Holder Robert (legal representative) 590793 590793 Holder, Robert, of Yardley, executors of 0
5504420 2506299 2506299 defendant Shilton Thomas husbandman 590793 590793 Shilton, Thomas, of Yardley, husbandman 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);