names

45 rows where place_id = 613773

✎ 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
3700215 1926301 1926301 plaintiff Atkyns David draper 613773 613773 Atkyns, David, of Chepstowe, draper 0
3761465 1945598 1945598 defendant Bollande Roger tailor 613773 613773 Bollande, Roger, of Chepstowe, tailor 3
3779120 1951193 1951193 plaintiff du Peryor Christopher merchant 613773 613773 du Peryor, Christopher, of Chepstowe, merchant 0
3813369 1962095 1962095 plaintiff Duperiour Christopher merchant 613773 613773 Duperiour, Christopher, of Chepstowe, merchant 0
3886753 1985827 1985827 defendant Clyfford Thomas shoemaker 613773 613773 Clyfford, Thomas, of Chepstowe, shoemaker 0
3907652 1992848 1992848 defendant Heggys William yeoman 613773 613773 Heggys, William, of Chepstowe, yeoman 0
3912672 1994571 1994571 defendant Bere Humphrey merchant 613773 613773 Bere, Humphrey, of Chepstowe, merchant 1
3914603 1995227 1995227 defendant Beere Humphrey innholder 613773 613773 Beere, Humphrey, of Chepstowe, innholder 2
3914604 1995227 1995227 defendant Vorth John, senior   613773 613773 Vorth, John, senior, of Chepstowe 3
3914605 1995227 1995227 defendant Hopkyn Roger yeoman 613773 613773 Hopkyn, Roger, of Chepstowe, yeoman 4
3955911 2009135 2009135 defendant Lloyd Thomas yeoman 613773 613773 Lloyd, Thomas, of Chepstowe, yeoman 4
3957569 2009710 2009710 defendant Kyngett Robert yeoman 613773 613773 Kyngett, Robert, of Chepstowe, yeoman 0
3957578 2009711 2009711 defendant Barnes Alan yeoman 613773 613773 Barnes, Alan, of Chepstowe, yeoman 3
3959851 2010537 2010537 defendant Lloyde Thomas yeoman 613773 613773 Lloyde, Thomas, of Chepstowe, yeoman 0
3960040 2010609 2010609 defendant Stone Peter laborer 613773 613773 Stone, Peter, of Chepstowe, laborer 1
3977432 2016678 2016678 defendant Herbert Lewis gent 613773 613773 Herbert, Lewis, of Chepstowe, gent 0
4007768 2027563 2027563 plaintiff Mathew Thomas Watkin   613773 613773 Mathew, Thomas Watkin, of Chepstowe 0
4014865 2030031 2030031 defendant Marten Miles cooper 613773 613773 Marten, Miles, of Chepstowe, cooper 2
4015710 2030316 2030316 plaintiff Somersett Thomas esq 613773 613773 Somersett, Thomas, of Chepstowe, or of Ragarstone Graunde, Monmouth, esq 0
4038954 2038553 2038553 defendant Wylcocke William yeoman 613773 613773 Wylcocke, William, of Chepstowe, yeoman 0
4038955 2038553 2038553 defendant Barnes Alan yeoman 613773 613773 Barnes, Alan, of Chepstowe, yeoman 1
4046259 2041102 2041102 defendant Thomas alias Customer Watkins yeoman 613773 613773 Thomas alias Customer, Watkins, of Chepstowe, yeoman 0
4046260 2041102 2041102 defendant Aldaye Roger yeoman 613773 613773 Aldaye, Roger, of Chepstowe, yeoman 1
4046885 2041339 2041339 defendant Strobrydge Richard merchant 613773 613773 Strobrydge, Richard, of Chepstowe, merchant 0
4052857 2043457 2043457 defendant Rosser John yeoman 613773 613773 Rosser, John, of Chepstowe, yeoman 0
4059938 2045950 2045950 plaintiff Crane Richard merchant 613773 613773 Crane, Richard, of Chepstowe, merchant 0
4073929 2050968 2050968 defendant Badam William yeoman 613773 613773 Badam, William, of Chepstowe, yeoman 0
4074299 2051108 2051108 plaintiff Pynner William butcher 613773 613773 Pynner, William, of Chepstowe, butcher 0
4080322 2053272 2053272 defendant Reynold Thomas shoemaker 613773 613773 Reynold, Thomas, of Chepstowe, shoemaker 0
4104804 2061994 2061994 defendant Taylor John yeoman 613773 613773 Taylor, John, of Chepstowe, yeoman 0
4109775 2063755 2063755 defendant Badam William husbandman 613773 613773 Badam, William, of Chepstowe, husbandman 0
4124859 2069182 2069182 defendant Rynalde Thomas   613773 613773 Rynalde, Thomas, of Chepstowe, "cosyer" 1
4130345 2071162 2071162 defendant Walter Richard chapman 613773 613773 Walter, Richard, of Chepstowe, chapman 2
4215919 2101065 2101065 defendant Parker Walter yeoman 613773 613773 Parker, Walter, of Chepstowe, yeoman 0
4218194 2101865 2101865 defendant Herbert Lewis gent 613773 613773 Herbert, Lewis, of Chepstowe, gent 0
4223124 2103577 2103577 defendant Charity alias Pynner William butcher 613773 613773 Charity alias Pynner, William, of Chepstowe, butcher 0
4223144 2103583 2103583 defendant Lewes Thomas gent 613773 613773 Lewes, Thomas, of Chepstowe, gent 0
4275680 2121440 2121440 defendant Jeyne Alice widow 613773 613773 Jeyne, Alice, of Chepstowe, widow 0
4283308 2124069 2124069 defendant Herbert Lewis gent 613773 613773 Herbert, Lewis, of Chepstowe, gent 0
4369087 2154010 2154010 defendant Evans Thomas yeoman 613773 613773 Evans, Thomas, of Chepstowe, yeoman 0
4369837 2154266 2154266 defendant Walter Howell cordwainer 613773 613773 Walter, Howell, of Chepstowe, cordwainer 3
4380346 2158076 2158076 defendant Parker Walter boatman 613773 613773 Parker, Walter, of Chepstowe, boatman 0
4813435 2300314 2300314 plaintiff Chynam John merchant 613773 613773 Chynam, John, of Chepstowe, merchant 1
5410883 2478207 2478207 defendant Legh Thomas   613773 613773 Legh, Thomas, of Chepstowe, franklin 0
5410884 2478207 2478207 defendant Legh (illegible) yeoman 613773 613773 Legh, _, of Chepstowe, yeoman 1

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