names

44 rows where place_id = 592139

✎ 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
3606705 1869772 1869772 defendant Nevall William lorimer 592139 592139 Nevall, William, of Walsall, Staffs, lorimer 1
3632788 1905066 1905066 defendant Wilkes George gent 592139 592139 Wilkes, George, of Walsall, Staffs, gent 2
3637419 1906508 1906508 defendant Wylkes George gent 592139 592139 Wylkes, George, of Walsall, Staffs, gent 2
3668693 1916145 1916145 defendant Walker William yeoman 592139 592139 Walker, William, of Walsall, Staffs, yeoman 0
3687672 1922313 1922313 defendant Dyngley Richard spurrier 592139 592139 Dyngley, Richard, of Walsall, Staffs, spurrier 2
3703413 1927344 1927344 defendant Thomson John pewterer 592139 592139 Thomson, John, of Walsall, Staffs, pewterer 0
3750320 1942016 1942016 defendant Kempson Thomas yeoman 592139 592139 Kempson, Thomas, of Walsall, Staffs, yeoman 0
3765791 1946965 1946965 defendant Kempson Thomas yeoman 592139 592139 Kempson, Thomas, of Walsall, Staffs, yeoman 0
3783790 1952696 1952696 defendant Kempson Thomas yeoman 592139 592139 Kempson, Thomas, of Walsall, Staffs, yeoman 0
3806325 1959893 1959893 defendant Dunston Ralph yeoman 592139 592139 Dunston, Ralph, of Walsall, Staffs, yeoman 0
3865337 1978618 1978618 defendant Hopkyn Richard lorimer 592139 592139 Hopkyn, Richard, of Walsall, Staffs, lorimer 0
3892355 1987693 1987693 defendant Thomason John draper 592139 592139 Thomason, John, of Walsall, Staffs, draper 0
3897762 1989457 1989457 defendant Marten George smith 592139 592139 Marten, George, of Walsall, Staffs, smith 0
3901309 1990662 1990662 defendant Tomson John clothier 592139 592139 Tomson, John, of Walsall, Staffs, clothier 0
3925289 1998771 1998771 defendant Brasyer John yeoman 592139 592139 Brasyer, John, of Walsall, Staffs, yeoman 3
3930692 2000615 2000615 defendant Wetherbie Roger pewterer 592139 592139 Wetherbie, Roger, of Walsall, Staffs, pewterer 0
3940949 2003982 2003982 defendant Jenkyns John mercer 592139 592139 Jenkyns, John, of Walsall, Staffs, mercer 0
3954973 2008802 2008802 defendant Ley Thomas spurrier 592139 592139 Ley, Thomas, of Walsall, Staffs, spurrier 1
3970309 2014212 2014212 defendant Horte John lorimer 592139 592139 Horte, John, of Walsall, Staffs, lorimer 1
3983654 2018923 2018923 defendant Martyn George yeoman 592139 592139 Martyn, George, of Walsall, Staffs, yeoman 0
3996713 2023589 2023589 plaintiff Dewcy James yeoman 592139 592139 Dewcy, James, of Walsall, Staffs, yeoman 0
4051615 2042998 2042998 defendant Spensar Thomas, junior brasier or potter 592139 592139 Spensar, Thomas, junior, of Walsall, Staffs, brasier or potter 1
4051898 2043100 2043100 plaintiff Worthington Richard brasier 592139 592139 Worthington, Richard, of Walsall, Staffs, brasier 0
4051902 2043100 2043100 defendant Morte Richard yeoman 592139 592139 Morte, Richard, of Walsall, Staffs, yeoman 3
4081502 2053694 2053694 defendant Dorre Richard chapman 592139 592139 Dorre, Richard, of Walsall, Staffs, chapman 0
4102241 2061093 2061093 defendant Lysatt William yeoman 592139 592139 Lysatt, William, of Walsall, Staffs, yeoman 0
4102243 2061094 2061094 defendant Lysatt William yeoman 592139 592139 Lysatt, William, of Walsall, Staffs, yeoman 0
4102245 2061095 2061095 defendant Stone Richard yeoman 592139 592139 Stone, Richard, of Walsall, Staffs, yeoman 0
4102247 2061096 2061096 defendant Stone Richard   592139 592139 Stone, Richard, of Walsall, Staffs, yeoman, stirup maker 0
4103692 2061596 2061596 defendant Worley George gent 592139 592139 Worley, George, of Walsall, Staffs, gent 4
4125832 2069523 2069523 defendant Stone John   592139 592139 Stone, John, of Walsall, Staffs, "lawryman" 0
4138079 2073984 2073984 defendant Comlege or Comelage George   592139 592139 Comlege or Comelage, George, of Walsall, Staffs, administrators of 3
4140706 2074914 2074914 defendant Foster John spurrier 592139 592139 Foster, John, of Walsall, Staffs, spurrier 2
4184411 2090051 2090051 defendant Stone Francis   592139 592139 Stone, Francis, of Walsall, Staffs, yeoman, "lawryman" 0
4213754 2100325 2100325 defendant Stone John   592139 592139 Stone, John, of Walsall, Staffs, "lawryman" 0
4237807 2108825 2108825 defendant Clerkson George gent 592139 592139 Clerkson, George, of Walsall, Staffs, gent 2
4237811 2108826 2108826 defendant Clerkson George gent 592139 592139 Clerkson, George, of Walsall, Staffs, gent 2
4246408 2111775 2111775 defendant Clerkson George gent 592139 592139 Clerkson, George, of Walsall, Staffs, gent 2
4250270 2113071 2113071 defendant Worthyngton John yeoman 592139 592139 Worthyngton, John, of Walsall, Staffs, yeoman 0
4295792 2128587 2128587 defendant Mountforte or Mountford Baldwin gent 592139 592139 Mountforte or Mountford, Baldwin, of Walsall, Staffs, gent 0
4672543 2257059 2257059 defendant Lowe Richard gent 592139 592139 Lowe, Richard, of Walsall, Staffs, gent 1
5537430 2516201 2516201 defendant Dore Roger   592139 592139 Dore, Roger, of Walsall, Staffs, yeoman, bailiff 1
5551311 2520417 2520417 defendant Haynes Richard lorimer 592139 592139 Haynes, Richard, of Walsall, Staffs, lorimer 1
5597380 2534085 2534085 defendant Hopkyns William husbandman 592139 592139 Hopkyns, William, of Walsall, Staffs, husbandman 1

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