names

26 rows where place_id = 675621

✎ 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
4019384 2031667 2031667 plaintiff Watt Thomas, junior   675621 675621 Watt, Thomas, junior, of Mattishall 0
4122006 2068172 2068172 defendant Rightought Thomas yeoman 675621 675621 Rightought, Thomas, of Mattishall, yeoman 1
4128926 2070643 2070643 defendant Potter alias Warner John yeoman 675621 675621 Potter alias Warner, John, of Mattishall, yeoman 1
4169439 2084814 2084814 defendant Watt John yeoman 675621 675621 Watt, John, of Mattishall, yeoman 0
4169440 2084814 2084814 defendant Watt Thomas yeoman 675621 675621 Watt, Thomas, of Mattishall, yeoman 1
4200219 2095629 2095629 defendant Ryxe or Rick Edmund yeoman 675621 675621 Ryxe or Rick, Edmund, of Mattishall, yeoman 0
4213289 2100162 2100162 defendant Watt Thomss   675621 675621 Watt, Thomss, of Mattishall, wool chapman 3
4219965 2102485 2102485 defendant Elvye Edward butcher 675621 675621 Elvye, Edward, of Mattishall, butcher 0
4245118 2111353 2111353 defendant Long John tailor 675621 675621 Long, John, of Mattishall, tailor 2
4245133 2111360 2111360 defendant Watt Thomas, junior   675621 675621 Watt, Thomas, junior, of Mattishall, wool chapman 0
4252683 2113885 2113885 defendant Croshold Henry grocer 675621 675621 Croshold, Henry, of Mattishall, grocer 0
4252684 2113885 2113885 defendant Baker Robert husbandman 675621 675621 Baker, Robert, of Mattishall, husbandman 1
4254139 2114381 2114381 defendant Whelpdale John yeoman 675621 675621 Whelpdale, John, of Mattishall, yeoman 1
4288231 2125835 2125835 defendant Deane Richard husbandman 675621 675621 Deane, Richard, of Mattishall, husbandman 0
4289692 2126377 2126377 defendant Deane John butcher 675621 675621 Deane, John, of Mattishall, butcher 3
4309998 2133654 2133654 defendant Pilche Thomas grocer 675621 675621 Pilche, Thomas, of Mattishall, grocer 1
4309999 2133654 2133654 defendant Dorman William miller 675621 675621 Dorman, William, of Mattishall, miller 2
4336353 2142451 2142451 defendant Watt James gent 675621 675621 Watt, James, of Mattishall, gent 1
4351197 2147668 2147668 defendant Elnye or Elvye Roger husbandman 675621 675621 Elnye or Elvye, Roger, of Mattishall, husbandman 0
4365008 2152539 2152539 defendant Pylch Thomas grocer 675621 675621 Pylch, Thomas, of Mattishall, grocer 0
4393652 2162480 2162480 defendant Wattes John husbandman 675621 675621 Wattes, John, of Mattishall, husbandman 1
4393653 2162480 2162480 defendant Wattes Thomas husbandman 675621 675621 Wattes, Thomas, of Mattishall, husbandman 2
4403554 2165762 2165762 defendant Ryx Thomas yeoman 675621 675621 Ryx, Thomas, of Mattishall, yeoman 2
4405060 2166268 2166268 defendant Baldwyn Richard yeoman 675621 675621 Baldwyn, Richard, of Mattishall, yeoman 0
4476974 2193458 2193458 defendant Pepyn William   675621 675621 Pepyn, William, of Mattishall 0
5390032 2472211 2472211 defendant Bukle John husbandman 675621 675621 Bukle, John, of Mattishall, husbandman 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);