names

306 rows where place_id = 588643

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595138 1866110 1866110 defendant Levet or Lenet William fuller 588643 588643 Levet or Lenet, William, of Walden, Essex, fuller 3
3604758 1869153 1869153 plaintiff Harvy John (legal representative) 588643 588643 Harvy, John, of Walden, Essex, mercer, executor of 0
3608128 1870193 1870193 defendant Barker William yeoman 588643 588643 Barker, William, of Walden, Essex, yeoman 0
3616841 1872897 1872897 defendant Wragge John husbandman 588643 588643 Wragge, John, of Walden, Essex, husbandman 0
3621126 1874162 1874162 defendant Birde John yeoman 588643 588643 Birde, John, of Walden, Essex, yeoman 9
3621813 1874360 1874360 defendant Lambert Thomas mercer 588643 588643 Lambert, Thomas, of Walden, Essex, mercer 0
3640391 1907426 1907426 plaintiff Adam Nicholas   588643 588643 Adam, Nicholas, of Walden, Essex, grocer, administrators of 0
3643989 1908552 1908552 defendant Everard Thomas butcher 588643 588643 Everard, Thomas, of Walden, Essex, butcher 2
3648906 1910046 1910046 defendant White John   588643 588643 White, John, of Walden, Essex, tallow chandler 1
3661037 1913726 1913726 defendant Dawson John chapman 588643 588643 Dawson, John, of Walden, Essex, chapman 3
3661042 1913727 1913727 defendant Dawson John chapman 588643 588643 Dawson, John, of Walden, Essex, chapman 3
3662947 1914325 1914325 plaintiff Nicoll John draper 588643 588643 Nicoll, John, of Walden, Essex, draper 0
3679848 1919762 1919762 defendant Boyton Thomas chapman 588643 588643 Boyton, Thomas, of Walden, Essex, chapman 2
3679853 1919763 1919763 defendant Deyton Thomas chapman 588643 588643 Deyton, Thomas, of Walden, Essex, chapman 2
3683662 1921021 1921021 defendant Wykham John barber 588643 588643 Wykham, John, of Walden, Essex, barber 0
3722992 1933456 1933456 plaintiff Nicolle John draper 588643 588643 Nicolle, John, of Walden, Essex, draper 0
3744220 1940089 1940089 defendant Abrey Thomas fishmonger 588643 588643 (Abrey, Thomas, of Walden, Essex, fishmonger 1
3745698 1940563 1940563 plaintiff Byrd William mercer 588643 588643 Byrd, William, of Walden, Essex, mercer 0
3752263 1942629 1942629 defendant Boyton Thomas chapman 588643 588643 Boyton, Thomas, of Walden, Essex, chapman 2
3755297 1943612 1943612 defendant Yewe Richard yeoman 588643 588643 Yewe, Richard, of Walden, Essex, yeoman, Fisk, Nicholas, of Est Derham, Norf, yeoman 1
3756455 1943991 1943991 defendant Avrey or Aurey Thomas fishmonger 588643 588643 Avrey or Aurey, Thomas, of Walden, Essex, fishmonger 2
3758653 1944702 1944702 plaintiff Byrde Thomas mercer 588643 588643 Byrde, Thomas, of Walden, Essex, mercer 0
3771592 1948814 1948814 defendant Gryswell Richard mercer 588643 588643 Gryswell, Richard, of Walden, Essex, mercer 0
3776697 1950461 1950461 plaintiff Byrd Thomas mercer 588643 588643 Byrd, Thomas, of Walden, Essex, mercer 0
3793359 1955784 1955784 defendant Grosswell Richard chapman 588643 588643 Grosswell, Richard, of Walden, Essex, chapman 3
3793826 1955934 1955934 defendant Smyth Thomas yeoman 588643 588643 Smyth, Thomas, of Walden, Essex, yeoman 0
3795282 1956391 1956391 defendant Willihamson James yeoman 588643 588643 Willihamson, James, of Walden, Essex, yeoman 0
3799545 1957779 1957779 defendant Hessewell Richard yeoman 588643 588643 Hessewell, Richard, of Walden, Essex, yeoman 0
3812343 1961751 1961751 defendant Wicam John barber or surgeon 588643 588643 Wicam, John, of Walden, Essex, barber or surgeon 1
3815743 1962843 1962843 defendant Esywell alias Hessewell Richard mercer 588643 588643 Esywell alias Hessewell, Richard, of Walden, Essex, mercer 0
3818241 1963620 1963620 defendant Wykham John barber surgeon 588643 588643 Wykham, John, of Walden, essex, barber surgeon 1
3819996 1964135 1964135 defendant Boneer Thomas   588643 588643 Boneer, Thomas, of Walden, Essex, organ maker 0
3822720 1965007 1965007 defendant Balle John glover 588643 588643 Balle, John, of Walden, Essex, glover 3
3822943 1965083 1965083 defendant Ben John yeoman of the crown 588643 588643 Ben, John, of Walden, Essex, yeoman of the crown 0
3828448 1966771 1966771 defendant Smyth Thomas (legal representative) 588643 588643 Smyth, Thomas, of Walden, Essex, yeoman, administratrix of 0
3830222 1967345 1967345 defendant Danbery John yeoman 588643 588643 Danbery, John, of Walden, Essex, yeoman 0
3832209 1967985 1967985 defendant Reymond Anthony chapman 588643 588643 Reymond, Anthony, of Walden, Essex, chapman 1
3837600 1969669 1969669 plaintiff Spruce John   588643 588643 Spruce, John, of Walden, Essex 0
3838996 1970124 1970124 defendant Sernte Richard yeoman 588643 588643 Sernte, Richard, of Walden, Essex, yeoman 1
3847087 1972640 1972640 defendant Danbury John yeoman 588643 588643 Danbury, John, of Walden, Essex, yeoman 0
3849882 1973549 1973549 defendant Wykham John barber 588643 588643 Wykham, John, of Walden, Essex, barber 1
3849886 1973550 1973550 defendant Wykham John barber 588643 588643 Wykham, John, of Walden, Essex, barber 1
3849953 1973572 1973572 defendant Vawdy James gent 588643 588643 Vawdy, James, of Walden, Essex, gent 0
3850880 1973869 1973869 defendant Vandy or Vaudy James gent 588643 588643 Vandy or Vaudy, James, of Walden, Essex, gent 0
3859507 1976669 1976669 defendant Smyth Thomas (legal representative) 588643 588643 Smyth, Thomas, of Walden, Essex, yeoman, administratrix of 0
3859508 1976669 1976669 defendant Smyth Ellen widow 588643 588643 Smyth, Ellen, of Walden, Essex, widow 1
3865942 1978839 1978839 defendant Reymond Anthony haberdasher 588643 588643 Reymond, Anthony, of Walden, Essex, haberdasher 0
3867356 1979315 1979315 defendant Batman John chapman 588643 588643 Batman, John, of Walden, Essex, chapman 1
3867362 1979316 1979316 defendant Batman John chapman 588643 588643 Batman, John, of Walden, Essex, chapman 1
3873711 1981424 1981424 defendant Wyllyamson James husbandman 588643 588643 Wyllyamson, James, of Walden, Essex, husbandman 0
3881288 1984009 1984009 defendant Raymond Anthony chapman 588643 588643 Raymond, Anthony, of Walden, Essex, chapman 3
3883127 1984618 1984618 defendant Wyllyamson James husbandman 588643 588643 Wyllyamson, James, of Walden, Essex, husbandman 0
3884930 1985229 1985229 defendant Makerell Clement haberdasher 588643 588643 Makerell, Clement, of Walden, Essex, haberdasher 0
3888180 1986301 1986301 defendant Robson John yeoman 588643 588643 Robson, John, of Walden, Essex, yeoman 1
3902689 1991131 1991131 defendant Brampton John baker 588643 588643 Brampton, John, of Walden, Essex, baker 0
3907024 1992637 1992637 defendant Danbery John butcher 588643 588643 Danbery, John, of Walden, Essex, butcher 0
3908652 1993188 1993188 defendant Lomkyn John   588643 588643 Lomkyn, John, of Walden, Essex 2
3910114 1993691 1993691 defendant Robson John gent 588643 588643 Robson, John, of Walden, Essex, gent 0
3911585 1994194 1994194 defendant Robson John   588643 588643 Robson, John, of Walden, Essex 0
3911904 1994305 1994305 defendant Wyllyamson James gent 588643 588643 Wyllyamson, James, of Walden, Essex, gent 0
3914517 1995199 1995199 defendant Lawe Thomas grocer 588643 588643 Lawe, Thomas, of Walden, Essex, grocer 0
3915512 1995557 1995557 defendant Boyton Thomas yeoman 588643 588643 Boyton, Thomas, of Walden, essex, yeoman 0
3921674 1997592 1997592 defendant Lawe John chapman 588643 588643 Lawe, John, of Walden, Essex, chapman 5
3925267 1998762 1998762 defendant Danbury John yeoman 588643 588643 Danbury, John, of Walden, Essex, yeoman 0
3938162 2003102 2003102 plaintiff Pomfret Katherine widow 588643 588643 Pomfret, Katherine, of Walden, Essex, widow 0
3956794 2009445 2009445 defendant Waters William yeoman or maltster 588643 588643 Waters, William, of Walden, Essex, yeoman or maltster 0
3959745 2010499 2010499 plaintiff Smyth William   588643 588643 Smyth, William, of Walden, Essex 0
3961054 2010959 2010959 defendant Pratt Roger chapman 588643 588643 Pratt, Roger, of Walden, Essex, chapman 2
3972454 2014943 2014943 defendant Turner John chapman 588643 588643 Turner, John, of Walden, Essex, linen draper, chapman 0
3975238 2015906 2015906 defendant Ewsewall Thomas chapman 588643 588643 Ewsewall, Thomas, of Walden, Essex, chapman 0
3975240 2015907 2015907 defendant Ewsewell Thomas chapman 588643 588643 Ewsewell, Thomas, of Walden, Essex, chapman 0
3982071 2018346 2018346 defendant Malyn William innholder 588643 588643 Malyn, William, of Walden, Essex, innholder 0
3982073 2018347 2018347 defendant Malyn William innholder 588643 588643 Malyn, William, of Walden, Essex, innholder 0
3994042 2022618 2022618 plaintiff Clarke Thomas maltster 588643 588643 Clarke, Thomas, of Walden, Essex, maltster 0
4000657 2025008 2025008 defendant Lecheworthe James yeoman 588643 588643 Lecheworthe, James, of Walden, Essex, yeoman 1
4016470 2030595 2030595 plaintiff Strachy William draper 588643 588643 Strachy, William, of Walden, Essex, draper 0
4021695 2032485 2032485 plaintiff Adam William draper 588643 588643 Adam, William, of Walden, Essex, draper 0
4021698 2032486 2032486 plaintiff Adam William draper 588643 588643 Adam, William, of Walden, Essex, draper 0
4021701 2032487 2032487 plaintiff Adam William draper 588643 588643 Adam, William, of Walden, Essex, draper 0
4021703 2032488 2032488 plaintiff Adam William draper 588643 588643 Adam, William, of Walden, Essex, draper 0
4021705 2032489 2032489 plaintiff Adam William draper 588643 588643 Adam, William, of Walden, Essex, draper 0
4021707 2032490 2032490 plaintiff Adam William draper 588643 588643 Adam, William, of Walden, Essex, draper 0
4035435 2037342 2037342 defendant Jon John chapman 588643 588643 Jon, John, of Walden, Essex, chapman 0
4036833 2037856 2037856 plaintiff Jackson John, junior maltster 588643 588643 Jackson, John, junior, of Walden, Essex, maltster 0
4037658 2038119 2038119 defendant Freman William yeoman 588643 588643 Freman, William, of Walden, Essex, yeoman 1
4038437 2038385 2038385 defendant Seriche Francis yeoman 588643 588643 Seriche, Francis, of Walden, Essex, yeoman 1
4040612 2039138 2039138 defendant Pumfrett George yeoman 588643 588643 Pumfrett, George, of Walden, Essex, yeoman 0
4040617 2039140 2039140 defendant Pumfrett George yeoman 588643 588643 Pumfrett, George, of Walden, Essex, yeoman 0
4044327 2040426 2040426 defendant Rayment Giles (legal representative) 588643 588643 Rayment, Giles, of Walden, Essex, haberdasher, administratrix of 3
4047750 2041645 2041645 plaintiff Strachy William draper 588643 588643 Strachy, William, of Walden, Essex, draper 0
4065287 2047867 2047867 defendant Swallowe Thomas husbandman 588643 588643 Swallowe, Thomas, of Walden, Essex, husbandman 0
4077854 2052378 2052378 defendant Sparke William carpenter 588643 588643 Sparke, William, of Walden, Essex, carpenter 0
4077885 2052391 2052391 plaintiff Strachye William draper 588643 588643 Strachye, William, of Walden, Essex, draper 0
4077887 2052392 2052392 plaintiff Strachye William draper 588643 588643 Strachye, William, of Walden, Essex, draper 0
4118628 2066955 2066955 defendant Owen Edward tailor 588643 588643 Owen, Edward, of Walden, Essex, tailor 0
4139553 2074507 2074507 defendant Stewarde Henry pedder 588643 588643 Stewarde, Henry, of Walden, Essex, yeoman, pedder 2
4156573 2080374 2080374 defendant Rande Mathew beer brewer 588643 588643 Rande, Mathew, of Walden, Essex, beer brewer 0
4191757 2092674 2092674 defendant Sorbye Jonas singleman 588643 588643 Sorbye, Jonas, of Walden, Essex, gent, singleman 0
4260569 2116502 2116502 defendant Clarke Thomas yeoman 588643 588643 Clarke, Thomas, of Walden, Essex, yeoman 0
4260572 2116503 2116503 defendant Clarke Thomas yeoman 588643 588643 Clarke, Thomas, of Walden, Essex, yeoman 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);