names

19 rows where place_id = 825655

✎ 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
4944999 2340425 2340425 defendant Martyn Roger gent 825655 825655 Martyn, Roger, of North Berkhamstede, gent 0
4945001 2340425 2340425 defendant Whelpley Thomas smith 825655 825655 together with Whelpley, Thomas, of North Berkhamstede, smith 2
4945006 2340427 2340427 defendant Whelpley Thomas smith 825655 825655 Whelpley, Thomas, of North Berkhamstede, smith 0
4945007 2340427 2340427 defendant Martyn Roger gent 825655 825655 together with Martyn, Roger, of North Berkhamstede, gent 1
4948583 2341537 2341537 defendant Exham Thomas writer 825655 825655 Exham, Thomas, of North Berkhamstede, writer 0
4948584 2341537 2341537 defendant Whelpley William laborer 825655 825655 Whelpley, William, of North Berkhamstede, laborer 1
4948585 2341537 2341537 defendant Whelpley Thomas smith 825655 825655 together with Whelpley, Thomas, of North Berkhamstede, smith 2
4948587 2341538 2341538 defendant Whelpley Thomas smith 825655 825655 Whelpley, Thomas, of North Berkhamstede, smith 0
4948588 2341538 2341538 defendant Exham Thomas writer 825655 825655 together with Exham, Thomas, of North Berkhamstede, writer 1
4948589 2341538 2341538 defendant Whelpley William laborer 825655 825655 Whelpley, William, of North Berkhamstede, laborer 2
4948591 2341539 2341539 defendant Hexham Thomas writer 825655 825655 Hexham, Thomas, of North Berkhamstede, writer 0
4957713 2344279 2344279 defendant Whelpele Thomas husbandman 825655 825655 Whelpele, Thomas, of North Berkhamstede, husbandman 0
4962185 2345593 2345593 defendant Whelpeley Thomasd smith 825655 825655 Whelpeley, Thomasd, of North Berkhamstede, smith 0
4994000 2355078 2355078 defendant Whelpley Thomas   825655 825655 Whelpley, Thomas, of North Berkhamstede, shovel maker 0
5006533 2358809 2358809 defendant Whelpley Richard yeoman 825655 825655 Whelpley, Richard, of North Berkhamstede, yeoman 1
5037236 2367760 2367760 defendant Whelpley Thomas husbandman 825655 825655 Whelpley, Thomas, of North Berkhamstede, husbandman 0
5130248 2395334 2395334 defendant Dawebeney William husbandman 825655 825655 Dawebeney, William, of North Berkhamstede, husbandman 0
5214160 2419867 2419867 defendant Whelpley Richard yeoman 825655 825655 Whelpley, Richard, of North Berkhamstede, yeoman 3
5508375 2507494 2507494 defendant Hoverhall or Honerhall Edmund tiler 825655 825655 Hoverhall or Honerhall, Edmund, of North Berkhamstede, tiler 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);