names

45 rows where place_id = 600869

✎ 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
3642901 1908230 1908230 defendant Baker Roger merchant 600869 600869 Baker, Roger, of Tawnton, merchant 0
3687793 1922346 1922346 defendant Collns Richard merchant 600869 600869 Collns, Richard, of Tawnton, merchant 3
3701664 1926762 1926762 defendant Shomaker Lewis cordwainer 600869 600869 Shomaker, Lewis, of Tawnton, cordwainer 0
3716132 1931335 1931335 defendant Vaughan Thomas chapman 600869 600869 Vaughan, Thomas, of Tawnton, chapman 0
3731601 1936111 1936111 plaintiff Chapelyn William, senior merchant 600869 600869 Chapelyn, William, senior, of Tawnton, merchant 0
3736150 1937548 1937548 defendant Hyll alias Barbour Thomas barber 600869 600869 Hyll alias Barbour, Thomas, of Tawnton, barber 0
3740452 1938871 1938871 defendant Baker Roger merchant 600869 600869 Baker, Roger, of Tawnton, merchant 1
3740459 1938873 1938873 defendant Rowsewell William husbandman 600869 600869 Rowsewell, William, of Tawnton, husbandman 0
3742784 1939599 1939599 defendant Huett Joan widow 600869 600869 Huett, Joan, of Tawnton, widow 1
3782614 1952303 1952303 defendant Hyll Robert yeoman 600869 600869 Hyll, Robert, of Tawnton, yeoman 0
3782615 1952303 1952303 defendant Sydenham William gent 600869 600869 Sydenham, William, of Tawnton, gent 1
3782616 1952303 1952303 defendant Femell Richard goldsmith 600869 600869 Femell, Richard, of Tawnton, goldsmith 2
3782617 1952303 1952303 defendant Roper Joan widow 600869 600869 Roper, Joan, of Tawnton, widow 3
3790036 1954705 1954705 defendant Hayes Cornelius tucker 600869 600869 (Hayes, Cornelius, of Tawnton, tucker 1
3854813 1975149 1975149 defendant Muggeley Thomas fishmonger 600869 600869 Muggeley, Thomas, of Tawnton, fishmonger 0
3866302 1978960 1978960 defendant Muddesley Thomas merchant 600869 600869 Muddesley, Thomas, of Tawnton, merchant 0
3918526 1996523 1996523 plaintiff Horssey William merchant 600869 600869 Horssey, William, of Tawnton, merchant 0
3924230 1998413 1998413 defendant Kenford William merchant 600869 600869 Kenford, William, of Tawnton, merchant 0
3941604 2004204 2004204 defendant Togwell Margaret widow 600869 600869 Togwell, Margaret, of Tawnton, widow 1
3957344 2009632 2009632 plaintiff Peyrse John draper 600869 600869 Peyrse, John, of Tawnton, draper 0
3982970 2018688 2018688 defendant Norse Thomas yeoman 600869 600869 Norse, Thomas, of Tawnton, yeoman 1
3999525 2024595 2024595 plaintiff Fyvean Simon tucker 600869 600869 Fyvean, Simon, of Tawnton, tucker 0
4002080 2025526 2025526 defendant Gryffyn Simon mercer 600869 600869 Gryffyn, Simon, of Tawnton, mercer 0
4002081 2025526 2025526 defendant Sheyffyld James yeoman 600869 600869 Sheyffyld, James, of Tawnton, yeoman 1
4002082 2025526 2025526 defendant Mayne William yeoman 600869 600869 Mayne, William, of Tawnton, yeoman 2
4006103 2026954 2026954 plaintiff Lawrence alias Hutchins Nicholas   600869 600869 Lawrence alias Hutchins, Nicholas, of Tawnton 0
4009852 2028300 2028300 defendant Lankaster Justinian clerk 600869 600869 Lankaster, Justinian, of Tawnton, clerk 0
4013087 2029412 2029412 plaintiff Riche John clothier 600869 600869 Riche, John, of Tawnton, clothier 0
4043648 2040186 2040186 plaintiff Pownde Edward dyer 600869 600869 Pownde, Edward, of Tawnton, dyer 0
4065245 2047853 2047853 plaintiff Harte William tailor 600869 600869 Harte, William, of Tawnton, tailor 0
4075347 2051485 2051485 defendant Dawley Thomas yeoman or brewer 600869 600869 Dawley, Thomas, of Tawnton, yeoman or brewer 1
4159713 2081466 2081466 defendant Skott or Scott Nicholas hosier 600869 600869 Skott or Scott, Nicholas, of Tawnton, hosier 0
4159714 2081466 2081466 defendant Ryve or Reeve Nicholas goldsmith 600869 600869 Ryve or Reeve, Nicholas, of Tawnton, goldsmith 1
4159715 2081466 2081466 defendant Alford John spicer 600869 600869 Alford, John, of Tawnton, spicer 2
4161068 2081947 2081947 defendant Graddon Edmund tailor 600869 600869 Graddon, Edmund, of Tawnton, tailor 0
4170290 2085101 2085101 defendant Olyver Garett retailer 600869 600869 Olyver, Garett, of Tawnton, retailer 1
4171708 2085571 2085571 defendant Reve Nicholas goldsmith 600869 600869 Reve, Nicholas, of Tawnton, goldsmith 1
4248327 2112430 2112430 defendant Alvord alias Gryffin Mary widow 600869 600869 Alvord alias Gryffin, Mary, of Tawnton, widow 1
4270006 2119551 2119551 defendant Griffithe Mary widow 600869 600869 Griffithe, Mary, of Tawnton, widow 2
4292210 2127284 2127284 defendant Browne John cardmaker 600869 600869 Browne, John, of Tawnton, cardmaker 0
4292211 2127284 2127284 defendant Morce John clothier 600869 600869 Morce, John, of Tawnton, clothier 1
4981190 2351304 2351304 defendant Felpotte John merchant 600869 600869 Felpotte, John, of Tawnton, merchant 0
4981191 2351304 2351304 defendant Roche Thomas husbandman 600869 600869 Roche, Thomas, of Tawnton, husbandman 1
5004058 2358073 2358073 plaintiff Philpyt John merchant 600869 600869 Philpyt, John, of Tawnton, merchant 0
5585162 2530428 2530428 plaintiff Horsey Robert merchant 600869 600869 Horsey, Robert, of Tawnton, merchant 0

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