names

25 rows where place_id = 603745

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3655662 1912034 1912034 defendant Very Luke husbandman 603745 603745 Very, Luke, of Benteley, husbandman 1
3882427 1984387 1984387 defendant Heys John husbandman 603745 603745 Heys, John, of Benteley, husbandman 1
4147886 2077396 2077396 defendant Will Margery widow 603745 603745 Will, Margery, of Benteley, widow 1
4178521 2087964 2087964 defendant Beche John yeoman 603745 603745 Beche, John, of Benteley, yeoman 2
4218903 2102106 2102106 defendant Addams Margery widow 603745 603745 Addams, Margery, of Benteley, widow 3
4451002 2185281 2185281 defendant Hobbe William   603745 603745 Hobbe, William, of Benteley 0
4500297 2200719 2200719 defendant Taillour Ralph   603745 603745 Taillour, Ralph, of Benteley 3
4504536 2201977 2201977 defendant Byrcheley Thomas   603745 603745 Byrcheley, Thomas, of Benteley 0
4504537 2201977 2201977 defendant Byrcheley Richard   603745 603745 Byrcheley, Richard, of Benteley 1
4531397 2210091 2210091 plaintiff Peek William   603745 603745 Peek, William, of Benteley 0
4556766 2218050 2218050 defendant Talmage Richard   603745 603745 Talmage, Richard, of Benteley 0
4600416 2231356 2231356 defendant Nicolson John   603745 603745 Nicolson, John, of Benteley 1
4700878 2265675 2265675 defendant Wely Thomas husbandman 603745 603745 Wely, Thomas, of Benteley, husbandman 0
4735043 2276108 2276108 defendant Ryche Joan spinster 603745 603745 Ryche, Joan, of Benteley, spinster 0
4770824 2286855 2286855 defendant Brandeston John husbandman 603745 603745 Brandeston, John, of Benteley, husbandman 0
4851439 2311896 2311896 defendant Norman John husbandman 603745 603745 Norman, John, of Benteley, husbandman 1
4879428 2320497 2320497 defendant Norewode John husbandman 603745 603745 Norewode, John, of Benteley, husbandman 2
4915186 2331256 2331256 defendant Wode Edmund yeoman 603745 603745 Wode, Edmund, of Benteley, yeoman 1
4938133 2338306 2338306 defendant Branston or Brauston Thomas yeoman 603745 603745 Branston or Brauston, Thomas, of Benteley, yeoman 2
5064532 2375929 2375929 defendant Waterman John husbandman 603745 603745 Waterman, John, of Benteley, husbandman 1
5259562 2433112 2433112 defendant Ranye Robert, junior yeoman 603745 603745 Ranye, Robert, junior, of Benteley, yeoman 3
5300611 2445144 2445144 defendant Burgeys John yeoman 603745 603745 Burgeys, John, of Benteley, yeoman 0
5346996 2459218 2459218 defendant Burton Peter   603745 603745 Burton, Peter, of Benteley, yeoman, son of Burton, Nicholas 6
5553381 2521029 2521029 defendant Lewes Thomas husbandman 603745 603745 Lewes, Thomas, of Benteley, husbandman 0
5553382 2521029 2521029 defendant Hardyng William yeoman 603745 603745 Hardyng, William, of Benteley, yeoman 1

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);