names

147 rows where place_id = 595870

✎ 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
3622192 1874476 1874476 defendant Aunsell William husbandman 595870 595870 Aunsell, William, of Mersham, husbandman 0
3622837 1874673 1874673 defendant Gille John (legal representative) 595870 595870 Gille, John, of Mersham, husbandman, executrix of 0
3623371 1874840 1874840 defendant Lucas Nicholas merchant 595870 595870 Lucas, Nicholas, of Mersham, merchant 0
3623374 1874841 1874841 defendant Lucas Nicholas merchant 595870 595870 Lucas, Nicholas, of Mersham, merchant 1
3650281 1910464 1910464 defendant Andrewes John smith 595870 595870 Andrewes, John, of Mersham, smith 1
3703873 1927490 1927490 defendant Rooke Thomas husbandman or merchant 595870 595870 Rooke, Thomas, of Mersham, husbandman or merchant 0
3719136 1932268 1932268 defendant Wevyll Thomas husbandman 595870 595870 Wevyll, Thomas, of Mersham, husbandman 0
3734967 1937172 1937172 defendant Webyll or Wevyll Thomas husbandman 595870 595870 Webyll or Wevyll, Thomas, of Mersham, husbandman 0
3775876 1950207 1950207 defendant Best Richard, junior yeoman 595870 595870 Best, Richard, junior, of Mersham, yeoman 3
3793518 1955837 1955837 defendant Selsey John husbandman 595870 595870 Selsey, John, of Mersham, husbandman 0
3793519 1955837 1955837 defendant Myller Edward husbandman 595870 595870 Myller, Edward, of Mersham, husbandman 1
3814240 1962361 1962361 defendant Halle Willam husbandman 595870 595870 Halle, Willam, of Mersham, husbandman 1
3815018 1962618 1962618 defendant Hyll Thomas tanner 595870 595870 Hyll, Thomas, of Mersham, tanner 0
3825149 1965731 1965731 defendant Barletott Thomas tailor 595870 595870 Barletott, Thomas, of Mersham, tailor 0
3856291 1975585 1975585 defendant Bulwerd John   595870 595870 Bulwerd, John, of Mersham, worsted weaver 3
3875029 1981875 1981875 defendant Sely John yeoman 595870 595870 Sely, John, of Mersham, yeoman 0
3876889 1982511 1982511 defendant Smyth William husbandman 595870 595870 Smyth, William, of Mersham, husbandman 4
3884198 1984981 1984981 defendant Wylcoke Robert husbandman 595870 595870 Wylcoke, Robert, of Mersham, husbandman 0
3899597 1990084 1990084 defendant Halke Nicholas husbandman 595870 595870 Halke, Nicholas, of Mersham, husbandman 2
3908579 1993168 1993168 defendant Dygenson John butcher 595870 595870 Dygenson, John, of Mersham, butcher 0
3946787 2005946 2005946 defendant Grygby Margaret widow 595870 595870 Grygby, Margaret, of Mersham, widow 1
3972950 2015113 2015113 defendant Pledger John husbandman 595870 595870 Pledger, John, of Mersham, husbandman 0
3996400 2023468 2023468 defendant Auncell Robert tailor 595870 595870 Auncell, Robert, of Mersham, tailor 0
4013353 2029508 2029508 defendant Smythe Michael yeoman 595870 595870 Smythe, Michael, of Mersham, yeoman 1
4025389 2033739 2033739 defendant Smythe Michael (legal representative) 595870 595870 Smythe, Michael, of Mersham, yeoman, administratrix of 0
4025390 2033739 2033739 defendant Smythe Margery widow 595870 595870 Smythe, Margery, of Mersham, widow 1
4083740 2054457 2054457 defendant Manawaye John (legal representative) 595870 595870 Manawaye, John, of Mersham, butcher, executrix of 0
4083741 2054457 2054457 defendant Manawaye Anne widow 595870 595870 Manawaye, Anne, of Mersham, widow 1
4233720 2107315 2107315 defendant Bellinge William yeoman 595870 595870 Bellinge, William, of Mersham, yeoman 1
4324269 2138516 2138516 defendant Watt John husbandman 595870 595870 Watt, John, of Mersham, husbandman 0
4402452 2165407 2165407 defendant Barrowe John yeoman 595870 595870 Barrowe, John, of Mersham, yeoman 1
4402453 2165407 2165407 defendant Ducker or Duker John tanner 595870 595870 Ducker or Duker, John, of Mersham, tanner 2
4435256 2175785 2175785 defendant atte Holde Henry   595870 595870 atte Holde, Henry, of Mersham 0
4452689 2185851 2185851 defendant Dene John   595870 595870 Dene, John, of Mersham 0
4456273 2186983 2186983 plaintiff Neylond Thomas   595870 595870 Neylond, Thomas, of Mersham, parson 0
4509703 2203517 2203517 defendant Curteys Thomas   595870 595870 together with Curteys, Thomas, of Mersham 1
4513305 2204577 2204577 plaintiff Brode John   595870 595870 Brode, John, of Mersham 0
4541804 2213326 2213326 defendant Harald John   595870 595870 Harald, John, of Mersham 1
4546613 2214866 2214866 plaintiff Brode (illegible)   595870 595870 Brode, _, of Mersham 0
4550759 2216177 2216177 defendant Brode John   595870 595870 Brode, John, of Mersham 3
4577366 2224435 2224435 defendant Adam John   595870 595870 Adam, John, of Mersham 1
4656828 2248031 2248031 defendant Benyngton John chaplain 595870 595870 Benyngton, John, of Mersham, chaplain 3
4668224 2255774 2255774 defendant Hammyngherst John husbandman 595870 595870 Hammyngherst, John, of Mersham, husbandman 0
4668225 2255774 2255774 defendant Hammyngherst Thomas laborer 595870 595870 Hammyngherst, Thomas, of Mersham, laborer 1
4669158 2256060 2256060 defendant atte Hill Robert husbandman 595870 595870 atte Hill, Robert, of Mersham, husbandman 6
4673031 2257209 2257209 defendant atte Hoke Roger smith 595870 595870 atte Hoke, Roger, of Mersham, smith 0
4673032 2257209 2257209 defendant atte Hoke William yeoman & son of Roger 595870 595870 atte Hoke, William, of Mersham, yeoman & son of Roger 1
4693374 2263430 2263430 defendant Hammyngherst John husbandman 595870 595870 Hammyngherst, John, of Mersham, husbandman 0
4713640 2269589 2269589 defendant Couherd Thomas barber 595870 595870 Couherd, Thomas, of Mersham, barber 0
4730794 2274832 2274832 defendant Aleyn Wilalim husbandman 595870 595870 Aleyn, Wilalim, of Mersham, husbandman 3
4734442 2275941 2275941 defendant Breketappe John laborer 595870 595870 Breketappe, John, of Mersham, laborer 0
4752733 2281256 2281256 defendant Miles William carter 595870 595870 Miles, William, of Mersham, carter 0
4754150 2281679 2281679 defendant atte Holde William husbandman 595870 595870 atte Holde, William, of Mersham, husbandman 0
4754151 2281679 2281679 defendant atte Hoke Roger husbandman 595870 595870 atte Hoke, Roger, of Mersham, husbandman 1
4762005 2284100 2284100 defendant Braunche John husbandman 595870 595870 Braunche, John, of Mersham, husbandman 1
4763973 2284725 2284725 plaintiff Hammyngherst John husbandman 595870 595870 Hammyngherst, John, of Mersham, husbandman 0
4770854 2286864 2286864 plaintiff Jolyf Thomas   595870 595870 Jolyf, Thomas, of Mersham 1
4770855 2286864 2286864 defendant Hammyngherst John husbandman 595870 595870 Hammyngherst, John, of Mersham, husbandman 0
4785241 2291402 2291402 defendant Hikke John husbandman 595870 595870 Hikke, John, of Mersham, husbandman 0
4785242 2291402 2291402 defendant Hikke Thomas laborer 595870 595870 Hikke, Thomas, of Mersham, laborer 1
4786138 2291703 2291703 defendant Hamyngherst John husbandman 595870 595870 Hamyngherst, John, of Mersham, husbandman 1
4787693 2292221 2292221 defendant Rogger Nicholas yeoman 595870 595870 Rogger, Nicholas, of Mersham, yeoman 0
4787696 2292221 2292221 defendant Fox William laborer 595870 595870 Fox, William, of Mersham, laborer 3
4787697 2292221 2292221 defendant Geffrey William laborer 595870 595870 Geffrey, William, of Mersham, laborer 4
4790096 2292978 2292978 defendant Hammyngherst John husbandman 595870 595870 Hammyngherst, John, of Mersham, husbandman 0
4827949 2304796 2304796 defendant Stokke John butcher 595870 595870 Stokke, John, of Mersham, butcher 0
4827951 2304796 2304796 defendant Colyere John laborer 595870 595870 Colyere, John, of Mersham, laborer 2
4839513 2308282 2308282 defendant Colyn Walter yeoman 595870 595870 Colyn, Walter, of Mersham, yeoman 2
4847190 2310619 2310619 defendant Kent John husbandman 595870 595870 Kent, John, of Mersham, husbandman 2
4866295 2316426 2316426 defendant Barry Thomas gent 595870 595870 Barry, Thomas, of Mersham, gent 0
4873566 2318678 2318678 defendant Founteyn Eleanor widow 595870 595870 (Founteyn, Eleanor, of Mersham, widow 5
4879318 2320463 2320463 defendant Sandre Thomas husbandman 595870 595870 Sandre, Thomas, of Mersham, husbandman 0
4882130 2321313 2321313 plaintiff Aleyn John   595870 595870 Aleyn, John, of Mersham 0
4892637 2324425 2324425 plaintiff Colyer John, senior   595870 595870 Colyer, John, senior, of Mersham 0
4896916 2325686 2325686 defendant Hikke John husbandman 595870 595870 Hikke, John, of Mersham, husbandman 3
4896917 2325686 2325686 defendant Stokke John butcher 595870 595870 Stokke, John, of Mersham, butcher 4
4896921 2325687 2325687 defendant Hikke John husbandman 595870 595870 Hikke, John, of Mersham, husbandman 2
4896922 2325687 2325687 defendant Stokke John butcher 595870 595870 Stokke, John, of Mersham, butcher 3
4897030 2325724 2325724 defendant Clerk Thomas smith 595870 595870 Clerk, Thomas, of Mersham, smith 1
4900233 2326701 2326701 defendant Fonteyn Eleanor widow 595870 595870 Fonteyn, Eleanor, of Mersham, widow 1
4907013 2328769 2328769 defendant Mellere John carpenter 595870 595870 Mellere, John, of Mersham, carpenter 0
4908739 2329281 2329281 defendant Asshere John laborer 595870 595870 Asshere, John, of Mersham, laborer 0
4908741 2329282 2329282 defendant Elshert John laborer 595870 595870 Elshert, John, of Mersham, laborer 0
4925464 2334398 2334398 defendant Brood John gent 595870 595870 Brood, John, of Mersham, gent 0
4925466 2334399 2334399 defendant Brood John gent 595870 595870 Brood, John, of Mersham, gent 0
4925468 2334400 2334400 defendant Brood John gent 595870 595870 Brood, John, of Mersham, gent 0
4928575 2335367 2335367 defendant Lougbregge alias Souter Stephen butcher 595870 595870 Lougbregge alias Souter, Stephen, of Mersham, butcher 0
4950797 2342221 2342221 defendant Brood John gent 595870 595870 Brood, John, of Mersham, gent 0
4960765 2345181 2345181 defendant Hoke William husbandman 595870 595870 Hoke, William, of Mersham, husbandman 0
4986374 2352852 2352852 defendant Stokke John husbandman 595870 595870 Stokke, John, of Mersham, husbandman 0
5006166 2358692 2358692 defendant Fontayn Stephen smith 595870 595870 Fontayn, Stephen, of Mersham, smith 0
5006167 2358692 2358692 defendant Braunche John yeoman 595870 595870 Braunche, John, of Mersham, yeoman 1
5025570 2364383 2364383 defendant Kenet William laborer 595870 595870 Kenet, William, of Mersham, laborer 4
5045305 2370222 2370222 defendant Stok John husbandman 595870 595870 with Stok, John, of Mersham, husbandman 1
5063476 2375603 2375603 plaintiff Fox William   595870 595870 (Fox, William, of Mersham 1
5063478 2375603 2375603 defendant Auncell Nicholas husbandman 595870 595870 Auncell, Nicholas, of Mersham, husbandman 0
5075489 2379164 2379164 defendant Grydle John husbandman 595870 595870 Grydle, John, of Mersham, husbandman 0
5087568 2382745 2382745 plaintiff Fox William   595870 595870 (Fox, William, of Mersham 1
5087570 2382745 2382745 defendant Auncell Nicholas drover 595870 595870 Auncell, Nicholas, of Mersham, drover 0
5088189 2382918 2382918 defendant Hoke Simon porter 595870 595870 Hoke, Simon, of Mersham, porter 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);