names

126 rows where place_id = 597387

✎ 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
3628374 1903740 1903740 defendant Wiat Richard clerk 597387 597387 Wiat, Richard, of Southwell, clerk 0
3630737 1904437 1904437 defendant Savage James (legal representative) 597387 597387 Savage, James, of Southwell, esq, executrix of 1
3658093 1912786 1912786 defendant Ellys Henry mercer 597387 597387 Ellys, Henry, of Southwell, mercer 0
3696430 1925108 1925108 defendant Benne Thomas butcher 597387 597387 Benne, Thomas, of Southwell, butcher 0
3707832 1928747 1928747 defendant Kynston or Kyngston Edmund clerk 597387 597387 Kynston or Kyngston, Edmund, of Southwell, clerk 0
3761673 1945662 1945662 defendant Wryght John yeoman 597387 597387 Wryght, John, of Southwell, yeoman 0
3767573 1947495 1947495 defendant Barry Robert (legal representative) 597387 597387 Barry, Robert, of Southwell, clerk, executors of 1
3767574 1947495 1947495 defendant Barry Robert, senior yeoman 597387 597387 (Barry, Robert, senior, of Southwell, yeoman 2
3767575 1947495 1947495 defendant Barry Robert, junior yeoman 597387 597387 Barry, Robert, junior, of Southwell, yeoman 3
3875850 1982178 1982178 defendant Loksmyth alias Brereley Edward clerk 597387 597387 Loksmyth alias Brereley, Edward, of Southwell, clerk 0
3897833 1989479 1989479 defendant Lyttell Thomas husbandman 597387 597387 Lyttell, Thomas, of Southwell, husbandman 0
3906602 1992502 1992502 defendant Ambre Robert butcher 597387 597387 Ambre, Robert, of Southwell, butcher 0
3913174 1994741 1994741 defendant FitzHerbert John clerk 597387 597387 FitzHerbert, John, of Southwell, clerk 0
3913175 1994741 1994741 defendant Held Thomas yeoman 597387 597387 Held, Thomas, of Southwell, yeoman 1
3913176 1994741 1994741 defendant Woodcok Henry yeoman 597387 597387 Woodcok, Henry, of Southwell, yeoman 2
3913177 1994741 1994741 defendant Pereson Thomas yeoman 597387 597387 Pereson, Thomas, of Southwell, yeoman 3
3913178 1994741 1994741 defendant Bull George laborer 597387 597387 Bull, George, of Southwell, laborer 4
3935859 2002304 2002304 plaintiff Lee Reginal esq 597387 597387 Lee, Reginal, of Southwell, esq 0
3937600 2002908 2002908 defendant Bulbye Robert tanner 597387 597387 Bulbye, Robert, of Southwell, tanner 1
3937714 2002947 2002947 defendant Baynes Richard husbandman 597387 597387 Baynes, Richard, of Southwell, husbandman 0
3951613 2007618 2007618 defendant Lee Reginald gent 597387 597387 Lee, Reginald, of Southwell, gent 2
3955348 2008938 2008938 defendant Lee Reginald gent 597387 597387 Lee, Reginald, of Southwell, gent 0
3955349 2008938 2008938 defendant Lemmyng Lawrence laborer 597387 597387 Lemmyng, Lawrence, of Southwell, laborer 1
3955350 2008938 2008938 defendant Bayte Randall laborer 597387 597387 Bayte, Randall, of Southwell, laborer 2
3955351 2008938 2008938 defendant Baynes Robert laborer 597387 597387 Baynes, Robert, of Southwell, laborer 3
3955643 2009046 2009046 defendant Lee Geoffrey (legal representative) 597387 597387 Lee, Geoffrey, of Southwell, esq, father of Reginald, administrator of Edward Lee, Archbishop of York, executor of 0
3967252 2013174 2013174 defendant Caley William husbandman 597387 597387 Caley, William, of Southwell, husbandman 0
3989933 2021156 2021156 plaintiff Beamond James gent 597387 597387 Beamond, James, of Southwell, gent 0
3989934 2021156 2021156 plaintiff Beamond Agnes widow of Jefferey Lee, esq 597387 597387 Agnes his wife, widow of Jefferey Lee, of Southwell, esq 1
3992151 2021957 2021957 plaintiff Bulby Robert tanner 597387 597387 Bulby, Robert, of Southwell, tanner 0
4001036 2025145 2025145 defendant Grayme Roger yeoman 597387 597387 Grayme, Roger, of Southwell, yeoman 0
4015692 2030310 2030310 defendant Troughton Thomas gent 597387 597387 Troughton, Thomas, of Southwell, gent 0
4015693 2030310 2030310 defendant Seynton Edward gent 597387 597387 Seynton, Edward, of Southwell, gent 1
4015700 2030313 2030313 defendant Seynton Edward gent 597387 597387 Seynton, Edward, of Southwell, gent 1
4054482 2043993 2043993 defendant Trowghton Thomas gent 597387 597387 Trowghton, Thomas, of Southwell, gent 0
4057987 2045236 2045236 defendant Troughton Thomas   597387 597387 Troughton, Thomas, of Southwell gent 0
4062597 2046915 2046915 defendant Aslyn Thomas husbandman 597387 597387 Aslyn, Thomas, of Southwell, husbandman 1
4103653 2061585 2061585 defendant Chapman Richard smith 597387 597387 Chapman, Richard, of Southwell, smith 3
4115936 2065985 2065985 defendant Gylbey Margaret widow 597387 597387 Gylbey, Margaret, of Southwell, widow 1
4121617 2068025 2068025 defendant Burnell Edward gent 597387 597387 Burnell, Edward, of Southwell, gent 0
4144605 2076273 2076273 defendant Wethered Thomas clerk 597387 597387 Wethered, Thomas, of Southwell, clerk 0
4151500 2078647 2078647 defendant Wethered Thomas yeoman 597387 597387 Wethered, Thomas, of Southwell, yeoman 0
4153172 2079209 2079209 defendant Walker Robert yeoman 597387 597387 Walker, Robert, of Southwell, yeoman 0
4154528 2079677 2079677 defendant Wethered Thomas clerk 597387 597387 Wethered, Thomas, of Southwell, clerk 0
4157215 2080593 2080593 defendant Wethered Thomas   597387 597387 Wethered, Thomas, of Southwell, clerk, prebendary of Southell 0
4162694 2082508 2082508 defendant Wetherde Thomas   597387 597387 Wetherde, Thomas, of Southwell clerk, prebendary of collegiate church of Southwell 0
4186985 2090940 2090940 defendant Southby John, senior yeoman 597387 597387 Southby, John, senior, of Southwell, yeoman 0
4228801 2105556 2105556 defendant Stringer George gent 597387 597387 Stringer, George, of Southwell, gent 0
4250967 2113304 2113304 defendant Baskafeld Hugh   597387 597387 Baskafeld, Hugh, of Southwell, gent, administrators of 0
4300321 2130216 2130216 defendant Matlocke Robert husbandman 597387 597387 Matlocke, Robert, of Southwell, husbandman 0
4304226 2131613 2131613 defendant Sterne Thomas tailor 597387 597387 Sterne, Thomas, of Southwell, or of of Harleston, Norf, tailor 0
4346057 2145877 2145877 defendant Kerrell   gent 597387 597387 Kerrell, , of Southwell, gent 1
4362263 2151551 2151551 defendant Markham John gent 597387 597387 Markham, John, of Southwell, gent 0
4375253 2156203 2156203 defendant Feild Jervase butcher 597387 597387 Feild, Jervase, of Southwell, butcher 0
4377094 2156882 2156882 defendant Feiuld Jervase butcher 597387 597387 Feiuld, Jervase, of Southwell, butcher 0
4380391 2158096 2158096 defendant Barley Thomas laborer 597387 597387 Barley, Thomas, of Southwell, laborer 0
4408144 2167293 2167293 defendant Willingbye William yeoman 597387 597387 Willingbye, William, of Southwell, yeoman 2
4416565 2170044 2170044 defendant Bakestere John le   597387 597387 Bakestere, John le, of Southwell 0
4464788 2189650 2189650 defendant Richemond John   597387 597387 Richemond, John, of Southwell 4
4464796 2189651 2189651 defendant Richaemond John de   597387 597387 Richaemond, John de, of Southwell 4
4482888 2195350 2195350 defendant Worsop John draper 597387 597387 Worsop, John, of Southwell, draper 0
4506046 2202403 2202403 defendant Smyth John   597387 597387 Smyth, John, of Southwell 0
4521277 2206999 2206999 plaintiff Fyssher John   597387 597387 Fyssher, John, of Southwell, son of John 3
4530479 2209828 2209828 defendant Enyngton John de (legal representative) 597387 597387 Enyngton, John de, of Southwell, executrix of 2
4530480 2209828 2209828 defendant Enyngton Alice de   597387 597387 Enyngton, Alice de, of Southwell, formerly wife of John 3
4531609 2210153 2210153 defendant Leydenham John de   597387 597387 Leydenham, John de, of Southwell 3
4540708 2212999 2212999 plaintiff Rolleston Thomas de   597387 597387 Rolleston, Thomas de, of Southwell, vicar choral(? 1
4541552 2213253 2213253 plaintiff Wryght Roger   597387 597387 Wryght, Roger, of Southwell 0
4556259 2217899 2217899 defendant Evyngton John de (legal representative) 597387 597387 Evyngton, John de, of Southwell, executors of 0
4570758 2222426 2222426 defendant Kyrkard John   597387 597387 Kyrkard, John, of Southwell 0
4580061 2225252 2225252 defendant Hudde William   597387 597387 Hudde, William, of Southwell 0
4583808 2226353 2226353 plaintiff Andrewe Richard   597387 597387 (Andrewe, Richard, of Southwell, perpetual vicar 1
4583809 2226353 2226353 plaintiff Ulseby Hugh   597387 597387 Ulseby, Hugh, of Southwell, vicar choral 2
4612041 2234832 2234832 plaintiff Conyngston Richard clerk & canon of the collegiate church of the BM 597387 597387 Conyngston, Richard, of Southwell, clerk & canon of the collegiate church of the BM 0
4614918 2235676 2235676 plaintiff Eppeworth John de   597387 597387 Eppeworth, John de, of Southwell, vicar choral in the collegiate church 0
4614920 2235677 2235677 plaintiff Eppeworth John de   597387 597387 Eppeworth, John de, of Southwell, vicar choral in the collegiate church 0
4630560 2240471 2240471 defendant Kyrkeby alias Fowne Henry de   597387 597387 Kyrkeby alias Fowne, Henry de, of Southwell 1
4639418 2243043 2243043 plaintiff Conyngston Richard clerk & canon of the collegiate church of the BM 597387 597387 Conyngston, Richard, of Southwell, master, clerk & canon of the collegiate church of the BM 0
4642538 2243940 2243940 defendant Ledenham John   597387 597387 Ledenham, John, of Southwell 1
4642539 2243940 2243940 defendant Fawen Henry   597387 597387 Fawen, Henry, of Southwell 2
4642542 2243940 2243940 defendant Andrewe Richard   597387 597387 Andrewe, Richard, of Southwell, vicar 5
4646068 2244923 2244923 defendant Cache John butcher 597387 597387 Cache, John, of Southwell, butcher 3
4697821 2264817 2264817 defendant Bule Walter chapman 597387 597387 Bule, Walter, of Southwell, chapman 0
4704694 2266849 2266849 defendant Snowe William tailor 597387 597387 Snowe, William, of Southwell, tailor 0
4710989 2268794 2268794 plaintiff Roldeston Thomas   597387 597387 Roldeston, Thomas, of Southwell, vicar choral, in the collegiate church 0
4711439 2268906 2268906 defendant Hudde William husbandman 597387 597387 Hudde, William, of Southwell, husbandman 0
4713566 2269563 2269563 defendant Bocher Thomas butcher 597387 597387 Bocher, Thomas, of Southwell, butcher 1
4716404 2270448 2270448 defendant Hudde William butcher 597387 597387 Hudde, William, of Southwell, butcher 2
4724554 2272976 2272976 defendant Kyng Thomas chapman 597387 597387 Kyng, Thomas, of Southwell, chapman 0
4732243 2275264 2275264 defendant Abbot John mercer 597387 597387 Abbot, John, of Southwell, mercer 0
4732244 2275264 2275264 defendant Hughson John husbandman 597387 597387 Hughson, John, of Southwell, husbandman 1
4734281 2275897 2275897 plaintiff Sampson Margaret   597387 597387 Sampson, Margaret, of Southwell, formerly wife of Robert 0
4736538 2276558 2276558 defendant Cumberworth Robert   597387 597387 Cumberworth, Robert, of Southwell, gent, formerly of Hundon, Lincs 0
4749830 2280424 2280424 defendant Dorant Richard gent 597387 597387 Dorant, Richard, of Southwell, gent 2
4754827 2281889 2281889 defendant Rag Thomas yeoman 597387 597387 Rag, Thomas, of Southwell, yeoman 2
4773221 2287593 2287593 defendant Sutton John husbandman 597387 597387 Sutton, John, of Southwell, husbandman 0
4775700 2288396 2288396 defendant Lombe William husbandman 597387 597387 Lombe, William, of Southwell, husbandman 0
4797337 2295340 2295340 defendant Archer Walter yeoman 597387 597387 Archer, Walter, of Southwell, yeoman 0
4821791 2302892 2302892 defendant Wyntryngton Richard husbandman 597387 597387 Wyntryngton, Richard, of Southwell, husbandman 0
4821801 2302893 2302893 defendant Hoson John husbandman 597387 597387 Hoson, John, of Southwell, husbandman 3

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