names

35 rows where place_id = 636343

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3830265 1967360 1967360 defendant Bowman Thomas mercer 636343 636343 Bowman, Thomas, of Peterborowe, Nhants, mercer 1
3834124 1968614 1968614 defendant Baker Walter innholder 636343 636343 Baker, Walter, of Peterborowe, Nhants, innholder 0
3932378 2001124 2001124 defendant Bullner Ralph clerk 636343 636343 Bullner, Ralph, of Peterborowe, Nhants, clerk 3
3947758 2006280 2006280 defendant Brumble John butcher 636343 636343 Brumble, John, of Peterborowe, Nhants, butcher 0
3996018 2023331 2023331 defendant Grenhall or Grenehawe John yeoman 636343 636343 Grenhall or Grenehawe, John, of Peterborowe, Nhants, yeoman 0
4005975 2026911 2026911 defendant Surflett Thomas chapman 636343 636343 Surflett, Thomas, of Peterborowe, Nhants, chapman 0
4013270 2029479 2029479 plaintiff Robynson Thomas yeoman 636343 636343 Robynson, Thomas, of Peterborowe, Nhants, yeoman 0
4013272 2029480 2029480 plaintiff Robynson Thomas yeoman 636343 636343 Robynson, Thomas, of Peterborowe, Nhants, yeoman 0
4013274 2029481 2029481 plaintiff Robynson Thomas yeoman 636343 636343 Robynson, Thomas, of Peterborowe, Nhants, yeoman 0
4018999 2031531 2031531 defendant Mason John chandler 636343 636343 Mason, John, of Peterborowe, Nhants, chandler 0
4039560 2038770 2038770 defendant Norres John chapman 636343 636343 Norres, John, of Peterborowe, Nhants, chapman 1
4039564 2038771 2038771 defendant Norres John chapman or waterman 636343 636343 Norres, John, of Peterborowe, Nhants, chapman or waterman 1
4134278 2072585 2072585 defendant Wollason Robert chapman 636343 636343 Wollason, Robert, of Peterborowe, Nhants, chapman 0
4167012 2083966 2083966 defendant Hutten George gent 636343 636343 Hutten, George, of Peterborowe, Nhants, gent 0
4223238 2103619 2103619 defendant Manestye Richard chapman 636343 636343 Manestye, Richard, of Peterborowe, Nhants, or of Gaynsborowe, Lincs, chapman 0
4227914 2105245 2105245 defendant Farforthe Parnella widow 636343 636343 Farforthe, Parnella, of Peterborowe, Nhants, widow 1
4271585 2120077 2120077 defendant Mallory Anthony yeoman 636343 636343 Mallory, Anthony, of Peterborowe, Nhants, yeoman 2
4273581 2120717 2120717 defendant Manestye Richard husbandman 636343 636343 Manestye, Richard, of Peterborowe, Nhants, or of Gaynesborowe, Lincs, husbandman 0
4273582 2120717 2120717 defendant Manestie Thomas tanner 636343 636343 Manestie, Thomas, of Peterborowe, Nhants, husbandman, tanner 1
4289078 2126151 2126151 defendant Ellys James esq 636343 636343 Ellys, James, of Peterborowe, Nhants, esq 2
4311460 2134152 2134152 defendant Godlington Richard   636343 636343 Godlington, Richard, of Peterborowe, Nhants, horse courser 1
4316587 2135919 2135919 defendant Clapham Edmund gent 636343 636343 Clapham, Edmund, of Peterborowe, Nhants, gent 0
4336598 2142527 2142527 defendant Robinson William chapman 636343 636343 Robinson, William, of Peterborowe, Nhants, chapman 2
4338321 2143146 2143146 defendant Cordell Thomas mercer 636343 636343 Cordell, Thomas, of Peterborowe, Nhants, mercer 1
4338787 2143320 2143320 defendant Shute John gent 636343 636343 Shute, John, of Peterborowe, Nhants, or of St Ives, Hunts, gent 0
4346026 2145867 2145867 defendant Austyn Thomas shoemaker 636343 636343 Austyn, Thomas, of Peterborowe, Nhants, shoemaker 1
4352170 2147995 2147995 defendant Bellingham Nicholas vintner 636343 636343 Bellingham, Nicholas, of Peterborowe, Nhants, vintner 0
4353112 2148317 2148317 defendant Foster Anthony   636343 636343 Foster, Anthony, of Peterborowe, Nhants, rough mason 0
4359862 2150690 2150690 defendant Robinson William chapman 636343 636343 Robinson, William, of Peterborowe, Nhants, chapman 2
4372063 2155071 2155071 defendant Sculthorpe Robert glover 636343 636343 Sculthorpe, Robert, of Peterborowe, Nhants, glover 0
4387953 2160599 2160599 defendant Manestry Thomas tanner 636343 636343 Manestry, Thomas, of Peterborowe, Nhants, tanner 0
5452144 2490517 2490517 defendant Kirkeham Robert gent 636343 636343 Kirkeham, Robert, of Peterborowe, Nhants, gent 0
5464062 2494163 2494163 defendant Kyrkham Robert gent 636343 636343 Kyrkham, Robert, of Peterborowe, Nhants, gent 0
5472640 2496783 2496783 defendant Kyrkeham Robert gent 636343 636343 Kyrkeham, Robert, of Peterborowe, Nhants, gent 0
5475632 2497709 2497709 defendant Kyrkeham Robert gent 636343 636343 Kyrkeham, Robert, of Peterborowe, Nhants, gent 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);