names

139 rows where place_id = 587423

✎ 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
3591370 1864925 1864925 defendant Hoigges William clothmaker 587423 587423 Hoigges, William, of Benenden, clothmaker 3
3597329 1866783 1866783 defendant Hoigge William clothmaker 587423 587423 Hoigge, William, of Benenden, clothmaker 0
3604921 1869205 1869205 defendant Hoigge William clothmaker 587423 587423 Hoigge, William, of Benenden, clothmaker 0
3641902 1907921 1907921 defendant Ramysden John yeoman 587423 587423 Ramysden, John, of Benenden, yeoman 1
3654777 1911752 1911752 defendant Hubberd Willaim clothier 587423 587423 Hubberd, Willaim, of Benenden, clothier 0
3659022 1913084 1913084 defendant Hubberd Willaim fuller 587423 587423 Hubberd, Willaim, of Benenden, fuller 0
3718489 1932060 1932060 defendant Morlyn John yeoman 587423 587423 Morlyn, John, of Benenden, yeoman 1
3903907 1991545 1991545 defendant Leche William butcher 587423 587423 Leche, William, of Benenden, butcher 0
3910413 1993799 1993799 defendant Pykys Robert clothier 587423 587423 Pykys, Robert, of Benenden, clothier 4
3910415 1993800 1993800 defendant Tayller Thomas husbandman 587423 587423 Tayller, Thomas, of Benenden, husbandman 0
3915176 1995434 1995434 defendant Ranysden John clothier 587423 587423 Ranysden, John, of Benenden, clothier 0
3943828 2004951 2004951 defendant Rede John gent 587423 587423 Rede, John, of Benenden, gent 0
3980609 2017828 2017828 defendant Rade John gent 587423 587423 Rade, John, of Benenden, gent 0
3996209 2023394 2023394 defendant Crothole John sherman 587423 587423 Crothole, John, of Benenden, sherman 0
3996210 2023394 2023394 defendant Savedge Henry carpenter 587423 587423 Savedge, Henry, of Benenden, carpenter 1
4006714 2027181 2027181 defendant Ramsden Walter clothier 587423 587423 Ramsden, Walter, of Benenden, clothier 0
4008016 2027630 2027630 defendant Delman Thomas clothier 587423 587423 Delman, Thomas, of Benenden, clothier 0
4021338 2032354 2032354 defendant Leache Thomas yeoman 587423 587423 Leache, Thomas, of Benenden, yeoman 0
4021340 2032355 2032355 defendant Leiche Thomas yeoman 587423 587423 Leiche, Thomas, of Benenden, yeoman 0
4063561 2047255 2047255 defendant Evernden Thomas husbandman 587423 587423 Evernden, Thomas, of Benenden, husbandman 1
4067795 2048795 2048795 defendant Smyth Richard sherman 587423 587423 Smyth, Richard, of Benenden, sherman 0
4067796 2048795 2048795 defendant Furner Walter   587423 587423 Furner, Walter, of Benenden, linen weaver 1
4067797 2048795 2048795 defendant Jull Hugh clothier 587423 587423 Jull, Hugh, of Benenden, clothier 2
4075881 2051677 2051677 defendant Morlen George butcher 587423 587423 Morlen, George, of Benenden, butcher 0
4077603 2052277 2052277 defendant Henley William husbandman 587423 587423 Henley, William, of Benenden, husbandman 2
4088882 2056326 2056326 defendant Ducke John, junior tanner 587423 587423 Ducke, John, junior, of Benenden, tanner 0
4119898 2067407 2067407 defendant Golding Richard tanner 587423 587423 Golding, Richard, of Benenden, tanner 0
4131580 2071612 2071612 defendant Allen Richard husbandman 587423 587423 Allen, Richard, of Benenden, husbandman 0
4142972 2075713 2075713 defendant Goldyng Richard tanner 587423 587423 Goldyng, Richard, of Benenden, tanner 0
4145118 2076453 2076453 defendant Gouldinge Richard yeoman 587423 587423 Gouldinge, Richard, of Benenden, yeoman 1
4149184 2077842 2077842 defendant Dallyngton John, junior butcher 587423 587423 Dallyngton, John, junior, of Benenden, butcher 0
4152124 2078856 2078856 defendant Bygge Richard tanner 587423 587423 Bygge, Richard, of Benenden, tanner 1
4155275 2079938 2079938 defendant Allen Richard husbandman 587423 587423 Allen, Richard, of Benenden, husbandman 0
4165217 2083343 2083343 defendant Ramsden William tailor 587423 587423 Ramsden, William, of Benenden, tailor 0
4174631 2086594 2086594 defendant Saunder Mark clerk 587423 587423 Saunder, Mark, of Benenden, clerk 2
4181828 2089124 2089124 defendant Morleyne George butcher 587423 587423 Morleyne, George, of Benenden, butcher 0
4232276 2106793 2106793 defendant Batcocke James miller 587423 587423 Batcocke, James, of Benenden, miller 1
4235336 2107922 2107922 defendant Reade Thomas husbandman 587423 587423 Reade, Thomas, of Benenden, husbandman 0
4239968 2109615 2109615 defendant Gryggesbye John thatcher 587423 587423 Gryggesbye, John, of Benenden, thatcher 0
4239969 2109615 2109615 defendant Spryngatt Robert husbandman 587423 587423 Spryngatt, Robert, of Benenden, husbandman 1
4285710 2124939 2124939 defendant Fowle Edward husbandman 587423 587423 Fowle, Edward, of Benenden, husbandman 0
4293054 2127579 2127579 defendant Sharpye Stephen weaver 587423 587423 Sharpye, Stephen, of Benenden, yeoman, together with Earle, Peter, of Benenden, weaver 0
4293055 2127579 2127579 defendant Beck William weaver 587423 587423 Beck, William, of Benenden, weaver 1
4293056 2127579 2127579 defendant Haselman Thomas weaver 587423 587423 Haselman, Thomas, of Benenden, weaver 2
4310481 2133820 2133820 defendant Earle Peter weaver 587423 587423 Earle, Peter, of Benenden, weaver 0
4310482 2133820 2133820 defendant Beck William weaver 587423 587423 Beck, William, of Benenden, weaver 1
4310483 2133820 2133820 defendant Sharpye Stephen yeoman 587423 587423 together with Sharpye, Stephen, of Benenden, yeoman 2
4310484 2133820 2133820 defendant Haselman Thomas weaver 587423 587423 Haselman, Thomas, of Benenden, weaver 3
4310486 2133821 2133821 defendant Haselman Thomas weaver 587423 587423 Haselman, Thomas, of Benenden, weaver 0
4310487 2133821 2133821 defendant Sharpye Stephen yeoman 587423 587423 together with Sharpye, Stephen, of Benenden, yeoman 1
4310488 2133821 2133821 defendant Earle Peter weaver 587423 587423 Earle, Peter, of Benenden, weaver 2
4310489 2133821 2133821 defendant Beck William weaver 587423 587423 Beck, William, of Benenden, weaver 3
4317782 2136331 2136331 defendant Morleyn Jervase, senior husbandman 587423 587423 Morleyn, Jervase, senior, of Benenden, husbandman 0
4317783 2136331 2136331 defendant Goram John clothier 587423 587423 Goram, John, of Benenden, clothier 1
4317784 2136331 2136331 defendant Raylor Robert clothier 587423 587423 Raylor, Robert, of Benenden, clothier 2
4317785 2136331 2136331 defendant Morleyn Richard husbandman 587423 587423 Morleyn, Richard, of Benenden, husbandman 3
4322798 2138043 2138043 defendant Pattenden Thomas clothier 587423 587423 Pattenden, Thomas, of Benenden, clothier 0
4322799 2138043 2138043 defendant Rade John yeoman 587423 587423 Rade, John, of Benenden, yeoman 1
4323207 2138177 2138177 defendant Haselman Thomas yeoman 587423 587423 Haselman, Thomas, of Benenden, yeoman 0
4323208 2138177 2138177 defendant Houbberd John tailor 587423 587423 Houbberd, John, of Benenden, tailor 1
4323209 2138177 2138177 defendant Nower Robert   587423 587423 Nower, Robert, of Benenden, broad weaver 2
4324454 2138573 2138573 defendant Earle Peter weaver 587423 587423 Earle, Peter, of Benenden, weaver 0
4324455 2138573 2138573 defendant Beck William weaver 587423 587423 Beck, William, of Benenden, weaver 1
4324456 2138573 2138573 defendant Sharpye Stephen yeoman 587423 587423 together with Sharpye, Stephen, of Benenden, yeoman 2
4324457 2138573 2138573 defendant Haselman Thomas weaver 587423 587423 Haselman, Thomas, of Benenden, weaver 3
4332191 2141061 2141061 defendant Brand James yeoman 587423 587423 Brand, James, of Benenden, yeoman 2
4359339 2150499 2150499 defendant Kynge John yeoman 587423 587423 Kynge, John, of Benenden, yeoman 0
4359954 2150724 2150724 defendant Willard Stephen tailor 587423 587423 Willard, Stephen, of Benenden, tailor 3
4361583 2151306 2151306 defendant Whitman Christopher clothier 587423 587423 Whitman, Christopher, of Benenden, clothier 0
4363632 2152065 2152065 defendant Sharpe Richard yeoman 587423 587423 Sharpe, Richard, of Benenden, yeoman 0
4364311 2152298 2152298 defendant Morlyn Thomas weaver 587423 587423 Morlyn, Thomas, of Benenden, weaver 0
4364313 2152299 2152299 defendant Morlyn Thomas weaver 587423 587423 Morlyn, Thomas, of Benenden, weaver 0
4364861 2152484 2152484 defendant Tomkyn Robert clothier 587423 587423 Tomkyn, Robert, of Benenden, clothier 0
4377168 2156907 2156907 defendant Pattenden Thomas clothier 587423 587423 Pattenden, Thomas, of Benenden, clothier 1
4377328 2156967 2156967 defendant Hopper John laborer 587423 587423 Hopper, John, of Benenden, laborer 1
4380853 2158268 2158268 defendant Bigge Edward yeoman 587423 587423 Bigge, Edward, of Benenden, yeoman 0
4380854 2158268 2158268 defendant Austen William yeoman 587423 587423 Austen, William, of Benenden, yeoman 1
4395378 2163036 2163036 defendant Rade John yeoman 587423 587423 Rade, John, of Benenden, yeoman 0
4517335 2205823 2205823 plaintiff Crotehole John   587423 587423 Crotehole, John, of Benenden 0
4524222 2207910 2207910 defendant Roberd John   587423 587423 Roberd, John, of Benenden 0
4538352 2212283 2212283 defendant Grygge John   587423 587423 Grygge, John, of Benenden 0
4576545 2224175 2224175 defendant Stace John   587423 587423 Stace, John, of Benenden 0
4576548 2224175 2224175 defendant Goldyng Robert   587423 587423 Goldyng, Robert, of Benenden 3
4577357 2224432 2224432 defendant More Thomas   587423 587423 More, Thomas, of Benenden 1
4596688 2230202 2230202 defendant Kenghamme Richard   587423 587423 Kenghamme, Richard, of Benenden 3
4619303 2237031 2237031 defendant Duk Henry   587423 587423 Duk, Henry, of Benenden 0
4636463 2242237 2242237 defendant Lucas Richard   587423 587423 Lucas, Richard, of Benenden 0
4638492 2242798 2242798 defendant Duke Herny   587423 587423 Duke, Herny, of Benenden 2
4646833 2245137 2245137 defendant Gerdelere John   587423 587423 Gerdelere, John, of Benenden 2
4693992 2263627 2263627 defendant Skypper Thomas fuller 587423 587423 Skypper, Thomas, of Benenden, fuller 0
4696670 2264434 2264434 defendant Applyby William husbandman 587423 587423 Applyby, William, of Benenden, husbandman 2
4702227 2266106 2266106 defendant Hoigge Mathew yeoman 587423 587423 Hoigge, Mathew, of Benenden, yeoman 0
4709093 2268211 2268211 defendant Hogge Matthew laborer 587423 587423 Hogge, Matthew, of Benenden, laborer 1
4709399 2268293 2268293 defendant Stace Robert husbandman 587423 587423 Stace, Robert, of Benenden, husbandman 1
4758110 2282911 2282911 defendant Austyn Stephen   587423 587423 Austyn, Stephen, of Benenden 0
4758114 2282912 2282912 defendant Austyn Stephen baker 587423 587423 Austyn, Stephen, of Benenden, baker 0
4759077 2283189 2283189 defendant Appelby William husbandman 587423 587423 Appelby, William, of Benenden, husbandman 0
4768968 2286272 2286272 defendant Grenehelle John clerk 587423 587423 Grenehelle, John, of Benenden, clerk 0
4842881 2309315 2309315 defendant Brynchesley John   587423 587423 Brynchesley, John, of Benenden, wood man 0
4987372 2353173 2353173 defendant Coppe William butcher 587423 587423 Coppe, William, of Benenden, 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);