names

61 rows where place_id = 599733

✎ 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
3638037 1906715 1906715 defendant Strynger Alice widow 599733 599733 Strynger, Alice, of Bryghthelmeston, widow 0
3638038 1906715 1906715 defendant Waterman Thomas laborer 599733 599733 Waterman, Thomas, of Bryghthelmeston, laborer 1
3638039 1906715 1906715 defendant Saunder Richard   599733 599733 Saunder, Richard, of Bryghthelmeston, wax chandler 2
3718045 1931939 1931939 defendant Smythe Richard husbandman 599733 599733 Smythe, Richard, of Bryghthelmeston, husbandman 0
3775630 1950126 1950126 defendant Blake John yeoman 599733 599733 Blake, John, of Bryghthelmeston, yeoman 0
3775632 1950127 1950127 defendant Blake John yeoman 599733 599733 Blake, John, of Bryghthelmeston, yeoman 0
3811649 1961542 1961542 defendant Kyng Nicholas butcher 599733 599733 Kyng, Nicholas, of Bryghthelmeston, butcher 0
3820526 1964304 1964304 defendant Kyng Nicholas butcher 599733 599733 Kyng, Nicholas, of Bryghthelmeston, butcher 2
3820527 1964304 1964304 defendant Smyth John husbandman 599733 599733 Smyth, John, of Bryghthelmeston, husbandman 3
3820710 1964366 1964366 defendant Kyngyswode John fisherman 599733 599733 Kyngyswode, John, of Bryghthelmeston, fisherman 1
3859887 1976813 1976813 defendant Lucas Richard butcher 599733 599733 Lucas, Richard, of Bryghthelmeston, butcher 1
3895498 1988701 1988701 defendant Ede William shoemaker 599733 599733 Ede, William, of Bryghthelmeston, shoemaker 0
3895500 1988701 1988701 defendant Smythe John fisherman 599733 599733 Smythe, John, of Bryghthelmeston, fisherman 2
3895501 1988701 1988701 defendant Stone William fisherman 599733 599733 Stone, William, of Bryghthelmeston, fisherman 3
3942629 2004543 2004543 defendant Spencer Goeffrey, senior merchant 599733 599733 Spencer, Goeffrey, senior, of Bryghthelmeston, merchant 0
3981207 2018039 2018039 defendant Hubbert Thomas beer brewer 599733 599733 Hubbert, Thomas, of Bryghthelmeston, beer brewer 0
4063871 2047361 2047361 defendant Slutter John yeoman 599733 599733 Slutter, John, of Bryghthelmeston, yeoman 2
4066314 2048242 2048242 defendant Swanne John tailor 599733 599733 Swanne, John, of Bryghthelmeston, tailor 0
4077332 2052176 2052176 defendant Slutter John, senior fisherman 599733 599733 Slutter, John, senior, of Bryghthelmeston, fisherman 0
4077333 2052176 2052176 defendant Baker Henry fisherman 599733 599733 Baker, Henry, of Bryghthelmeston, fisherman 1
4079279 2052891 2052891 defendant Warde Richard fisherman 599733 599733 Warde, Richard, of Bryghthelmeston, fisherman 0
4079617 2053008 2053008 defendant Brapole Thomas yeoman 599733 599733 Brapole, Thomas, of Bryghthelmeston, yeoman 0
4079618 2053008 2053008 defendant Baker Thomas fisherman 599733 599733 Baker, Thomas, of Bryghthelmeston, fisherman 1
4124242 2068960 2068960 defendant Eston John mariner 599733 599733 Eston, John, of Bryghthelmeston, mariner 0
4127787 2070227 2070227 defendant Brydger Robert fisherman 599733 599733 Brydger, Robert, of Bryghthelmeston, fisherman 1
4127788 2070227 2070227 defendant Hayne William fisherman 599733 599733 Hayne, William, of Bryghthelmeston, fisherman 2
4127789 2070227 2070227 defendant Bonde Hugh baker 599733 599733 Bonde, Hugh, of Bryghthelmeston, baker 3
4130125 2071082 2071082 defendant Cobbey John fisherman 599733 599733 Cobbey, John, of Bryghthelmeston, fisherman 0
4135120 2072879 2072879 defendant Bullye Thomas fisherman 599733 599733 Bullye, Thomas, of Bryghthelmeston, fisherman 0
4135121 2072879 2072879 defendant Ockenden Edward fisherman 599733 599733 Ockenden, Edward, of Bryghthelmeston, fisherman 1
4135124 2072880 2072880 defendant Nycholl Edward fisherman 599733 599733 Nycholl, Edward, of Bryghthelmeston, fisherman 1
4135127 2072881 2072881 defendant Nycholls Edward fisherman 599733 599733 Nycholls, Edward, of Bryghthelmeston, fisherman 1
4135133 2072883 2072883 defendant Norton Robert innholder 599733 599733 Norton, Robert, of Bryghthelmeston, innholder 2
4135758 2073116 2073116 defendant Bullye or Bulle Thomas mariner 599733 599733 Bullye or Bulle, Thomas, of Bryghthelmeston, mariner 0
4135759 2073116 2073116 defendant Duffeld William mariner 599733 599733 Duffeld, William, of Bryghthelmeston, mariner 1
4168991 2084648 2084648 defendant Okenden Joan widow 599733 599733 Okenden, Joan, of Bryghthelmeston, widow 1
4176507 2087265 2087265 defendant Aldrydge Thomas fisherman 599733 599733 Aldrydge, Thomas, of Bryghthelmeston, fisherman 0
4176586 2087288 2087288 defendant Duffeld William mariner 599733 599733 Duffeld, William, of Bryghthelmeston, mariner 0
4176587 2087288 2087288 defendant Cobby John mariner 599733 599733 Cobby, John, of Bryghthelmeston, mariner 1
4176593 2087289 2087289 defendant Baylye John fisherman 599733 599733 Baylye, John, of Bryghthelmeston, fisherman 2
4177546 2087622 2087622 defendant Efson John husbandman 599733 599733 Efson, John, of Bryghthelmeston, husbandman 3
4182943 2089513 2089513 defendant Locke Edmund fisherman 599733 599733 Locke, Edmund, of Bryghthelmeston, fisherman 1
4184744 2090173 2090173 defendant Nicholles John mariner 599733 599733 Nicholles, John, of Bryghthelmeston, mariner 0
4184745 2090173 2090173 defendant Swane Robert   599733 599733 Swane, Robert, of Bryghthelmeston, "whypwryght" 1
4368486 2153775 2153775 defendant Hun William, junior fisherman 599733 599733 Hun, William, junior, of Bryghthelmeston, fisherman 1
4380298 2158057 2158057 defendant Ede Robert blacksmith 599733 599733 Ede, Robert, of Bryghthelmeston, blacksmith 1
4582722 2226036 2226036 plaintiff Loveryk John   599733 599733 Loveryk, John, of Bryghthelmeston 3
5000616 2357049 2357049 defendant Somer William husbandman 599733 599733 Somer, William, of Bryghthelmeston, husbandman 0
5021007 2363042 2363042 defendant Taillour Nicholas husbandman 599733 599733 Taillour, Nicholas, of Bryghthelmeston, husbandman 3
5043742 2369754 2369754 defendant Fonte or Foute Henry   599733 599733 Fonte or Foute, Henry, of Bryghthelmeston, shepherd 0
5220649 2421735 2421735 defendant Erlegh John husbandman 599733 599733 Erlegh, John, of Bryghthelmeston, husbandman 0
5220650 2421735 2421735 defendant Farlegh John husbandman 599733 599733 Farlegh, John, of Bryghthelmeston, husbandman 1
5220655 2421736 2421736 defendant Erlegh John husbandman 599733 599733 Erlegh, John, of Bryghthelmeston, husbandman 0
5220656 2421736 2421736 defendant Farlegh John husbandman 599733 599733 Farlegh, John, of Bryghthelmeston, husbandman 1
5289280 2441867 2441867 defendant Farlay William clerk 599733 599733 Farlay, William, of Bryghthelmeston, clerk 0
5438088 2486327 2486327 defendant Toche Richard smith 599733 599733 Toche, Richard, of Bryghthelmeston, smith 2
5477839 2498389 2498389 defendant Ilgate John husbandman 599733 599733 Ilgate, John, of Bryghthelmeston, husbandman 0
5523144 2512064 2512064 defendant Hertforth Thomas mariner 599733 599733 Hertforth, Thomas, of Bryghthelmeston, mariner 0
5574825 2527206 2527206 defendant Smyth Ruchard yeoman 599733 599733 Smyth, Ruchard, of Bryghthelmeston, yeoman 0
5574826 2527206 2527206 defendant Farley Thomas yeoman 599733 599733 Farley, Thomas, of Bryghthelmeston, yeoman 1
5590378 2531961 2531961 defendant Smyth Richard yeoman 599733 599733 Smyth, Richard, of Bryghthelmeston, yeoman 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);