names

229 rows where place_id = 588575

✎ 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
3594970 1866056 1866056 defendant Dyer William butcher 588575 588575 Dyer, William, of Goutherst, butcher 1
3595343 1866175 1866175 defendant Lymden John fuller 588575 588575 Lymden, John, of Goutherst, fuller 1
3595346 1866176 1866176 defendant Lymden John fuller 588575 588575 Lymden, John, of Goutherst, fuller 1
3595351 1866178 1866178 defendant Lymden Henry clothmaker 588575 588575 Lymden, Henry, of Goutherst, clothmaker 0
3595354 1866179 1866179 defendant Lymden Henry clothmaker 588575 588575 Lymden, Henry, of Goutherst, clothmaker 0
3595442 1866208 1866208 defendant Vynceherst John   588575 588575 Vynceherst, John, of Goutherst, cartwright 0
3596127 1866417 1866417 defendant Knyght John laborer 588575 588575 Knyght, John, of Goutherst, laborer 0
3596361 1866495 1866495 defendant Robert Richard husbandman 588575 588575 Robert, Richard, of Goutherst, husbandman 0
3615593 1872516 1872516 defendant Roberd Stephen tanner 588575 588575 Roberd, Stephen, of Goutherst, tanner 1
3615991 1872637 1872637 defendant Courthop Henry smith 588575 588575 Courthop, Henry, of Goutherst, smith 0
3615992 1872637 1872637 defendant Sare Thomas ripper 588575 588575 Sare, Thomas, of Goutherst, ripper 1
3615993 1872637 1872637 defendant Meryham Stephen wheeler 588575 588575 Meryham, Stephen, of Goutherst, wheeler 2
3615994 1872637 1872637 defendant Patynden Henry clothier 588575 588575 Patynden, Henry, of Goutherst, clothier 3
3618105 1873285 1873285 defendant Burgeys John chapman 588575 588575 Burgeys, John, of Goutherst, chapman 2
3620919 1874105 1874105 defendant Whatman James   588575 588575 Whatman, James, of Goutherst, "rypyer" 0
3622666 1874619 1874619 defendant Love or Lone Stephen draper 588575 588575 Love or Lone, Stephen, of Goutherst, draper 0
3622825 1874671 1874671 defendant Benchekyn George smith 588575 588575 Benchekyn, George, of Goutherst, smith 0
3622832 1874672 1874672 defendant Bratell John cutler 588575 588575 Bratell, John, of Goutherst, cutler 1
3623683 1874939 1874939 defendant Smyth Margaret widow 588575 588575 (Smyth, Margaret, of Goutherst, widow 1
3623684 1874939 1874939 defendant atte Well alias Wellys Henry yeoman 588575 588575 atte Well alias Wellys, Henry, of Goutherst, yeoman 2
3623685 1874939 1874939 defendant Averey William smith 588575 588575 Averey, William, of Goutherst, smith 3
3628983 1903941 1903941 defendant Pekham John laborer 588575 588575 Pekham, John, of Goutherst, laborer 0
3648105 1909801 1909801 defendant Sherpe William yeoman 588575 588575 Sherpe, William, of Goutherst, yeoman 0
3649489 1910229 1910229 defendant Rod Edward   588575 588575 Rod, Edward, of Goutherst, scythe smith 0
3653076 1911291 1911291 defendant Browne William husbandman 588575 588575 Browne, William, of Goutherst, husbandman 1
3655607 1912015 1912015 defendant Bratyll John cutler 588575 588575 Bratyll, John, of Goutherst, cutler 0
3680128 1919854 1919854 defendant Cumden Thomas husbandman 588575 588575 Cumden, Thomas, of Goutherst, husbandman 0
3686298 1921870 1921870 defendant Comden William chapman 588575 588575 Comden, William, of Goutherst, chapman 0
3692665 1923895 1923895 defendant Roberth Walter husbandman 588575 588575 Roberth, Walter, of Goutherst, husbandman 0
3694172 1924383 1924383 defendant Rede Richard yeoman 588575 588575 Rede, Richard, of Goutherst, yeoman 0
3695001 1924647 1924647 defendant Jeffray Morgan clothmaker 588575 588575 Jeffray, Morgan, of Goutherst, clothmaker 1
3697741 1925515 1925515 plaintiff Thorngate Thomas joiner 588575 588575 Thorngate, Thomas, of Goutherst, joiner 0
3700609 1926437 1926437 defendant Mugge Richard yeoman 588575 588575 Mugge, Richard, of Goutherst, yeoman 0
3702008 1926883 1926883 defendant Moreley Lawrence yeoman 588575 588575 Moreley, Lawrence, of Goutherst, yeoman 1
3703465 1927356 1927356 defendant Morley Lawrence yeoman 588575 588575 Morley, Lawrence, of Goutherst, yeoman 0
3706195 1928225 1928225 plaintiff Horsmonden Richard clothmaker 588575 588575 Horsmonden, Richard, of Goutherst, clothmaker 0
3708989 1929105 1929105 defendant Jefferey Morgan clothmaker 588575 588575 Jefferey, Morgan, of Goutherst, clothmaker 0
3709520 1929283 1929283 defendant Armestrong George yeoman 588575 588575 Armestrong, George, of Goutherst, yeoman 0
3709788 1929376 1929376 defendant Roberde Stephen yeoman 588575 588575 Roberde, Stephen, of Goutherst, yeoman 1
3709789 1929376 1929376 defendant Pykenden Thomas yeoman 588575 588575 Pykenden, Thomas, of Goutherst, yeoman 2
3714247 1930753 1930753 defendant Mugge Richard yeoman 588575 588575 Mugge, Richard, of Goutherst, yeoman 0
3714248 1930753 1930753 defendant Fowkes Thomas husbandman 588575 588575 Fowkes, Thomas, of Goutherst, husbandman 1
3717054 1931620 1931620 plaintiff Culpeper Alexander esq 588575 588575 Culpeper, Alexander, of Goutherst, esq 0
3740311 1938834 1938834 defendant Burre John husbandman 588575 588575 Burre, John, of Goutherst, husbandman 0
3740312 1938834 1938834 defendant Rogger Stephen weaver 588575 588575 Rogger, Stephen, of Goutherst, weaver 1
3744642 1940217 1940217 defendant Mugge Richard yeoman 588575 588575 Mugge, Richard,of Goutherst, yeoman 0
3744643 1940217 1940217 defendant Fowkes Thomas husbandman 588575 588575 Fowkes, Thomas, of Goutherst, husbandman 1
3795521 1956480 1956480 plaintiff Culpepir Alexander esq 588575 588575 Culpepir, Alexander, of Goutherst, esq 0
3828824 1966893 1966893 defendant Ellyott Richard yeoman 588575 588575 Ellyott, Richard, of Goutherst, yeoman 0
3834145 1968621 1968621 defendant tate Andrew tanner 588575 588575 tate, Andrew, of Goutherst, tanner 3
3834149 1968622 1968622 defendant Tate Andrew tanner 588575 588575 Tate, Andrew, of Goutherst, tanner 2
3844588 1971846 1971846 defendant Tate Andrew tanner 588575 588575 Tate, Andrew, of Goutherst, tanner 0
3863194 1977894 1977894 plaintiff Horsmonden John, senior (legal representative) 588575 588575 Horsmonden, John, senior, of Goutherst, yeoman, executor of 0
4232185 2106761 2106761 defendant Combden John yeoman 588575 588575 Combden, John, of Goutherst, yeoman 0
4232186 2106761 2106761 defendant Combden William husbandman 588575 588575 Combden, William, of Goutherst, husbandman 1
4316428 2135863 2135863 defendant Patynden Henry yeoman 588575 588575 Patynden, Henry, of Goutherst, yeoman 0
4467003 2190349 2190349 defendant Bereworth John tanner 588575 588575 Bereworth, John, of Goutherst, tanner 0
4494524 2198979 2198979 defendant Stonden William   588575 588575 Stonden, William, of Goutherst 0
4539783 2212704 2212704 defendant Culverman Richard   588575 588575 Culverman, Richard, of Goutherst 0
4539787 2212705 2212705 defendant Culverman Richard   588575 588575 Culverman, Richard, of Goutherst 2
4540126 2212814 2212814 plaintiff Waterman Robert   588575 588575 Waterman, Robert, of Goutherst 0
4540127 2212814 2212814 defendant Hegham Hamond   588575 588575 Hegham, Hamond, of Goutherst 0
4568778 2221819 2221819 plaintiff Walter Robert   588575 588575 Walter, Robert, of Goutherst 0
4569172 2221949 2221949 defendant Vynsherst John   588575 588575 Vynsherst, John, of Goutherst 0
4618801 2236878 2236878 defendant Hekkere Robert   588575 588575 Hekkere, Robert, of Goutherst 4
4618803 2236878 2236878 defendant Ive Roger   588575 588575 Ive, Roger, of Goutherst 6
4653127 2246915 2246915 defendant Walter Robert yeoman 588575 588575 Walter, Robert, of Goutherst, yeoman 0
4653128 2246915 2246915 defendant Swyft Maurice laborer 588575 588575 Swyft, Maurice, of Goutherst, laborer 1
4653131 2246916 2246916 defendant Walter Robert yeoman 588575 588575 Walter, Robert, of Goutherst, yeoman 0
4653132 2246916 2246916 defendant Wychynden Thomas laborer 588575 588575 Wychynden, Thomas, of Goutherst, laborer 1
4677239 2258498 2258498 defendant Pykynden Robert wheeler 588575 588575 Pykynden, Robert, of Goutherst, wheeler 3
4740715 2277803 2277803 defendant Lyfford John rypier 588575 588575 Lyfford, John, of Goutherst, rypier 0
4747151 2279671 2279671 defendant Bereworth John yeoman 588575 588575 Bereworth, John, of Goutherst, yeoman 3
4778086 2289134 2289134 defendant Holbeme John ripier or fishmonger 588575 588575 Holbeme, John, of Goutherst, ripier or fishmonger 0
4778088 2289135 2289135 defendant Northbery Thomas ripier or fishmonger 588575 588575 Northbery, Thomas, of Goutherst, ripier or fishmonger 0
4778090 2289136 2289136 defendant Holbeme John ripier or fishmonger 588575 588575 Holbeme, John, of Goutherst, ripier or fishmonger 0
4778092 2289137 2289137 defendant Northbery Thomas rypier or fishmonger 588575 588575 Northbery, Thomas, of Goutherst, rypier or fishmonger 0
4778225 2289173 2289173 defendant Ropere John   588575 588575 Ropere, John, of Goutherst, ripiere or fishmonger 1
4778226 2289173 2289173 defendant Ropere William laborer 588575 588575 Ropere, William, of Goutherst, laborer 2
4779427 2289548 2289548 plaintiff Bourne Stephen   588575 588575 Bourne, Stephen, of Goutherst 0
4779428 2289548 2289548 defendant Halpeny John butcher 588575 588575 Halpeny, John, of Goutherst, butcher 0
4779506 2289569 2289569 defendant Halpeny John butcher 588575 588575 Halpeny, John, of Goutherst, butcher 0
4789181 2292672 2292672 plaintiff Hoo Thomas   588575 588575 Hoo, Thomas, of Goutherst 0
4789182 2292672 2292672 defendant Meryham William   588575 588575 Meryham, William, of Goutherst, "cartemaker" or card maker 0
4796224 2294968 2294968 defendant Clerk Thomas   588575 588575 Clerk, Thomas, of Goutherst, cook 1
4796804 2295151 2295151 defendant Ropere John laborer 588575 588575 Ropere, John, of Goutherst, laborer 0
4797578 2295413 2295413 defendant Overey John smith 588575 588575 Overey, John, of Goutherst, smith 0
4804076 2297461 2297461 defendant Cryps John husbandman 588575 588575 Cryps, John, of Goutherst, husbandman 0
4805538 2297946 2297946 defendant Harry John weaver 588575 588575 Harry, John, of Goutherst, weaver 0
4814671 2300702 2300702 defendant Sander Robert husbandman 588575 588575 Sander, Robert, of Goutherst, husbandman 0
4822162 2303009 2303009 defendant Bulvynch Stephen laborer 588575 588575 Bulvynch, Stephen, of Goutherst, laborer 0
4855645 2313135 2313135 defendant Burgeys Richard wheeler 588575 588575 Burgeys, Richard, of Goutherst, wheeler 0
4861388 2314931 2314931 defendant Holbeme John rypyer or fishmonger 588575 588575 Holbeme, John, of Goutherst, rypyer or fishmonger 0
4861817 2315072 2315072 defendant atte Wode Simon butcher 588575 588575 atte Wode, Simon, of Goutherst, butcher 0
4861819 2315073 2315073 plaintiff Culpeper Walter esq 588575 588575 (Culpeper, Walter, of Goutherst, esq 1
4861824 2315074 2315074 plaintiff Culpeper Walter esq 588575 588575 (Culpeper, Walter, of Goutherst, esq 1
4866094 2316368 2316368 defendant Horsmonden Stephen husbandman 588575 588575 Horsmonden, Stephen, of Goutherst, husbandman 0
4869307 2317368 2317368 plaintiff Kynott Richard   588575 588575 Kynott, Richard, of Goutherst 0
4869308 2317368 2317368 defendant Heygham William Roger 588575 588575 Heygham, William, of Goutherst, husbandman, son of Heygham, Roger 0
4880418 2320785 2320785 plaintiff Wayte Thomas draper 588575 588575 Wayte, Thomas, of Goutherst, draper 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);