names

77 rows where place_id = 606457

✎ 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
3665278 1915092 1915092 defendant Byre Robert husbandman 606457 606457 Byre, Robert, of Thorndon, husbandman 2
3675597 1918403 1918403 defendant Godard Robert husbandman 606457 606457 Godard, Robert, of Thorndon, husbandman 0
3725018 1934109 1934109 defendant Pygott Fulk husbandman 606457 606457 Pygott, Fulk, of Thorndon, husbandman 1
3727923 1934998 1934998 defendant Tempylman Thomas laborer 606457 606457 Tempylman, Thomas, of Thorndon, laborer 13
3778422 1950965 1950965 defendant Palgrave Geoffrey thatcher 606457 606457 Palgrave, Geoffrey, of Thorndon, thatcher 0
3778423 1950965 1950965 defendant Kyng John   606457 606457 Kyng, John, of Thorndon, "lattesmaker" 1
3794998 1956300 1956300 defendant Nounne or Nomme John husbandman 606457 606457 Nounne or Nomme, John, of Thorndon, husbandman 0
3804379 1959307 1959307 defendant Bradwey William husbandman 606457 606457 Bradwey, William, of Thorndon, husbandman 0
3804380 1959307 1959307 defendant Templeman Thomas husbandman 606457 606457 Templeman, Thomas, of Thorndon, husbandman 1
3805620 1959701 1959701 defendant Gyldenslave William husbandman 606457 606457 Gyldenslave, William, of Thorndon, husbandman 0
3812731 1961875 1961875 defendant Palgrave Geoffrey thatcher 606457 606457 Palgrave, Geoffrey, of Thorndon, thatcher 0
3812732 1961875 1961875 defendant Kyng John husbandman 606457 606457 Kyng, John, of Thorndon, husbandman 1
3822834 1965049 1965049 defendant Templeman Thomas husbandman 606457 606457 Templeman, Thomas, of Thorndon, husbandman 0
3833515 1968414 1968414 plaintiff London Robert   606457 606457 (London, Robert, of Thorndon 1
3928538 1999883 1999883 defendant Dey John husbandman 606457 606457 Dey, John, of Thorndon, husbandman 1
3984104 2019080 2019080 defendant Nolethe Robert yeoman 606457 606457 Nolethe, Robert, of Thorndon, yeoman 0
3987518 2020286 2020286 defendant Corbolde Gregory husbandman 606457 606457 Corbolde, Gregory, of Thorndon, husbandman 0
4060169 2046037 2046037 defendant Nulluff Thomas yeoman 606457 606457 Nulluff, Thomas, of Thorndon, yeoman 0
4060170 2046037 2046037 defendant Nulluff Edmund yeoman 606457 606457 Nulluff, Edmund, of Thorndon, yeoman, son of Robert Nulluff of Thorndon, yeoman 1
4060174 2046038 2046038 defendant Shorte Richard yeoman 606457 606457 Shorte, Richard, of Thorndon, yeoman 0
4073885 2050952 2050952 defendant Shorte Richard yeoman 606457 606457 Shorte, Richard, of Thorndon, yeoman 0
4076400 2051856 2051856 defendant Medowe William husbandman 606457 606457 Medowe, William, of Thorndon, husbandman 3
4076402 2051857 2051857 defendant Ryall John husbandman 606457 606457 Ryall, John, of Thorndon, husbandman 0
4076403 2051857 2051857 defendant Borowe John husbandman 606457 606457 Borowe, John, of Thorndon, husbandman 1
4085188 2054987 2054987 defendant Pretyman William yeoman 606457 606457 Pretyman, William, of Thorndon, or of Backton, yeoman 0
4303940 2131512 2131512 defendant Bett Clarence gent 606457 606457 Bett, Clarence, of Thorndon, gent 0
4493803 2198754 2198754 defendant Capper Thomas   606457 606457 Capper, Thomas, of Thorndon 6
4511023 2203898 2203898 defendant Cappe Thomas   606457 606457 Cappe, Thomas, of Thorndon 0
4599038 2230917 2230917 defendant Hewode William   606457 606457 Hewode, William, of Thorndon 0
4599040 2230917 2230917 defendant Shetenhayt John   606457 606457 Shetenhayt, John, of Thorndon 2
4599043 2230918 2230918 defendant Howode William   606457 606457 Howode, William, of Thorndon 0
4599045 2230918 2230918 defendant Shetenhayt Thomas   606457 606457 Shetenhayt, Thomas, of Thorndon 2
4604200 2232484 2232484 defendant Deye Michael   606457 606457 Deye, Michael, of Thorndon 0
4613600 2235269 2235269 plaintiff Lampet William   606457 606457 Lampet, William, of Thorndon 1
4621381 2237681 2237681 plaintiff Lampet William   606457 606457 Lampet, William, of Thorndon 0
4621386 2237682 2237682 plaintiff Lampet William   606457 606457 Lampet, William, of Thorndon 0
4623170 2238219 2238219 defendant Cappe Thomas   606457 606457 Cappe, Thomas, of Thorndon 2
4637605 2242548 2242548 defendant Boonde John   606457 606457 Boonde, John, of Thorndon 1
4643745 2244272 2244272 plaintiff Lampet William   606457 606457 Lampet, William, of Thorndon 0
4706216 2267323 2267323 defendant Brikke Richard husbandman 606457 606457 Brikke, Richard, of Thorndon, husbandman 0
4747350 2279728 2279728 defendant Yustas John husbandman 606457 606457 Yustas, John, of Thorndon, husbandman 0
4850567 2311639 2311639 defendant Haughe Thomas husbandman 606457 606457 Haughe, Thomas, of Thorndon, husbandman 0
4894958 2325087 2325087 plaintiff Short John, senior   606457 606457 Short, John, senior, of Thorndon 0
4899565 2326504 2326504 defendant Yenstas or Yeustas John singleman 606457 606457 Yenstas or Yeustas, John, of Thorndon, singleman 1
4968689 2347602 2347602 defendant Stamford William husbandman 606457 606457 Stamford, William, of Thorndon, husbandman 2
4968694 2347603 2347603 defendant Stamford William husbandman 606457 606457 Stamford, William, of Thorndon, husbandman 2
4981925 2351513 2351513 defendant Popy Stephen yeoman 606457 606457 Popy, Stephen, of Thorndon, yeoman 1
5032755 2366469 2366469 defendant Neweman Simon husbandman 606457 606457 Neweman, Simon, of Thorndon, husbandman 0
5047206 2370784 2370784 defendant Taillour John laborer 606457 606457 Taillour, John, of Thorndon, laborer 0
5048198 2371090 2371090 defendant Holm John yeoman 606457 606457 Holm, John, of Thorndon, yeoman 0
5053455 2372637 2372637 defendant Colman Thomas yeoman 606457 606457 Colman, Thomas, of Thorndon, yeoman 1
5059886 2374523 2374523 defendant Haldyn Andrew fuller 606457 606457 Haldyn, Andrew, of Thorndon, fuller 1
5140730 2398403 2398403 defendant Haldeyn Andrew fuller 606457 606457 Haldeyn, Andrew, of Thorndon, fuller 0
5157837 2403418 2403418 defendant Cove Thomas tailor 606457 606457 Cove, Thomas, of Thorndon, tailor 2
5161852 2404575 2404575 defendant Haldeyn Andrew fuller 606457 606457 Haldeyn, Andrew, of Thorndon, fuller 0
5173601 2407980 2407980 defendant Cove Thomas tailor 606457 606457 Cove, Thomas, of Thorndon, tailor 2
5175992 2408663 2408663 defendant Horscroft John yeoman 606457 606457 Horscroft, John, of Thorndon, yeoman 1
5217927 2420977 2420977 defendant Ynstas or Yustas Ralph carpenter 606457 606457 Ynstas or Yustas, Ralph, of Thorndon, carpenter 0
5222942 2422425 2422425 defendant Cone or Cove Thomas husbandman 606457 606457 Cone or Cove, Thomas, of Thorndon, husbandman 0
5247682 2429477 2429477 defendant Horseman William husbandman 606457 606457 Horseman, William, of Thorndon, husbandman 1
5270316 2436421 2436421 defendant Pye William laborer 606457 606457 Pye, William, of Thorndon, laborer 0
5270317 2436421 2436421 defendant Pye Thomas husbandman 606457 606457 Pye, Thomas, of Thorndon, husbandman 1
5311560 2448481 2448481 defendant Style John husbandman 606457 606457 Style, John, of Thorndon, husbandman 0
5313742 2449136 2449136 defendant Carter John husbandman 606457 606457 Carter, John, of Thorndon, husbandman 2
5372006 2466837 2466837 defendant Sengylton Thomas yeoman 606457 606457 Sengylton, Thomas, of Thorndon, yeoman 0
5372010 2466838 2466838 defendant Sengylton Thomas yeoman 606457 606457 Sengylton, Thomas, of Thorndon, yeoman 0
5431726 2484455 2484455 defendant Canon Robert   606457 606457 Canon, Robert, of Thorndon, spoon maker 2
5448050 2489305 2489305 defendant Canon Robert sporier or iron worker 606457 606457 Canon, Robert, of Thorndon, sporier or iron worker 2
5451741 2490395 2490395 defendant Grymeson George gent 606457 606457 Grymeson, George, of Thorndon, gent 0
5464579 2494324 2494324 defendant Grymeston George gent 606457 606457 Grymeston, George, of Thorndon, gent 0
5476090 2497862 2497862 defendant Grymeston George gent 606457 606457 Grymeston, George, of Thorndon, gent 0
5568743 2525406 2525406 defendant Wyghtman John husbandman 606457 606457 Wyghtman, John, of Thorndon, husbandman 0
5584529 2530230 2530230 defendant Whyghtman John husbandman 606457 606457 Whyghtman, John, of Thorndon, husbandman 1
5584533 2530231 2530231 defendant Whyghtman John husbandman 606457 606457 Whyghtman, John, of Thorndon, husbandman 2
5595381 2533502 2533502 defendant Cowper John husbandman 606457 606457 Cowper, John, of Thorndon, husbandman 0
5597519 2534126 2534126 defendant Revett Robert husbandman 606457 606457 Revett, Robert, of Thorndon, husbandman 3
5625034 2551765 2551765 plaintiff Loudenays or Londenays John   606457 606457 Loudenays or Londenays, John, of Thorndon 0

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);