names

46 rows where place_id = 695147

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4100693 2060570 2060570 defendant Bybye Stephen   695147 695147 Bybye, Stephen, of Attleborowe, wheelwright 0
4108005 2063136 2063136 defendant Mowlde Peter yeoman 695147 695147 Mowlde, Peter, of Attleborowe, yeoman 1
4115820 2065943 2065943 defendant Walter John, senior husbandman 695147 695147 Walter, John, senior, of Attleborowe, husbandman 0
4143765 2075980 2075980 defendant Deane Daniel yeoman 695147 695147 Deane, Daniel, of Attleborowe, yeoman 2
4197973 2094841 2094841 defendant Mayster John joiner 695147 695147 Mayster, John, of Attleborowe, joiner 0
4202129 2096290 2096290 defendant Sherwyn Nicholas   695147 695147 Sherwyn, Nicholas, of Attleborowe, wheelwright 2
4216400 2101231 2101231 defendant Nune Walter yeoman 695147 695147 Nune, Walter, of Attleborowe, yeoman 0
4216401 2101231 2101231 defendant Towson Richard husbandman 695147 695147 Towson, Richard, of Attleborowe, husbandman 1
4220372 2102631 2102631 defendant Reder Nicholas   695147 695147 Reder, Nicholas, of Attleborowe butcher 0
4220373 2102631 2102631 defendant Barrett Peter   695147 695147 Barrett, Peter, of Attleborowe felt maker 1
4222075 2103212 2103212 defendant Dowe Simon yeoman 695147 695147 Dowe, Simon, of Attleborowe, yeoman 1
4227718 2105178 2105178 defendant Rumbold Roger husbandman 695147 695147 Rumbold, Roger, of Attleborowe, husbandman 1
4245337 2111418 2111418 defendant Moule John yeoman 695147 695147 Moule, John, of Attleborowe, yeoman 0
4251755 2113578 2113578 defendant Reder Nicholas butcher 695147 695147 Reder, Nicholas, of Attleborowe, butcher 0
4257191 2115382 2115382 defendant Nunne Walter yeoman 695147 695147 Nunne, Walter, of Attleborowe, yeoman 0
4257192 2115382 2115382 defendant Catton William husbandman 695147 695147 Catton, William, of Attleborowe, husbandman 1
4284897 2124647 2124647 defendant Smyth John, senior laborer 695147 695147 Smyth, John, senior, of Attleborowe, laborer 1
4284898 2124647 2124647 defendant Taykor Thomas laborer 695147 695147 Taykor, Thomas, of Attleborowe, laborer 2
4284899 2124647 2124647 defendant Dowe Richard yeoman 695147 695147 Dowe, Richard, of Attleborowe, yeoman 3
4285856 2124995 2124995 defendant Smyth alias Hovell or Houell John yeoman 695147 695147 Smyth alias Hovell or Houell, John, of Attleborowe, yeoman 0
4323806 2138374 2138374 defendant Howes Thomas shoemaker 695147 695147 Howes, Thomas, of Attleborowe, shoemaker 2
4325119 2138785 2138785 defendant Phillipps or Phillipson Edward tailor 695147 695147 Phillipps or Phillipson, Edward, of Attleborowe, tailor 1
4325848 2139018 2139018 defendant Potter Stephen husbandman 695147 695147 Potter, Stephen, of Attleborowe, husbandman 1
4325849 2139018 2139018 defendant Parson Simon tanner 695147 695147 Parson, Simon, of Attleborowe, tanner 2
4325850 2139018 2139018 defendant Salter James butcher 695147 695147 Salter, James, of Attleborowe, butcher 3
4326220 2139135 2139135 defendant Norris John husbandman 695147 695147 Norris, John, of Attleborowe, husbandman 0
4326610 2139260 2139260 defendant Jollye Adam husbandman 695147 695147 Jollye, Adam, of Attleborowe, husbandman 0
4326612 2139260 2139260 defendant Parker Thomas hatmaker 695147 695147 Parker, Thomas, of Attleborowe, hatmaker 2
4331768 2140919 2140919 defendant Cooper John grocer 695147 695147 Cooper, John, of Attleborowe, grocer 0
4333559 2141504 2141504 defendant Thompson Robert haberdasher 695147 695147 Thompson, Robert, of Attleborowe, haberdasher 0
4349164 2146968 2146968 defendant Cooper Thomas yeoman 695147 695147 Cooper, Thomas, of Attleborowe, yeoman 0
4366206 2152953 2152953 defendant Earle Joseph haberdasher 695147 695147 Earle, Joseph, of Attleborowe, husbandman, or of Norwich, haberdasher 3
4370561 2154521 2154521 defendant Mould John yeoman 695147 695147 Mould, John, of Attleborowe, yeoman 3
4376629 2156709 2156709 defendant Person Richard husbandman 695147 695147 Person, Richard, of Attleborowe, husbandman 2
4387128 2160347 2160347 defendant Cooper William yeoman 695147 695147 Cooper, William, of Attleborowe, yeoman 1
4387129 2160347 2160347 defendant Hill John yeoman 695147 695147 Hill, John, of Attleborowe, yeoman 2
4387130 2160347 2160347 defendant Phillipson Tristram yeoman 695147 695147 Phillipson, Tristram, of Attleborowe, yeoman 3
4390275 2161369 2161369 defendant Salter Thomas husbandman 695147 695147 Salter, Thomas, of Attleborowe, husbandman 1
4390276 2161369 2161369 defendant Barker Robert yeoman 695147 695147 Barker, Robert, of Attleborowe, yeoman 2
4393201 2162333 2162333 defendant Earle or Garle Joseph haberdasher 695147 695147 Earle or Garle, Joseph, of Attleborowe, or of Norwich, haberdasher 3
4395415 2163049 2163049 defendant Twaytes Jerome gent 695147 695147 Twaytes, Jerome, of Attleborowe, gent 0
4398013 2163914 2163914 defendant Tan Isaac miller 695147 695147 Tan, Isaac, of Attleborowe, miller 0
4399460 2164406 2164406 defendant Cowper William tailor 695147 695147 Cowper, William, of Attleborowe, tailor 2
4400545 2164774 2164774 defendant Dowe Simon yeoman 695147 695147 Dowe, Simon, of Attleborowe, yeoman 0
4400547 2164774 2164774 defendant Potter Stephen yeoman 695147 695147 Potter, Stephen, of Attleborowe, yeoman 2
4405781 2166502 2166502 defendant Parson Richard husbandman 695147 695147 Parson, Richard, of Attleborowe, husbandman 2

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