names

197 rows where place_id = 590055

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599736 1867562 1867562 defendant Grene Brian butcher 590055 590055 Grene, Brian, of Solyhull, butcher 0
3599737 1867562 1867562 defendant Bowatur Richard husbandman 590055 590055 Bowatur, Richard, of Solyhull, husbandman 1
3599738 1867562 1867562 defendant atte Wode Thomas husbandman 590055 590055 atte Wode, Thomas, of Solyhull, husbandman 2
3643286 1908325 1908325 defendant Butteler Katherine widow 590055 590055 Butteler, Katherine, of Solyhull, widow 0
3645963 1909130 1909130 defendant Butler Katherine widow 590055 590055 Butler, Katherine, of Solyhull, widow 1
3649968 1910356 1910356 defendant Wollette John husbandman 590055 590055 Wollette, John, of Solyhull, husbandman 0
3649976 1910358 1910358 defendant Wollet John husbandman 590055 590055 Wollet, John, of Solyhull, husbandman 0
3651535 1910837 1910837 defendant Butler Richard gent 590055 590055 Butler, Richard, of Solyhull, gent 0
3653058 1911286 1911286 defendant Harwell Roger gent 590055 590055 Harwell, Roger, of Solyhull, gent 2
3658189 1912815 1912815 defendant Goldsmyth Peter draper 590055 590055 Goldsmyth, Peter, of Solyhull, draper 1
3659733 1913296 1913296 defendant Ecculs Edward carpenter 590055 590055 Ecculs, Edward, of Solyhull, carpenter 0
3659735 1913296 1913296 defendant Mathewe John butcher 590055 590055 Mathewe, John, of Solyhull, butcher 2
3663234 1914425 1914425 defendant Barnethurst John husbandman 590055 590055 Barnethurst, John, of Solyhull, husbandman 0
3664095 1914722 1914722 defendant Wellott John husbandman 590055 590055 Wellott, John, of Solyhull, husbandman 0
3664245 1914766 1914766 defendant Wellett John husbandman 590055 590055 Wellett, John, of Solyhull, husbandman 0
3671612 1917106 1917106 defendant Hunter Nicholas yeoman 590055 590055 Hunter, Nicholas, of Solyhull, yeoman 0
3701549 1926731 1926731 defendant Wodewall William weaver 590055 590055 Wodewall, William, of Solyhull, weaver 0
3701550 1926731 1926731 defendant Eccles alias Gales Edward carpenter 590055 590055 Eccles alias Gales, Edward, of Solyhull, carpenter 1
3714829 1930938 1930938 defendant Boteler Richard gent 590055 590055 Boteler, Richard, of Solyhull, gent 0
3724250 1933871 1933871 defendant Harwell Roger gent 590055 590055 Harwell, Roger, of Solyhull, gent 0
3731401 1936043 1936043 defendant Fulford Richard husbandman 590055 590055 Fulford, Richard, of Solyhull, husbandman 0
3734880 1937149 1937149 defendant Cossage Alan smith 590055 590055 Cossage, Alan, of Solyhull, smith 1
3735833 1937445 1937445 defendant Wold James butcher 590055 590055 Wold, James, of Solyhull, butcher 0
3735834 1937445 1937445 defendant Harwell Roger gent 590055 590055 Harwell, Roger, of Solyhull, gent 1
3735836 1937445 1937445 defendant Cokkys William yeoman 590055 590055 Cokkys, William, of Solyhull, yeoman 3
3740989 1939040 1939040 defendant Walker Thomas yeoman 590055 590055 Walker, Thomas, of Solyhull, yeoman 0
3759188 1944861 1944861 defendant Hygford Richard yeoman 590055 590055 Hygford, Richard, of Solyhull, yeoman 1
3773667 1949482 1949482 defendant Hygford Richard yeoman 590055 590055 Hygford, Richard, of Solyhull, yeoman 0
3775735 1950160 1950160 defendant Corveser Thomas yeoman 590055 590055 Corveser, Thomas, of Solyhull, yeoman 0
3791039 1955029 1955029 defendant Wodwall William yeoman 590055 590055 Wodwall, William, of Solyhull, yeoman 0
3823737 1965321 1965321 defendant Holden Richard laborer 590055 590055 Holden, Richard, of Solyhull, laborer 0
3823738 1965321 1965321 defendant Coterell Thomas laborer 590055 590055 Coterell, Thomas, of Solyhull, laborer 1
3823739 1965321 1965321 defendant Corser Thomas laborer 590055 590055 Corser, Thomas, of Solyhull, laborer 2
3898664 1989761 1989761 defendant Bretten Danie smith 590055 590055 Bretten, Danie, of Solyhull, smith 0
3903710 1991472 1991472 defendant Grysewold Alice spinster 590055 590055 Grysewold, Alice, of Solyhull, spinster 0
3928920 2000010 2000010 defendant Gryffyth John laborer 590055 590055 Gryffyth, John, of Solyhull, laborer 2
3930225 2000458 2000458 defendant Bott Humphrey yeoman 590055 590055 Bott, Humphrey, of Solyhull, yeoman 0
3955368 2008942 2008942 defendant Hall Nicholas husbandman 590055 590055 Hall, Nicholas, of Solyhull, husbandman 2
3955369 2008942 2008942 defendant Kymberley or Rymberley Richard husbandman 590055 590055 Kymberley or Rymberley, Richard, of Solyhull, husbandman 3
3955370 2008942 2008942 defendant Glover James husbandman 590055 590055 Glover, James, of Solyhull, husbandman 4
3957155 2009567 2009567 defendant Ball William laborer 590055 590055 Ball, William, of Solyhull, laborer 0
3957156 2009567 2009567 defendant Ley John cutler 590055 590055 Ley, John, of Solyhull, cutler 1
3978131 2016929 2016929 plaintiff Marston Thomas carpenter 590055 590055 Marston, Thomas, of Solyhull, carpenter 0
4015161 2030114 2030114 defendant Marrowe Andrew gent 590055 590055 Marrowe, Andrew, of Solyhull, gent 1
4050530 2042618 2042618 plaintiff Watton William   590055 590055 Watton, William, of Solyhull 0
4055842 2044472 2044472 defendant Bowkeley Margery spinster 590055 590055 Bowkeley, Margery, of Solyhull, spinster 2
4067174 2048559 2048559 plaintiff Hygford Henry gent 590055 590055 Hygford, Henry, of Solyhull, gent 0
4067437 2048663 2048663 defendant Smyth Henry clerk 590055 590055 Smyth, Henry, of Solyhull, clerk 0
4067438 2048663 2048663 defendant Walker John tanner 590055 590055 Walker, John, of Solyhull, tanner 1
4067439 2048663 2048663 defendant Evans Roger tailor 590055 590055 Evans, Roger, of Solyhull, tailor 2
4067442 2048664 2048664 defendant Evans Roger tailor 590055 590055 Evans, Roger, of Solyhull, tailor 1
4069416 2049344 2049344 plaintiff Ley Humphrey (legal representative) 590055 590055 Ley, Humphrey, of Solyhull, tanner, executor of 0
4070155 2049616 2049616 defendant Tayler Edward sherman 590055 590055 Tayler, Edward, of Solyhull, sherman 1
4074468 2051172 2051172 defendant Butler William yeoman 590055 590055 Butler, William, of Solyhull, yeoman 2
4074471 2051173 2051173 defendant Pennynge Humphrey tailor 590055 590055 Pennynge, Humphrey, of Solyhull, tailor 0
4086754 2055549 2055549 defendant Tayler Thomas yeoman 590055 590055 Tayler, Thomas, of Solyhull, yeoman 0
4102016 2061030 2061030 defendant Wright Nicholas husbandman 590055 590055 Wright, Nicholas, of Solyhull, husbandman 1
4105080 2062090 2062090 defendant Gossage Alan carpenter 590055 590055 Gossage, Alan, of Solyhull, carpenter 0
4105081 2062090 2062090 defendant Dounton Simon carpenter 590055 590055 Dounton, Simon, of Solyhull, carpenter 1
4118598 2066946 2066946 defendant Junckson Richard husbandman 590055 590055 Junckson, Richard, of Solyhull, husbandman 0
4118599 2066946 2066946 defendant Baker Thomas collier 590055 590055 Baker, Thomas, of Solyhull, collier 1
4121903 2068131 2068131 defendant Wythye John husbandman 590055 590055 Wythye, John, of Solyhull, husbandman 1
4121904 2068131 2068131 defendant Cottrell Thomas miller 590055 590055 Cottrell, Thomas, of Solyhull, miller 2
4122367 2068310 2068310 defendant Hawes William yeoman 590055 590055 Hawes, William, of Solyhull, yeoman 0
4130382 2071179 2071179 defendant Higford Henry, senior gent 590055 590055 Higford, Henry, senior, of Solyhull, gent 0
4130383 2071179 2071179 defendant Higford Henry, junior gent 590055 590055 Higford, Henry, junior, of Solyhull, gent 1
4130385 2071180 2071180 defendant Higford Henry, senior gent 590055 590055 Higford, Henry, senior, of Solyhull, gent 0
4130386 2071180 2071180 defendant Higford Henry, junior gent 590055 590055 Higford, Henry, junior, of Solyhull, gent 1
4141200 2075080 2075080 defendant Cotterell Robert weaver 590055 590055 Cotterell, Robert, of Solyhull, weaver 0
4147350 2077212 2077212 defendant Cottrell John yeoman 590055 590055 Cottrell, John, of Solyhull, yeoman 0
4147351 2077212 2077212 defendant Gilbert Thomas weaver 590055 590055 Gilbert, Thomas, of Solyhull, weaver 1
4147934 2077411 2077411 defendant Swett Timothy yeoman 590055 590055 Swett, Timothy, of Solyhull, yeoman 0
4147935 2077411 2077411 defendant Redele Cornelius carpenter 590055 590055 Redele, Cornelius, of Solyhull, carpenter 1
4148914 2077739 2077739 defendant Dawes Henry mercer 590055 590055 Dawes, Henry, of Solyhull, mercer 1
4153873 2079450 2079450 defendant Doley William husbandman 590055 590055 Doley, William, of Solyhull, husbandman 0
4153874 2079450 2079450 defendant Ashehurste William husbandman 590055 590055 Ashehurste, William, of Solyhull, husbandman 1
4153875 2079450 2079450 defendant Ashehurste Richard laborer 590055 590055 Ashehurste, Richard, of Solyhull, laborer 2
4153877 2079451 2079451 defendant Doley William husbandman 590055 590055 Doley, William, of Solyhull, husbandman 0
4153878 2079451 2079451 defendant Ashehurste William husbandman 590055 590055 Ashehurste, William, of Solyhull, husbandman 1
4153879 2079451 2079451 defendant Ashehurste William laborer 590055 590055 Ashehurste, William, of Solyhull, laborer 2
4153881 2079452 2079452 defendant Doley William husbandman 590055 590055 Doley, William, of Solyhull, husbandman 0
4153882 2079452 2079452 defendant Ashehurste William husbandman 590055 590055 Ashehurste, William, of Solyhull, husbandman 1
4153883 2079452 2079452 defendant Kemble Nicholas husbandman 590055 590055 Kemble, Nicholas, of Solyhull, husbandman 2
4153884 2079452 2079452 defendant Tuckey Nicholas butcher 590055 590055 Tuckey, Nicholas, of Solyhull, butcher 3
4156413 2080319 2080319 defendant Willies John husbandman 590055 590055 Willies, John, of Solyhull, husbandman 0
4169668 2084881 2084881 defendant Fulforde Richard husbandman 590055 590055 Fulforde, Richard, of Solyhull, husbandman 0
4170309 2085108 2085108 defendant Duffe alias Duffeilde John husbandman 590055 590055 Duffe alias Duffeilde, John, of Solyhull, husbandman 0
4176917 2087398 2087398 defendant Weley Robert wheeler 590055 590055 Weley, Robert, of Solyhull, or of Horbourne, Staffs, wheeler 0
4176918 2087398 2087398 defendant Weley Thomas nailer 590055 590055 Weley, Thomas, of Solyhull, or of Horbourne, nailer 1
4187051 2090962 2090962 defendant Swifte William tanner 590055 590055 Swifte, William, of Solyhull, tanner 0
4187778 2091228 2091228 defendant Dawes Henry mercer 590055 590055 Dawes, Henry, of Solyhull, mercer 1
4192464 2092923 2092923 defendant Hawkes William yeoman 590055 590055 Hawkes, William, of Solyhull, yeoman 0
4192551 2092957 2092957 defendant Brookes Francis yeoman 590055 590055 Brookes, Francis, of Solyhull, yeoman 0
4199421 2095345 2095345 defendant Gybbs William husbandman 590055 590055 Gybbs, William, of Solyhull, husbandman 0
4203731 2096861 2096861 defendant Willies John husbandman 590055 590055 Willies, John, of Solyhull, husbandman 0
4222436 2103340 2103340 defendant Wolley Henry gent 590055 590055 Wolley, Henry, of Solyhull, gent 0
4222437 2103340 2103340 defendant Penn John shoemaker 590055 590055 Penn, John, of Solyhull, shoemaker 1
4279800 2122853 2122853 defendant Balle William butcher 590055 590055 Balle, William, of Solyhull, butcher 0
4296425 2128822 2128822 defendant Say William brewer 590055 590055 Say, William, of Solyhull, brewer 1
4297284 2129136 2129136 defendant Reddell Thomas carpenter 590055 590055 Reddell, Thomas, of Solyhull, carpenter 2

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