names

16 rows where case_id = 2361558

✎ 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
5015955 2361558 2361558 plaintiff Brompton John abbot of Jorevall Abbey   Brompton, John, abbot of Jorevall Abbey 0
5015956 2361558 2361558 defendant Parkour Roger chaplain 590526 590526 Parkour, Roger, of Masham, chaplain 0
5015957 2361558 2361558 defendant Smerthwayte Thomas yeoman 590526 590526 Smerthwayte, Thomas, of Masham, yeoman 1
5015958 2361558 2361558 defendant Hoton George yeoman 671152 671152 Hoton, George, of Constable Burton, yeoman 2
5015959 2361558 2361558 defendant Loblay William yeoman 802193 802193 Loblay, William, of Leghton, Masham, yeoman 3
5015960 2361558 2361558 defendant Rawe Thomas yeoman 835477 835477 Rawe, Thomas, of Clyfron juxta Masham, yeoman 4
5015961 2361558 2361558 defendant Bayn William yeoman 835478 835478 Bayn, William, of Swynton juxta Masham, yeoman 5
5015962 2361558 2361558 defendant Bayn John yeoman 835479 835479 Bayn, John, of Stubbarcote juxta Feerby, yeoman 6
5015963 2361558 2361558 defendant Horsman William yeoman 835480 835480 Horsman, William, of Ilton juxta Masham, yeoman 7
5015964 2361558 2361558 defendant Ketiswell Richard yeoman 590526 590526 Ketiswell, Richard, of Masham, yeoman 8
5015965 2361558 2361558 defendant Ecok Ralph yeoman 590526 590526 Ecok, Ralph, of Masham, yeoman 9
5015966 2361558 2361558 defendant Broun John laborer 590526 590526 Broun, John, of Masham, laborer 10
5015967 2361558 2361558 defendant Brigges William   590526 590526 Brigges, William, of Masham, parish clerk 11
5015968 2361558 2361558 defendant Ecok William laborer 590526 590526 Ecok, William, of Masham, laborer 12
5015969 2361558 2361558 defendant Horsman William laborer 835482 835482 Horsman, William, of Helay juxta Masham, laborer 13
5015970 2361558 2361558 defendant Craven William laborer 590526 590526 Craven, William, of Masham, laborer 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);