names

141 rows where place_id = 588673

✎ 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
3595249 1866148 1866148 defendant Carter Richard husbandman 588673 588673 Carter, Richard, of Sele, husbandman 1
3595451 1866210 1866210 defendant Carter Reginald yeoman 588673 588673 Carter, Reginald, of Sele, yeoman 0
3608859 1870428 1870428 plaintiff Ware John (legal representative) 588673 588673 Ware, John, of Sele, executors of 0
3633835 1905392 1905392 defendant Joure John, senior husbandman 588673 588673 Joure, John, senior, of Sele, husbandman 5
3635085 1905771 1905771 defendant Barton Thomas tailor 588673 588673 Barton, Thomas, of Sele, tailor 0
3670007 1916565 1916565 plaintiff Bowland Roger   588673 588673 Bowland, Roger, of Sele 1
3691854 1923613 1923613 defendant Howley Richard husbandman 588673 588673 Howley, Richard, of Sele, husbandman 2
3712531 1930233 1930233 defendant Jowre Richard husbandman 588673 588673 Jowre, Richard, of Sele, husbandman 0
3734544 1937049 1937049 defendant Barne Richard tanner 588673 588673 Barne, Richard, of Sele, tanner 4
3761463 1945598 1945598 defendant Porter Richard husbandman 588673 588673 Porter, Richard, of Sele, husbandman 1
3765359 1946827 1946827 defendant Olyver George yeoman 588673 588673 Olyver, George, of Sele, yeoman 0
3765365 1946828 1946828 defendant Olyver John yeoman 588673 588673 Olyver, John, of Sele, yeoman 0
3765371 1946829 1946829 defendant Olyver George yeoman 588673 588673 Olyver, George, of Sele, yeoman 0
3765377 1946830 1946830 defendant Olyver John yeoman 588673 588673 Olyver, John, of Sele, yeoman 0
3776175 1950293 1950293 defendant Idley Thomas   588673 588673 Idley, Thomas, of Sele, "bedysmaker" 0
3776176 1950293 1950293 defendant Dawson John   588673 588673 Dawson, John, of Sele, "bedysmaker" 1
3792954 1955652 1955652 defendant Best William, junior laborer 588673 588673 Best, William, junior, of Sele, laborer 1
3809640 1960903 1960903 defendant Best William, junior laborer 588673 588673 Best, William, junior, of Sele, laborer 1
3810485 1961174 1961174 defendant Dawson William   588673 588673 Dawson, William, of Sele, beds maker 1
3911416 1994133 1994133 defendant Beste William husbandman 588673 588673 Beste, William, of Sele, husbandman 0
4011743 2028938 2028938 defendant Stace Denise widow 588673 588673 Stace, Denise, of Sele, widow 1
4132868 2072083 2072083 defendant Seman Henry husbandman 588673 588673 Seman, Henry, of Sele, husbandman 3
4491638 2198070 2198070 defendant Colishille Richard   588673 588673 Colishille, Richard, of Sele 0
4495874 2199389 2199389 plaintiff Chipstede John (legal representative) 588673 588673 Chipstede, John, of Sele, executors of 0
4533860 2210860 2210860 defendant Colyshill Richard   588673 588673 Colyshill, Richard, of Sele 1
4548066 2215333 2215333 defendant Shode William   588673 588673 Shode, William, of Sele 0
4566658 2221145 2221145 defendant Rook John   588673 588673 Rook, John, of Sele, mason 0
4572421 2222913 2222913 defendant atte Bourne Robert   588673 588673 atte Bourne, Robert, of Sele 3
4572784 2223024 2223024 defendant Smyth Simon   588673 588673 Smyth, Simon, of Sele 2
4596244 2230076 2230076 defendant Colyshille Richard   588673 588673 Colyshille, Richard, of Sele 3
4604970 2232715 2232715 defendant Tebaud Thomas   588673 588673 Tebaud, Thomas, of Sele 0
4630740 2240508 2240508 defendant Fullere John, sen   588673 588673 Fullere, John, sen, of Sele 0
4630741 2240508 2240508 defendant Fullere John   588673 588673 Fullere, John, of Sele, son of John, sen 1
4638326 2242755 2242755 defendant Carter John   588673 588673 Carter, John, of Sele 0
4638327 2242755 2242755 defendant Tebald Thomas   588673 588673 Tebald, Thomas, of Sele 1
4638374 2242768 2242768 defendant Shode Thomas   588673 588673 Shode, Thomas, of Sele 0
4638910 2242901 2242901 defendant Dyne Thomas   588673 588673 Dyne, Thomas, of Sele 0
4640020 2243208 2243208 defendant Tebald Thomas   588673 588673 Tebald, Thomas, of Sele 0
4646976 2245176 2245176 defendant Baker Reginald   588673 588673 Baker, Reginald, of Sele 1
4673963 2257473 2257473 defendant Maryet John husbandman 588673 588673 Maryet, John, of Sele, husbandman 0
4680702 2259579 2259579 defendant Blakcherll Richard laborer 588673 588673 Blakcherll, Richard, of Sele, laborer 0
4692989 2263317 2263317 defendant Brodok Richard potter 588673 588673 Brodok, Richard, of Sele, potter 5
4735458 2276235 2276235 defendant Sewale John laborer 588673 588673 Sewale, John, of Sele, laborer 0
4746684 2279521 2279521 defendant Sewale John, senior laborer 588673 588673 Sewale, John, senior, of Sele, laborer 1
4758822 2283113 2283113 plaintiff Carter John   588673 588673 Carter, John, of Sele 0
4767976 2285954 2285954 defendant Everard Thomas husbandman 588673 588673 (Everard, Thomas, of Sele, husbandman 4
4777557 2288976 2288976 defendant Sewale John laborer 588673 588673 Sewale, John, of Sele, laborer 0
4777558 2288976 2288976 defendant atte Hoke William laborer 588673 588673 atte Hoke, William, of Sele, laborer 1
4777559 2288976 2288976 defendant North John laborer 588673 588673 North, John, of Sele, laborer 2
4777560 2288976 2288976 defendant Priour William laborer 588673 588673 Priour, William, of Sele, laborer 3
4783692 2290922 2290922 defendant Baker Reginald husbandman 588673 588673 Baker, Reginald, of Sele, husbandman 0
4783694 2290923 2290923 defendant Baker Reginald husbandman 588673 588673 Baker, Reginald, of Sele, husbandman 0
4801700 2296712 2296712 defendant Coggere John shoemaker 588673 588673 Coggere, John, of Sele, shoemaker 0
4801701 2296712 2296712 defendant Coggere William shoemaker 588673 588673 Coggere, William, of Sele, shoemaker 1
4808578 2298849 2298849 defendant Pertrich John husbandman 588673 588673 Pertrich, John, of Sele, husbandman 0
4832673 2306240 2306240 plaintiff Cartere John husbandman 588673 588673 Cartere, John, of Sele, husbandman 0
4887495 2322926 2322926 defendant Everard Thomas husbandman 588673 588673 Everard, Thomas, of Sele, husbandman 3
4887496 2322926 2322926 defendant Rymond John husbandman 588673 588673 Rymond, John, of Sele, husbandman 4
4900249 2326708 2326708 defendant Thebaude Thomas husbandman 588673 588673 Thebaude, Thomas, of Sele, husbandman 0
4902982 2327548 2327548 defendant Mayn Richard husbandman 588673 588673 Mayn, Richard, of Sele, husbandman 5
4902992 2327549 2327549 defendant Mayn Richard husbandman 588673 588673 Mayn, Richard, of Sele, husbandman 5
4919176 2332508 2332508 defendant Smyth William laborer 588673 588673 Smyth, William, of Sele, laborer 1
4923510 2333786 2333786 defendant Torre John laborer 588673 588673 Torre, John, of Sele, laborer 2
4930138 2335833 2335833 defendant Fauconer Thomas shoemaker 588673 588673 Fauconer, Thomas, of Sele, shoemaker 1
4950545 2342131 2342131 plaintiff Partriche John   588673 588673 Partriche, John, of Sele 0
4960873 2345215 2345215 defendant Shode Richard gent 588673 588673 Shode, Richard, of Sele, gent 0
4963526 2346005 2346005 defendant atte Hye Stephen smith 588673 588673 atte Hye, Stephen, of Sele, smith 0
4965816 2346706 2346706 defendant Shode William labirer 588673 588673 Shode, William, of Sele, labirer 1
4967939 2347354 2347354 defendant Hewet John, junior husbandman 588673 588673 Hewet, John, junior, of Sele, husbandman 2
4969741 2347896 2347896 defendant Taverner Robert husbandman 588673 588673 together with Taverner, Robert, of Sele, husbandman 11
4969742 2347896 2347896 defendant Taverner Hugh butcher 588673 588673 Taverner, Hugh, of Sele, butcher 12
4969743 2347896 2347896 defendant Taverner John soaper 588673 588673 Taverner, John, of Sele, soaper 13
4969744 2347896 2347896 defendant Taverner Richard yeoman 588673 588673 Taverner, Richard, of Sele, yeoman 14
4981955 2351521 2351521 plaintiff Taverner Hugh   588673 588673 Taverner, Hugh, of Sele 0
4988307 2353472 2353472 defendant Fuller John husbandman 588673 588673 Fuller, John, of Sele, husbandman 1
4990937 2354179 2354179 defendant Murton Robert husbandman 588673 588673 Murton, Robert, of Sele, husbandman 1
5007339 2359041 2359041 defendant Faukener Thomas husbandman 588673 588673 Faukener, Thomas, of Sele, husbandman 1
5012892 2360603 2360603 defendant Pepyr William husbandman 588673 588673 Pepyr, William, of Sele, husbandman 0
5014777 2361194 2361194 defendant Shode Richard husbandman 588673 588673 Shode, Richard, of Sele, husbandman 0
5019171 2362496 2362496 defendant Shoode Isabel widow 588673 588673 Shoode, Isabel, of Sele, widow 0
5040396 2368729 2368729 defendant (not given) John prior of Twyford 588673 588673 Twyford, John, of Sele, prior of the House & Church 0
5050438 2371756 2371756 defendant Frende Walter fuller 588673 588673 Frende, Walter, of Sele, fuller 3
5050439 2371756 2371756 defendant Tayllour John tailor 588673 588673 Tayllour, John, of Sele, tailor 4
5050440 2371756 2371756 defendant Baron William fuller 588673 588673 Baron, William, of Sele, fuller 5
5050447 2371757 2371757 defendant Frende Walter fuller 588673 588673 Frende, Walter, of Sele, fuller 4
5050448 2371757 2371757 defendant Tayllour John tailor 588673 588673 Tayllour, John, of Sele, tailor 5
5070828 2377768 2377768 defendant Shode Joan widow 588673 588673 Shode, Joan, of Sele, widow 2
5078994 2380201 2380201 defendant Burton Thomas baker 588673 588673 Burton, Thomas, of Sele, baker 1
5078995 2380201 2380201 defendant Burton Robert   588673 588673 Burton, Robert, of Sele 2
5078999 2380202 2380202 defendant Burton Thomas baker 588673 588673 Burton, Thomas, of Sele, baker 1
5079000 2380202 2380202 defendant Burton Richard clothier 588673 588673 Burton, Richard, of Sele, clothier 2
5080516 2380664 2380664 defendant Burton Robert laborer 588673 588673 Burton, Robert, of Sele, laborer 0
5080517 2380664 2380664 defendant Burton Thomas baker 588673 588673 Burton, Thomas, of Sele, baker 1
5088398 2382983 2382983 defendant Burnard Thomas yeoman 588673 588673 Burnard, Thomas, of Sele, yeoman 2
5095390 2385072 2385072 plaintiff Shode Isabel   588673 588673 Shode, Isabel, of Sele 0
5095395 2385073 2385073 plaintiff Shode Isabel   588673 588673 Shode, Isabel, of Sele 0
5110663 2389522 2389522 defendant Shyrreve William tailor 588673 588673 Shyrreve, William, of Sele, tailor 0
5116701 2391318 2391318 defendant Fuller John husbandman 588673 588673 Fuller, John, of Sele, husbandman 0
5119570 2392155 2392155 plaintiff Shode Isabel   588673 588673 Shode, Isabel, of Sele 0
5133208 2396194 2396194 defendant Grygge or Grigge John   588673 588673 Grygge or Grigge, John, of Sele, Sussex, prior 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);