names

163 rows where place_id = 596437

✎ 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
3624757 1875279 1875279 defendant Gybson Thomas yeoman 596437 596437 Gybson, Thomas, of Soterton, yeoman 1
3624759 1875279 1875279 defendant Pees John yeoman 596437 596437 Pees, John, of Soterton, yeoman 3
3655027 1911836 1911836 defendant Morfote Richard husbandman 596437 596437 Morfote, Richard, of Soterton, husbandman 0
3655028 1911836 1911836 defendant Saunderson Thomas husbandman 596437 596437 Saunderson, Thomas, of Soterton, husbandman 1
3655029 1911836 1911836 defendant Bray John husbandman 596437 596437 Bray, John, of Soterton, husbandman 2
3688299 1922488 1922488 defendant Gybon Thomas cutler 596437 596437 Gybon, Thomas, of Soterton, cutler 0
3690996 1923347 1923347 defendant Dughty Thomas husbandman 596437 596437 Dughty, Thomas, of Soterton, husbandman 0
3691007 1923351 1923351 plaintiff Halgh Thomas gent 596437 596437 Halgh, Thomas, of Soterton, gent 0
3691010 1923351 1923351 defendant Gybon Thomas cutler 596437 596437 Gybon, Thomas, of Soterton, cutler 2
3705323 1927954 1927954 defendant Bradshawe Richard yeoman 596437 596437 Bradshawe, Richard, of Soterton, yeoman 0
3735154 1937231 1937231 defendant Alger Richard husbandman 596437 596437 Alger, Richard, of Soterton, husbandman 0
3748720 1941530 1941530 defendant Alger Richard husbandman 596437 596437 Alger, Richard, of Soterton, husbandman 0
3763194 1946124 1946124 defendant Alger Richard husbandman 596437 596437 Alger, Richard, of Soterton, husbandman 0
3786246 1953495 1953495 defendant Dyconson John husbandman 596437 596437 Dyconson, John, of Soterton, husbandman 0
3815270 1962691 1962691 defendant Benett Richard husbandman 596437 596437 Benett, Richard, of Soterton, husbandman 1
3876679 1982445 1982445 defendant Howson Thomas tailor 596437 596437 Howson, Thomas, of Soterton, tailor 1
3986014 2019766 2019766 plaintiff Waysse or Wace Richard yeoman 596437 596437 Waysse or Wace, Richard, of Soterton, yeoman 0
4038349 2038355 2038355 defendant Irbie Leonard (legal representative) 596437 596437 Irbie, Leonard, of Soterton, esq, executrix of 0
4172828 2085951 2085951 defendant Benet William   596437 596437 Benet, William, of Soterton husbandman 1
4196050 2094169 2094169 defendant Benet William husbandman 596437 596437 Benet, William, of Soterton, husbandman 1
4431179 2174511 2174511 defendant Skynner Roger   596437 596437 Skynner, Roger, of Soterton 0
4431656 2174668 2174668 defendant Boneworte Richard   596437 596437 Boneworte, Richard, of Soterton 1
4432745 2174996 2174996 plaintiff Strug or String John   596437 596437 Strug or String, John, of Soterton 3
4439518 2181623 2181623 defendant Clerk John   596437 596437 Clerk, John, of Soterton, son of Gilbert 0
4439545 2181631 2181631 defendant Clerk John   596437 596437 Clerk, John, of Soterton, son of William 0
4439549 2181632 2181632 defendant Clerk John   596437 596437 Clerk, John, of Soterton, son of William 0
4439550 2181632 2181632 defendant Clerk John   596437 596437 Clerk, John, of Soterton, son of John 1
4439551 2181632 2181632 defendant Clerk John   596437 596437 together with Clerk, John, of Soterton, son of Gilbert 2
4439552 2181632 2181632 defendant Clerk Alice   596437 596437 Clerk, Alice, of Soterton, sister of John, son of John 3
4453163 2185994 2185994 defendant Malyn John   596437 596437 Malyn, John, of Soterton, son of Lambert 3
4469771 2191217 2191217 defendant Bosy John   596437 596437 Bosy, John, of Soterton, son of John 1
4478277 2193878 2193878 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4478278 2193878 2193878 defendant Fysshemer Hugh   596437 596437 Fysshemer, Hugh, of Soterton 1
4478279 2193878 2193878 defendant Stevenson John   596437 596437 Stevenson, John, of Soterton 2
4482341 2195180 2195180 defendant Llawe Thomas   596437 596437 Llawe, Thomas, of Soterton 1
4487657 2196855 2196855 plaintiff Malyn John   596437 596437 Malyn, John, of Soterton 1
4490120 2197628 2197628 defendant Skynner John   596437 596437 Skynner, John, of Soterton 2
4496685 2199631 2199631 defendant Fysshemer Hugh   596437 596437 Fysshemer, Hugh, of Soterton 0
4496686 2199631 2199631 defendant Ster--son John   596437 596437 Ster--son, John, of Soterton 1
4501984 2201218 2201218 defendant Merytnson John   596437 596437 Merytnson, John, of Soterton 2
4519261 2206379 2206379 plaintiff Dyste William chaplain 596437 596437 Dyste, William, of Soterton, chaplain 0
4519262 2206379 2206379 defendant Cranmer Gilbert   596437 596437 Cranmer, Gilbert, of Soterton 0
4537512 2212004 2212004 plaintiff Symond Thomas   596437 596437 Symond, Thomas, of Soterton 0
4541641 2213280 2213280 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4541642 2213280 2213280 defendant Stevenson John   596437 596437 Stevenson, John, of Soterton 1
4546111 2214728 2214728 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4549391 2215752 2215752 defendant Brunton John   596437 596437 Brunton, John, of Soterton 1
4553529 2217033 2217033 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4555393 2217621 2217621 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4559465 2218908 2218908 defendant Lawe Thomas   596437 596437 Lawe, Thomas, of Soterton 0
4565709 2220839 2220839 plaintiff Symond Peter   596437 596437 Symond, Peter, of Soterton 1
4565710 2220839 2220839 defendant Fyskmere Hugh de   596437 596437 Fyskmere, Hugh de, of Soterton 0
4570643 2222394 2222394 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4570644 2222394 2222394 defendant Stevenson John   596437 596437 Stevenson, John, of Soterton 1
4575698 2223912 2223912 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4586164 2227095 2227095 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4594349 2229490 2229490 plaintiff Poles Alice   596437 596437 Poles, Alice, of Soterton, formerly wife of Thomas 0
4600125 2231263 2231263 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4600127 2231264 2231264 defendant Stephenesson John   596437 596437 Stephenesson, John, of Soterton 0
4606767 2233230 2233230 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4606769 2233230 2233230 defendant Bulle William   596437 596437 Bulle, William, of Soterton 2
4631084 2240618 2240618 plaintiff Symond Thomas   596437 596437 Symond, Thomas, of Soterton 0
4631091 2240621 2240621 plaintiff Symund atte Kirke Thomas   596437 596437 Symund atte Kirke, Thomas, of Soterton 0
4631092 2240621 2240621 defendant Stevenson John   596437 596437 Stevenson, John, of Soterton 0
4631093 2240621 2240621 defendant Symund de Baretrowe Thomas   596437 596437 Symund de Baretrowe, Thomas, of Soterton 1
4636430 2242228 2242228 defendant Bosy John   596437 596437 Bosy, John, of Soterton 0
4641511 2243616 2243616 defendant Saumby John clerk 596437 596437 Saumby, John, of Soterton, clerk 1
4666944 2255390 2255390 defendant Dunworth John chaplain 596437 596437 Dunworth, John, of Soterton, chaplain 3
4668183 2255758 2255758 defendant Polmr Hugh husbandman 596437 596437 Polmr, Hugh, of Soterton, husbandman 0
4692229 2263085 2263085 defendant Kirketon Henry de yeoman 596437 596437 Kirketon, Henry de, of Soterton, yeoman 0
4704191 2266688 2266688 plaintiff Hughson Thomas (legal representative) 596437 596437 Hughson, Thomas, of Soterton, executors of 0
4712572 2269250 2269250 defendant Bosy Roger laborer 596437 596437 Bosy, Roger, of Soterton, son of John, laborer 1
4757737 2282795 2282795 defendant Catelyn Hugh husbandman 596437 596437 Catelyn, Hugh, of Soterton, husbandman 0
4780728 2289971 2289971 defendant Saunderson Robert Joseson husbandman 596437 596437 Saunderson, Robert Joseson, of Soterton, husbandman 0
4782966 2290692 2290692 defendant Bosy John, senior husbandman 596437 596437 Bosy, John, senior, of Soterton, husbandman 3
4809760 2299215 2299215 defendant Trasshe William cooper 596437 596437 Trasshe, William, of Soterton, cooper 0
4816128 2301133 2301133 plaintiff Athelyn William   596437 596437 Athelyn, William, of Soterton 1
4816129 2301133 2301133 defendant Everard William gent 596437 596437 Everard, William, of Soterton, gent 0
4837635 2307702 2307702 defendant Gleppe John husbandman 596437 596437 Gleppe, John, of Soterton, husbandman 0
4838148 2307853 2307853 defendant Besy Roger husbandman 596437 596437 Besy, Roger, of Soterton, husbandman 4
4838149 2307853 2307853 defendant Saunderson William husbandman 596437 596437 Saunderson, William, of Soterton, husbandman 5
4839017 2308133 2308133 defendant Myles William butcher 596437 596437 Myles, William, of Soterton, butcher 0
4839019 2308133 2308133 defendant Auger Thomas husbandman 596437 596437 Auger, Thomas, of Soterton, husbandman 2
4840038 2308433 2308433 defendant Blysbery John husbandman 596437 596437 Blysbery, John, of Soterton, husbandman 0
4850225 2311528 2311528 defendant Gybon John (legal representative) 596437 596437 Gybon, John, of Soterton, executor of 2
4870312 2317688 2317688 defendant Bese or Befe John husbandman 596437 596437 Bese or Befe, John, of Soterton, husbandman 0
4872624 2318390 2318390 defendant Brumpton John husbandman 596437 596437 Brumpton, John, of Soterton, husbandman 1
4874510 2318971 2318971 defendant Catelyn Hugh husbandman 596437 596437 Catelyn, Hugh, of Soterton, husbandman 0
4874511 2318971 2318971 defendant Lucke Thomas husbandman 596437 596437 Lucke, Thomas, of Soterton, husbandman 1
4879488 2320513 2320513 defendant Hunnyng Richard husbandman 596437 596437 Hunnyng, Richard, of Soterton, husbandman 5
4881175 2321020 2321020 defendant Athekyn William husbandman 596437 596437 Athekyn, William, of Soterton, husbandman 0
4884692 2322124 2322124 defendant Everard William gent 596437 596437 Everard, William, of Soterton, gent 2
4887784 2323009 2323009 defendant Saunderson William husbandman 596437 596437 Saunderson, William, of Soterton, husbandman 8
4891162 2323974 2323974 defendant Everard William gent 596437 596437 Everard, William, of Soterton, gent 0
4891174 2323974 2323974 defendant Hunnyng Richard husbandman 596437 596437 Hunnyng, Richard, of Soterton, husbandman 12
4892817 2324482 2324482 defendant Everard William esq 596437 596437 Everard, William, of Soterton, esq 0
4917748 2332065 2332065 defendant Polver Helen widow 596437 596437 Polver, Helen, of Soterton, widow 0
4917749 2332065 2332065 defendant Polver Thomas   596437 596437 Polver, Thomas, of Soterton, servant 1
4926409 2334680 2334680 defendant Hoberd John husbandman 596437 596437 Hoberd, John, of Soterton, husbandman 0
4974567 2349357 2349357 defendant Symond Roger husbandman 596437 596437 Symond, Roger, of Soterton, husbandman 1

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