names

27 rows where place_id = 698566

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4124731 2069139 2069139 defendant Drax Anthony smith 698566 698566 Drax, Anthony, of Messingham, smith 3
4136268 2073316 2073316 defendant Porter Nicholas shoemaker 698566 698566 Porter, Nicholas, of Messingham, shoemaker 0
4140282 2074767 2074767 defendant Steper Christopher laborer 698566 698566 Steper, Christopher, of Messingham, laborer 1
4159280 2081316 2081316 defendant Wighen William clerk 698566 698566 Wighen, William, of Messingham, clerk 0
4169912 2084972 2084972 defendant Mawger Robert husbandman 698566 698566 Mawger, Robert, of Messingham, husbandman 1
4172875 2085967 2085967 defendant Sewrsbe Andrew smith 698566 698566 Sewrsbe, Andrew, of Messingham, smith 1
4184329 2090020 2090020 defendant Stevenson John husbandman 698566 698566 Stevenson, John, of Messingham, husbandman 0
4193229 2093201 2093201 defendant Mawger Robert husabandman 698566 698566 Mawger, Robert, of Messingham, husabandman 1
4225169 2104273 2104273 defendant Suthill Nicholas gent 698566 698566 Suthill, Nicholas, of Messingham, gent 0
4225170 2104273 2104273 defendant Harryson John yeoman 698566 698566 Harryson, John, of Messingham, yeoman 1
4232535 2106882 2106882 defendant Steper James maltster 698566 698566 Steper, James, of Messingham, yeoman, maltster 0
4232574 2106896 2106896 defendant Southill Nicholas gent 698566 698566 Southill, Nicholas, of Messingham, gent 1
4239156 2109319 2109319 defendant Harrys William carpenter 698566 698566 Harrys William, of Messingham, carpenter 2
4247543 2112166 2112166 defendant Harrys William carpenter 698566 698566 Harrys, William, of Messingham, carpenter 1
4251595 2113518 2113518 defendant Suthill Nicholas gent 698566 698566 Suthill, Nicholas, of Messingham, gent 0
4251596 2113518 2113518 defendant Harryson John yeoman 698566 698566 Harryson, John, of Messingham, yeoman 1
4277725 2122133 2122133 defendant Southill Nicholas gent 698566 698566 Southill, Nicholas, of Messingham, gent 1
4280233 2122991 2122991 defendant Harryson John yeoman 698566 698566 Harryson, John, of Messingham, yeoman 2
4282665 2123840 2123840 defendant Southill Nicholas gent 698566 698566 Southill, Nicholas, of Messingham, gent 0
4299552 2129928 2129928 defendant Duckley or Duckell John husbandman 698566 698566 Duckley or Duckell, John, of Messingham, husbandman 1
4348754 2146825 2146825 defendant Freman Gerrard yeoman 698566 698566 Freman, Gerrard, of Messingham, yeoman 0
4348755 2146825 2146825 defendant Freeman Alice widow 698566 698566 Freeman, Alice, of Messingham, widow 1
4355042 2148983 2148983 defendant Rowbotham Richard clerk 698566 698566 Rowbotham, Richard, of Messingham, clerk 0
4359270 2150477 2150477 defendant Harom William blacksmith 698566 698566 Harom, William, of Messingham, blacksmith 0
4360644 2150976 2150976 defendant Hopkynson Edward gent 698566 698566 Hopkynson, Edward, of Messingham, gent 0
4376116 2156521 2156521 defendant Steper James yeoman 698566 698566 Steper, James, of Messingham, yeoman 2
4376135 2156529 2156529 defendant Rowbotham Richard clerk 698566 698566 Rowbotham, Richard, of Messingham, clerk 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);