names

17 rows where case_id = 2290820

✎ 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
4783365 2290820 2290820 plaintiff de Assheton John knight   de Assheton, John, knight 0
4783366 2290820 2290820 defendant Pilkynton John   801793 801793 Pilkynton, John, of Pilkynton, Lancs, knight 0
4783367 2290820 2290820 defendant Dalton Richard gent 801794 801794 Dalton, Richard, of Byspam, Lancs, gent 1
4783368 2290820 2290820 defendant Scarysbrek Henry gent 801795 801795 Scarysbrek, Henry, of Scarysbrek, Lancs, gent 2
4783369 2290820 2290820 defendant Pilkynton Alexander gent 801796 801796 Pilkynton, Alexander, of Rovynton, Lancs, gent 3
4783370 2290820 2290820 defendant Halsall Henry son of Halsall, Robert, of Halsall, Lancs, gent   Halsall, Henry, son of Halsall, Robert, of Halsall, Lancs, gent 4
4783371 2290820 2290820 defendant Barton Thomas son of Barton, Gilbert, of Barton, Lancs, gent   Barton, Thomas, son of Barton, Gilbert, of Barton, Lancs, gent 5
4783372 2290820 2290820 defendant Holte Peter son of Holte, Robert, of Bere, Lancs, gent   Holte, Peter, son of Holte, Robert, of Bere, Lancs, gent 6
4783373 2290820 2290820 defendant Holte Geoffrey son of Holte, Robert, of Bere, Lancs, gent   Holte, Geoffrey, son of Holte, Robert, of Bere, Lancs, gent 7
4783374 2290820 2290820 defendant Bradshagh John gent 801797 801797 Bradshagh, John, of Bradshagh, Lancs, gent 8
4783375 2290820 2290820 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4783376 2290820 2290820 defendant Levir William gent 801798 801798 Levir, William, of Levir, Lancs, gent 10
4783377 2290820 2290820 defendant Levir Henry gent 801799 801799 Levir, Henry, of Levir, gent 11
4783378 2290820 2290820 defendant Levir Roger gent 801800 801800 Levir, Roger, of Lostok, Lancs, gent 12
4783379 2290820 2290820 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4783380 2290820 2290820 defendant Prestwych Edmund gent 725790 725790 Prestwych, Edmund, of Chetam, Lancs, gent 14
4783381 2290820 2290820 defendant Chernok Edward gent 801801 801801 Chernok, Edward, of Eukeston, Lancs, gent 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);