names

94 rows where place_id = 586056

✎ 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
3587820 1863836 1863836 defendant Thymolby Thomas laborer 586056 586056 Thymolby, Thomas, of Thedilthorp, laborer 0
3587821 1863836 1863836 defendant Nicolson Thomas tailor 586056 586056 Nicolson, Thomas, of Thedilthorp, tailor 1
3622807 1874663 1874663 defendant Bonde Richard yeoman 586056 586056 Bonde, Richard, of Thedilthorp, yeoman 3
3622808 1874663 1874663 defendant Trecy Thomas husbandman 586056 586056 Trecy, Thomas, of Thedilthorp, husbandman 4
3622810 1874664 1874664 defendant Bonde Richard yeoman 586056 586056 Bonde, Richard, of Thedilthorp, yeoman 0
3795387 1956428 1956428 defendant Poterell Robert yeoman 586056 586056 Poterell, Robert, of Thedilthorp, yeoman 0
3798844 1957553 1957553 defendant Gaunte Barnard yeoman 586056 586056 Gaunte, Barnard, of Thedilthorp, yeoman 0
3828238 1966701 1966701 defendant White Robert husbandman 586056 586056 White, Robert, of Thedilthorp, husbandman 0
3832269 1968007 1968007 defendant Raye Nicholas husbandman 586056 586056 Raye, Nicholas, of Thedilthorp, husbandman 2
3897047 1989230 1989230 defendant Tutbere Robert yeoman 586056 586056 Tutbere, Robert, of Thedilthorp, yeoman 1
3934624 2001875 2001875 defendant Puttrell Thomas, junior yeoman 586056 586056 Puttrell, Thomas, junior, of Thedilthorp, yeoman 0
3934625 2001875 2001875 defendant Cayburne Robert drover 586056 586056 Cayburne, Robert, of Thedilthorp, drover 1
3943030 2004678 2004678 defendant Caborne Robert drover 586056 586056 Caborne, Robert, of Thedilthorp, drover 1
3985236 2019476 2019476 defendant Scupholm Christopher gent 586056 586056 Scupholm, Christopher, of Thedilthorp, gent 2
4075719 2051622 2051622 defendant Oresby Thomas yeoman 586056 586056 Oresby, Thomas, of Thedilthorp, yeoman 0
4075723 2051623 2051623 defendant Saull Thomas husbandman 586056 586056 Saull, Thomas, of Thedilthorp, husbandman 0
4187407 2091094 2091094 defendant Alenson Robert carpenter 586056 586056 Alenson, Robert, of Thedilthorp, carpenter 1
4187414 2091096 2091096 defendant Bredford James carpenter 586056 586056 Bredford, James, of Thedilthorp, carpenter 0
4540357 2212883 2212883 defendant Norton John   586056 586056 Norton, John, of Thedilthorp 2
4542109 2213425 2213425 defendant Challowe Richard   586056 586056 Challowe, Richard, of Thedilthorp 1
4553309 2216968 2216968 defendant Aobel Simon   586056 586056 Aobel, Simon, of Thedilthorp 0
4588104 2227678 2227678 defendant Benet John   586056 586056 Benet, John, of Thedilthorp 0
4611726 2234730 2234730 defendant (not given) John rector of Bliton 586056 586056 Bliton, John, of Thedilthorp, rector of the church of St Helen 3
4611727 2234730 2234730 defendant Smyth John chaplain 586056 586056 Smyth, John, of Thedilthorp, chaplain 4
4611728 2234730 2234730 defendant at Well William   586056 586056 at Well, William, of Thedilthorp 5
4639451 2243054 2243054 defendant Warde John chaplain 586056 586056 Warde, John, of Thedilthorp, chaplain 0
4668694 2255924 2255924 defendant Cholls or Cholle Richard   586056 586056 Cholls or Cholle, Richard, of Thedilthorp 0
4668695 2255924 2255924 defendant Benet Robert   586056 586056 Benet, Robert, of Thedilthorp 1
4668696 2255924 2255924 defendant Benet John   586056 586056 Benet, John, of Thedilthorp 2
4693733 2263541 2263541 defendant Thoreald John husbandman 586056 586056 Thoreald, John, of Thedilthorp, husbandman 1
4731480 2275046 2275046 plaintiff Moyne Lawrence esq 586056 586056 Moyne, Lawrence, of Thedilthorp, esq 0
4808123 2298716 2298716 defendant Warde Robert husbandman 586056 586056 Warde, Robert, of Thedilthorp, husbandman 0
4808583 2298850 2298850 defendant Segeford Stephen   586056 586056 Segeford, Stephen, of Thedilthorp 0
4817449 2301545 2301545 defendant Lourdwyn John husbandman 586056 586056 Lourdwyn, John, of Thedilthorp, husbandman 1
4830845 2305674 2305674 plaintiff Botercake John   586056 586056 Botercake, John, of Thedilthorp 0
4886138 2322524 2322524 defendant Seggeford Stephen husbandman 586056 586056 Seggeford, Stephen, of Thedilthorp, husbandman 0
4924008 2333949 2333949 plaintiff Moygne Lawrence (legal representative) 586056 586056 Moygne, Lawrence, of Thedilthorp, esq, executors of 0
4924010 2333949 2333949 plaintiff Sallay Thomas   586056 586056 Sallay, Thomas, of Thedilthorp, vicar 2
4927812 2335133 2335133 defendant Seggeford Stephen husbandman 586056 586056 Seggeford, Stephen, of Thedilthorp, husbandman 0
4932466 2336550 2336550 plaintiff Chaumpard John   586056 586056 Chaumpard, John, of Thedilthorp 2
4945572 2340593 2340593 defendant Lourdewyn William husbandman 586056 586056 Lourdewyn, William, of Thedilthorp, husbandman 0
4987754 2353300 2353300 defendant Aungevyn Bernard gent 586056 586056 Aungevyn, Bernard, of Thedilthorp, gent 9
4992263 2354579 2354579 defendant Yongar Henry husbandman 586056 586056 Yongar, Henry, of Thedilthorp, husbandman 2
4993141 2354829 2354829 defendant Clerk John husbandman 586056 586056 Clerk, John, of Thedilthorp, husbandman 2
5003205 2357838 2357838 defendant Clerk John chaplain 586056 586056 Clerk, John, of Thedilthorp, chaplain 0
5003207 2357839 2357839 defendant Clerk John chaplain 586056 586056 Clerk, John, of Thedilthorp, chaplain 0
5019010 2362451 2362451 defendant Mercand john husbandman 586056 586056 Mercand, john, of Thedilthorp, husbandman 1
5029843 2365603 2365603 plaintiff Pape John   586056 586056 Pape, John, of Thedilthorp 0
5038000 2368000 2368000 defendant Wystowe John tailor 586056 586056 Wystowe, John, of Thedilthorp, tailor 0
5049783 2371563 2371563 defendant Broune Thomas laborer 586056 586056 Broune, Thomas, of Thedilthorp, laborer 0
5085681 2382211 2382211 defendant Markand John, junior husbandman 586056 586056 (Markand, John, junior, of Thedilthorp, husbandman 1
5108744 2388995 2388995 defendant Solley Thomas clerk 586056 586056 Solley, Thomas, of Thedilthorp, clerk 0
5108745 2388995 2388995 defendant Craconell William husbandman 586056 586056 Craconell, William, of Thedilthorp, husbandman 1
5108746 2388995 2388995 defendant Thorold William husbandman 586056 586056 Thorold, William, of Thedilthorp, husbandman 2
5108747 2388995 2388995 defendant Cook Richard husbandman 586056 586056 Cook, Richard, of Thedilthorp, husbandman 3
5108748 2388995 2388995 defendant Roger William husbandman 586056 586056 Roger, William, of Thedilthorp, husbandman 4
5124283 2393548 2393548 defendant Makefeld Nicholas husbandman 586056 586056 Makefeld, Nicholas, of Thedilthorp, husbandman 2
5129204 2395030 2395030 defendant Warde John, senior husbandman 586056 586056 Warde, John, senior, of Thedilthorp, husbandman 3
5129205 2395030 2395030 defendant Markand Thomas husbandman 586056 586056 Markand, Thomas, of Thedilthorp, husbandman 4
5130235 2395330 2395330 defendant Wythern Robert yeoman 586056 586056 Wythern, Robert, of Thedilthorp, yeoman 0
5130237 2395331 2395331 defendant Wythern Robert yeoman 586056 586056 Wythern, Robert, of Thedilthorp, yeoman 0
5135141 2396777 2396777 defendant Ovy or Oby Robert husbandman 586056 586056 Ovy or Oby, Robert, of Thedilthorp, husbandman 0
5139702 2398087 2398087 defendant Warde John, senior husbandman 586056 586056 Warde, John, senior,of Thedilthorp, husbandman 1
5139703 2398087 2398087 defendant Warde Robert, junior husbandman 586056 586056 Warde, Robert, junior, of Thedilthorp, husbandman 2
5140520 2398334 2398334 defendant Ovy or Oby Robert husbandman 586056 586056 Ovy or Oby, Robert, of Thedilthorp, husbandman 0
5155248 2402684 2402684 defendant Ely Robert husbandman 586056 586056 Ely, Robert, of Thedilthorp, husbandman 0
5160613 2404199 2404199 defendant Warde John, sen husbandman 586056 586056 Warde, John, sen, of Thedilthorp, husbandman 1
5161650 2404510 2404510 defendant Ely Robert husbandman 586056 586056 Ely, Robert, of Thedilthorp, husbandman 0
5161651 2404510 2404510 defendant Warde John, sen husbandman 586056 586056 Warde, John, sen, of Thedilthorp, husbandman 1
5175369 2408486 2408486 defendant Warde John, sen husbandman 586056 586056 Warde, John, sen, of Thedilthorp, husbandman 1
5190422 2412943 2412943 defendant Marchand John, sen husbandman 586056 586056 Marchand, John, sen, of Thedilthorp, husbandman 0
5196537 2414740 2414740 defendant Warde John, sen husbandman 586056 586056 Warde, John, sen, of Thedilthorp, husbandman 1
5215288 2420199 2420199 defendant Crees Lawrence laborer 586056 586056 Crees, Lawrence, of Thedilthorp, laborer 0
5236855 2426361 2426361 defendant Cochour John husbandman 586056 586056 Cochour, John, of Thedilthorp, husbandman 1
5241094 2427595 2427595 defendant Makefeld Nicholas husbandman 586056 586056 Makefeld, Nicholas, of Thedilthorp, husbandman 2
5263724 2434404 2434404 defendant Crakenell William husbandman 586056 586056 Crakenell, William, of Thedilthorp, husbandman 0
5263725 2434404 2434404 defendant Webster John husbandman 586056 586056 Webster, John, of Thedilthorp, husbandman 1
5263727 2434405 2434405 defendant Crakonell William husbandman 586056 586056 Crakonell, William, of Thedilthorp, husbandman 0
5263728 2434405 2434405 defendant Webster John husbandman 586056 586056 Webster, John, of Thedilthorp, husbandman 1
5263730 2434406 2434406 defendant Crakonell William husbandman 586056 586056 Crakonell, William, of Thedilthorp, husbandman 0
5263731 2434406 2434406 defendant Webster John husbandman 586056 586056 Webster, John, of Thedilthorp, husbandman 1
5266779 2435365 2435365 defendant Symkynson Richard merchant 586056 586056 Symkynson, Richard, of Thedilthorp, merchant 0
5266780 2435365 2435365 defendant Couper Thomas laborer 586056 586056 Couper, Thomas, of Thedilthorp, laborer 1
5266781 2435365 2435365 defendant Johnson William husbandman 586056 586056 Johnson, William, of Thedilthorp, husbandman 2
5323574 2452133 2452133 defendant Pape John husbandman 586056 586056 Pape, John, of Thedilthorp, husbandman 0
5345618 2458790 2458790 defendant Symkynson Richard merchant 586056 586056 Symkynson, Richard, of Thedilthorp, merchant 0
5484086 2500175 2500175 defendant Bailly John husbandman 586056 586056 Bailly, John, of Thedilthorp, husbandman 0
5501054 2505263 2505263 defendant Pape John husbandman 586056 586056 Pape, John, of Thedilthorp, husbandman 0
5514778 2509464 2509464 defendant Fresshenay Lawrence husbandman 586056 586056 Fresshenay, Lawrence, of Thedilthorp, husbandman 0
5521062 2511413 2511413 defendant Bowd Richard yeoman 586056 586056 Bowd, Richard, of Thedilthorp, yeoman 0
5615657 2548687 2548687 plaintiff Grayne Alan (legal representative) 586056 586056 Grayne, Alan, of Thedilthorp, son of William, executor of 0
5615659 2548687 2548687 defendant Grayne John   586056 586056 Grayne, John, of Thedilthorp, son of Gilbert 0
5617861 2549402 2549402 defendant Genel John   586056 586056 Genel, John, of Thedilthorp 0
5617864 2549403 2549403 defendant Kenet John   586056 586056 Kenet, John, of Thedilthorp 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);