names

128 rows where place_id = 590526

✎ 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
3601492 1868122 1868122 defendant Bysshopp Robert husbandman 590526 590526 Bysshopp, Robert, of Masham, husbandman 0
3625897 1902953 1902953 defendant Staneley or Staveley Henry gent 590526 590526 Staneley or Staveley, Henry, of Masham, gent 0
3625900 1902954 1902954 defendant Staneley or Staveley Henry gent 590526 590526 Staneley or Staveley, Henry, of Masham, gent 0
3640600 1907501 1907501 defendant Bayn John yeoman 590526 590526 Bayn, John, of Masham, yeoman 0
3678320 1919273 1919273 defendant Doddyswirth Peter gent 590526 590526 Doddyswirth, Peter, of Masham, gent 1
3678321 1919273 1919273 defendant Brigewater John chaplain 590526 590526 Brigewater, John, of Masham, chaplain 2
3794517 1956164 1956164 defendant Lofthouse William yeoman 590526 590526 Lofthouse, William, of Masham, yeoman 0
3794518 1956164 1956164 defendant Doddesworth Peter gent 590526 590526 Doddesworth, Peter, of Masham, gent 1
3810364 1961132 1961132 defendant Kyng Richard yeoman 590526 590526 Kyng, Richard, of Masham, yeoman 1
3810365 1961132 1961132 defendant Hawkyns William yeoman 590526 590526 Hawkyns, William, of Masham, yeoman 2
3810366 1961132 1961132 defendant Losthouse William yeoman 590526 590526 Losthouse, William, of Masham, yeoman 3
3810367 1961132 1961132 defendant Losthouse Thomas yeoman 590526 590526 Losthouse, Thomas, of Masham, yeoman 4
3973222 2015206 2015206 defendant Tesdale Richard yeoman 590526 590526 Tesdale, Richard, of Masham, yeoman 0
4060058 2045995 2045995 plaintiff Crome Robert husbandman 590526 590526 Crome, Robert, of Masham, husbandman 0
4187129 2090990 2090990 defendant Clarke Robert butcher 590526 590526 Clarke, Robert, of Masham, yeoman, butcher 0
4223608 2103746 2103746 defendant Mandall Henry yeoman 590526 590526 Mandall, Henry, of Masham, yeoman 0
4225514 2104388 2104388 defendant Beckwith William yeoman 590526 590526 Beckwith, William, of Masham, yeoman 0
4225515 2104388 2104388 defendant Bourdell Christopher yeoman 590526 590526 Bourdell, Christopher, of Masham, yeoman 1
4225516 2104388 2104388 defendant Sigiswick Thomas yeoman 590526 590526 Sigiswick, Thomas, of Masham, yeoman 2
4225517 2104388 2104388 defendant Pickersgill John yeoman 590526 590526 Pickersgill, John, of Masham, yeoman 3
4453593 2186136 2186136 defendant Mallom John   590526 590526 Mallom, John, of Masham 0
4466012 2190028 2190028 defendant Mallom John de   590526 590526 Mallom, John de, of Masham 0
4501173 2200971 2200971 plaintiff le Scrop Stephen   590526 590526 le Scrop, Stephen, of Masham, knight 0
4501175 2200972 2200972 plaintiff le Scrop Stephen   590526 590526 le Scrop, Stephen, of Masham, knight 0
4527088 2208755 2208755 plaintiff Lescrop Stephen   590526 590526 Lescrop, Stephen, of Masham, knight 0
4527090 2208756 2208756 plaintiff Lescrop Stephen   590526 590526 Lescrop, Stephen, of Masham, knight 0
4527093 2208757 2208757 plaintiff Lescrop Stephen   590526 590526 Lescrop, Stephen, of Masham, knight 0
4527097 2208758 2208758 plaintiff Lescrop Stephen   590526 590526 Lescrop, Stephen, of Masham, knight 0
4527101 2208759 2208759 plaintiff Lescrop Stephen   590526 590526 Lescrop, Stephen, of Masham, knight 0
4527103 2208760 2208760 plaintiff Lescrou Stephen   590526 590526 Lescrou, Stephen, of Masham, knight 0
4533016 2210595 2210595 plaintiff Raufman Robert   590526 590526 Raufman, Robert, of Masham 0
4542679 2213598 2213598 plaintiff Aldeburgh Robert   590526 590526 Aldeburgh, Robert, of Masham 0
4557942 2218414 2218414 plaintiff Lescrop Stephen   590526 590526 Lescrop, Stephen, of Masham, knight 0
4557944 2218415 2218415 plaintiff Lescrop Stephen   590526 590526 Lescrop, Stephen, of Masham, knight 0
4557946 2218416 2218416 plaintiff Lescrop Stephen   590526 590526 Lescrop, Stephen, of Masham, knight 0
4557948 2218417 2218417 plaintiff Lescrop Stephen   590526 590526 Lescrop, Stephen, of Masham, knight 0
4571166 2222553 2222553 defendant Gest John   590526 590526 Gest, John, of Masham 1
4589272 2228024 2228024 plaintiff Lescrop Henry   590526 590526 Lescrop, Henry, of Masham, knight 0
4621970 2237848 2237848 defendant Norton John de   590526 590526 Norton, John de, of Masham 0
4621972 2237848 2237848 defendant Danyell Richard   590526 590526 Danyell, Richard, of Masham 2
4740303 2277673 2277673 defendant Bryanns William yeoman 590526 590526 Bryanns, William, of Masham, yeoman 1
4764766 2284964 2284964 defendant Staveley William de yeoman 590526 590526 Staveley, William de, of Masham, yeoman 0
4764767 2284964 2284964 defendant Horsman Thomas yeoman 590526 590526 Horsman, Thomas, of Masham, yeoman 1
4764768 2284964 2284964 defendant Kendele Richard de yeoman 590526 590526 Kendele, Richard de, of Masham, yeoman 2
4776683 2288697 2288697 defendant Bryg John husbandman 590526 590526 Bryg, John, of Masham, husbandman 1
4789488 2292779 2292779 defendant Loftehous William yeoman 590526 590526 Loftehous, William, of Masham, yeoman 0
4789542 2292801 2292801 defendant Staneley or Staveley William yeoman 590526 590526 Staneley or Staveley, William, of Masham, yeoman 0
4789543 2292801 2292801 defendant de kendale Richard yeoman 590526 590526 de kendale, Richard, of Masham, yeoman 1
4794129 2294299 2294299 defendant Clerk John chaplain 590526 590526 (Clerk, John, of Masham, chaplain 1
4794130 2294299 2294299 defendant Clerk Alice widow 590526 590526 Clerk, Alice, of Masham, widow 2
4810602 2299464 2299464 defendant Bryan Thomas draper 590526 590526 Bryan, Thomas, of Masham, draper 3
4810616 2299465 2299465 defendant Mendsant William, junior yeoman 590526 590526 Mendsant, William, junior, of Masham, yeoman 5
4810631 2299466 2299466 defendant Lytster Simon dyer 590526 590526 Lytster, Simon, of Masham, dyer 6
4810667 2299469 2299469 defendant Mendfant William, junior yeoman 590526 590526 Mendfant, William, junior, of Masham, yeoman 5
4810681 2299470 2299470 defendant Wyght William husbandman 590526 590526 Wyght, William, of Masham, husbandman 4
4810683 2299470 2299470 defendant Lytster Simon dyer 590526 590526 Lytster, Simon, of Masham, dyer 6
4810719 2299473 2299473 defendant Bryan Thomas draper 590526 590526 Bryan, Thomas, of Masham, draper 3
4864651 2315916 2315916 defendant Lounde Roger gent 590526 590526 Lounde, Roger, of Masham, gent 0
4864653 2315916 2315916 defendant Neuton John gent 590526 590526 Neuton, John, of Masham, gent 2
4864654 2315916 2315916 defendant Beeston William yeoman 590526 590526 Beeston, William, of Masham, yeoman 3
4864655 2315916 2315916 defendant Estby Thomas yeoman 590526 590526 Estby, Thomas, of Masham, yeoman 4
4864656 2315916 2315916 defendant Mendfaut William yeoman 590526 590526 Mendfaut, William, of Masham, yeoman 5
4864657 2315916 2315916 defendant Walker Richard yeoman 590526 590526 Walker, Richard, of Masham, yeoman 6
4864658 2315916 2315916 defendant Fydeler William yeoman 590526 590526 Fydeler, William, of Masham, yeoman 7
4888603 2323232 2323232 defendant Bryan Thomas draper 590526 590526 Bryan, Thomas, of Masham, draper 3
4888604 2323232 2323232 defendant Prudhowe William yeoman 590526 590526 Prudhowe, William, of Masham, yeoman 4
4888605 2323232 2323232 defendant Mendfaute William yeoman 590526 590526 Mendfaute, William, of Masham, yeoman 5
4888614 2323233 2323233 defendant Bryan William chapman 590526 590526 Bryan, William, of Masham, chapman 2
4898620 2326213 2326213 defendant Ranaldson Simon dyer 590526 590526 Ranaldson, Simon, of Masham, dyer 0
4908841 2329316 2329316 defendant Skelton Edmund (legal representative) 590526 590526 Skelton, Edmund, of Masham, executors of 0
4908842 2329316 2329316 defendant Lunne Roger gent 590526 590526 (Lunne, Roger, of Masham, gent 1
4908843 2329316 2329316 defendant Skelton Joan widow 590526 590526 Skelton, Joan, of Masham, widow 2
4930038 2335801 2335801 defendant Bayne William gent 590526 590526 Bayne, William, of Masham, gent 0
4930344 2335891 2335891 defendant Lunde Roger gent 590526 590526 Lunde, Roger, of Masham, gent 0
4930346 2335892 2335892 defendant Lunde Roger gent 590526 590526 Lunde, Roger, of Masham, gent 0
4934598 2337214 2337214 defendant Lunne Roger gent 590526 590526 Lunne, Roger, of Masham, gent 0
4942423 2339615 2339615 defendant Bayne William yeoman 590526 590526 (Bayne, William, of Masham, yeoman 1
4947316 2341153 2341153 defendant Lounde Roger gent 590526 590526 Lounde, Roger, of Masham, gent 0
4947341 2341163 2341163 defendant Purdowe or Pruddowe William husbandman 590526 590526 Purdowe or Pruddowe, William, of Masham, husbandman 0
4947342 2341163 2341163 defendant Clyve or Clyne John smith 590526 590526 Clyve or Clyne, John, of Masham, smith 1
4947343 2341163 2341163 defendant Watson Thomas walker 590526 590526 Watson, Thomas, of Masham, walker 2
4954312 2343261 2343261 defendant Goldthwayte Thpomas yeoman 590526 590526 Goldthwayte, Thpomas, of Masham, yeoman 0
4964501 2346288 2346288 defendant Ketilwell Richard yeoman 590526 590526 Ketilwell, Richard, of Masham, yeoman 1
4966069 2346780 2346780 defendant Lund Roger gent 590526 590526 Lund, Roger, of Masham, gent 0
4973246 2348934 2348934 defendant London Roger gent 590526 590526 London, Roger, of Masham, gent 0
4973247 2348934 2348934 defendant Ketylwell Richard yeoman 590526 590526 Ketylwell, Richard, of Masham, yeoman 1
4973248 2348934 2348934 defendant Flesshewer Roger butcher 590526 590526 Flesshewer, Roger, of Masham, butcher 2
4973249 2348934 2348934 defendant Fydelere William husbandman 590526 590526 Fydelere, William, of Masham, husbandman 3
4973250 2348934 2348934 defendant Fydeler Thomas husbandman 590526 590526 Fydeler, Thomas, of Masham, husbandman 4
4973254 2348936 2348936 defendant Stokdale William yeoman 590526 590526 Stokdale, William, of Masham, yeoman 0
4977630 2350275 2350275 defendant de Beston Miles gent 590526 590526 de Beston, Miles, of Masham, gent 0
4977633 2350275 2350275 defendant Fourneys Giles laborer 590526 590526 Fourneys, Giles, of Masham, laborer 3
4977639 2350278 2350278 defendant Beeston Miles gent 590526 590526 Beeston, Miles, of Masham, gent 0
4977641 2350278 2350278 defendant Fourneys Giles laborer 590526 590526 Fourneys, Giles, of Masham, laborer 2
4980646 2351147 2351147 defendant Bayn William yeoman 590526 590526 Bayn, William, of Masham, yeoman 4
4986639 2352936 2352936 defendant Lytster John yeoman 590526 590526 Lytster, John, of Masham, yeoman 1
4986640 2352936 2352936 defendant Mendefante William yeoman 590526 590526 Mendefante, William, of Masham, yeoman 2
4992029 2354503 2354503 defendant Yates John slater 590526 590526 Yates, John, of Masham, slater 1
5000369 2356975 2356975 defendant Ketilwell Henry husbandman 590526 590526 Ketilwell, Henry, of Masham, husbandman 1
5015956 2361558 2361558 defendant Parkour Roger chaplain 590526 590526 Parkour, Roger, of Masham, chaplain 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);