names

401 rows where place_id = 587266

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590945 1864795 1864795 defendant Harryson Walter butcher 587266 587266 Harryson, Walter, of Rypon, butcher 0
3590966 1864802 1864802 defendant Rylston Isabel widow 587266 587266 Rylston, Isabel, of Rypon, widow 0
3590967 1864802 1864802 defendant Morehous Richard chaplain 587266 587266 Morehous, Richard, of Rypon, chaplain 1
3595883 1866348 1866348 defendant Harryson Richard butcher 587266 587266 Harryson, Richard, of Rypon, butcher 0
3595887 1866348 1866348 defendant Rande Thomas butcher 587266 587266 Rande, Thomas, of Rypon, butcher 4
3597175 1866741 1866741 defendant Whykeley John yeoman 587266 587266 Whykeley, John, of Rypon, yeoman 3
3606260 1869625 1869625 plaintiff Middelton Simon yeoman 587266 587266 Middelton, Simon, of Rypon, yeoman 0
3612401 1871506 1871506 defendant Sele Henry butcher 587266 587266 Sele, Henry, of Rypon, butcher 0
3618183 1873310 1873310 defendant Grene Richard gent 587266 587266 Grene, Richard, of Rypon, gent 0
3618184 1873310 1873310 defendant Grene John chaplain 587266 587266 Grene, John, of Rypon, chaplain 1
3624209 1875104 1875104 defendant Shawe William yeoman 587266 587266 Shawe, William, of Rypon, yeoman 0
3624210 1875104 1875104 defendant Tebym William miller 587266 587266 Tebym William, of Rypon, miller 1
3632812 1905075 1905075 defendant Myddylton Robert yeoman 587266 587266 Myddylton, Robert, of Rypon, yeoman 0
3653119 1911306 1911306 defendant Pratt John yeoman 587266 587266 Pratt, John, of Rypon, yeoman 0
3655943 1912108 1912108 defendant Colynson John chaplain 587266 587266 Colynson, John, of Rypon, chaplain 0
3667326 1915718 1915718 defendant Preston Gilbert yeoman 587266 587266 Preston, Gilbert, of Rypon, yeoman 1
3667327 1915718 1915718 defendant Glover Robert   587266 587266 Glover, Robert, of Rypon, shoe maker 2
3667328 1915718 1915718 defendant Glover Joan spinster 587266 587266 Glover, Joan, of Rypon, spinster 3
3679567 1919677 1919677 plaintiff Plommer John   587266 587266 Plommer, John, of Rypon 0
3707778 1928731 1928731 plaintiff Mawkeswell William   587266 587266 Mawkeswell, William, of Rypon 0
3770663 1948509 1948509 plaintiff Smyth William chaplain 587266 587266 Smyth, William, of Rypon, chaplain 0
3770665 1948509 1948509 defendant Gowthwayte Richard yeoman 587266 587266 Gowthwayte, Richard, of Rypon, yeoman 1
3770934 1948595 1948595 plaintiff Stanely or Stavely Thomas gent 587266 587266 Stanely or Stavely, Thomas, of Rypon, gent 0
3771026 1948626 1948626 defendant Wynder John glover 587266 587266 Wynder, John, of Rypon, glover 1
3771757 1948870 1948870 defendant Preston Brian yeoman 587266 587266 Preston, Brian, of Rypon, yeoman 0
3788724 1954276 1954276 plaintiff Staveley Thomas gent 587266 587266 Staveley, Thomas, of Rypon, gent 0
3792601 1955546 1955546 plaintiff Baron Robert cordwainer 587266 587266 Baron, Robert, of Rypon, cordwainer 0
3801876 1958484 1958484 defendant Ukkerley Anthony yeoman 587266 587266 Ukkerley, Anthony, of Rypon, yeoman 2
3829612 1967152 1967152 plaintiff Dawson Stephen clerk 587266 587266 Dawson, Stephen, of Rypon, clerk 0
3829614 1967152 1967152 defendant Coke Ralph yeoman 587266 587266 Coke, Ralph, of Rypon, yeoman 1
3835497 1969042 1969042 defendant Kettelwell William barker 587266 587266 Kettelwell, William, of Rypon, barker 2
3841363 1970877 1970877 defendant Norman Thomas barber 587266 587266 Norman, Thomas, of Rypon, barber 0
3848789 1973207 1973207 defendant Waldby Marmaduke clerk 587266 587266 Waldby, Marmaduke, of Rypon, clerk 0
3848790 1973207 1973207 defendant Ward Walter gent 587266 587266 Ward, Walter, of Rypon, gent 1
3848791 1973207 1973207 defendant Johnson Thomas yeoman 587266 587266 Johnson, Thomas, of Rypon, yeoman 2
3848792 1973207 1973207 defendant Coke John yeoman 587266 587266 Coke, John, of Rypon, yeoman 3
3848793 1973207 1973207 defendant Horsekeper Robert yeoman 587266 587266 Horsekeper, Robert, of Rypon, yeoman 4
3849264 1973363 1973363 defendant Coke Robert yeoman 587266 587266 Coke, Robert, of Rypon, yeoman 0
3853771 1974814 1974814 defendant Sele William (legal representative) 587266 587266 Sele, William, of Rypon, yeoman, executors of 0
3853772 1974814 1974814 defendant Baron Robert shoemaker 587266 587266 (Baron, Robert, of Rypon, shoemaker 1
3853773 1974814 1974814 defendant Sele Christopher clerk 587266 587266 Sele, Christopher, of Rypon, clerk 2
3868195 1979600 1979600 defendant Baron Rober shoemaker 587266 587266 Baron, Rober, of Rypon, shoemaker 0
3879072 1983252 1983252 defendant Nelson John yeoman 587266 587266 Nelson, John, of Rypon, yeoman 0
3882062 1984261 1984261 defendant Baron Robert shoemaker 587266 587266 Baron, Robert, of Rypon, shoemaker 0
3884405 1985054 1985054 defendant Askruyth William tanner 587266 587266 Askruyth, William, of Rypon, tanner 0
3884406 1985054 1985054 defendant Chawmer William tanner 587266 587266 Chawmer, William, of Rypon, tanner 1
3884407 1985054 1985054 defendant Ketylwell William tanner 587266 587266 Ketylwell, William, of Rypon, tanner 2
3884408 1985054 1985054 defendant Sigeswyk Stephen tanner 587266 587266 Sigeswyk, Stephen, of Rypon, tanner 3
3885551 1985421 1985421 plaintiff Bell Ralph   587266 587266 Bell, Ralph, of Rypon 0
3892689 1987803 1987803 defendant Wheteley William tanner 587266 587266 Wheteley, William, of Rypon, tanner 2
3895642 1988748 1988748 plaintiff Staveley Thomas   587266 587266 Staveley, Thomas, of Rypon 0
3919013 1996684 1996684 plaintiff Johnson Thomas   587266 587266 Johnson, Thomas, of Rypon 0
3940624 2003872 2003872 plaintiff Staveley Thomas   587266 587266 Staveley, Thomas, of Rypon 0
3941161 2004048 2004048 defendant Drac William laborer 587266 587266 Drac, William, of Rypon, laborer 0
3941162 2004048 2004048 defendant Tyrrye Edward carpenter 587266 587266 Tyrrye, Edward, of Rypon, carpenter 1
3958194 2009938 2009938 defendant Channer John tanner 587266 587266 Channer, John, of Rypon, tanner 0
3987502 2020279 2020279 defendant Henryson or Hereson Robert yeoman 587266 587266 Henryson or Hereson, Robert, of Rypon, yeoman 0
3987503 2020279 2020279 defendant Munckton Richard husbandman 587266 587266 Munckton, Richard, of Rypon, or of Sharrco, husbandman 1
4085769 2055183 2055183 plaintiff Blande Christopher merchant 587266 587266 Blande, Christopher, of Rypon, merchant 0
4222811 2103470 2103470 defendant Thornton Lawrence yeoman 587266 587266 Thornton, Lawrence, of Rypon, yeoman 0
4222812 2103470 2103470 defendant Lockey Henry yeoman 587266 587266 Lockey, Henry, of Rypon, yeoman 1
4414312 2169388 2169388 defendant Smale John le   587266 587266 Smale, John le, of Rypon, prebendary of the prebend in the church of St Wolfridus 0
4418804 2170748 2170748 defendant Eseby Ellis de   587266 587266 Eseby, Ellis de, of Rypon, physician 0
4450717 2185185 2185185 plaintiff Hauteswyk John de   587266 587266 Hauteswyk, John de, of Rypon 0
4450719 2185185 2185185 plaintiff Clynt John de chaplain 587266 587266 Clynt, John de, of Rypon, chaplain 2
4452125 2185650 2185650 defendant Tanfeld John de   587266 587266 Tanfeld, John de, of Rypon 0
4462712 2189039 2189039 plaintiff Thoresby John (legal representative) 587266 587266 Thoresby, John, of Rypon, formerly master & canon of the church, executors of 0
4462717 2189039 2189039 defendant Toppecliff John   587266 587266 Toppecliff, John, of Rypon 0
4464294 2189496 2189496 defendant Frankys John   587266 587266 Frankys, John, of Rypon 0
4466658 2190248 2190248 defendant Cadeby Richard dyer 587266 587266 Cadeby, Richard, of Rypon, dyer 0
4468127 2190703 2190703 defendant Cadchy or Oadeby Richard dyer 587266 587266 Cadchy or Oadeby, Richard, of Rypon, dyer 1
4476757 2193393 2193393 defendant Halomshire Robert de   587266 587266 Halomshire, Robert de, of Rypon 0
4480870 2194688 2194688 plaintiff Ledes William de   587266 587266 Ledes, William de, of Rypon, on his own account 0
4482041 2195095 2195095 plaintiff Marsshall Robert   587266 587266 Marsshall, Robert, of Rypon, on his own account 0
4486466 2196477 2196477 defendant Ternour Henry   587266 587266 Ternour, Henry, of Rypon 0
4489138 2197318 2197318 defendant Catsby Richard   587266 587266 Catsby, Richard, of Rypon 2
4492684 2198415 2198415 defendant Stowe Richard de   587266 587266 Stowe, Richard de, of Rypon 0
4494158 2198865 2198865 defendant Hosyer Thomas   587266 587266 Hosyer, Thomas, of Rypon 0
4498067 2200044 2200044 defendant Barker Adam   587266 587266 Barker, Adam, of Rypon 0
4500217 2200697 2200697 defendant Bene John clerk 587266 587266 Bene, John, of Rypon, clerk 2
4501295 2201009 2201009 defendant Pape Thomas   587266 587266 Pape, Thomas, of Rypon 0
4501296 2201009 2201009 defendant Bedale William butcher 587266 587266 Bedale, William, of Rypon, butcher 1
4503985 2201803 2201803 defendant Fyssher Robert   587266 587266 Fyssher, Robert, of Rypon 1
4518642 2206204 2206204 defendant Emson Henry   587266 587266 Emson, Henry, of Rypon 0
4520072 2206607 2206607 defendant Manson Robert   587266 587266 Manson, Robert, of Rypon 0
4537816 2212108 2212108 defendant Mason Adam   587266 587266 (Mason, Adam, of Rypon 1
4546646 2214876 2214876 defendant Sharowe Richard glover 587266 587266 Sharowe, Richard, of Rypon, glover 1
4552805 2216824 2216824 defendant fissher Robert   587266 587266 fissher, Robert, of Rypon 2
4552806 2216824 2216824 defendant Batty John   587266 587266 Batty, John, of Rypon 3
4552814 2216824 2216824 defendant Merot John   587266 587266 Merot, John, of Rypon 11
4557811 2218373 2218373 plaintiff Ledes William de   587266 587266 Ledes, William de, of Rypon 0
4560978 2219387 2219387 defendant Clyston Thomas   587266 587266 Clyston, Thomas, of Rypon 2
4560981 2219387 2219387 defendant Batsyde John   587266 587266 Batsyde, John, of Rypon 5
4560985 2219388 2219388 defendant Clyfton Thomas   587266 587266 Clyfton, Thomas, of Rypon 2
4564526 2220465 2220465 defendant Kyng Robert   587266 587266 Kyng, Robert, of Rypon 0
4564965 2220610 2220610 plaintiff Shirburn Richard de   587266 587266 Shirburn, Richard de, of Rypon 0
4565782 2220854 2220854 defendant Fencotes William   587266 587266 Fencotes, William, of Rypon 0
4565784 2220855 2220855 defendant Fencotes William   587266 587266 Fencotes, William, of Rypon 0
4569338 2221999 2221999 defendant Midhope John   587266 587266 Midhope, John, of Rypon 0
4570912 2222469 2222469 plaintiff Wynpeny Robert   587266 587266 Wynpeny, Robert, of Rypon 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);