names

106 rows where place_id = 596931

✎ 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
3626674 1903188 1903188 defendant Cosyn Robert fuller 596931 596931 Cosyn, Robert, of Newbery, fuller 2
3626675 1903188 1903188 defendant Baron Thomas shoemaker 596931 596931 Baron, Thomas, of Newbery, shoemaker 3
3633655 1905336 1905336 defendant Twyt John mercer and chandler 596931 596931 Twyt, John, of Newbery, mercer and chandler 0
3637146 1906417 1906417 defendant Seman John fuller 596931 596931 Seman, John, of Newbery, fuller 0
3637392 1906502 1906502 defendant Sadeler Robert butcher 596931 596931 Sadeler, Robert, of Newbery, butcher 2
3648020 1909783 1909783 defendant Leyfeld John dyer 596931 596931 Leyfeld, John, of Newbery, dyer 0
3648021 1909783 1909783 defendant Hall Thomas dyer 596931 596931 Hall, Thomas, of Newbery, dyer 1
3648022 1909783 1909783 defendant Sadyll Robert yeoman 596931 596931 Sadyll, Robert, of Newbery, yeoman 2
3648023 1909783 1909783 defendant Forty Robert yeoman 596931 596931 Forty, Robert, of Newbery, yeoman 3
3650948 1910666 1910666 defendant Bedford William gent 596931 596931 Bedford, William, of Newbery, gent 4
3682406 1920598 1920598 defendant Coke Richard weaver 596931 596931 Coke, Richard, of Newbery, weaver 0
3685736 1921696 1921696 defendant Repon Thomas clothman 596931 596931 Repon, Thomas, of Newbery, clothman 2
3686832 1922040 1922040 defendant Medwey John weaver 596931 596931 Medwey, John, of Newbery, weaver 2
3688497 1922559 1922559 defendant Rypon Thomas fuller 596931 596931 Rypon, Thomas, of Newbery, fuller 0
3699360 1926019 1926019 defendant Hoke Nicholas shoemaker 596931 596931 Hoke, Nicholas, of Newbery, shoemaker 0
3701167 1926612 1926612 defendant Bemet William (legal representative) 596931 596931 Bemet, William, of Newbery, mercer, executors of 1
3703992 1927533 1927533 defendant Leycetur Thomas yeoman 596931 596931 Leycetur, Thomas, of Newbery, yeoman 0
3711688 1929967 1929967 defendant Waterton Robert butcher 596931 596931 Waterton, Robert, of Newbery, butcher 0
3713836 1930627 1930627 defendant Medewey Luke clothier 596931 596931 Medewey, Luke, of Newbery, clothier 0
3714509 1930834 1930834 defendant Kyllyng William clothier 596931 596931 Kyllyng, William, of Newbery, clothier 1
3739210 1938482 1938482 defendant Mayer Nicholas yeoman 596931 596931 Mayer, Nicholas, of Newbery, yeoman 0
3744602 1940207 1940207 defendant Galcyan John shoemaker 596931 596931 Galcyan, John, of Newbery, shoemaker 0
3745462 1940487 1940487 defendant Chyld Christopher fuller 596931 596931 Chyld, Christopher, of Newbery, fuller 0
3751782 1942478 1942478 defendant Mayer Nicholas yeoman 596931 596931 Mayer, Nicholas, of Newbery, yeoman 0
3754598 1943397 1943397 defendant Kyen Henry butcher 596931 596931 Kyen, Henry, of Newbery, butcher 0
3754599 1943397 1943397 defendant Webbe Henry butcher 596931 596931 Webbe, Henry, of Newbery, butcher 1
3755735 1943755 1943755 defendant Elys John yeoman 596931 596931 Elys, John, of Newbery, yeoman 0
3758682 1944709 1944709 defendant Chyld Christopher fuller 596931 596931 Chyld, Christopher, of Newbery, fuller 0
3791480 1955172 1955172 defendant Robynson John fuller 596931 596931 Robynson, John, of Newbery, fuller 0
3804462 1959336 1959336 defendant Warterton Thomas butcher 596931 596931 Warterton, Thomas, of Newbery, butcher 1
3804463 1959336 1959336 defendant Seman John mercer 596931 596931 Seman, John, of Newbery, mercer 2
3809585 1960884 1960884 defendant Maye Robert fuller 596931 596931 Maye, Robert, of Newbery, fuller 0
3814725 1962518 1962518 defendant Waterton Thomas butcher 596931 596931 Waterton, Thomas, of Newbery, butcher 0
3820747 1964378 1964378 defendant Smyth Richard mercer 596931 596931 Smyth, Richard, of Newbery, mercer 0
3830291 1967367 1967367 defendant Freman John dyer 596931 596931 Freman, John, of Newbery, dyer 0
3833563 1968430 1968430 defendant Soper Christopher fuller 596931 596931 Soper, Christopher, of Newbery, fuller 0
3836348 1969275 1969275 defendant Freman John dyer 596931 596931 Freman, John, of Newbery, dyer 0
3839915 1970419 1970419 plaintiff Wynchecombe John clothier 596931 596931 Wynchecombe, John, of Newbery, clothier 0
3848343 1973058 1973058 defendant Phyllypp Henry butcher 596931 596931 Phyllypp, Henry, of Newbery, butcher 0
3856515 1975665 1975665 plaintiff Wydnam John clothman 596931 596931 Wydnam, John, of Newbery, clothman 0
3858969 1976493 1976493 plaintiff Burgeys Henry esq 596931 596931 Burgeys, Henry, of Newbery, esq 0
3859944 1976828 1976828 defendant Tytynge Robert fuller 596931 596931 Tytynge, Robert, of Newbery, fuller 0
3862916 1977793 1977793 defendant Chamer John butcher 596931 596931 Chamer, John, of Newbery, butcher 0
3863208 1977898 1977898 defendant Chamer John butcher 596931 596931 Chamer, John, of Newbery, butcher 0
3873044 1981199 1981199 defendant Palmer Richard mercer 596931 596931 Palmer, Richard, of Newbery, mercer 0
3877019 1982555 1982555 plaintiff Helyar William clothman 596931 596931 Helyar, William, of Newbery, clothman 0
3878141 1982938 1982938 defendant Waterton Thmoas butcher 596931 596931 Waterton, Thmoas, of Newbery, butcher 1
3882998 1984578 1984578 defendant Broke Thomas chapman 596931 596931 Broke, Thomas, of Newbery, chapman 3
3883488 1984747 1984747 defendant Parkyns alias Myller Thomas miller 596931 596931 Parkyns alias Myller, Thomas, of Newbery, miller 0
3910505 1993831 1993831 defendant Arnold Thomas weaver 596931 596931 Arnold, Thomas, of Newbery, weaver 0
3912183 1994402 1994402 plaintiff Wynchecombe John, senior   596931 596931 Wynchecombe, John, senior, of Newbery 0
3912390 1994475 1994475 defendant Clerke Henry yeoman 596931 596931 Clerke, Henry, of Newbery, yeoman 0
3922576 1997866 1997866 defendant Colman Nicholas dyer 596931 596931 Colman, Nicholas, of Newbery, dyer 0
3925907 1998980 1998980 defendant Meston William husbandman 596931 596931 Meston, William, of Newbery, husbandman 0
3952809 2008054 2008054 defendant Edwardes John carpenter 596931 596931 Edwardes, John, of Newbery, carpenter 0
3972866 2015083 2015083 plaintiff Godfather Elias yeoman 596931 596931 Godfather, Elias, of Newbery, yeoman 0
3973237 2015213 2015213 plaintiff Grene John yeoman 596931 596931 Grene, John, of Newbery, yeoman 0
3976596 2016389 2016389 defendant Chamberlyn Brian clothier 596931 596931 Chamberlyn, Brian, of Newbery, clothier 0
3978144 2016934 2016934 defendant Norton John haberdasher 596931 596931 Norton, John, of Newbery, haberdasher 0
3986674 2019974 2019974 defendant Shuffe or Shusse Maurice miller 596931 596931 Shuffe or Shusse, Maurice, of Newbery, miller 0
4001311 2025247 2025247 defendant Hynde Giles glover 596931 596931 Hynde, Giles, of Newbery, glover 1
4031618 2035971 2035971 defendant Hynde Giles glover 596931 596931 Hynde, Giles, of Newbery, glover 1
4031622 2035972 2035972 defendant Hinde Giles glover 596931 596931 Hinde, Giles, of Newbery, glover 1
4064693 2047660 2047660 defendant Bote John clothier 596931 596931 Bote, John, of Newbery, clothier 1
4064694 2047660 2047660 defendant Goodgame Richard clothier 596931 596931 Goodgame, Richard, of Newbery, clothier 2
4092299 2057545 2057545 defendant Reason William brewer 596931 596931 Reason, William, of Newbery, brewer 2
4102391 2061147 2061147 defendant Chamberlayne Robert yeoman 596931 596931 Chamberlayne, Robert, of Newbery, yeoman 0
4102393 2061148 2061148 defendant Chamberleyne Robert yeoman 596931 596931 Chamberleyne, Robert, of Newbery, yeoman 0
4107567 2062994 2062994 defendant Upton Thomas butcher 596931 596931 Upton, Thomas, of Newbery, butcher 1
4107569 2062994 2062994 defendant Champe John sawyer 596931 596931 Champe, John, of Newbery, sawyer 3
4107572 2062994 2062994 defendant Knappe Richard sawyer 596931 596931 Knappe, Richard, of Newbery, sawyer 6
4123578 2068734 2068734 defendant Atwell John innholder 596931 596931 Atwell, John, of Newbery, innholder 1
4124279 2068975 2068975 defendant Bennett Lawrence fuller 596931 596931 Bennett, Lawrence, of Newbery, fuller 1
4132171 2071818 2071818 defendant Barker Anthony gent 596931 596931 Barker, Anthony, of Newbery, gent 1
4132175 2071820 2071820 defendant Harrys William fishmonger 596931 596931 Harrys, William, of Newbery, fishmonger 0
4132176 2071820 2071820 defendant Boxall John barber 596931 596931 Boxall, John, of Newbery, ,barber 1
4134584 2072701 2072701 defendant Rippon John yeoman 596931 596931 Rippon, John, of Newbery, yeoman 1
4154227 2079574 2079574 defendant Pryce Edward shoemaker 596931 596931 Pryce, Edward, of Newbery, shoemaker 0
4159153 2081270 2081270 defendant Knappe Richard sawyer 596931 596931 Knappe, Richard, of Newbery, sawyer 5
4162217 2082342 2082342 defendant Kynton Richard shoemaker 596931 596931 Kynton, Richard, of Newbery, shoemaker 0
4162219 2082342 2082342 defendant Clace John yeoman 596931 596931 Clace, John, of Newbery, yeoman 2
4162636 2082492 2082492 defendant Hynde Henry mercer 596931 596931 Hynde, Henry, of Newbery, mercer 2
4203140 2096647 2096647 defendant Cooke Robert grocer 596931 596931 Cooke, Robert, of Newbery, grocer 0
4210044 2099075 2099075 defendant Apprice Edward shoemaker 596931 596931 Apprice, Edward, of Newbery, shoemaker 0
4210045 2099075 2099075 defendant Skynner Robert blacksmith 596931 596931 Skynner, Robert, of Newbery, blacksmith 1
4210046 2099075 2099075 defendant Wilkenson Griffin chandler 596931 596931 Wilkenson, Griffin, of Newbery, chandler 2
4302164 2130876 2130876 defendant Harrys William vintner 596931 596931 Harrys, William, of Newbery, vintner 0
4307026 2132598 2132598 defendant Underwood John vintner 596931 596931 Underwood, John, of Newbery, vintner 0
4307027 2132598 2132598 defendant Hynde John vintner 596931 596931 Hynde, John, of Newbery, vintner 1
4342630 2144695 2144695 defendant Lynche Henry sherman 596931 596931 Lynche, Henry, of Newbery, sherman 3
4385550 2159852 2159852 defendant Packer Thomas mercer 596931 596931 Packer, Thomas, of Newbery, mercer 0
4392762 2162197 2162197 defendant Wyllyams Richard clothier 596931 596931 Wyllyams, Richard, of Newbery, or of Bristol, clothier 1
4394198 2162660 2162660 defendant Floide Rice gent 596931 596931 Floide, Rice, of Newbery, gent 3
4398506 2164079 2164079 defendant Phillipps John mercer 596931 596931 Phillipps, John, of Newbery, mercer 1
4401028 2164934 2164934 defendant Gough Thomas drover 596931 596931 Gough, Thomas, of Newbery, drover 0
4797319 2295333 2295333 defendant Townesende John   596931 596931 Townesende, John, of Newbery, parchment maker 0
4870024 2317590 2317590 defendant Clerk alias Smyth Thomas smith 596931 596931 Clerk alias Smyth, Thomas, of Newbery, smith 0
4870784 2317842 2317842 defendant Fryth Robert hosier 596931 596931 Fryth, Robert, of Newbery, hosier 1
5226261 2423345 2423345 defendant Chyllond Roger fuller 596931 596931 Chyllond, Roger, of Newbery, fuller 0
5226264 2423346 2423346 defendant Chyllond Roger fuller 596931 596931 Chyllond, Roger, of Newbery, fuller 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);