names

23 rows where place_id = 667234

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3984351 2019160 2019160 defendant Stawper George yeoman 667234 667234 Stawper, George, of Nettleton, yeoman 15
4034842 2037136 2037136 defendant Snell or Suell Ellen widow 667234 667234 Snell or Suell, Ellen, of Nettleton, widow 0
4049054 2042106 2042106 defendant Taylor Richard husbandman 667234 667234 Taylor, Richard, of Nettleton, husbandman 0
4067114 2048536 2048536 defendant Jones John husbandman 667234 667234 Jones, John, of Nettleton, husbandman 0
4078295 2052537 2052537 defendant Taylor Richard yeoman 667234 667234 Taylor, Richard, of Nettleton, yeoman 2
4171045 2085354 2085354 defendant Adyson Peter mercer 667234 667234 Adyson, Peter, of Nettleton, mercer 3
4171049 2085355 2085355 defendant Adison Peter mercer 667234 667234 Adison, Peter, of Nettleton, mercer 2
4174890 2086683 2086683 defendant Ware William yeoman 667234 667234 Ware, William, of Nettleton, yeoman 2
4174895 2086684 2086684 defendant Ware William yeoman 667234 667234 Ware, William, of Nettleton, yeoman 2
4224462 2104037 2104037 defendant Warr William yeoman 667234 667234 Warr, William, of Nettleton, yeoman 1
4231664 2106577 2106577 defendant Frankishe Hugh yeoman 667234 667234 Frankishe, Hugh, of Nettleton, yeoman 0
4232642 2106920 2106920 defendant Warr William yeoman 667234 667234 Warr, William, of Nettleton, yeoman 1
4277178 2121950 2121950 defendant Tayler Richard yeoman 667234 667234 Tayler, Richard, of Nettleton, yeoman 3
4277183 2121951 2121951 defendant Tailer Richard yeoman 667234 667234 Tailer, Richard, of Nettleton, yeoman 3
4277187 2121952 2121952 defendant Bradshawe James laborer 667234 667234 Bradshawe, James, of Nettleton, laborer 2
4277191 2121953 2121953 defendant Bradshawe James laborer 667234 667234 Bradshawe, James, of Nettleton, laborer 2
4279823 2122859 2122859 defendant Taler Richard butcher 667234 667234 Taler, Richard, of Nettleton, butcher 1
4340639 2143995 2143995 defendant Tilson Thomas yeoman 667234 667234 Tilson, Thomas, of Nettleton juxta Caister, yeoman 0
4353326 2148387 2148387 defendant Nicolls Robert husbandman 667234 667234 Nicolls, Robert, of Nettleton, husbandman 0
4360170 2150800 2150800 defendant Grantham Hamond laborer 667234 667234 Grantham, Hamond, of Nettleton, laborer 3
4361421 2151249 2151249 defendant Newton Nicholas yeoman 667234 667234 Newton, Nicholas, of Nettleton, yeoman 0
4361434 2151252 2151252 defendant Newton Nicholas yeoman 667234 667234 Newton, Nicholas, of Nettleton, yeoman 0
4381049 2158337 2158337 defendant Redman Arthur laborer 667234 667234 Redman, Arthur, of Nettleton, laborer 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);