names

145 rows where place_id = 591351

✎ 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
3604150 1868964 1868964 defendant Emere John gent 591351 591351 (Emere, John, of Wynthorp, gent 1
3613096 1871748 1871748 defendant Waryson Thomas husbandman 591351 591351 Waryson, Thomas, of Wynthorp, husbandman 0
3699419 1926042 1926042 defendant Smyth Thomas husbandman 591351 591351 Smyth, Thomas, of Wynthorp, husbandman 1
3727006 1934713 1934713 defendant Smythe Thomas husbandman 591351 591351 Smythe, Thomas, of Wynthorp, husbandman 1
3740657 1938939 1938939 defendant Arlek Robert husbandman 591351 591351 Arlek, Robert, of Wynthorp, husbandman 0
3766951 1947330 1947330 defendant Shittylwode Robert husbandman 591351 591351 Shittylwode, Robert, of Wynthorp, husbandman 0
3826880 1966257 1966257 defendant Cotnam Simon husbandman 591351 591351 Cotnam, Simon, of Wynthorp, husbandman 0
3836475 1969315 1969315 defendant Thory Robert yeoman 591351 591351 Thory, Robert, of Wynthorp, yeoman 1
3841492 1970919 1970919 defendant Rychardson Thomas husbandman 591351 591351 Rychardson, Thomas, of Wynthorp, husbandman 3
3852569 1974412 1974412 defendant Thory Robert yeoman 591351 591351 Thory, Robert, of Wynthorp, yeoman 0
3882602 1984446 1984446 plaintiff Thore Robert husbandman 591351 591351 Thore, Robert, of Wynthorp, husbandman 0
3907373 1992757 1992757 plaintiff Palmer Lawrence yeoman 591351 591351 Palmer, Lawrence, of Wynthorp, yeoman 0
3951979 2007755 2007755 defendant Westhern Richard yeoman 591351 591351 Westhern, Richard, of Wynthorp, yeoman 2
4016276 2030521 2030521 defendant Palmer Lawrence (legal representative) 591351 591351 Palmer, Lawrence, of Wynthorp, yeoman, executors of 0
4419147 2170857 2170857 plaintiff atte Welle Simon   591351 591351 atte Welle, Simon, of Wynthorp, son of Ralph 0
4419149 2170857 2170857 defendant Nowil Randolf   591351 591351 Nowil, Randolf, of Wynthorp 1
4449264 2184718 2184718 plaintiff atte Brigge John   591351 591351 atte Brigge, John, of Wynthorp 5
4460671 2188397 2188397 defendant Milner William   591351 591351 Milner, William, of Wynthorp 0
4460673 2188398 2188398 defendant Milner William   591351 591351 Milner, William, of Wynthorp 0
4463052 2189144 2189144 plaintiff Tothach Robert   591351 591351 Tothach, Robert, of Wynthorp 0
4479612 2194286 2194286 defendant atte Brygge Richard chaplain 591351 591351 atte Brygge, Richard, of Wynthorp, chaplain 1
4485112 2196045 2196045 defendant Jonkynson William chaplain 591351 591351 Jonkynson, William, of Wynthorp, chaplain 0
4526458 2208554 2208554 defendant Couper Maud   591351 591351 Couper, Maud, of Wynthorp 2
4557373 2218246 2218246 defendant Couper Maud   591351 591351 Couper, Maud, of Wynthorp 2
4575192 2223761 2223761 defendant Crown John   591351 591351 Crown, John, of Wynthorp 0
4585079 2226755 2226755 plaintiff Grome Robert   591351 591351 Grome, Robert, of Wynthorp, son of John 0
4585080 2226755 2226755 defendant Tut Robert   591351 591351 Tut, Robert, of Wynthorp 0
4585081 2226755 2226755 defendant Conyngsgate William de   591351 591351 Conyngsgate, William de, of Wynthorp 1
4593207 2229172 2229172 plaintiff Palmer Guy   591351 591351 Palmer, Guy, of Wynthorp, son of Gilbert 0
4605973 2232984 2232984 plaintiff atte Munkes John   591351 591351 atte Munkes, John, of Wynthorp 0
4605975 2232984 2232984 defendant Carter Alice   591351 591351 Carter, Alice, of Wynthorp 1
4609563 2234090 2234090 defendant Cartere John   591351 591351 Cartere, John, of Wynthorp 1
4633501 2241332 2241332 defendant Raven Robert   591351 591351 Raven, Robert, of Wynthorp 0
4643660 2244246 2244246 defendant Jonson John   591351 591351 Jonson, John, of Wynthorp, son of Robert 3
4657504 2248240 2248240 defendant Tontte or Toutte Robert husbandman 591351 591351 Tontte or Toutte, Robert, of Wynthorp, husbandman 1
4660859 2249222 2249222 defendant Tutte John husbandman 591351 591351 Tutte, John, of Wynthorp, husbandman 0
4679681 2259260 2259260 defendant atte Monkes John chaplain 591351 591351 atte Monkes, John, of Wynthorp, chaplain 1
4712846 2269328 2269328 defendant Palmer John husbandman 591351 591351 Palmer, John, of Wynthorp, husbandman 0
4724037 2272815 2272815 defendant Roberdson Jonesson John yeoman 591351 591351 Roberdson Jonesson, John, of Wynthorp, yeoman 0
4724038 2272815 2272815 defendant Palmer Gilbert chaplain 591351 591351 Palmer, Gilbert, of Wynthorp, chaplain 1
4724039 2272815 2272815 defendant Monkes John chaplain 591351 591351 Monkes, John, of Wynthorp, chaplain 2
4724041 2272816 2272816 defendant Roberdson John yeoman 591351 591351 Roberdson, John, of Wynthorp, son of John, yeoman 0
4724042 2272816 2272816 defendant Palmer Gilbert chaplain 591351 591351 Palmer, Gilbert, of Wynthorp, chaplain 1
4724043 2272816 2272816 defendant Monkes John chaplain 591351 591351 Monkes, John, of Wynthorp, chaplain 2
4763894 2284699 2284699 defendant Palmer William husbandman 591351 591351 Palmer, William, of Wynthorp, husbandman 0
4767178 2285719 2285719 defendant atte Monkes John chaplain 591351 591351 atte Monkes, John, of Wynthorp, chaplain 0
4767639 2285864 2285864 defendant Munk John chaplain 591351 591351 Munk, John, of Wynthorp, chaplain 0
4783698 2290925 2290925 defendant Temple Thomas husbandman 591351 591351 Temple, Thomas, of Wynthorp, husbandman 0
4787686 2292218 2292218 defendant Palmer William husbandman 591351 591351 Palmer, William, of Wynthorp, husbandman 0
4791583 2293462 2293462 defendant atte Monkes John chaplain 591351 591351 atte Monkes, John, of Wynthorp, chaplain 0
4791671 2293493 2293493 defendant Munk John chaplain 591351 591351 Munk, John, of Wynthorp, chaplain 0
4806980 2298382 2298382 defendant Tut Walter husbandman 591351 591351 Tut, Walter, of Wynthorp, husbandman 0
4812489 2300018 2300018 defendant atte Moukes John clerk 591351 591351 atte Moukes, John, of Wynthorp, clerk 4
4818102 2301735 2301735 plaintiff Nevyll John   591351 591351 Nevyll, John, of Wynthorp 0
4845615 2310138 2310138 defendant Erbek William husbandman 591351 591351 Erbek, William, of Wynthorp, husbandman 2
4868606 2317156 2317156 plaintiff Jonson John Robertson (legal representative) 591351 591351 Jonson, John Robertson, of Wynthorp, executors of 0
4873309 2318605 2318605 defendant Erlyk William husbandman 591351 591351 Erlyk, William, of Wynthorp, husbandman 2
4911528 2330107 2330107 defendant Lymber William husbandman 591351 591351 Lymber, William, of Wynthorp, husbandman 0
4911529 2330107 2330107 defendant Lymber Thomas husbandman 591351 591351 Lymber, Thomas, of Wynthorp, husbandman 1
4926976 2334868 2334868 plaintiff Roberson Jonson John (legal representative) 591351 591351 Roberson Jonson, John, of Wynthorp, son of Robert Johson or Wynthorp, executors of 0
4928287 2335273 2335273 defendant Fulwode John husbandman 591351 591351 Fulwode, John, of Wynthorp, husbandman 1
4955375 2343566 2343566 defendant Goderykson Richard husbandman 591351 591351 Goderykson, Richard, of Wynthorp, husbandman 0
4955491 2343603 2343603 defendant Gudricson Richard chapman 591351 591351 Gudricson, Richard, of Wynthorp, chapman 5
4957611 2344249 2344249 defendant Waryson William husbandman 591351 591351 Waryson, William, of Wynthorp, husbandman 0
4963532 2346008 2346008 defendant Rodyng John husbandman 591351 591351 Rodyng, John, of Wynthorp, husbandman 0
4965367 2346564 2346564 defendant Sybsey William laborer 591351 591351 Sybsey, William, of Wynthorp, laborer 0
4970021 2347984 2347984 defendant Depdale John husbandman 591351 591351 Depdale, John, of Wynthorp, husbandman 0
4981954 2351520 2351520 defendant Lymber William   591351 591351 Lymber, William, of Wynthorp, "cosour" or courser 1
4985409 2352558 2352558 defendant Depdale John husbandman 591351 591351 Depdale, John, of Wynthorp, husbandman 0
4996457 2355796 2355796 defendant Depdale John husbandman 591351 591351 Depdale, John, of Wynthorp, husbandman 0
4998015 2356267 2356267 defendant Tyll John husbandman 591351 591351 Tyll, John, of Wynthorp, husbandman 1
4998016 2356267 2356267 defendant Tyll John husbandman husbandman 591351 591351 Tyll, John, of Wynthorp, husbandman husbandman 2
4999213 2356637 2356637 defendant Goderykson Richard husbandman 591351 591351 Goderykson, Richard, of Wynthorp, husbandman 0
5039528 2368471 2368471 defendant Sutton William husbandman 591351 591351 Sutton, William, of Wynthorp, husbandman 3
5059676 2374457 2374457 defendant Ranyer John husbandman 591351 591351 Ranyer, John, of Wynthorp, husbandman 1
5061889 2375150 2375150 defendant Philipson William husbandman 591351 591351 Philipson, William, of Wynthorp, husbandman 0
5067054 2376670 2376670 defendant Conyngeswate William husbandman 591351 591351 Conyngeswate, William, of Wynthorp, husbandman 0
5072859 2378366 2378366 defendant Raven John husbandman 591351 591351 Raven, John, of Wynthorp, husbandman 0
5072860 2378366 2378366 defendant Magnus Thomas husbandman 591351 591351 together with Magnus, Thomas, of Wynthorp, husbandman 1
5074139 2378752 2378752 defendant Maltby Margaret   591351 591351 Maltby, Margaret, of Wynthorp, servant 1
5081403 2380943 2380943 defendant Ranyer John husbandman 591351 591351 Ranyer, John, of Wynthorp, husbandman 0
5098854 2386097 2386097 plaintiff Warryson William   591351 591351 Warryson, William, of Wynthorp 0
5099112 2386168 2386168 defendant Waryson William courser 591351 591351 Waryson, William,of Wynthorp, courser 0
5108861 2389014 2389014 defendant Waryson William husbandman 591351 591351 Waryson,William, of Wynthorp, husbandman 2
5109131 2389094 2389094 defendant Watryson William husbandman 591351 591351 Watryson, William, of Wynthorp, husbandman 0
5121395 2392689 2392689 defendant Barowe William yeoman 591351 591351 Barowe, William, of Wynthorp, yeoman 2
5129452 2395099 2395099 defendant Warryson William husbandman 591351 591351 Warryson, William, of Wynthorp, husbandman 2
5131517 2395700 2395700 plaintiff Waryson William   591351 591351 Waryson, William, of Wynthorp 1
5141872 2398741 2398741 defendant Granne Robert husbandman 591351 591351 Granne, Robert, of Wynthorp, husbandman 0
5141873 2398741 2398741 defendant Wesylhede John husbandman 591351 591351 Wesylhede, John, of Wynthorp, husbandman 1
5141874 2398741 2398741 defendant Bryg William laborer 591351 591351 Bryg, William, of Wynthorp, laborer 2
5141875 2398741 2398741 defendant Bryg (illegible) widow 591351 591351 Bryg, ----, of Wynthorp, widow 3
5149838 2401087 2401087 plaintiff Waryson William   591351 591351 Waryson, William, of Wynthorp 1
5160399 2404135 2404135 defendant Ranyer John husbandman 591351 591351 Ranyer, John, of Wynthorp, husbandman 0
5168621 2406542 2406542 plaintiff Warison William   591351 591351 Warison, William, of Wynthorp 1
5179876 2409850 2409850 defendant Wynthorp Gilbert yeoman 591351 591351 Wynthorp, Gilbert, of Wynthorp, yeoman 0
5181883 2410448 2410448 defendant Waryson William husbandman 591351 591351 Waryson, William, of Wynthorp, husbandman 1
5192360 2413501 2413501 defendant Wynthorp Gilbert yeoman 591351 591351 Wynthorp, Gilbert, of Wynthorp, yeoman 0
5196313 2414673 2414673 defendant Ranyer John husbandman 591351 591351 Ranyer, John, of Wynthorp, husbandman 1
5199262 2415536 2415536 defendant Graune Robert husbandman 591351 591351 Graune, Robert, of Wynthorp, husbandman 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);