names

194 rows where place_id = 590919

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602720 1868514 1868514 defendant Wodward John brasier 590919 590919 Wodward, John, of Walsall, brasier 0
3620330 1873940 1873940 defendant Key William tailor 590919 590919 Key, William, of Walsall, tailor 0
3628877 1903907 1903907 defendant Marshall William yeoman 590919 590919 Marshall, William, of Walsall, yeoman 0
3628880 1903908 1903908 defendant Marshall William yeoman 590919 590919 Marshall, William, of Walsall, yeoman 0
3628894 1903914 1903914 defendant Ruston Robert yeoman 590919 590919 Ruston, Robert, of Walsall, yeoman 0
3629309 1904026 1904026 defendant Marshall William, senior yeoman 590919 590919 Marshall, William, senior, of Walsall, yeoman 0
3629310 1904026 1904026 defendant Dyngley Richard spurrier 590919 590919 Dyngley, Richard, of Walsall, spurrier 1
3635634 1905947 1905947 defendant Taillour Thomas lorimer 590919 590919 Taillour, Thomas, of Walsall, lorimer 0
3636831 1906312 1906312 defendant Banaster John gent 590919 590919 Banaster, John, of Walsall, gent 0
3640112 1907353 1907353 defendant Rogers Richard lorimer 590919 590919 Rogers, Richard, of Walsall, lorimer 0
3640115 1907353 1907353 defendant yerdley William cooper 590919 590919 yerdley, William, of Walsall, cooper 3
3644981 1908839 1908839 defendant Kempson Thomas   590919 590919 Kempson, Thomas, of Walsall 0
3645417 1908976 1908976 defendant Rogers Richard yeoman 590919 590919 Rogers, Richard, of Walsall, yeoman 0
3650192 1910429 1910429 defendant Banaster John gent 590919 590919 Banaster, John, of Walsall, gent 0
3650194 1910430 1910430 defendant Banaster John gent 590919 590919 Banaster, John, of Walsall, gent 0
3650196 1910431 1910431 defendant Banaster John gent 590919 590919 Banaster, John, of Walsall, gent 0
3650198 1910432 1910432 defendant Banaster John gent 590919 590919 Banaster, John, of Walsall, gent 0
3653846 1911466 1911466 defendant Walker William yeoman 590919 590919 Walker, William, of Walsall, yeoman 0
3653847 1911466 1911466 defendant Hopkys Richard yeoman 590919 590919 Hopkys, Richard, of Walsall, yeoman 1
3653848 1911466 1911466 defendant Parsons John husbandman 590919 590919 Parsons, John, of Walsall, husbandman 2
3653849 1911466 1911466 defendant Borrowys Thomas laborer 590919 590919 Borrowys, Thomas, of Walsall, laborer 3
3658676 1912969 1912969 defendant Brendwod John gent 590919 590919 Brendwod, John, of Walsall, gent 0
3660059 1913409 1913409 defendant Parker Thomas milner 590919 590919 Parker, Thomas, of Walsall, milner 0
3660637 1913589 1913589 defendant Greygose Roger baker 590919 590919 Greygose, Roger, of Walsall, baker 0
3664498 1914845 1914845 defendant Astley John potter 590919 590919 Astley, John, of Walsall, potter 0
3668425 1916076 1916076 plaintiff Asteley James   590919 590919 Asteley, James, of Walsall 0
3673194 1917629 1917629 defendant Brasier Roger yeoman 590919 590919 Brasier, Roger, of Walsall, yeoman 1
3673824 1917844 1917844 defendant Dyngley Richard lorimer 590919 590919 Dyngley, Richard, of Walsall, lorimer 0
3686159 1921834 1921834 defendant Dawson Christopher carpenter 590919 590919 Dawson, Christopher, of Walsall, carpenter 0
3688177 1922451 1922451 defendant Hyndley John chaplain 590919 590919 Hyndley, John, of Walsall, chaplain 4
3699081 1925919 1925919 defendant Stone Richard yeoman 590919 590919 Stone, Richard, of Walsall, yeoman 0
3703414 1927344 1927344 defendant Brasier Roger innholder 590919 590919 Brasier, Roger, of Walsall, innholder 1
3723606 1933656 1933656 defendant Ball John laborer 590919 590919 Ball, John, of Walsall, laborer 0
3723609 1933657 1933657 defendant Balle John laborer 590919 590919 Balle, John, of Walsall, laborer 0
3723613 1933658 1933658 defendant Ball John laborer 590919 590919 Ball, John, of Walsall, laborer 1
3726753 1934633 1934633 defendant Acton Thomas gent 590919 590919 Acton, Thomas, of Walsall, gent 0
3726754 1934633 1934633 defendant Sheppard Richard yeoman 590919 590919 Sheppard, Richard, of Walsall, yeoman 1
3746894 1940945 1940945 defendant Frythe Roger brazier 590919 590919 Frythe, Roger, of Walsall, brazier 0
3759029 1944811 1944811 defendant Doore Roger laborer 590919 590919 Doore, Roger, of Walsall, laborer 0
3759680 1945017 1945017 defendant Webbe Thomas lorimer 590919 590919 Webbe, Thomas, of Walsall, lorimer 1
3759681 1945017 1945017 defendant Rogers Richard laborer 590919 590919 Rogers, Richard, of Walsall, laborer 2
3759682 1945017 1945017 defendant Hurst William laborer 590919 590919 Hurst, William, of Walsall, laborer 3
3760908 1945416 1945416 defendant Clarkson Thomas pewterer 590919 590919 Clarkson, Thomas, of Walsall, pewterer 0
3760909 1945416 1945416 defendant Frith Roger brasier 590919 590919 Frith, Roger, of Walsall, brasier 1
3778124 1950869 1950869 defendant Hyndeley John chaplain 590919 590919 Hyndeley, John, of Walsall, chaplain 0
3778125 1950869 1950869 defendant Downyng Henry laborer 590919 590919 Downyng, Henry, of Walsall, laborer 1
3778126 1950869 1950869 defendant Dore John lorimer 590919 590919 Dore, John, of Walsall, lorimer 2
3778127 1950869 1950869 defendant Coke Thomas lorimer 590919 590919 Coke, Thomas, of Walsall, lorimer 3
3788555 1954217 1954217 defendant Castell John carpenter 590919 590919 Castell, John, of Walsall, carpenter 2
3796140 1956657 1956657 defendant Hancoke John brasier 590919 590919 Hancoke, John, of Walsall, brasier 1
3801161 1958283 1958283 defendant Dyngley Richard spurrier 590919 590919 Dyngley, Richard, of Walsall, spurrier 0
3804336 1959292 1959292 defendant Pakyngton Richard smith 590919 590919 Pakyngton, Richard, of Walsall, smith 1
3812720 1961872 1961872 defendant Fryth Roger brasier 590919 590919 Fryth, Roger, of Walsall, brasier 0
3815606 1962796 1962796 defendant Hole William smith 590919 590919 Hole, William, of Walsall, smith 1
3818657 1963738 1963738 defendant Alporte William husbandman 590919 590919 Alporte, William, of Walsall, husbandman 0
3822246 1964862 1964862 defendant Vycars John yeoman 590919 590919 Vycars, John, of Walsall, yeoman 0
3822249 1964862 1964862 defendant Fylkes John lorimer 590919 590919 Fylkes, John, of Walsall, lorimer 3
3822428 1964912 1964912 defendant Rauschaull John saddler 590919 590919 Rauschaull, John, of Walsall, saddler 1
3827113 1966340 1966340 defendant Stone John yeoman 590919 590919 Stone, John, of Walsall, yeoman 0
3827599 1966493 1966493 defendant Marten George nailer 590919 590919 Marten, George, of Walsall, nailer 2
3831136 1967624 1967624 defendant Stone John lorimer 590919 590919 Stone, John, of Walsall, lorimer 0
3837599 1969668 1969668 defendant Vycars John lorimer 590919 590919 Vycars, John, of Walsall, lorimer 0
3837783 1969732 1969732 defendant Marten George smith 590919 590919 Marten, George, of Walsall, smith 1
3837786 1969733 1969733 defendant Clerkson Thomas laborer 590919 590919 Clerkson, Thomas, of Walsall, laborer 0
3837787 1969733 1969733 defendant Jenkynson John tailor 590919 590919 Jenkynson, John, of Walsall, tailor 1
3837788 1969733 1969733 defendant Dey John baker 590919 590919 Dey, John, of Walsall, baker 2
3837794 1969734 1969734 defendant Clerkson Thomas laborer 590919 590919 Clerkson, Thomas, of Walsall, laborer 2
3837795 1969734 1969734 defendant Jenkynson John tailor 590919 590919 Jenkynson, John, of Walsall, tailor 3
3859005 1976505 1976505 defendant Smyth alias Plowme Thomas chaplain 590919 590919 Smyth alias Plowme, Thomas, of Walsall, chaplain 0
3869321 1979981 1979981 defendant Jakson John draper 590919 590919 Jakson, John, of Walsall, draper 0
3882155 1984290 1984290 defendant Tyrle John bitmaker 590919 590919 Tyrle, John, of Walsall, bitmaker 2
3882161 1984291 1984291 defendant Tyrle John   590919 590919 Tyrle, John, of Walsall, bit maker 3
3884355 1985035 1985035 defendant Sheyperde Richard yeoman 590919 590919 Sheyperde, Richard, of Walsall, yeoman 3
3890158 1986947 1986947 defendant Asteley James potter or brasier 590919 590919 Asteley, James, of Walsall, potter or brasier 0
3892466 1987726 1987726 defendant Stone John yeoman 590919 590919 Stone, John, of Walsall, yeoman 0
3892467 1987726 1987726 defendant Stone Thomas yeoman 590919 590919 Stone, Thomas, of Walsall, yeoman 1
3892557 1987753 1987753 defendant Hogettes John husbandman 590919 590919 Hogettes, John, of Walsall, husbandman 2
3892917 1987878 1987878 defendant Hoggettys John yeoman 590919 590919 Hoggettys, John, of Walsall, yeoman 2
3896795 1989140 1989140 defendant Stone Thomas lorimer 590919 590919 Stone, Thomas, of Walsall, lorimer 0
3908694 1993204 1993204 defendant Stone Richard lorimer 590919 590919 Stone, Richard, of Walsall, lorimer 0
3908719 1993213 1993213 defendant Dyngley Richard yeoman 590919 590919 Dyngley, Richard, of Walsall, yeoman 0
3911142 1994054 1994054 defendant Stone Thomas lorimer 590919 590919 Stone, Thomas, of Walsall, lorimer 0
3915371 1995508 1995508 defendant Kyrpye William bloomer 590919 590919 Kyrpye, William, of Walsall, bloomer 1
3918936 1996654 1996654 defendant Jenkyns John tailor 590919 590919 Jenkyns, John, of Walsall, tailor 0
3923168 1998056 1998056 defendant Wetton Richard tailor 590919 590919 Wetton, Richard, of Walsall, tailor 0
3924877 1998638 1998638 defendant Stone Thomas lorimer 590919 590919 Stone, Thomas, of Walsall, lorimer 0
3925744 1998925 1998925 defendant Dawson John pewterer 590919 590919 Dawson, John, of Walsall, pewterer 0
3931661 2000887 2000887 plaintiff Ducy James   590919 590919 Ducy, James, of Walsall 0
3946441 2005824 2005824 defendant Clemson John yeoman 590919 590919 Clemson, John, of Walsall, yeoman 0
3952555 2007963 2007963 defendant Eryn Hugh laborer 590919 590919 Eryn, Hugh, of Walsall, laborer 0
3952578 2007971 2007971 defendant Gryn Hugh laborer 590919 590919 Gryn, Hugh, of Walsall, laborer 0
3955126 2008855 2008855 defendant Stone John yeoman 590919 590919 Stone, John, of Walsall, yeoman 1
3955535 2009006 2009006 defendant Dawson John husbandman 590919 590919 Dawson, John, of Walsall, husbandman 0
3956281 2009261 2009261 defendant Garbott William yeoman 590919 590919 Garbott, William, of Walsall, yeoman 0
3956284 2009262 2009262 defendant Woodward alias Brasyer Joan spinster 590919 590919 Woodward alias Brasyer, Joan, of Walsall, spinster 0
3956285 2009262 2009262 defendant Woodward alias Brasyer Thomas brasier 590919 590919 Woodward alias Brasyer, Thomas, of Walsall, brasier 1
3963849 2011960 2011960 plaintiff Alpart Peter roper 590919 590919 Alpart, Peter, of Walsall, roper 0
3966209 2012811 2012811 defendant Marten George lorimer 590919 590919 Marten, George, of Walsall, lorimer 0
3977765 2016793 2016793 plaintiff Lydyatt John yeoman 590919 590919 Lydyatt, John, of Walsall, yeoman 0
3977766 2016793 2016793 defendant Whyte Thomas tailor 590919 590919 Whyte, Thomas, of Walsall, tailor 0

Next page

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