names

170 rows where place_id = 597375

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628324 1903720 1903720 defendant Broke Robert husbandman 597375 597375 Broke, Robert, of Manytre, husbandman 0
3667910 1915904 1915904 defendant Kelyk William innkeeper 597375 597375 Kelyk, William, of Manytre, innkeeper 0
3671630 1917114 1917114 defendant Elen or Glen alias Paylemaker William mariner 597375 597375 Elen or Glen alias Paylemaker, William, of Manytre, mariner 0
3672167 1917294 1917294 plaintiff Cradok John   597375 597375 Cradok, John, of Manytre 0
3675258 1918300 1918300 defendant Game Robert sherman 597375 597375 Game, Robert, of Manytre, sherman 0
3693410 1924155 1924155 defendant Watson Robert barber 597375 597375 Watson, Robert, of Manytre, barber 0
3710686 1929663 1929663 defendant Game Robert sherman 597375 597375 Game, Robert, of Manytre, sherman 1
3710689 1929663 1929663 defendant Brown John husbandman 597375 597375 Brown, John, of Manytre, husbandman 4
3742230 1939439 1939439 plaintiff Thweyte Christopher (legal representative) 597375 597375 Thweyte, Christopher, of Manytre, merchant, executors of 0
3742232 1939439 1939439 plaintiff Budde John   597375 597375 Budde, John, of Manytre 2
3776622 1950433 1950433 plaintiff Butler John   597375 597375 Butler, John, of Manytre 0
3776623 1950433 1950433 defendant Jaffen John merchant or fishmonger 597375 597375 Jaffen, John, of Manytre, merchant or fishmonger 0
3783693 1952663 1952663 defendant Butler John mariner 597375 597375 Butler, John, of Manytre, mariner 0
3792530 1955519 1955519 defendant Sprotte John tailor 597375 597375 Sprotte, John, of Manytre, tailor 0
3793260 1955751 1955751 defendant Jefson or Jesson John merchant 597375 597375 Jefson or Jesson, John, of Manytre, merchant 0
3793307 1955766 1955766 defendant Cradok John tailor 597375 597375 Cradok, John, of Manytre, tailor 0
3793308 1955766 1955766 defendant Kyng James waterman 597375 597375 Kyng, James, of Manytre, waterman 1
3793309 1955766 1955766 defendant Parker William weaver 597375 597375 Parker, William, of Manytre, weaver 2
3793468 1955822 1955822 defendant Jobson John merchant 597375 597375 Jobson, John, of Manytre, merchant 1
3793469 1955822 1955822 defendant Reynesforth John merchant 597375 597375 Reynesforth, John, of Manytre, merchant 2
3799576 1957789 1957789 defendant Cradok John tailor 597375 597375 Cradok, John, of Manytre, tailor 0
3799578 1957789 1957789 defendant Braksted Robert capper 597375 597375 (Braksted, Robert, of Manytre, capper 2
3810949 1961325 1961325 plaintiff Butler John   597375 597375 Butler, John, of Manytre 0
3826859 1966249 1966249 defendant Bowman Brian carpenter 597375 597375 Bowman, Brian, of Manytre, carpenter 1
3872517 1981033 1981033 defendant Fyll Richard husbandman 597375 597375 Fyll, Richard, of Manytre, husbandman 0
3872525 1981034 1981034 defendant Cornelys Henry   597375 597375 Cornelys, Henry, of Manytre, "passynger" 2
3874597 1981726 1981726 defendant Sharpe Robert sherman 597375 597375 Sharpe, Robert, of Manytre, sherman 0
3906594 1992498 1992498 defendant Bonour Thomas merchant 597375 597375 Bonour, Thomas, of Manytre, merchant 0
3921966 1997690 1997690 defendant Harbard or Harvard Rice gent 597375 597375 Harbard or Harvard, Rice, of Manytre, gent 1
3924016 1998341 1998341 defendant Went Thomas clothier 597375 597375 Went, Thomas, of Manytre, clothier 3
3996922 2023667 2023667 plaintiff Dowett George cordwainer 597375 597375 Dowett, George, of Manytre, cordwainer 0
3996923 2023667 2023667 defendant Brabye John clothier 597375 597375 Brabye, John, of Manytre, clothier 0
4441951 2182415 2182415 defendant Lucas William   597375 597375 Lucas, William, of Manytre 0
4442674 2182657 2182657 defendant Pollard William   597375 597375 Pollard, William, of Manytre 4
4443036 2182784 2182784 defendant Hardyng John   597375 597375 Hardyng, John, of Manytre 0
4461541 2188689 2188689 defendant Pollard William   597375 597375 Pollard, William, of Manytre 0
4464257 2189485 2189485 defendant Pollard William   597375 597375 Pollard, William, of Manytre 0
4469021 2190982 2190982 defendant Talbot Robert   597375 597375 Talbot, Robert, of Manytre 8
4500593 2200809 2200809 plaintiff Joye John shoemaker 597375 597375 Joye, John, of Manytre, shoemaker 0
4527267 2208807 2208807 defendant Pollard William   597375 597375 Pollard, William, of Manytre 2
4543581 2213884 2213884 defendant Hardyng William   597375 597375 Hardyng, William, of Manytre 1
4549335 2215733 2215733 defendant Mounk John   597375 597375 Mounk, John, of Manytre 4
4552626 2216775 2216775 defendant Monk John   597375 597375 Monk, John, of Manytre 0
4559837 2219028 2219028 plaintiff Monk John   597375 597375 Monk, John, of Manytre 0
4559839 2219029 2219029 plaintiff Monk John   597375 597375 Monk, John, of Manytre 0
4574679 2223608 2223608 defendant Talbot Robert   597375 597375 Talbot, Robert, of Manytre 0
4575554 2223863 2223863 defendant Crall Adam weaver 597375 597375 Crall, Adam, of Manytre, weaver 0
4575555 2223863 2223863 defendant Reynold John fuller 597375 597375 Reynold, John, of manytre, fuller 1
4575556 2223863 2223863 defendant Mynot John   597375 597375 Mynot, John, of Manytre 2
4590904 2228507 2228507 defendant Bakere William   597375 597375 Bakere, William, of Manytre 0
4591993 2228850 2228850 defendant Barkere John   597375 597375 Barkere, John, of Manytre 2
4591994 2228850 2228850 defendant Yeleham John   597375 597375 Yeleham, John, of Manytre 3
4604870 2232694 2232694 defendant Skynnere John   597375 597375 Skynnere, John, of Manytre 2
4619756 2237166 2237166 defendant Joye John   597375 597375 Joye, John, of Manytre 0
4620488 2237388 2237388 defendant Baker Thomas   597375 597375 Baker, Thomas, of Manytre 2
4627309 2239486 2239486 defendant Reynold John   597375 597375 Reynold, John, of Manytre 0
4632337 2241001 2241001 defendant Joye John   597375 597375 Joye, John, of Manytre 1
4640094 2243220 2243220 plaintiff Dawe Margaret   597375 597375 Dawe, Margaret, of Manytre 0
4652333 2246681 2246681 plaintiff Aylewy William   597375 597375 Aylewy, William, of Manytre 0
4652334 2246681 2246681 plaintiff Essex John   597375 597375 Essex, John, of Manytre 1
4652618 2246776 2246776 plaintiff Baldewyne John   597375 597375 Baldewyne, John, of Manytre 0
4667799 2255635 2255635 plaintiff Aylewy William   597375 597375 Aylewy, William, of Manytre 0
4678769 2258964 2258964 plaintiff Hunte Thomas   597375 597375 Hunte, Thomas, of Manytre 0
4678774 2258965 2258965 plaintiff Hunte Thomas   597375 597375 Hunte, Thomas, of Manytre 0
4679282 2259130 2259130 plaintiff Joye John   597375 597375 Joye, John, of Manytre 0
4679284 2259131 2259131 plaintiff Joye John   597375 597375 Joye, John, of Manytre 0
4680721 2259587 2259587 defendant Joye John husbandman 597375 597375 Joye, John, of Manytre, husbandman 0
4705657 2267144 2267144 defendant Ekkeford Thomas yeoman 597375 597375 Ekkeford, Thomas, of Manytre, yeoman 0
4705658 2267144 2267144 defendant Joye John, sen yeoman 597375 597375 Joye, John, sen, of Manytre, yeoman 1
4723486 2272653 2272653 defendant Waryn John husbandman 597375 597375 Waryn, John, of Manytre, husbandman 1
4734582 2275980 2275980 defendant Jakys Henry husbandman 597375 597375 Jakys, Henry, of Manytre, husbandman 0
4770724 2286823 2286823 defendant Joye John husbandman 597375 597375 Joye, John, of Manytre, husbandman 1
4795674 2294800 2294800 defendant Barker John husbandman 597375 597375 Barker, John, of Manytre, husbandman 0
4829406 2305237 2305237 defendant Leche Thomas clerk 597375 597375 Leche, Thomas, of Manytre, clerk 0
4832306 2306135 2306135 defendant Neve Richard husbandman 597375 597375 Neve, Richard, of Manytre, husbandman 0
4835747 2307178 2307178 defendant Mows John husbandman 597375 597375 Mows, John, of Manytre, husbandman 0
4835748 2307178 2307178 defendant Barker John husbandman 597375 597375 Barker, John, of Manytre, husbandman 1
4835749 2307178 2307178 defendant Polle John (legal representative) 597375 597375 Polle, John, of manytre, executors of 2
4835750 2307178 2307178 defendant Mors William husbandman 597375 597375 (Mors, William, of Manytre, husbandman 3
4837583 2307687 2307687 defendant Hardyng William yeoman 597375 597375 Hardyng, William, of Manytre, yeoman 0
4847041 2310578 2310578 defendant Barker John husbandman 597375 597375 Barker, John, of Manytre, husbandman 1
4852089 2312085 2312085 defendant Hereward William waterman 597375 597375 Hereward, William, of Manytre, waterman 1
4852091 2312085 2312085 defendant Pollard John fuller 597375 597375 Pollard, John, of Manytre, fuller 3
4856267 2313332 2313332 plaintiff Barkere John   597375 597375 Barkere, John, of Manytre 0
4856268 2313332 2313332 defendant Pollard John fuller 597375 597375 Pollard, John, of Manytre, fuller 0
4859347 2314305 2314305 defendant Neve Richard husbandman 597375 597375 Neve, Richard, of Manytre, husbandman 0
4861142 2314843 2314843 defendant Debenham John merchant 597375 597375 Debenham, John, of Manytre, merchant 0
4874764 2319050 2319050 defendant Barker John husbandman 597375 597375 Barker, John, of Manytre, husbandman 0
4874766 2319051 2319051 defendant Debenham John draper 597375 597375 Debenham, John, of Manytre, draper 0
4879157 2320420 2320420 defendant Debenham John chapman 597375 597375 Debenham, John, of Manytre, chapman 0
4967593 2347249 2347249 defendant Holwode John   597375 597375 Holwode, John, of Manytre, wright 0
4967848 2347328 2347328 defendant Boylond John shipman 597375 597375 Boylond, John, of Manytre, shipman 0
4994589 2355242 2355242 defendant Gla_ John dyer 597375 597375 Gla_, John, of Manytre, dyer 0
4994590 2355242 2355242 defendant Goldyngton Thomas hosier 597375 597375 Goldyngton, Thomas, of Manytre, hosier 1
5000956 2357160 2357160 defendant Debynham John yeoman 597375 597375 Debynham, John, of Manytre, yeoman 0
5013005 2360636 2360636 defendant Sonday John chaplain 597375 597375 Sonday, John, of Manytre, chaplain 2
5018975 2362442 2362442 defendant Glaufeld John dyer 597375 597375 Glaufeld, John, of Manytre, dyer 0
5028998 2365350 2365350 defendant Wengham John barber 597375 597375 Wengham, John, of Manytre, barber 0
5034540 2366960 2366960 plaintiff Story Ralph   597375 597375 Story Ralph, of Manytre 0
5054638 2372964 2372964 defendant Chalys William butcher 597375 597375 Chalys, William, of Manytre, butcher 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);