names

11 rows where place_id = 767402

✎ 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
4539027 2212474 2212474 defendant Cook Richard   767402 767402 Cook, Richard, of Caresbroke 6
4561381 2219506 2219506 defendant Rake William   767402 767402 Rake, William, of Caresbroke 0
4645443 2244734 2244734 defendant Ulmys Odo de   767402 767402 Ulmys, Odo de, of Caresbroke, prior 0
4825124 2303900 2303900 defendant Lyghtfot John, junior laborer 767402 767402 Lyghtfot, John, junior, of Caresbroke, laborer 0
4960193 2345020 2345020 defendant Webbe William laborer 767402 767402 Webbe, William, of Caresbroke, laborer 2
5145897 2399925 2399925 defendant Whiteborn Thomas husbandman 767402 767402 Whiteborn, Thomas, of Caresbroke, husbandman 14
5155194 2402667 2402667 defendant Bodenham Robert gent 767402 767402 Bodenham, Robert, of Caresbroke, gent 1
5190257 2412891 2412891 defendant Bodenham Robert gent 767402 767402 Bodenham, Robert, of Caresbroke, gent 1
5202644 2416534 2416534 defendant Whoteborn Thomas weaver 767402 767402 Whoteborn, Thomas, of Caresbroke, weaver 14
5356884 2462214 2462214 defendant Lonyng or Lovyng William yeoman 767402 767402 Lonyng or Lovyng, William, of Caresbroke, yeoman 0
5356885 2462214 2462214 defendant Stratteford John yeoman 767402 767402 Stratteford, John, of Caresbroke, 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);