names

35 rows where place_id = 716886

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4216872 2101399 2101399 defendant Hardyng Arthur innholder 716886 716886 Hardyng, Arthur, of Buntingford, innholder 2
4216878 2101400 2101400 defendant Hardyng Arthur innholder 716886 716886 Hardyng, Arthur, of Buntingford, innholder 2
4278191 2122307 2122307 defendant Page John husbandman 716886 716886 (Page, John, of Buntingford, husbandman 2
4279063 2122607 2122607 defendant Thorogood Thomas yeoman 716886 716886 Thorogood, Thomas, of Buntingford, yeoman 1
4279064 2122607 2122607 defendant Norris Leonard yeoman 716886 716886 Norris, Leonard, of Buntingford, yeoman 2
4279387 2122714 2122714 defendant Hantler Robert yeoman 716886 716886 Hantler, Robert, of Buntingford, yeoman 1
4279388 2122714 2122714 defendant Hitche William yeoman 716886 716886 Hitche, William, of Buntingford, yeoman 2
4280974 2123248 2123248 defendant Hardye Arthur vintner 716886 716886 Hardye, Arthur, of Buntingford, vintner 2
4281162 2123317 2123317 defendant Thoroughgood Thomas   716886 716886 Thoroughgood, Thomas, of Buntingford, linen draper 0
4281163 2123317 2123317 defendant Slachy William yeoman 716886 716886 Slachy, William, of Buntingford, yeoman 1
4281164 2123317 2123317 defendant Howell James baker 716886 716886 Howell, James, of Buntingford, baker 2
4328262 2139767 2139767 defendant Gamlle or Ganille Thomas yeoman 716886 716886 Gamlle or Ganille, Thomas, of Buntingford, yeoman 0
4328263 2139767 2139767 defendant Lewys Thomas yeoman 716886 716886 Lewys, Thomas, of Buntingford, yeoman 1
4378604 2157421 2157421 defendant Packer Thomas fletcher 716886 716886 Packer, Thomas, of Buntingford, fletcher 0
4378605 2157421 2157421 defendant Arnolde Henry joiner 716886 716886 Arnolde, Henry, of Buntingford, joiner 1
4390163 2161331 2161331 defendant Thurgood Thomas   716886 716886 Thurgood, Thomas, of Buntingford, linen draper 0
4395116 2162954 2162954 defendant Thurgood Thomas   716886 716886 Thurgood, Thomas, of Buntingford, linen draper 0
4411174 2168325 2168325 defendant Dalton Clement brewer 716886 716886 Dalton, Clement, of Buntingford, brewer 0
4445477 2183541 2183541 defendant Bakere William   716886 716886 Bakere, William, of Buntingford 3
4706758 2267497 2267497 plaintiff Manlike Philip   716886 716886 Manlike, Philip, of Buntingford 0
4706760 2267498 2267498 plaintiff Manlike Philip   716886 716886 Manlike, Philip, of Buntingford 0
4711795 2269014 2269014 defendant Godard John tailor 716886 716886 Godard, John, of Buntingford, tailor 3
4734634 2275992 2275992 defendant Serchaunt Richard husbandman 716886 716886 Serchaunt, Richard, of Buntingford, husbandman 2
4834177 2306699 2306699 defendant Bayser Robert husbandman 716886 716886 Bayser, Robert, of Buntingford, husbandman 0
4847632 2310751 2310751 defendant atte Hill Richard smith 716886 716886 atte Hill, Richard, of Buntingford, smith 0
4847634 2310751 2310751 defendant Gofford John skinner 716886 716886 Gofford, John, of Buntingford, skinner 2
4847638 2310751 2310751 defendant Skynner William skinner 716886 716886 (Skynner, William, of Buntingford, skinner 6
4847639 2310751 2310751 defendant Miller William miller 716886 716886 Miller, William, of Buntingford, miller 7
4849908 2311443 2311443 defendant Spervere John (legal representative) 716886 716886 Spervere, John, of Buntingford, fuller, executors of 0
4849910 2311443 2311443 defendant Millere William miller 716886 716886 Millere, William, of Buntingford, miller 2
4849911 2311443 2311443 defendant Glovere William   716886 716886 Glovere, William, of Buntingford, glove maker 3
4851840 2312011 2312011 defendant Medewe Thomas yeoman 716886 716886 Medewe, Thomas, of Buntingford, yeoman 3
4851841 2312011 2312011 defendant Tayllour John yeoman 716886 716886 Tayllour, John, of Buntingford, yeoman 4
4968345 2347496 2347496 defendant Colman John hosteler 716886 716886 Colman, John, of Buntingford, hosteler 1
5177541 2409125 2409125 defendant Bryan John maltman 716886 716886 Bryan, John, of Buntingford, maltman 3

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