names

74 rows where place_id = 591966

✎ 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
3606146 1869591 1869591 defendant Fyssher John chapman 591966 591966 Fyssher, John, of Buntyngford, Herts, chapman 0
3613397 1871836 1871836 defendant Thorn John barker 591966 591966 Thorn, John, of Buntyngford, Herts, barker 2
3619511 1873668 1873668 defendant Skynner Thomas yeoman 591966 591966 Skynner, Thomas, of Buntyngford, herts, yeoman 2
3649952 1910352 1910352 defendant Serche John husbandman 591966 591966 (Serche, John, of Buntyngford, Herts, husbandman 1
3649964 1910354 1910354 defendant Serche John husbandman 591966 591966 (Serche, John, of Buntyngford, Herts, husbandman 5
3655355 1911933 1911933 defendant Kent Thomas yeoman 591966 591966 Kent, Thomas, of Buntyngford, Herts, yeoman 0
3655357 1911934 1911934 defendant Kent Thomas yeoman 591966 591966 Kent, Thomas, of Buntyngford, Herts, yeoman 0
3655359 1911935 1911935 defendant Kent Thomas yeoman 591966 591966 Kent, Thomas, of Buntyngford, Herts, yeoman 0
3672274 1917327 1917327 defendant Fyssher John yeoman 591966 591966 Fyssher, John, of Buntyngford, Herts, yeoman 0
3709540 1929291 1929291 defendant Wulley William draper 591966 591966 Wulley, William, of Buntyngford, Herts, draper 2
3713549 1930549 1930549 defendant Wheteley Henry butcher 591966 591966 Wheteley, Henry, of Buntyngford, Herts, butcher 0
3748441 1941447 1941447 defendant Fyssher John mercer 591966 591966 Fyssher, John, of Buntyngford, Herts, mercer 0
3753070 1942899 1942899 plaintiff Sawyer John (legal representative) 591966 591966 Sawyer, John, of Buntyngford, Herts, executors of 0
3756041 1943844 1943844 defendant Waren Roger smith 591966 591966 Waren, Roger, of Buntyngford, Herts, smith 1
3775121 1949950 1949950 defendant Awstyn alias Kente Thomas draper 591966 591966 Awstyn alias Kente, Thomas, of Buntyngford, Herts, draper 1
3787037 1953740 1953740 defendant Kent Thomas draper 591966 591966 Kent, Thomas, of Buntyngford, Herts, draper 4
3792748 1955585 1955585 defendant Awstell or Awston alias Kent Thomas draper 591966 591966 Awstell or Awston alias Kent, Thomas, of Buntyngford, Herts, draper 1
3811084 1961362 1961362 defendant Edrige William glover 591966 591966 Edrige, William, of Buntyngford, Herts, glover 1
3831015 1967582 1967582 defendant Hasses John smith 591966 591966 Hasses, John, of Buntyngford, Herts, smith 4
3837697 1969703 1969703 defendant Oker John yeoman 591966 591966 Oker, John, of Buntyngford, Herts, yeoman 0
3847847 1972902 1972902 defendant Byrtshall Alan innholder 591966 591966 Byrtshall, Alan, of Buntyngford, Herts, innholder 2
3859137 1976544 1976544 defendant Fishar John innholder 591966 591966 Fishar, John, of Buntyngford, Herts, innholder 0
3868183 1979596 1979596 defendant Oker John mercer 591966 591966 Oker, John, of Buntyngford, Herts, mercer 1
3868187 1979597 1979597 defendant Oker John mercer 591966 591966 Oker, John, of Buntyngford, Herts, mercer 2
3872335 1980971 1980971 defendant Fyschar John innholder 591966 591966 Fyschar, John, of Buntyngford, Herts, innholder 0
3893146 1987949 1987949 defendant Harryson Edmund smith 591966 591966 Harryson, Edmund, of Buntyngford, Herts, smith 1
3911203 1994073 1994073 defendant Northop John glover 591966 591966 Northop, John, of Buntyngford, Herts, glover 2
3937148 2002756 2002756 defendant Oker John gent 591966 591966 Oker, John, of Buntyngford, Herts, gent 0
3945935 2005656 2005656 defendant Brandon John capper 591966 591966 Brandon, John, of Buntyngford, Herts, capper 3
3981294 2018076 2018076 defendant Wattes Thomas yeoman 591966 591966 Wattes, Thomas, of Buntyngford, Herts, yeoman 0
4287306 2125516 2125516 defendant Sleecher William tailor 591966 591966 Sleecher, William, of Buntyngford, Herts, tailor 0
4728380 2274113 2274113 defendant Gurmount William ostler 591966 591966 Gurmount, William, of Buntyngford, Herts, ostler 0
4794830 2294528 2294528 defendant Clement John husbandman 591966 591966 Clement, John, of Buntyngford, Herts, husbandman 0
4795778 2294829 2294829 defendant Sakery William chaplain 591966 591966 Sakery, William, of Buntyngford, Herts, chaplain 6
4860705 2314709 2314709 defendant Clement William chapman 591966 591966 Clement, William, of Buntyngford, Herts, chapman 0
4860711 2314710 2314710 defendant Clement William chapman 591966 591966 Clement, William, of Buntyngford, Herts, chapman 0
4883569 2321779 2321779 defendant Gylly alias Spycer Robert chapman 591966 591966 Gylly alias Spycer, Robert, of Buntyngford, Herts, chapman 0
4893261 2324602 2324602 defendant Clement William chapman 591966 591966 Clement, William, of Buntyngford, Herts, chapman 1
4901863 2327191 2327191 defendant Stephen alias Smyth Henry smith 591966 591966 Stephen alias Smyth, Henry, of Buntyngford, Herts, smith 0
4906506 2328622 2328622 defendant Gylly alias Spycer Robert chapman 591966 591966 Gylly alias Spycer, Robert, of Buntyngford, Herts, chapman 0
4917269 2331907 2331907 defendant Colman John shoemaker 591966 591966 Colman, John, of Buntyngford, Herts, shoemaker 0
4942846 2339734 2339734 defendant Colman John cordwainer 591966 591966 Colman, John, of Buntyngford, Herts, cordwainer 0
4948204 2341411 2341411 defendant Miller William miller 591966 591966 Miller, William, of Buntyngford, Herts, miller 0
4972267 2348650 2348650 defendant Bryght William husbandman 591966 591966 Bryght, William, of Buntyngford, Herts, husbandman 0
4972292 2348654 2348654 defendant Bryght William husbandman 591966 591966 Bryght, William, of Buntyngford, Herts, husbandman 0
4986681 2352950 2352950 defendant Colman John ostler 591966 591966 Colman, John, of Buntyngford, Herts, ostler 0
4993037 2354803 2354803 defendant Colman John hosteller 591966 591966 Colman, John, of Buntyngford, Herts, hosteller 0
4993039 2354804 2354804 defendant Colman John hostiller 591966 591966 Colman, John, of Buntyngford, Herts, hostiller 0
5005921 2358634 2358634 defendant Colman John ostler 591966 591966 Colman, John, of Buntyngford, Herts, ostler 0
5011581 2360250 2360250 defendant Colman John ostler 591966 591966 Colman, John, of Buntyngford, Herts, ostler 0
5011588 2360251 2360251 defendant Colman John ostler 591966 591966 Colman, John, of Buntyngford, Herts, ostler 0
5032588 2366416 2366416 defendant Marcaunt William ostler 591966 591966 Marcaunt, William, of Buntyngford, Herts, ostler 0
5032594 2366417 2366417 defendant Marcaunt William ostler 591966 591966 Marcaunt, William, of Buntyngford, Herts, ostler 0
5074419 2378853 2378853 defendant Spayn John husbandman 591966 591966 Spayn, John, of Buntyngford, Herts, husbandman 1
5088764 2383091 2383091 defendant Wyndoute Thomas (legal representative) 591966 591966 Wyndoute, Thomas, of Buntyngford, Herts, executors of 0
5271876 2436861 2436861 defendant Reymond Walter husbandman 591966 591966 Reymond, Walter, of Buntyngford, Herts, husbandman 10
5271980 2436888 2436888 defendant Rougham William chapman 591966 591966 Rougham, William, of Buntyngford, Herts, chapman 4
5291261 2442448 2442448 defendant Bryan John husbandman 591966 591966 Bryan, John, of Buntyngford, Herts, husbandman 0
5291265 2442449 2442449 defendant Bryan John husbndman 591966 591966 Bryan, John, of Buntyngford, Herts, husbndman 0
5306117 2446818 2446818 defendant Waren Richard smith 591966 591966 Waren, Richard, of Buntyngford, Herts, smith 2
5318009 2450474 2450474 defendant Waren Richard smith 591966 591966 Waren, Richard, of Buntyngford, Herts, smith 0
5318130 2450514 2450514 defendant Hawekyn John husbandman 591966 591966 Hawekyn, John, of Buntyngford, Herts, husbandman 0
5323715 2452179 2452179 defendant Man Thomas barber 591966 591966 (Man, Thomas, of Buntyngford, Herts, barber 4
5326465 2453000 2453000 defendant Salter John tailor 591966 591966 Salter, John, of Buntyngford, Herts, tailor 2
5326470 2453001 2453001 defendant Salter John tailor 591966 591966 Salter, John, of Buntyngford, Herts, tailor 2
5358459 2462697 2462697 defendant Hyde Robert miller 591966 591966 Hyde, Robert, of Buntyngford, Herts, miller 3
5519207 2510852 2510852 defendant Mors Roger yeoman 591966 591966 Mors, Roger, of Buntyngford, Herts, yeoman 3
5519213 2510853 2510853 defendant Mors Roger yeoman 591966 591966 Mors, Roger, of Buntyngford, Herts, yeoman 3
5519459 2510933 2510933 defendant Gossone John baker 591966 591966 Gossone, John, of Buntyngford, Herts, baker 2
5519468 2510934 2510934 defendant Gossone John baker 591966 591966 Gossone, John, of Buntyngford, Herts, baker 2
5519484 2510936 2510936 defendant Gossone John baker 591966 591966 Gossone, John, of Buntyngford, Herts, baker 2
5557636 2522190 2522190 defendant Throssher Thomas husbandman 591966 591966 Throssher, Thomas, of Buntyngford, Herts, husbandman 3
5574378 2527071 2527071 defendant Scorburgh Robert clerk 591966 591966 Scorburgh, Robert, of Buntyngford, Herts, clerk 0
5584735 2530300 2530300 defendant Gosson John innholder 591966 591966 Gosson, John, of Buntyngford, Herts, innholder 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);