names

415 rows where place_id = 588127

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593459 1865587 1865587 defendant Verbe Edward hewster 588127 588127 Verbe, Edward, of Wolverhampton, hewster 0
3595558 1866247 1866247 defendant Mokslo John yeoman 588127 588127 Mokslo, John, of Wolverhampton, yeoman 0
3614510 1872186 1872186 defendant Byng John (legal representative) 588127 588127 Byng, John, of Wolverhampton, tanner, executors of 1
3614512 1872186 1872186 defendant Bynge William innholder 588127 588127 Bynge, William, of Wolverhampton, innholder 3
3621157 1874164 1874164 defendant Mitton John, junior gent 588127 588127 Mitton, John, junior, of Wolverhampton, gent 0
3627130 1903343 1903343 defendant Wynshurst Robert cooper 588127 588127 Wynshurst, Robert, of Wolverhampton, cooper 1
3644834 1908790 1908790 defendant Grene William merchant of the staple 588127 588127 (Grene, William, of Wolverhampton, merchant of the staple 1
3645396 1908968 1908968 defendant Wildecote John husbandman 588127 588127 Wildecote, John, of Wolverhampton, husbandman 0
3647059 1909474 1909474 defendant Grene William merchant 588127 588127 Grene, William, of Wolverhampton, merchant 0
3652514 1911117 1911117 defendant Grene Richard grasier 588127 588127 Grene, Richard, of Wolverhampton, grasier 2
3652518 1911118 1911118 defendant Grene Richard grasier 588127 588127 Grene, Richard, of Wolverhampton, grasier 2
3652522 1911119 1911119 defendant Grene Richard grasier 588127 588127 Grene, Richard, of Wolverhampton, grasier 2
3658064 1912777 1912777 defendant Lowson Thomas gent 588127 588127 Lowson, Thomas, of Wolverhampton, gent 0
3658065 1912777 1912777 defendant Fletcher Hugh dyer 588127 588127 Fletcher, Hugh, of Wolverhampton, dyer 1
3658066 1912777 1912777 defendant Foxall John tanner 588127 588127 Foxall, John, of Wolverhampton, tanner 2
3658067 1912777 1912777 defendant Coldlysse Roger gent 588127 588127 Coldlysse, Roger, of Wolverhampton, gent 3
3674543 1918091 1918091 plaintiff Rydley Nicholas gent 588127 588127 Rydley, Nicholas, of Wolverhampton, gent 1
3686395 1921899 1921899 defendant Rydley Nicholas gent 588127 588127 Rydley, Nicholas, of Wolverhampton, gent 0
3686397 1921899 1921899 defendant Leweson Thomas gent 588127 588127 Leweson, Thomas, of Wolverhampton, gent 2
3686781 1922021 1922021 defendant Barton Richard innholder 588127 588127 Barton, Richard, of Wolverhampton, innholder 0
3690062 1923051 1923051 defendant Fleccher John fletcher 588127 588127 Fleccher, John, of Wolverhampton, fletcher 0
3692668 1923897 1923897 plaintiff Kynnersley Robert   588127 588127 Kynnersley, Robert, of Wolverhampton, administrators of 0
3692673 1923897 1923897 defendant Smyth John butcher 588127 588127 Smyth, John, of Wolverhampton, butcher 2
3697852 1925549 1925549 defendant Smale William dyer 588127 588127 Smale, William, of Wolverhampton, dyer 1
3704225 1927620 1927620 defendant Foxhall John tanner 588127 588127 Foxhall, John, of Wolverhampton, tanner 1
3712268 1930150 1930150 defendant Sutton Richard laborer 588127 588127 Sutton, Richard, of Wolverhampton, laborer 1
3720690 1932762 1932762 defendant Adams John chaplain 588127 588127 Adams, John, of Wolverhampton, chaplain 0
3737329 1937912 1937912 defendant Salford William gent 588127 588127 Salford, William, of Wolverhampton, gent 0
3747502 1941134 1941134 defendant Bedyll Roger (legal representative) 588127 588127 Bedyll, Roger, of Wolverhampton, yeoman, administratrix of 2
3747966 1941281 1941281 defendant Luson Thomas gent 588127 588127 Luson, Thomas, of Wolverhampton, gent 0
3750066 1941938 1941938 plaintiff Kynnersley Robert   588127 588127 Kynnersley, Robert, of Wolverhampton, administrators of 0
3750345 1942025 1942025 defendant Smale William dyer 588127 588127 Smale, William, of Wolverhampton, dyer 0
3750353 1942029 1942029 defendant Smale William dyer 588127 588127 Smale, William, of Wolverhampton, dyer 0
3760855 1945397 1945397 defendant Abarton Ralph draper 588127 588127 Abarton, Ralph, of Wolverhampton, draper 0
3761945 1945742 1945742 defendant Luson Thomas gent 588127 588127 Luson, Thomas, of Wolverhampton, gent 0
3765332 1946820 1946820 plaintiff Kynnersley Robert (legal representative) 588127 588127 Kynnersley, Robert, of Wolverhampton, executor of Hickelyng, Isabel, of Stony Stratford, Bucks, widow, administrators of 0
3765338 1946821 1946821 plaintiff Kynnersley Robert (legal representative) 588127 588127 Kynnersley, Robert, of Wolverhampton, executor of Hyckelyng, Isabel, of Stony Stratford, Bucks, widow, administrators of 0
3771923 1948912 1948912 defendant Byng James mercer 588127 588127 Byng, James, of Wolverhampton, mercer 0
3774953 1949898 1949898 plaintiff Barrey Richard   588127 588127 Barrey, Richard, of Wolverhampton 0
3775515 1950085 1950085 defendant Luson John gent 588127 588127 Luson, John, of Wolverhampton, gent 0
3775516 1950085 1950085 defendant Cowesey Gen tanner 588127 588127 Cowesey, Gen, of Wolverhampton, tanner 1
3778122 1950868 1950868 defendant Wyrrall John cordwainer 588127 588127 Wyrrall, John, of Wolverhampton, cordwainer 2
3781226 1951868 1951868 defendant Fleccher John fletcher 588127 588127 Fleccher, John, of Wolverhampton, fletcher 0
3782435 1952248 1952248 defendant Barton Ralph tailor 588127 588127 Barton, Ralph, of Wolverhampton, tailor 4
3783009 1952437 1952437 defendant Whitmere Robert innholder 588127 588127 Whitmere, Robert, of Wolverhampton, innholder 0
3783011 1952437 1952437 defendant Cadney Thomas mercer 588127 588127 Cadney, Thomas, of Wolverhampton, mercer 2
3783390 1952555 1952555 plaintiff Kynnersley Robert (legal representative) 588127 588127 Kynnersley, Robert, of Wolverhampton, executor of Hyckelyng, Isabel, of Stony Stratford, widow, administrators of 0
3788708 1954271 1954271 defendant Bynge James yeoman 588127 588127 Bynge, James, of Wolverhampton, yeoman 0
3792750 1955586 1955586 defendant Heylyn Nicholas merchant of the staple 588127 588127 Heylyn, Nicholas, of Wolverhampton, merchant of the staple 0
3795562 1956494 1956494 defendant Byng James yeoman 588127 588127 Byng, James, of Wolverhampton, yeoman 0
3796909 1956912 1956912 defendant Whytmer William yeoman 588127 588127 Whytmer, William, of Wolverhampton, yeoman 0
3797011 1956943 1956943 defendant Luson Thomas gent 588127 588127 Luson, Thomas, of Wolverhampton, gent 0
3797932 1957251 1957251 defendant Bennet Nicholas nailer 588127 588127 Bennet, Nicholas, of Wolverhampton, nailer 1
3799020 1957605 1957605 defendant Barton Ralph laborer 588127 588127 Barton, Ralph, of Wolverhampton, laborer 0
3799900 1957886 1957886 plaintiff Kynnersley Robert (legal representative) 588127 588127 Kynnersley, Robert, of Wolverhampton, executor of Hicklyng, Isabel, of Stony Stratford, Bucks, widow, administrators of 0
3801220 1958304 1958304 defendant Corbett Thomas drover 588127 588127 Corbett, Thomas, of Wolverhampton, drover 0
3802941 1958816 1958816 defendant Rydley Richard gent 588127 588127 Rydley, Richard, of Wolverhampton, gent 1
3809359 1960811 1960811 defendant Rideley Richard gent 588127 588127 Rideley, Richard, of Wolverhampton, gent 1
3809754 1960940 1960940 defendant Rideley Richard gent 588127 588127 Rideley, Richard, of Wolverhampton, gent 1
3823210 1965172 1965172 defendant Gurden Nicholas glover 588127 588127 Gurden, Nicholas, of Wolverhampton, glover 3
3829444 1967093 1967093 defendant Forster Richard gent 588127 588127 Forster, Richard, of Wolverhampton, gent 0
3829446 1967093 1967093 defendant Rypton Thomas smith 588127 588127 Rypton, Thomas, of Wolverhampton, smith 2
3831716 1967820 1967820 defendant Whytmer Robert merchant of the staple 588127 588127 Whytmer, Robert, of Wolverhampton, merchant of the staple 0
3844146 1971717 1971717 defendant Leveson Thomas gent 588127 588127 Leveson, Thomas, of Wolverhampton, gent 0
3844805 1971920 1971920 defendant Whytmere Robert yeoman 588127 588127 Whytmere, Robert, of Wolverhampton, yeoman 1
3844837 1971928 1971928 defendant Russhton Lewis mercer 588127 588127 Russhton, Lewis, of Wolverhampton, mercer 0
3844838 1971928 1971928 defendant Nevett Thomas mercer 588127 588127 Nevett, Thomas, of Wolverhampton, mercer 1
3846430 1972437 1972437 defendant Leveson Thomas gent 588127 588127 Leveson, Thomas, of Wolverhampton, gent 0
3849387 1973406 1973406 plaintiff Leveson James   588127 588127 Leveson, James, of Wolverhampton, merchant, esq, receiver general for Tucket, John, knight, Lord Awdeley 0
3849394 1973407 1973407 defendant Howlett John draper 588127 588127 Howlett, John, of Wolverhampton, draper 0
3852785 1974476 1974476 defendant Barton Ralph tailor 588127 588127 Barton, Ralph, of Wolverhampton, tailor 0
3852787 1974477 1974477 defendant Barton Ralph tailor 588127 588127 Barton, Ralph, of Wolverhampton, tailor 0
3852790 1974478 1974478 defendant Rydley Richard gent 588127 588127 Rydley, Richard, of Wolverhampton, gent 1
3857824 1976085 1976085 defendant Cowley Alice widow 588127 588127 Cowley, Alice, of Wolverhampton, widow 2
3860360 1976964 1976964 plaintiff Cutte Robert (legal representative) 588127 588127 Cutte, Robert, of Wolverhampton, executors of 0
3860368 1976965 1976965 plaintiff Cutte Robert (legal representative) 588127 588127 Cutte, Robert, of Wolverhampton, executors of 0
3860372 1976965 1976965 defendant Bynge James   588127 588127 Bynge, James, of Wolverhampton, mercer, son of Byngg, John, of Wolverhampton 1
3860373 1976966 1976966 plaintiff Cutte Robert (legal representative) 588127 588127 Cutte, Robert, of Wolverhampton, executors of 0
3862241 1977556 1977556 defendant Lyveson Thomas gent 588127 588127 Lyveson, Thomas, of Wolverhampton, gent 0
3862242 1977556 1977556 defendant Ingram William laborer 588127 588127 Ingram, William, of Wolverhampton, laborer 1
3874314 1981634 1981634 defendant Banys Agnes widow 588127 588127 Banys, Agnes, of Wolverhampton, widow 2
3874609 1981729 1981729 plaintiff Cutt Robert (legal representative) 588127 588127 Cutt, Robert, of Wolverhampton, executors of 0
3874612 1981729 1981729 defendant Fourde alias Baker Thomas yeoman 588127 588127 Fourde alias Baker, Thomas, of Wolverhampton, yeoman 0
3876517 1982392 1982392 defendant Leveson Thomas gent 588127 588127 Leveson, Thomas, of Wolverhampton, gent 0
3876518 1982392 1982392 defendant Ingram William laborer 588127 588127 Ingram, William, of Wolverhampton, laborer 1
3877521 1982719 1982719 defendant Leveson Thomas esq 588127 588127 Leveson, Thomas, of Wolverhampton, esq 0
3878563 1983076 1983076 plaintiff Leveson James esq 588127 588127 Leveson, James, of Wolverhampton, esq 0
3878571 1983079 1983079 defendant Howlett John draper 588127 588127 Howlett, John, of Wolverhampton, draper 0
3882005 1984241 1984241 defendant Aberton Ralph chapman 588127 588127 Aberton, Ralph, of Wolverhampton, chapman 0
3887558 1986089 1986089 defendant Sheldon Thomas laborer 588127 588127 Sheldon, Thomas, of Wolverhampton, laborer 2
3888971 1986553 1986553 plaintiff Foxall John, junior   588127 588127 Foxall, John, junior, of Wolverhampton 0
3888974 1986553 1986553 defendant Benbowe John fisher 588127 588127 Benbowe, John, of Wolverhampton, fisher 2
3889537 1986732 1986732 defendant Smyth Thomas yeoman 588127 588127 Smyth, Thomas, of Wolverhampton, yeoman 1
3904955 1991919 1991919 defendant Latymer John whitawer 588127 588127 Latymer, John, of Wolverhampton, whitawer 0
3921008 1997374 1997374 defendant Muggall John (legal representative) 588127 588127 Muggall, John, of Wolverhampton, administratrix of 2
3924538 1998521 1998521 defendant Franke John sherman 588127 588127 Franke, John, of Wolverhampton, sherman 1
3924539 1998521 1998521 defendant Toye Henry tailor 588127 588127 Toye, Henry, of Wolverhampton, tailor 2
3927904 1999670 1999670 defendant Creswall Thomas tailor 588127 588127 Creswall, Thomas, of Wolverhampton, tailor 0
3930635 2000592 2000592 plaintiff Creswall William   588127 588127 Creswall, William, of Wolverhampton 0
3933212 2001403 2001403 defendant Warynges Nicholas gent 588127 588127 Warynges, Nicholas, of Wolverhampton, gent 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);