names

29 rows where case_id = 2389358

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5110028 2389358 2389358 plaintiff Graystok Ralph knight, Lord Graystok   Graystok, Ralph, knight, Lord Graystok 0
5110029 2389358 2389358 defendant Eles Robert esq 596031 596031 Eles, Robert, of Everyngham, esq 0
5110030 2389358 2389358 defendant Lee John clerk 596031 596031 Lee, John, of Everyngham, clerk 1
5110031 2389358 2389358 defendant Metham Henry gent 596031 596031 Metham, Henry, of Everyngham, gent 2
5110032 2389358 2389358 defendant Hotham Stephen   596031 596031 Hotham, Stephen, of Everyngham, franklin 3
5110033 2389358 2389358 defendant Atkynson William yeoman 596031 596031 Atkynson, William, of Everyngham, yeoman 4
5110034 2389358 2389358 defendant Armet Richard yeoman 596031 596031 Armet, Richard, of Everyngham, yeoman 5
5110035 2389358 2389358 defendant Barcroft Thomas yeoman 596031 596031 Barcroft, Thomas, of Everyngham, yeoman 6
5110036 2389358 2389358 defendant Barcroft Henry yeoman 596031 596031 Barcroft, Henry, of Everyngham, yeoman 7
5110037 2389358 2389358 defendant Colson Richard yeoman 596031 596031 Colson, Richard, of Everyngham, yeoman 8
5110038 2389358 2389358 defendant Holand John yeoman 596031 596031 Holand, John, of Everyngham, yeoman 9
5110039 2389358 2389358 defendant Kalowe Robert yeoman 596031 596031 Kalowe, Robert, of Everyngham, yeoman 10
5110040 2389358 2389358 defendant Syreson Oliver chaplain 596031 596031 Syreson, Oliver, of Everyngham, chaplain 11
5110041 2389358 2389358 defendant Atkynson Robert yeoman 596031 596031 Atkynson, Robert, of Everyngham, yeoman 12
5110042 2389358 2389358 defendant Perkynson John laborer 596031 596031 Perkynson, John, of Everyngham, laborer 13
5110043 2389358 2389358 defendant Santon John laborer 596031 596031 Santon, John, of Everyngham, laborer 14
5110044 2389358 2389358 defendant Atkynson Robert husbandman 596031 596031 Atkynson, Robert, of Everyngham, husbandman 15
5110045 2389358 2389358 defendant Spenser Thomas husbandman 596031 596031 Spenser, Thomas, of Everyngham, husbandman 16
5110046 2389358 2389358 defendant Skate John husbandman 596031 596031 Skate, John, of Everyngham, husbandman 17
5110047 2389358 2389358 defendant Grene Stephen husbandman 596031 596031 Grene, Stephen, of Everyngham, husbandman 18
5110048 2389358 2389358 defendant Tove Thomas husbandman 596031 596031 Tove, Thomas, of Everyngham, husbandman 19
5110049 2389358 2389358 defendant Smyth John husbandman 596031 596031 Smyth, John, of Everyngham, husbandman 20
5110050 2389358 2389358 defendant Wryght Robert husbandman 596031 596031 Wryght, Robert, of Everyngham, husbandman 21
5110051 2389358 2389358 defendant Atkynson Robert clerk 596031 596031 Atkynson, Robert, of Everyngham, clerk 22
5110052 2389358 2389358 defendant Atkynson Robert laborer 596031 596031 Atkynson, Robert, of Everyngham, laborer 23
5110053 2389358 2389358 defendant Hesell John husbandman 596031 596031 Hesell, John, of Everyngham, husbandman 24
5110054 2389358 2389358 defendant Rashell Robert husbandman 596031 596031 Rashell, Robert, of Everyngham, husbandman 25
5110055 2389358 2389358 defendant Grene John yeoman 596031 596031 Grene, John, of Everyngham, yeoman 26
5110056 2389358 2389358 defendant Armet Thomas husbandman 596031 596031 Armet, Thomas, of Everyngham, husbandman 27

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