names

104 rows where place_id = 593687

✎ 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
3612945 1871695 1871695 defendant Baker Thomas butcher 593687 593687 Baker, Thomas, of Methewold, butcher 0
3643575 1908423 1908423 defendant Rumbold John husbandman 593687 593687 Rumbold, John, of Methewold, husbandman 0
3643576 1908423 1908423 defendant Yong Etheldred widow 593687 593687 Yong, Etheldred, of Methewold, widow 1
3643577 1908423 1908423 defendant Barker Robert husbandman 593687 593687 Barker, Robert, of Methewold, husbandman 2
3822230 1964857 1964857 defendant Stalworthy Richard husbandman 593687 593687 Stalworthy, Richard, of Methewold, husbandman 0
4012967 2029370 2029370 plaintiff Reymund Robert   593687 593687 Reymund, Robert, of Methewold 0
4428218 2173654 2173654 plaintiff Stalworth Robert   593687 593687 Stalworth, Robert, of Methewold 0
4494317 2198912 2198912 defendant Michell John   593687 593687 Michell, John, of Methewold 6
4512080 2204220 2204220 defendant Barbour William   593687 593687 Barbour, William, of Methewold 0
4532933 2210569 2210569 defendant Mounteford William   593687 593687 Mounteford, William, of Methewold 0
4573242 2223166 2223166 defendant Stalworthy John   593687 593687 Stalworthy, John, of Methewold 1
4573253 2223168 2223168 defendant Stalworty John   593687 593687 Stalworty, John, of Methewold 1
4600173 2231280 2231280 defendant Kenynghale (illegible)   593687 593687 Kenynghale, _, of Methewold 0
4636356 2242206 2242206 defendant Baldewyn Thomas   593687 593687 Baldewyn, Thomas, of Methewold 2
4637807 2242597 2242597 plaintiff Shraggere Margaret   593687 593687 Shraggere, Margaret, of Methewold, formerly wife of John 2
4652812 2246813 2246813 plaintiff Barbour John   593687 593687 Barbour, John, of Methewold 0
4663901 2250192 2250192 defendant Spenser John yeoman 593687 593687 Spenser, John, of Methewold, yeoman 0
4744270 2278847 2278847 defendant Spenser John yeoman 593687 593687 Spenser, John, of Methewold, yeoman 3
4758346 2282983 2282983 defendant Spencer John yeoman 593687 593687 Spencer, John, of Methewold, yeoman 2
4760721 2283694 2283694 defendant Rumbald William husbandman 593687 593687 Rumbald, William, of Methewold, husbandman 4
4760727 2283695 2283695 defendant Rumbald William husbandman 593687 593687 Rumbald, William, of Methewold, husbandman 4
4777824 2289055 2289055 defendant Spenser John yeoman 593687 593687 Spenser, John, of Methewold, yeoman 3
4803729 2297349 2297349 defendant Rycheman Peter thatcher 593687 593687 Rycheman, Peter, of Methewold, thatcher 0
4803731 2297349 2297349 defendant Richeman Thomas laborer 593687 593687 Richeman, Thomas, of Methewold, laborer 2
4803732 2297349 2297349 defendant Baldewyn Thomas husbandman 593687 593687 Baldewyn, Thomas, of Methewold, husbandman 3
4803733 2297349 2297349 defendant Chast John laborer 593687 593687 Chast, John, of Methewold, laborer 4
4803734 2297349 2297349 defendant Cok John yeoman 593687 593687 Cok, John, of Methewold, yeoman 5
4833603 2306518 2306518 defendant Cranewys Geoffrey   593687 593687 Cranewys, Geoffrey, of Methewold, franklin 0
4842634 2309232 2309232 defendant Stokeman Edmund husbandman 593687 593687 Stokeman, Edmund, of Methewold, husbandman 1
4860601 2314674 2314674 defendant Cranewys Geoffrey   593687 593687 Cranewys, Geoffrey, of Methewold, franklin 0
4863405 2315524 2315524 plaintiff Dyghton William   593687 593687 Dyghton, William, of Methewold 0
4941085 2339234 2339234 plaintiff Dyghton William (legal representative) 593687 593687 Dyghton, William, of Methewold, executors of 0
4955473 2343600 2343600 defendant Dytton William (legal representative) 593687 593687 Dytton, William, of Methewold, executors of 4
4955474 2343600 2343600 defendant Dytton Thomas yeoman 593687 593687 (Dytton, Thomas, of Methewold, yeoman 5
4955475 2343600 2343600 defendant Dytton Agnes widow 593687 593687 Dytton, Agnes, of Methewold, widow 6
4960866 2345212 2345212 defendant Rombold William husbandman 593687 593687 Rombold, William, of Methewold, husbandman 0
4985688 2352634 2352634 defendant Dyghton Thomas   593687 593687 Dyghton, Thomas, of Methewold 0
5020738 2362964 2362964 defendant Chast John, senior husbandman 593687 593687 Chast, John, senior, of Methewold, husbandman 0
5020739 2362964 2362964 defendant Hog Thomas laborer 593687 593687 Hog, Thomas, of Methewold, laborer 1
5020740 2362964 2362964 defendant Chast Nicholas weaver 593687 593687 Chast, Nicholas, of Methewold, weaver 2
5022220 2363392 2363392 defendant Dyghton Thomas yeoman 593687 593687 Dyghton, Thomas, of Methewold, yeoman 1
5028664 2365260 2365260 defendant Rumbold William husbandman 593687 593687 Rumbold, William, of Methewold, husbandman 0
5030367 2365755 2365755 defendant Ditton Thomas yeoman 593687 593687 Ditton, Thomas, of Methewold, yeoman 0
5046973 2370719 2370719 defendant Keteryngham Thomas husbandman 593687 593687 Keteryngham, Thomas, of Methewold, husbandman 0
5055727 2373283 2373283 defendant Bacon Nicholas husbandman 593687 593687 Bacon, Nicholas, of Methewold, husbandman 0
5055728 2373283 2373283 defendant Toffeye Thomas butcher 593687 593687 Toffeye, Thomas, of Methewold, butcher 1
5055729 2373283 2373283 defendant Chaste John husbandman 593687 593687 Chaste, John, of Methewold, husbandman 2
5071147 2377863 2377863 defendant Warde Richard cordwainer 593687 593687 Warde, Richard, of Methewold, cordwainer 3
5077357 2379725 2379725 defendant Nanzeglose Robert gent 593687 593687 Nanzeglose, Robert, of Methewold, gent 0
5077358 2379725 2379725 defendant Donce or Douce John yeoman 593687 593687 Donce or Douce, John, of Methewold, yeoman 1
5129919 2395240 2395240 defendant (illegible) John husbandman 593687 593687 --, John, of Methewold, husbandman 1
5133954 2396430 2396430 defendant Curteys Robert husbandman 593687 593687 Curteys, Robert, of Methewold, husbandman 0
5133955 2396430 2396430 defendant Stede John husbandman 593687 593687 Stede, John, of Methewold, husbandman 1
5133956 2396430 2396430 defendant Nettelysworth Thomas husbandman 593687 593687 Nettelysworth, Thomas, of Methewold, husbandman 2
5139210 2397959 2397959 defendant Frenssh Robert yeoman 593687 593687 Frenssh, Robert, of Methewold, yeoman 0
5160085 2404050 2404050 defendant Frenssh alias Frenge Robert yeoman 593687 593687 Frenssh alias Frenge, Robert, of Methewold, yeoman 0
5171140 2407282 2407282 defendant Curteys Robert husbandman 593687 593687 Curteys, Robert, of Methewold, husbandman 0
5171141 2407282 2407282 defendant Stede John husbandman 593687 593687 Stede, John, of Methewold, husbandman 1
5171143 2407282 2407282 defendant Neell William husbandman 593687 593687 together with Neell, William, of Methewold, husbandman 3
5171144 2407282 2407282 defendant Brachet John husbandman 593687 593687 Brachet, John, of Methewold, husbandman 4
5171145 2407282 2407282 defendant Game Thomas husbandman 593687 593687 Game, Thomas, of Methewold, husbandman 5
5171146 2407282 2407282 defendant Thornton Thomas husbandman 593687 593687 Thornton, Thomas, of Methewold, husbandman 6
5171147 2407282 2407282 defendant Potter Simon husbandman 593687 593687 Potter, Simon, of Methewold, husbandman 7
5171148 2407282 2407282 defendant Constable Thomas laborer 593687 593687 Constable, Thomas, of Methewold, laborer 8
5171149 2407282 2407282 defendant Nettellysworth Thomas husbandman 593687 593687 Nettellysworth, Thomas, of Methewold, husbandman 9
5174987 2408378 2408378 defendant Frenssh Robert yeoman 593687 593687 Frenssh, Robert, of Methewold, yeoman 0
5209456 2418504 2418504 defendant Frensshe Robert yeoman 593687 593687 Frensshe, Robert, of Methewold, yeoman 0
5216713 2420623 2420623 plaintiff Dobbes John   593687 593687 Dobbes, John, of Methewold 0
5223976 2422695 2422695 defendant Stede John husbandman 593687 593687 Stede, John, of Methewold, husbandman 0
5223977 2422695 2422695 defendant Donse or Douse John husbandman 593687 593687 Donse or Douse, John, of Methewold, husbandman 1
5223978 2422695 2422695 defendant Bullymer John husbandman 593687 593687 Bullymer, John, of Methewold, husbandman 2
5230694 2424589 2424589 defendant Dobbes John husbandman 593687 593687 Dobbes, John, of Methewold, husbandman 0
5231567 2424814 2424814 defendant Wryght John, junior laborer 593687 593687 Wryght, John, junior, of Methewold, laborer 0
5231568 2424814 2424814 defendant Neell William   593687 593687 Neell, William, of Methewold, shepherd 1
5283057 2440106 2440106 plaintiff Dytton Thomas   593687 593687 Dytton, Thomas, of Methewold 0
5296792 2444050 2444050 plaintiff Wryght Robert   593687 593687 Wryght, Robert, of Methewold 0
5296793 2444050 2444050 defendant Yonge Thomas, junior husbandman 593687 593687 Yonge, Thomas, junior, of Methewold, husbandman 0
5296794 2444050 2444050 defendant Stalworthy John husbandman 593687 593687 Stalworthy, John, of Methewold, husbandman 1
5306720 2447001 2447001 defendant Wylson Thomas husbandman 593687 593687 Wylson, Thomas, of Methewold, husbandman 0
5319602 2450956 2450956 defendant Dyghton Thomas yeoman 593687 593687 Dyghton, Thomas, of Methewold, yeoman 0
5319879 2451032 2451032 defendant Salus or Salez Robert yeoman 593687 593687 Salus or Salez, Robert, of Methewold, yeoman 0
5325143 2452607 2452607 plaintiff Salus Robert   593687 593687 Salus, Robert, of Methewold 0
5325144 2452607 2452607 plaintiff Marchale Robert   593687 593687 Marchale, Robert, of Methewold 1
5325145 2452607 2452607 plaintiff Neell William   593687 593687 Neell, William, of Methewold 2
5341129 2457418 2457418 defendant Mason Thomas husbandman 593687 593687 Mason, Thomas, of Methewold, husbandman 1
5343783 2458243 2458243 defendant Dyttyn Thomas yeoman 593687 593687 Dyttyn, Thomas, of Methewold, yeoman 0
5344134 2458344 2458344 defendant Nele William husbandman 593687 593687 Nele, William, of Methewold, husbandman 0
5357809 2462513 2462513 defendant Marchale Richard yeoman 593687 593687 Marchale, Richard, of Methewold, yeoman 1
5357810 2462513 2462513 defendant Neell William yeoman 593687 593687 Neell, William, of Methewold, yeoman 2
5371364 2466623 2466623 defendant Neyghton Robert clerk 593687 593687 Neyghton, Robert, of Methewold, clerk 0
5373942 2467446 2467446 defendant Wodecrofte John husbandman 593687 593687 Wodecrofte, John, of Methewold, husbandman 1
5420154 2480946 2480946 defendant Ditton Joan widow 593687 593687 Ditton, Joan, of Methewold, widow 0
5438872 2486548 2486548 defendant Ditton Joan widow 593687 593687 Ditton, Joan, of Methewold, widow 0
5461135 2493276 2493276 defendant Flegge Thomas husbandman 593687 593687 Flegge, Thomas, of Methewold, husbandman 0
5467783 2495302 2495302 defendant Neyghton Robert clerk 593687 593687 Neyghton, Robert, of Methewold, clerk 0
5476013 2497838 2497838 defendant Noyton Robert clerk 593687 593687 Noyton, Robert, of Methewold, clerk 0
5484338 2500236 2500236 defendant Stede John husbandman 593687 593687 Stede, John, of Methewold, husbandman 0
5490003 2501897 2501897 plaintiff Battys John   593687 593687 Battys, John, of Methewold 0
5509465 2507810 2507810 defendant Rombald Richard husbandman 593687 593687 Rombald, Richard, of Methewold, husbandman 1
5515873 2509814 2509814 defendant Rumbold Richard husbandman 593687 593687 Rumbold, Richard, of Methewold, 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);