names

17 rows where case_id = 2317442

✎ 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
4869549 2317442 2317442 plaintiff Langley Thomas Bishop of Durham   Langley, Thomas, Bishop of Durham 0
4869550 2317442 2317442 defendant Bank John   755099 755099 Bank, John, of Neuburgh, organ player 0
4869551 2317442 2317442 defendant del Brewehous Geoffrey baker 613831 613831 del Brewehous, Geoffrey, of Cokwald, baker 1
4869552 2317442 2317442 defendant Kyghley John chaplain 815164 815164 Kyghley, John, of Eddeston, or of Kirkeby Moresheved, chaplain 2
4869553 2317442 2317442 defendant Bailly Henry   769308 769308 Bailly, Henry, of Kirkeby Moresheved, groom 3
4869554 2317442 2317442 defendant Hoggeson Lawrence yeoman 753048 753048 Hoggeson, Lawrence, of Farnedale, yeoman 4
4869555 2317442 2317442 defendant Preston Thomas yeoman 616408 616408 Preston, Thomas, of Brandesby, yeoman 5
4869556 2317442 2317442 defendant Ulthwayt William yeoman 604337 604337 Ulthwayt, William, of Durham, yeoman 6
4869557 2317442 2317442 defendant Spence Robert yeoman 755099 755099 Spence, Robert, of Neuburgh, yeoman 7
4869558 2317442 2317442 defendant Coke Richard   613831 613831 Coke, Richard, of Cokwald, cook 8
4869559 2317442 2317442 defendant Poonthorp William   613317 613317 Poonthorp, William, of Bridford, bailiff 9
4869560 2317442 2317442 defendant Appilton Thomas clerk 616408 616408 Appilton, Thomas, of Brandesby, clerk 10
4869561 2317442 2317442 defendant Gundy Thomas yeoman 634339 634339 Gundy, Thomas, of Sesay, yeoman 11
4869562 2317442 2317442 defendant Robert of Brandesby yeoman   Robert, of Brandesby, yeoman 12
4869563 2317442 2317442 defendant Bank Robert laborer 637117 637117 Bank, Robert, of Rosdale, laborer 13
4869564 2317442 2317442 defendant Recongeay Robert laborer 689481 689481 Recongeay, Robert, of Ulleston, laborer 14
4869565 2317442 2317442 defendant Farnedale John   599633 599633 Farnedale, John, of Stillyngton, wright 15

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