names

240 rows where place_id = 589928

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599298 1867424 1867424 defendant Panter Thomas miller 589928 589928 Panter, Thomas, of Mendham, miller 0
3603067 1868626 1868626 defendant Warde Richard husbandman 589928 589928 Warde, Richard, of Mendham, husbandman 0
3605912 1869511 1869511 defendant Gandy John husbandman 589928 589928 Gandy, John, of Mendham, husbandman 0
3642229 1908017 1908017 defendant Bonett William laborer 589928 589928 Bonett, William, of Mendham, laborer 2
3643766 1908479 1908479 defendant Sparke Edmund butcher 589928 589928 Sparke, Edmund, of Mendham, butcher 0
3658466 1912899 1912899 defendant Wevton John husbandman 589928 589928 Wevton, John, of Mendham, husbandman 1
3659799 1913318 1913318 defendant Stuntley John husbandman 589928 589928 Stuntley, John, of Mendham, husbandman 0
3680245 1919893 1919893 defendant Fereby William husbandman 589928 589928 Fereby, William, of Mendham, husbandman 0
3683403 1920931 1920931 defendant Weston Geoffrey yeoman 589928 589928 Weston, Geoffrey, of Mendham, yeoman 0
3704642 1927738 1927738 defendant Wyche Thomas yeoman 589928 589928 Wyche, Thomas, of Mendham, yeoman 0
3708906 1929077 1929077 defendant Dooke Adam laborer 589928 589928 Dooke, Adam, of Mendham, laborer 0
3738162 1938149 1938149 defendant Grene Nicholas yeoman 589928 589928 Grene, Nicholas, of Mendham, yeoman 1
3751843 1942494 1942494 defendant Whyte John clerk 589928 589928 Whyte, John, of Mendham, clerk 0
3773136 1949302 1949302 defendant Chamber John yeoman 589928 589928 Chamber, John, of Mendham, yeoman 0
3783682 1952658 1952658 defendant Godfrey Robert mercer 589928 589928 Godfrey, Robert, of Mendham, mercer 0
3790830 1954959 1954959 defendant Cooke William yeoman 589928 589928 Cooke, William, of Mendham, yeoman 0
3801134 1958274 1958274 defendant Grene Nicholas yeoman 589928 589928 Grene, Nicholas, of Mendham, yeoman 2
3813173 1962032 1962032 plaintiff Dogett Edmund (legal representative) 589928 589928 Dogett, Edmund, of Mendham, executors of 0
3814888 1962572 1962572 defendant Chamber John yeoman 589928 589928 Chamber, John, of Mendham, yeoman 0
3846562 1972481 1972481 defendant Ryall Robert smith 589928 589928 Ryall, Robert, of Mendham, smith 0
3852670 1974442 1974442 defendant Goodfrey Robert mercer 589928 589928 Goodfrey, Robert, of Mendham, mercer 0
3899893 1990179 1990179 defendant Grave William clerk 589928 589928 Grave, William, of Mendham, clerk 0
3919493 1996851 1996851 plaintiff Lawson Roland yeoman 589928 589928 Lawson, Roland, of Mendham, yeoman 0
3922181 1997729 1997729 defendant Weche Thomas gent 589928 589928 Weche, Thomas, of Mendham, gent 0
3922187 1997730 1997730 defendant Weche Thomas gent 589928 589928 Weche, Thomas, of Mendham, gent 0
3923592 1998199 1998199 defendant Doggett Robert butcher 589928 589928 Doggett, Robert, of Mendham, butcher 0
3927223 1999441 1999441 defendant Aleyne John laborer 589928 589928 Aleyne, John, of Mendham, laborer 0
3927224 1999441 1999441 defendant Smyth Leonard joiner 589928 589928 Smyth, Leonard, of Mendham, joiner 1
3933099 2001363 2001363 defendant Dryver George knacker 589928 589928 Dryver, George, of Mendham, knacker 1
3937889 2003006 2003006 defendant Rochester William yeoman 589928 589928 Rochester, William, of Mendham, yeoman 0
3937890 2003006 2003006 defendant Hopwood John laborer 589928 589928 Hopwood, John, of Mendham, laborer 1
3937893 2003006 2003006 defendant Legett John yeoman 589928 589928 Legett, John, of Mendham, yeoman 4
3942366 2004461 2004461 plaintiff Whytenham William butcher 589928 589928 Whytenham, William, of Mendham, butcher 0
3951285 2007516 2007516 defendant Freston Richard (legal representative) 589928 589928 Freston, Richard, of Mendham, knight, executors of 0
3963770 2011932 2011932 defendant Bowne Michael singlewoman 589928 589928 Bowne, Michael, of Mendham, spinster, singlewoman 0
3965212 2012445 2012445 defendant Gyrlynge Thomas tailor 589928 589928 Gyrlynge, Thomas, of Mendham, tailor 0
3968258 2013526 2013526 defendant Sossam or Soffam Nicholas (legal representative) 589928 589928 Sossam or Soffam, Nicholas, of Mendham, husbandman, executor of 0
3973663 2015361 2015361 defendant Payne William yeoman 589928 589928 Payne, William, of Mendham, yeoman 0
4024512 2033443 2033443 plaintiff Blobold John   589928 589928 Blobold, John, of Mendham 0
4047018 2041383 2041383 defendant Skete Bartholomew butcher 589928 589928 Skete, Bartholomew, of Mendham, butcher 0
4055852 2044476 2044476 defendant Eton or Heyton James yeoman 589928 589928 Eton or Heyton, James, of Mendham, yeoman 0
4127758 2070219 2070219 defendant Payne John husbandman 589928 589928 Payne, John, of Mendham, husbandman 0
4143213 2075795 2075795 defendant Cutler Edmund smith 589928 589928 Cutler, Edmund, of Mendham, smith 2
4176295 2087187 2087187 defendant Grene Robert yeoman 589928 589928 Grene, Robert, of Mendham, yeoman 0
4178190 2087844 2087844 defendant Milles Thomas yeoman 589928 589928 Milles, Thomas, of Mendham, yeoman 1
4200679 2095796 2095796 defendant Dickerson John plumber 589928 589928 Dickerson, John, of Mendham, plumber 0
4200680 2095796 2095796 defendant Flatman Peter   589928 589928 Flatman, Peter, of Mendham, mason 1
4218445 2101951 2101951 defendant Barbor John tailor 589928 589928 Barbor, John, of Mendham, tailor 3
4221079 2102867 2102867 defendant Smyth Richard gent 589928 589928 Smyth, Richard, of mendham, gent 3
4234441 2107585 2107585 defendant Smyth Richard gent 589928 589928 Smyth, Richard, of Mendham, gent 0
4251251 2113392 2113392 defendant Smyth Richard gent 589928 589928 Smyth, Richard, of Mendham, gent 1
4260119 2116348 2116348 defendant Bankes Samuel husbandman 589928 589928 Bankes, Samuel, of Mendham, husbandman 3
4274528 2121037 2121037 defendant Foxe Nicholas yeoman 589928 589928 Foxe, Nicholas, of Mendham, yeoman 0
4276338 2121668 2121668 defendant Smythe Richard gent 589928 589928 Smythe, Richard, of Mendham, gent 2
4277018 2121895 2121895 defendant Botwright Jeremy butcher 589928 589928 Botwright, Jeremy, of Mendham, butcher 0
4277471 2122043 2122043 defendant Fuller Thomas yeoman 589928 589928 Fuller, Thomas, of Mendham, yeoman 0
4285473 2124852 2124852 defendant Palgrave John yeoman 589928 589928 Palgrave, John, of Mendham, yeoman 0
4285474 2124852 2124852 defendant Palgrave Thomas yeoman 589928 589928 Palgrave, Thomas, of Mendham, yeoman 1
4285476 2124852 2124852 defendant Topelyn John yeoman 589928 589928 Topelyn, John, of Mendham, yeoman 3
4285696 2124934 2124934 defendant Carsye Robert yeoman 589928 589928 Carsye, Robert, of Mendham, yeoman 2
4288733 2126027 2126027 defendant Catlyn Nicholas laborer 589928 589928 Catlyn, Nicholas, of Mendham, laborer 1
4288734 2126027 2126027 defendant Whaylard Philip laborer 589928 589928 Whaylard Philip, of Mendham, laborer 2
4302803 2131100 2131100 defendant Palgrave John yeoman 589928 589928 Palgrave, John, of Mendham, yeoman 0
4318969 2136749 2136749 defendant Harper William cooper 589928 589928 Harper, William, of Mendham, cooper 0
4324109 2138469 2138469 defendant Bonde John yeoman 589928 589928 Bonde, John, of Mendham, yeoman 1
4327447 2139502 2139502 defendant Morrye Richard yeoman 589928 589928 Morrye, Richard, of Mendham, yeoman 0
4327448 2139502 2139502 defendant Bowles Richard yeoman 589928 589928 Bowles, Richard, of Mendham, yeoman 1
4327749 2139607 2139607 defendant Lacye Francis widow 589928 589928 Lacye, Francis, of Mendham, widow 0
4328851 2139961 2139961 defendant Thurston Isaiah yeoman 589928 589928 Thurston, Isaiah, of Mendham, yeoman 1
4332331 2141104 2141104 defendant Foxe Nicholas yeoman 589928 589928 Foxe, Nicholas, of Mendham, yeoman 0
4343604 2145041 2145041 defendant Skete Bartholomew butcher 589928 589928 Skete, Bartholomew, of Mendham, butcher 1
4343606 2145041 2145041 defendant Bootewright Jeremy butcher 589928 589928 Bootewright, Jeremy, of Mendham, butcher 3
4354101 2148660 2148660 defendant Bacon Richard yeoman 589928 589928 Bacon, Richard, of Mendham, yeoman 1
4354102 2148660 2148660 defendant Palle John yeoman 589928 589928 Palle, John, of Mendham, yeoman 2
4367537 2153444 2153444 defendant Harvy Joan widow 589928 589928 Harvy, Joan, of Mendham, widow 1
4386174 2160055 2160055 defendant Father John yeoman 589928 589928 Father, John, of Mendham, yeoman 1
4392510 2162116 2162116 defendant Botwright jeremy butcher 589928 589928 Botwright, jeremy, of Mendham, butcher 3
4400873 2164883 2164883 defendant Camplyn Lawrence miller 589928 589928 Camplyn, Lawrence, of Mendham, miller 2
4465641 2189928 2189928 defendant Austyn John chaplain 589928 589928 Austyn, John, of Mendham, chaplain 0
4465642 2189928 2189928 defendant Austyn Robert   589928 589928 Austyn, Robert, of Mendham 1
4469944 2191266 2191266 defendant Dawys Richard   589928 589928 Dawys, Richard, of Mendham 0
4480578 2194593 2194593 defendant Trotte William   589928 589928 Trotte, William, of Mendham 1
4482330 2195177 2195177 defendant Meller William   589928 589928 Meller, William, of Mendham 0
4499749 2200554 2200554 defendant Cokerell John   589928 589928 Cokerell, John, of Mendham 1
4511717 2204112 2204112 defendant Gaute (illegible)   589928 589928 Gaute, _, of Mendham 3
4555325 2217601 2217601 defendant Ryngers John   589928 589928 Ryngers, John, of Mendham 0
4557999 2218436 2218436 defendant Skut Thomas miller 589928 589928 Skut, Thomas, of Mendham, miller 0
4572754 2223017 2223017 plaintiff atte Wode William   589928 589928 atte Wode, William, of Mendham 0
4575494 2223844 2223844 defendant Strete John   589928 589928 Strete, John, of Mendham 1
4575729 2223919 2223919 defendant Cokerell John   589928 589928 Cokerell, John, of Mendham 0
4581268 2225608 2225608 defendant Scut Thomas   589928 589928 Scut, Thomas, of Mendham 0
4585745 2226965 2226965 defendant Fynch Richard   589928 589928 Fynch, Richard, of mendham 0
4645356 2244714 2244714 defendant Deye William   589928 589928 Deye, William, of Mendham 0
4666261 2250918 2250918 defendant Fynch Richard scalder 589928 589928 Fynch, Richard, of Mendham, scalder 2
4699120 2265189 2265189 defendant Woode William butcher 589928 589928 Woode, William, of Mendham, butcher 1
4718263 2271047 2271047 defendant Aldhous John yeoman 589928 589928 Aldhous, John, of Mendham, yeoman 1
4724168 2272851 2272851 defendant Fynche Thomas husbandman 589928 589928 Fynche, Thomas, of Mendham, husbandman 3
4747135 2279668 2279668 defendant Betele John   589928 589928 Betele, John, of Mendham, prior 0
4747136 2279668 2279668 defendant Wesyngham Richard another monk 589928 589928 Wesyngham, Richard, of Mendham, another monk 1
4747137 2279668 2279668 defendant Bailie John   589928 589928 Bailie, John, of Mendham, formerly prior 2

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