names

28 rows where place_id = 683736

✎ 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
4055225 2044263 2044263 defendant London Thomas yeoman 683736 683736 London, Thomas, of Foulsham, yeoman 0
4072987 2050637 2050637 defendant Olyver William husbandman 683736 683736 Olyver, William, of Foulsham, husbandman 0
4094977 2058532 2058532 defendant Ferrour Nicholas yeoman 683736 683736 Ferrour, Nicholas, of Foulsham, yeoman 0
4094978 2058532 2058532 defendant Pynchbeck Richard gent 683736 683736 Pynchbeck, Richard, of Foulsham, gent 1
4094979 2058532 2058532 defendant Hopkyns Edmund gent 683736 683736 Hopkyns, Edmund, of Foulsham, gent 2
4147850 2077385 2077385 defendant Kent William yeoman 683736 683736 Kent, William, of Foulsham, yeoman 1
4153930 2079471 2079471 defendant Hegward Robert butcher 683736 683736 Hegward , Robert, of Foulsham, butcher 1
4162771 2082536 2082536 defendant Rust Richard mercer 683736 683736 Rust, Richard, of Foulsham, mercer 2
4163857 2082886 2082886 defendant Heyward Robert butcher 683736 683736 Heyward, Robert, of Foulsham, butcher 0
4215730 2100998 2100998 defendant Bate Robert husbandman 683736 683736 Bate, Robert, of Foulsham, husbandman 3
4225117 2104253 2104253 defendant Bate Robert husbandman 683736 683736 Bate, Robert, of Foulsham, husbandman 3
4242549 2110505 2110505 defendant Hunt William gent 683736 683736 Hunt, William, of Foulsham, gent 2
4242554 2110506 2110506 defendant Hunt William gent 683736 683736 Hunt, William, of Foulsham, gent 3
4278708 2122487 2122487 defendant Elmyn John tailor 683736 683736 Elmyn, John, of Foulsham, tailor 2
4288437 2125912 2125912 defendant Engledewe John yeoman 683736 683736 Engledewe, John, of Foulsham, yeoman 2
4288441 2125913 2125913 defendant Roysse William yeoman 683736 683736 Roysse, William, of Foulsham, yeoman 1
4291589 2127070 2127070 defendant Themblethorpp George gent 683736 683736 Themblethorpp, George, of Foulsham, gent 0
4318889 2136719 2136719 defendant Lavile John gent 683736 683736 Lavile, John, of Foulsham, gent 0
4318890 2136719 2136719 defendant Brigg Edward gent 683736 683736 Brigg, Edward, of Foulsham, gent 1
4318892 2136719 2136719 defendant Ibbott Edward joiner 683736 683736 Ibbott, Edward, of Foulsham, joiner 3
4331826 2140936 2140936 defendant Ingledewe John chapman 683736 683736 Ingledewe, John, of Foulsham, chapman 2
4338441 2143195 2143195 defendant Framyngham Christopher tanner 683736 683736 Framyngham, Christopher, of Foulsham, tanner 0
4358858 2150332 2150332 defendant Hempsted William yeoman 683736 683736 Hempsted, William, of Foulsham, yeoman 0
4380159 2158007 2158007 defendant Lavyle John gent 683736 683736 Lavyle, John, of Foulsham, gent 0
4386524 2160167 2160167 defendant Dyamond Simon yeoman 683736 683736 Dyamond, Simon, of Foulsham, yeoman 2
4386525 2160167 2160167 defendant Juler or Inler Nicholas yeoman 683736 683736 Juler or Inler, Nicholas, of Foulsham, yeoman 3
4386526 2160167 2160167 defendant Anfle Philip yeoman 683736 683736 Anfle, Philip, of Foulsham, yeoman 4
4395513 2163082 2163082 defendant Lavyle John gent 683736 683736 Lavyle, John, of Foulsham, 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);