names

40 rows where place_id = 662323

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3951893 2007724 2007724 defendant Style alias Frary Richard   662323 662323 Style alias Frary, Richard, of Hockham husbandman 0
3964522 2012192 2012192 defendant Webbe George husbandman 662323 662323 Webbe, George, of Hockham, husbandman 0
3965916 2012697 2012697 defendant Plome John butcher 662323 662323 Plome, John, of Hockham, butcher 2
3967110 2013121 2013121 defendant Halsted George clerk 662323 662323 Halsted, George, of Hockham, clerk 0
3967536 2013277 2013277 defendant Beal Adam husbandman 662323 662323 Beal, Adam, of Hockham, husbandman 5
4026533 2034141 2034141 defendant Beales Adam husbandman 662323 662323 together with Beales, Adam, of Hockham, husbandman 2
4054574 2044024 2044024 defendant Wyllymont Christopher husbandman 662323 662323 Wyllymont, Christopher, of Hockham, husbandman 2
4117493 2066553 2066553 defendant Assey Adam husbandman 662323 662323 Assey, Adam, of Hockham, husbandman 0
4220847 2102786 2102786 defendant Norrys Ambrose yeoman 662323 662323 Norrys, Ambrose, of Hockham, yeoman 0
4220848 2102786 2102786 defendant Assey Margaret widow 662323 662323 Assey, Margaret, of Hockham, widow 1
4220849 2102786 2102786 defendant Norrys Agnes spinster 662323 662323 Norrys, Agnes, of Hockham, spinster 2
4255149 2114712 2114712 defendant Beales Adam yeoman 662323 662323 Beales, Adam, of Hockham, yeoman 0
4255150 2114712 2114712 defendant Fowler Thomas tailor 662323 662323 Fowler, Thomas, of Hockham, tailor 1
4255151 2114712 2114712 defendant Jessupp Jesse yeoman 662323 662323 Jessupp, Jesse, of Hockham, yeoman 2
4265226 2118008 2118008 defendant Gryffon John carpenter 662323 662323 Gryffon, John, of Hockham, carpenter 0
4270818 2119815 2119815 defendant Beales Adam yeoman 662323 662323 Beales, Adam, of Hockham, yeoman 0
4276311 2121657 2121657 defendant Morrys John yeoman 662323 662323 Morrys, John, of Hockham, yeoman 3
4278304 2122349 2122349 defendant Sharpyn Thomas husbandman 662323 662323 Sharpyn, Thomas, of Hockham, husbandman 3
4289732 2126389 2126389 defendant Gall Robert tailor 662323 662323 Gall, Robert, of Hockham, tailor 2
4335673 2142208 2142208 defendant Assey Edmund victualer 662323 662323 Assey, Edmund, of Hockham, yeoman, victualer 3
4336446 2142482 2142482 defendant Hayles Robert husbandman 662323 662323 Hayles, Robert, of Hockham, husbandman 0
4340485 2143939 2143939 defendant Robyns William grocer 662323 662323 Robyns, William, of Hockham, grocer 0
4340486 2143939 2143939 defendant Warren alias Hatter John butcher 662323 662323 Warren alias Hatter, John, of Hockham, butcher 1
4340487 2143939 2143939 defendant Olifaxe Henry husbandman 662323 662323 Olifaxe, Henry, of Hockham, husbandman 2
4375835 2156417 2156417 defendant Snell or Suell John husbandman 662323 662323 Snell or Suell, John, of Hockham, husbandman 0
4384920 2159648 2159648 defendant Hayles Robert husbandman 662323 662323 Hayles, Robert, of Hockham, husbandman 0
4384921 2159648 2159648 defendant Warren alias Hatter John butcher 662323 662323 Warren alias Hatter, John, of Hockham, butcher 1
4384923 2159648 2159648 defendant Robyns William husbandman 662323 662323 Robyns, William, of Hockham, husbandman 3
4393137 2162311 2162311 defendant Robyns William grocer 662323 662323 Robyns, William, of Hockham, grocer 0
4393138 2162311 2162311 defendant Sadd Stephen smith 662323 662323 Sadd, Stephen, of Hockham, smith 1
4395702 2163148 2163148 defendant Beales Adam yeoman 662323 662323 Beales, Adam, of Hockham, yeoman 0
4395703 2163148 2163148 defendant Beales William butcher 662323 662323 Beales, William, of Hockham, butcher 1
4400000 2164590 2164590 defendant Tallyer Richard laborer 662323 662323 Tallyer, Richard, of Hockham, laborer 0
4400001 2164590 2164590 defendant Tallyer Joan widow 662323 662323 Tallyer, Joan, of Hockham, widow 1
4400002 2164590 2164590 defendant Lovett Ambrose yeoman 662323 662323 Lovett, Ambrose, of Hockham, yeoman 2
4405994 2166570 2166570 defendant Sharpen Thomas tailor 662323 662323 Sharpen, Thomas, of Hockham, tailor 1
4405995 2166570 2166570 defendant Willemont Christopher husbandman 662323 662323 Willemont, Christopher, of Hockham, husbandman 2
4410843 2168216 2168216 defendant Beales Adam yeoman 662323 662323 Beales, Adam, of Hockham, yeoman 0
4410844 2168216 2168216 defendant Beales John laborer 662323 662323 Beales, John, of Hockham, laborer 1
4410845 2168216 2168216 defendant Beales William butcher 662323 662323 Beales, William, of Hockham, butcher 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);