names

36 rows where place_id = 648516

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3901981 1990891 1990891 defendant Punte Henry yeoman 648516 648516 Punte, Henry, of Baldocke, yeoman 1
3903962 1991564 1991564 defendant Adams John shoemaker 648516 648516 Adams, John, of Baldocke, shoemaker 0
3950920 2007388 2007388 plaintiff Goodman John   648516 648516 Goodman, John, of Baldocke, malt maker 0
3951434 2007564 2007564 plaintiff Gunyll Clement   648516 648516 Gunyll, Clement, of Baldocke, malt maker 0
3958582 2010073 2010073 plaintiff Rotherford John   648516 648516 Rotherford, John, of Baldocke, malt maker 0
3961192 2011009 2011009 plaintiff Tokefeilde Henry yeoman 648516 648516 Tokefeilde, Henry, of Baldocke, yeoman 0
3972879 2015087 2015087 plaintiff Godfrey Thomas laborer 648516 648516 Godfrey, Thomas, of Baldocke, laborer 0
3980649 2017845 2017845 defendant Fleccher William butcher 648516 648516 Fleccher, William, of Baldocke, butcher 0
4015499 2030241 2030241 plaintiff Smythe John tailor 648516 648516 Smythe, John, of Baldocke, tailor 0
4015502 2030242 2030242 plaintiff Smythe John tailor 648516 648516 Smythe, John, of Baldocke, tailor 0
4042301 2039728 2039728 plaintiff Parker John maltster 648516 648516 Parker, John, of Baldocke, maltster 0
4044833 2040603 2040603 plaintiff Rocheford or Retchford James maltmaker 648516 648516 Rocheford or Retchford, James, of Baldocke, maltmaker 0
4044839 2040605 2040605 plaintiff Rocheford James maltster 648516 648516 Rocheford, James, of Baldocke, maltster 0
4127955 2070288 2070288 defendant Dawson Thomas glover 648516 648516 Dawson, Thomas, of Baldocke, glover 1
4161732 2082171 2082171 defendant Gowge Richard   648516 648516 Gowge, Richard, of Baldocke, clerk, parson of Freston 0
4170636 2085231 2085231 defendant Rotchford John husbandman 648516 648516 Rotchford, John, of Baldocke, husbandman 0
4170638 2085231 2085231 defendant Fletcher William butcher 648516 648516 Fletcher, William, of Baldocke, butcher 2
4222085 2103215 2103215 defendant Bamford or Bainford John   648516 648516 Bamford or Bainford, John, of Baldocke yeoman 0
4222087 2103216 2103216 defendant Bamford John yeoman 648516 648516 Bamford, John, of Baldocke, yeoman 0
4274995 2121207 2121207 defendant Smythe Thomas maltster 648516 648516 Smythe, Thomas, of Baldocke, yeoman, maltster 0
4274998 2121208 2121208 defendant Smythe Thomas maltster 648516 648516 Smythe, Thomas, of Baldocke, yeoman, maltster 0
4279114 2122625 2122625 defendant Wenham William yeoman 648516 648516 Wenham, William, of Baldocke, yeoman 0
4283451 2124117 2124117 defendant Wenham William   648516 648516 Wenham, William, of Baldocke yeoman 0
4285618 2124908 2124908 defendant Gylman Henry maltster 648516 648516 Gylman, Henry, of Baldocke, maltster 0
4294400 2128078 2128078 defendant Gylman Henry maltster 648516 648516 Gylman, Henry, of Baldocke, maltster 0
4311027 2134003 2134003 defendant Smythe Thomas maltster 648516 648516 Smythe, Thomas, of Baldocke, yeoman, maltster 0
4327558 2139540 2139540 defendant Spurlyng Henry yeoman 648516 648516 Spurlyng, Henry, of Baldocke, yeoman 1
4370713 2154578 2154578 defendant Spurlinge Henry yeoman 648516 648516 Spurlinge, Henry, of Baldocke, yeoman 1
4370754 2154594 2154594 defendant Hynde Edward yeoman 648516 648516 Hynde, Edward, of Baldocke, yeoman 0
4390786 2161531 2161531 defendant Phippe Thomas yeoman 648516 648516 Phippe, Thomas, of Baldocke, yeoman 0
4390787 2161531 2161531 defendant Phippe John yeoman 648516 648516 Phippe, John, of Baldocke, yeoman 1
4392678 2162170 2162170 defendant Fletcher William butcher 648516 648516 Fletcher, William, of Baldocke, butcher 0
4405113 2166286 2166286 defendant Fletcher William butcher 648516 648516 Fletcher, William, of Baldocke, butcher 1
4412271 2168693 2168693 defendant Retchford James yeoman 648516 648516 Retchford, James, of Baldocke, yeoman 0
4412761 2168862 2168862 defendant Dawson Thomas glover 648516 648516 Dawson, Thomas, of Baldocke, glover 1
5236222 2426180 2426180 plaintiff Ede William yeoman 648516 648516 Ede, William, of Baldocke, 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);