names

16 rows where case_id = 2382082

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5085239 2382082 2382082 plaintiff Graystok Ralph Lord Graystok, knight   Graystok, Ralph, Lord Graystok, knight 0
5085240 2382082 2382082 defendant Sclater Nicholas yeoman 756499 756499 Sclater, Nicholas, of Caldebek, yeoman 0
5085241 2382082 2382082 defendant Litster Richard yeoman 756499 756499 Litster, Richard, of Caldebek, yeoman 1
5085242 2382082 2382082 defendant Nycholson John yeoman 756499 756499 Nycholson, John, of Caldebek, yeoman 2
5085243 2382082 2382082 defendant Nycholson Robert yeoman 756499 756499 Nycholson, Robert, of Caldebek, yeoman 3
5085244 2382082 2382082 defendant Todhunter Richard yeoman 756499 756499 Todhunter, Richard, of Caldebek, yeoman 4
5085245 2382082 2382082 defendant Cape Henry yeoman 844622 844622 Cape, Henry, of Chapelhous, Uldale, yeoman 5
5085246 2382082 2382082 defendant Denyson Roger yeoman 756499 756499 Denyson,Roger, of Caldebek, yeoman 6
5085247 2382082 2382082 defendant Richerdson John yeoman 756499 756499 Richerdson, John, of Caldebek, yeoman 7
5085248 2382082 2382082 defendant Key Roger yeoman 844623 844623 Key, Roger, of Milnhous, yeoman 8
5085249 2382082 2382082 defendant Yudale or Yndale Thomas miller 844623 844623 Yudale or Yndale, Thomas, of Milnhous, miller 9
5085250 2382082 2382082 defendant Kempe John, junior yeoman 844624 844624 Kempe, John, junior, of Haltleffebrigg, yeoman 10
5085251 2382082 2382082 defendant Hewar John yeoman 591223 591223 Hewar, John, of Soureby, yeoman 11
5085252 2382082 2382082 defendant Ricardby Richard yeoman 591223 591223 Ricardby, Richard, of Soureby, yeoman 12
5085253 2382082 2382082 defendant Sethwayte Thomas tailor 756499 756499 Sethwayte, Thomas, of Caldebek, tailor 13
5085254 2382082 2382082 defendant Watson William yeoman 756499 756499 Watson, William, of Caldebek, yeoman 14

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