names

35 rows where place_id = 671006

✎ 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
3958462 2010030 2010030 defendant Hevyngham Jane singlewoman 671006 671006 Hevyngham, Jane, of Baconsthorpe, singlewoman 1
3999813 2024696 2024696 plaintiff Gasington or Easington William   671006 671006 Gasington or Easington, William, of Baconsthorpe 0
3999819 2024699 2024699 plaintiff Gasington William   671006 671006 Gasington, William, of Baconsthorpe 0
3999822 2024700 2024700 plaintiff Gasington William   671006 671006 Gasington, William, of Baconsthorpe 0
3999825 2024701 2024701 plaintiff Gasington William   671006 671006 Gasington, William, of Baconsthorpe 0
4022529 2032782 2032782 defendant Sheparde Robert husbandman 671006 671006 Sheparde, Robert, of Baconsthorpe, husbandman 1
4026954 2034292 2034292 plaintiff Cawston Anthony yeoman 671006 671006 Cawston, Anthony, of Baconsthorpe, yeoman 0
4027020 2034311 2034311 defendant Shepperd Robert husbandman 671006 671006 Shepperd, Robert, of Baconsthorpe, husbandman 1
4039472 2038742 2038742 plaintiff Mallett Mathew yeoman 671006 671006 Mallett, Mathew, of Baconsthorpe, yeoman 0
4073399 2050773 2050773 defendant Sheppard Thomas butcher 671006 671006 Sheppard, Thomas, of Baconsthorpe, butcher 0
4073405 2050774 2050774 defendant Sheppard Thomas butcher 671006 671006 Sheppard, Thomas, of Baconsthorpe, butcher 2
4100633 2060551 2060551 defendant Shepperd Thomas butcher 671006 671006 Shepperd, Thomas, of Baconsthorpe, butcher 2
4150748 2078402 2078402 defendant Dowe John carpenter 671006 671006 Dowe, John, of Baconsthorpe, carpenter 0
4179849 2088427 2088427 defendant Cantrell Ralph gent 671006 671006 Cantrell, Ralph, of Baconsthorpe, gent 0
4183663 2089773 2089773 defendant Haydon William   671006 671006 Haydon, William, of Baconsthorpe, knight, sheriff of Norf 0
4183760 2089809 2089809 defendant Haydon William   671006 671006 Haydon, William, of Baconsthorpe, knight, sheriff of Norf 0
4187350 2091077 2091077 defendant Hayden William   671006 671006 Hayden, William, of Baconsthorpe, knight, sheriff 0
4204797 2097222 2097222 defendant Burward John clerk 671006 671006 Burward, John, of Baconsthorpe, clerk 1
4252441 2113809 2113809 defendant Beare Simon husbandman 671006 671006 Beare, Simon, of Baconsthorpe, husbandman 0
4256594 2115176 2115176 defendant Burwarde John clerk 671006 671006 Burwarde, John, of Baconsthorpe, clerk 1
4256595 2115176 2115176 defendant Dyxe George   671006 671006 Dyxe, George, of Baconsthorpe, worsted weaver 2
4281278 2123361 2123361 defendant Rowland Thomas, junior yeoman 671006 671006 Rowland, Thomas, junior, of Baconsthorpe, yeoman 1
4281282 2123362 2123362 defendant Rowlande Thomas, junior yeoman 671006 671006 Rowlande, Thomas, junior, of Baconsthorpe, yeoman 1
4286330 2125156 2125156 defendant Heydon Christopher esq 671006 671006 Heydon, Christopher, of Baconsthorpe, or of Sherington, esq 0
4311613 2134204 2134204 defendant Rowland Thomas, junior yeoman 671006 671006 Rowland, Thomas, junior, of Baconsthorpe, yeoman 2
4324123 2138473 2138473 defendant Rowland Thomas, junior yeoman 671006 671006 Rowland, Thomas, junior, of Baconsthorpe, yeoman 2
4329481 2140166 2140166 defendant Heydon Christopher esq 671006 671006 Heydon, Christopher, of Baconsthorpe, or of Sherington, Norf, esq 0
4331890 2140959 2140959 defendant Haydon Christopher esq 671006 671006 Haydon, Christopher, of Baconsthorpe, or of Sherington, Norf, esq 0
4337152 2142721 2142721 defendant Rowland Thomas, junior yeoman 671006 671006 Rowland, Thomas, junior, of Baconsthorpe, yeoman 0
4337346 2142795 2142795 defendant Heydon Christopher esq 671006 671006 Heydon, Christopher, of Baconsthorpe, or of Saxlingham, Norf, esq 0
4383050 2159044 2159044 defendant Rowland John yeoman 671006 671006 Rowland, John, of Baconsthorpe, yeoman 2
4389547 2161131 2161131 defendant Parre Christopher yeoman 671006 671006 Parre, Christopher, of Baconsthorpe, yeoman 0
4398565 2164100 2164100 defendant Heydon Christopher   671006 671006 Heydon, Christopher, of Baconsthorpe, knight 0
4409351 2167725 2167725 defendant Burward John clerk 671006 671006 Burward, John, of Baconsthorpe, clerk 1
5268383 2435879 2435879 defendant Loksmyth John husbandman 671006 671006 Loksmyth, John, of Baconsthorpe, husbandman 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);