names

128 rows where place_id = 587162

✎ 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
3590636 1864714 1864714 defendant Lye William husbandman 587162 587162 Lye, William, of Ermyngton, husbandman 0
3595366 1866183 1866183 defendant Legh William yeoman 587162 587162 Legh, William, of Ermyngton, yeoman 0
3595370 1866184 1866184 defendant Legh William yeoman 587162 587162 Legh, William, of Ermyngton, yeoman 1
3625006 1875354 1875354 defendant Rogers Thomas husbandman 587162 587162 Rogers, Thomas, of Ermyngton, husbandman 0
3630773 1904449 1904449 defendant Drake Robert husbandman 587162 587162 Drake, Robert, of Ermyngton, husbandman 3
3631318 1904605 1904605 defendant Ryche William husbandman 587162 587162 Ryche, William, of Ermyngton, husbandman 0
3631319 1904605 1904605 defendant Riche Christopher   587162 587162 Riche, Christopher, of Ermyngton, groom 1
3641975 1907938 1907938 defendant Deryng Thomas, senior yeoman or miller 587162 587162 Deryng, Thomas, senior, of Ermyngton, yeoman or miller 0
3650211 1910436 1910436 defendant Gyll William yeoman 587162 587162 Gyll, William, of Ermyngton, yeoman 0
3650216 1910437 1910437 defendant Gyll William yeoman 587162 587162 Gyll, William, of Ermyngton, yeoman 0
3658908 1913046 1913046 defendant Upcote John yeoman 587162 587162 Upcote, John, of Ermyngton, yeoman 0
3718531 1932075 1932075 defendant Ropcote Matilda widow 587162 587162 Ropcote, Matilda, of Ermyngton, widow 0
3722320 1933243 1933243 defendant Chapylman John carpenter 587162 587162 Chapylman, John, of Ermyngton, carpenter 0
3732676 1936450 1936450 defendant Copleston Thomas esq 587162 587162 Copleston, Thomas, of Ermyngton, esq 0
3811993 1961658 1961658 defendant Bowdon John, senior tanner 587162 587162 Bowdon, John, senior, of Ermyngton, tanner 0
3829975 1967269 1967269 defendant Foxe John husbandman 587162 587162 Foxe, John, of Ermyngton, husbandman 0
3882721 1984485 1984485 defendant Abbot John husbandman 587162 587162 Abbot, John, of Ermyngton, husbandman 0
3893847 1988164 1988164 defendant Gaye John   587162 587162 Gaye, John, of Ermyngton, groom 1
3950063 2007106 2007106 defendant Brodemede Richard husbandman 587162 587162 Brodemede, Richard, of Ermyngton, husbandman 0
3950064 2007106 2007106 defendant Brodemede John husbandman 587162 587162 Brodemede, John, of Ermyngton, husbandman 1
3955896 2009131 2009131 defendant Corpe George husbandman 587162 587162 Corpe, George, of Ermyngton, husbandman 0
3968302 2013543 2013543 defendant Cowne Ralph husbandman 587162 587162 Cowne, Ralph, of Ermyngton, husbandman 0
3968434 2013593 2013593 defendant Challons John gent 587162 587162 Challons, John, of Ermyngton, gent 0
3982465 2018504 2018504 defendant Challones John gent 587162 587162 Challones, John, of Ermyngton, gent 0
4004643 2026436 2026436 defendant Canamore alias Daniel Henry husbandman 587162 587162 Canamore alias Daniel, Henry, of Ermyngton, husbandman 0
4027141 2034353 2034353 defendant Broademeade Richard husbandman 587162 587162 Broademeade, Richard, of Ermyngton, husbandman 0
4054357 2043949 2043949 defendant Adams William husbandman 587162 587162 Adams, William, of Ermyngton, husbandman 0
4054358 2043949 2043949 defendant Yorke alias Chamborne Christopher yeoman 587162 587162 Yorke alias Chamborne, Christopher, of Ermyngton, yeoman 1
4135415 2072986 2072986 defendant Browne John husbandman 587162 587162 Browne, John, of Ermyngton, husbandman 0
4342108 2144520 2144520 defendant Rattenburye John   587162 587162 Rattenburye, John, of Ermyngton, groom 1
4548904 2215591 2215591 defendant Frende John   587162 587162 Frende, John, of Ermyngton 0
4561911 2219658 2219658 defendant Puddyng Walter   587162 587162 Puddyng, Walter, of Ermyngton 0
4651558 2246488 2246488 defendant Corn- Robert   587162 587162 Corn-, Robert, of Ermyngton bailiff 3
4665998 2250840 2250840 defendant Hough Jenry miller 587162 587162 Hough, Jenry, of Ermyngton, miller 0
4692563 2263190 2263190 defendant Chelwyll John husbandman 587162 587162 Chelwyll, John, of Ermyngton, husbandman 0
4699028 2265168 2265168 defendant Cornysshe Robert   587162 587162 Cornysshe, Robert, of Ermyngton, bailiff 0
4735794 2276343 2276343 defendant Cutfyn Walter husbandman 587162 587162 Cutfyn, Walter, of Ermyngton, husbandman 0
4742112 2278184 2278184 defendant Wyndegrynde John clerk 587162 587162 Wyndegrynde, John, of Ermyngton, clerk 4
4757133 2282602 2282602 defendant Wynkelegh John   587162 587162 Wynkelegh, John, of Ermyngton 0
4764634 2284924 2284924 defendant Elys William husbandman 587162 587162 Elys, William, of Ermyngton, husbandman 1
4779125 2289447 2289447 defendant Wynkelegh John   587162 587162 Wynkelegh, John, of Ermyngton, bailiff 0
4823472 2303430 2303430 defendant Mate William husbandman 587162 587162 Mate, William, of Ermyngton, husbandman 1
4830364 2305529 2305529 defendant Worsford Henry husbandman 587162 587162 Worsford, Henry, of Ermyngton, husbandman 0
4841256 2308803 2308803 defendant Cornyshche Robert   587162 587162 Cornyshche, Robert, of Ermyngton, bailiff 0
4844347 2309741 2309741 defendant Bastard William husbandman 587162 587162 Bastard, William, of Ermyngton, husbandman 0
4857658 2313775 2313775 defendant Worsford Henry husbandman 587162 587162 Worsford, Henry, of Ermyngton, husbandman 1
4860875 2314756 2314756 defendant Hertelond John husbandman 587162 587162 Hertelond, John, of Ermyngton, husbandman 0
4876637 2319663 2319663 defendant Pruston John gent 587162 587162 Pruston, John, of Ermyngton, gent 0
4900934 2326921 2326921 defendant Honnesdon William husbandman 587162 587162 Honnesdon, William, of Ermyngton, husbandman 0
4908861 2329321 2329321 defendant Attebroke Robert husbandman 587162 587162 Attebroke, Robert, of Ermyngton, husbandman 0
4944801 2340362 2340362 defendant Rogger Walter   587162 587162 Rogger, Walter, of Ermyngton, bailiff 0
4954893 2343420 2343420 defendant Croft William husbandman 587162 587162 Croft, William, of Ermyngton, husbandman 0
4957472 2344205 2344205 defendant Fortescu Richard gent 587162 587162 Fortescu, Richard, of Ermyngton, gent 0
4962865 2345808 2345808 defendant Peperell Hugh yeoman 587162 587162 Peperell, Hugh, of Ermyngton, yeoman 7
4963007 2345846 2345846 defendant Rogger Walter   587162 587162 Rogger, Walter, of Ermyngton, bailiff 6
4968032 2347383 2347383 defendant Burell Walter gent 587162 587162 Burell, Walter, of Ermyngton, gent 0
4979319 2350774 2350774 defendant Fortescu Richard gent 587162 587162 Fortescu, Richard, of Ermyngton, gent 0
4985230 2352510 2352510 defendant Rogger Walter   587162 587162 Rogger, Walter, of Ermyngton, bailiff 6
4996177 2355712 2355712 defendant Milward John carpenter 587162 587162 Milward, John, of Ermyngton, carpenter 2
5016031 2361573 2361573 defendant Roigger Walter   587162 587162 Roigger, Walter, of Ermyngton, bailiff 1
5016043 2361576 2361576 defendant Roigger Walter   587162 587162 Roigger, Walter, of Ermyngton, bailiff 1
5021538 2363198 2363198 defendant Rogger Walter   587162 587162 Rogger, Walter, of Ermyngton, bailiff 3
5023245 2363702 2363702 defendant Milward John carpenter 587162 587162 Milward, John, of Ermyngton, carpenter 1
5024225 2363999 2363999 defendant Rogger Andrew husbandman 587162 587162 Rogger, Andrew, of Ermyngton, husbandman 3
5032073 2366254 2366254 defendant Rogger Richard husbandman 587162 587162 Rogger, Richard, of Ermyngton, husbandman 0
5032074 2366254 2366254 defendant Rogger John   587162 587162 Rogger, John, of Ermyngton, groom, son of Rogger, Richard 1
5043838 2369783 2369783 defendant Wyot Hugh laborer 587162 587162 Wyot, Hugh, of Ermyngton, laborer 2
5054603 2372950 2372950 defendant Rytte John husbandman 587162 587162 Rytte, John, of Ermyngton, husbandman 2
5068827 2377173 2377173 defendant Baker Walter husbandman 587162 587162 Baker, Walter, of Ermyngton, husbandman 0
5070081 2377545 2377545 defendant Fortescu Richard gent 587162 587162 Fortescu, Richard, of Ermyngton, gent 0
5070083 2377546 2377546 defendant Fortescu Richard, senior (legal representative) 587162 587162 Fortescu, Richard, senior, of Ermyngton, esq, executors of 0
5070084 2377546 2377546 defendant Fortescu Agnes widow 587162 587162 (Fortescu, Agnes, of Ermyngton, widow 1
5070085 2377546 2377546 defendant Smert Robert clerk 587162 587162 Smert, Robert, of Ermyngton, clerk 2
5073640 2378598 2378598 defendant Stracchelegh Robert gent 587162 587162 Stracchelegh, Robert, of Ermyngton, gent 1
5074123 2378748 2378748 defendant Filham William laborer 587162 587162 Filham, William, of Ermyngton, laborer 1
5087410 2382696 2382696 defendant Oxenham Henry   587162 587162 Oxenham, Henry, of Ermyngton, bailiff 10
5094632 2384842 2384842 defendant Fortescu Richard, senior (legal representative) 587162 587162 Fortescu, Richard, senior, of Ermyngton, esq, executors of 0
5094633 2384842 2384842 defendant Fortescu Agnes widow 587162 587162 (Fortescu, Agnes, of Ermyngton, widow 1
5094634 2384842 2384842 defendant Smert Robert clerk 587162 587162 Smert, Robert, of Ermyngton, clerk 2
5094636 2384843 2384843 defendant Fortescu Richard, senior (legal representative) 587162 587162 Fortescu, Richard, senior, of Ermyngton, esq, executors of 0
5094637 2384843 2384843 defendant Fortescu Agnes widow 587162 587162 (Fortescu, Agnes, of Ermyngton, widow 1
5094638 2384843 2384843 defendant Smert Robert clerk 587162 587162 Smert, Robert, of Ermyngton, clerk 2
5111540 2389772 2389772 defendant Hounesdon William   587162 587162 Hounesdon, William, of Ermyngton, bailiff 0
5120867 2392534 2392534 defendant Cleve Thomas husbandman 587162 587162 Cleve, Thomas, of Ermyngton, husbandman 1
5137874 2397591 2397591 defendant Rogger Thomas tailor 587162 587162 Rogger, Thomas, of Ermyngton, tailor 2
5138794 2397847 2397847 defendant Fortescu Agnes   587162 587162 Fortescu, Agnes, of Ermyngton, widow, formerly wife of Richard Fortescu esq 0
5143151 2399133 2399133 defendant Rogger John tailor 587162 587162 Rogger, John, of Ermyngton, tailor 0
5210068 2418678 2418678 defendant Cleve Thomas husbandman 587162 587162 Cleve, Thomas, of Ermyngton, husbandman 1
5217658 2420898 2420898 defendant Baker Walter husbandman 587162 587162 Baker, Walter, of Ermyngton, husbandman 0
5217659 2420898 2420898 defendant Mey John laborer 587162 587162 Mey, John, of Ermyngton, laborer 1
5233974 2425526 2425526 defendant Marche John thatcher 587162 587162 Marche, John, of Ermyngton, thatcher 0
5233975 2425526 2425526 defendant Proute John husbandman 587162 587162 Proute, John, of Ermyngton, husbandman 1
5248382 2429659 2429659 defendant Clyne Thomas husbandman 587162 587162 Clyne, Thomas, of Ermyngton, husbandman 1
5282934 2440070 2440070 defendant Fesshemond Walter gent 587162 587162 Fesshemond, Walter, of Ermyngton, or of Lutton, gent 0
5303670 2446093 2446093 defendant Cleve or Clene John husbandman 587162 587162 Cleve or Clene, John, of Ermyngton, husbandman 1
5332158 2454694 2454694 defendant Hill John tailor 587162 587162 Hill, John, of Ermyngton, tailor 3
5333251 2455017 2455017 defendant Drewe Thomas husbandman 587162 587162 Drewe, Thomas, of Ermyngton, husbandman 0
5341394 2457500 2457500 defendant Halswyll Walter husbandman 587162 587162 Halswyll, Walter, of Ermyngton, husbandman 1
5347816 2459470 2459470 defendant Fortescu John, senior gent 587162 587162 Fortescu, John, senior, of Ermyngton, gent 0
5347817 2459470 2459470 defendant Fortescu John, junior gent 587162 587162 Fortescu, John, junior, of Ermyngton, gent 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);