names

15 rows where case_id = 2315916

✎ 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
4864650 2315916 2315916 plaintiff (not given)   abbot of Fountains Abbey   Fountains Abbey, abbot of 0
4864651 2315916 2315916 defendant Lounde Roger gent 590526 590526 Lounde, Roger, of Masham, gent 0
4864652 2315916 2315916 defendant Stanelay or Stavelay John gent 614922 614922 Stanelay or Stavelay, John, of Swynton, gent 1
4864653 2315916 2315916 defendant Neuton John gent 590526 590526 Neuton, John, of Masham, gent 2
4864654 2315916 2315916 defendant Beeston William yeoman 590526 590526 Beeston, William, of Masham, yeoman 3
4864655 2315916 2315916 defendant Estby Thomas yeoman 590526 590526 Estby, Thomas, of Masham, yeoman 4
4864656 2315916 2315916 defendant Mendfaut William yeoman 590526 590526 Mendfaut, William, of Masham, yeoman 5
4864657 2315916 2315916 defendant Walker Richard yeoman 590526 590526 Walker, Richard, of Masham, yeoman 6
4864658 2315916 2315916 defendant Fydeler William yeoman 590526 590526 Fydeler, William, of Masham, yeoman 7
4864659 2315916 2315916 defendant Pikergill William yeoman 814552 814552 Pikergill, William, of Ilketon, yeoman 8
4864660 2315916 2315916 defendant Jonson Thomas yeoman 814552 814552 Jonson, Thomas, of Ilketon, yeoman 9
4864661 2315916 2315916 defendant Horsman William, junior yeoman 814552 814552 Horsman, William, junior, of Ilketon, yeoman 10
4864662 2315916 2315916 defendant Horsman William, senior yeoman 814552 814552 Horsman, William, senior, of Ilketon, yeoman 11
4864663 2315916 2315916 defendant Lamhyrd Thomas yeoman 814552 814552 Lamhyrd, Thomas, of Ilketon, yeoman 12
4864664 2315916 2315916 defendant Looge Thomas yeoman 814552 814552 Looge, Thomas, of Ilketon, yeoman 13

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