names

17 rows where case_id = 2291022

✎ 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
4784069 2291022 2291022 plaintiff de Wadyngton Henry     de Wadyngton, Henry 0
4784070 2291022 2291022 defendant Pilkynton John   801793 801793 Pilkynton, John, of Pilkynton, Lancs, knight 0
4784071 2291022 2291022 defendant Dalton Richard gent 801794 801794 Dalton, Richard, of Byspam, Lancs, gent 1
4784072 2291022 2291022 defendant Scarysbrek Henry gent 801795 801795 Scarysbrek, Henry, of Scarysbrek, Lancs, gent 2
4784073 2291022 2291022 defendant Pilkynton Alexander gent 801796 801796 Pilkynton, Alexander, of Rovynton, Lancs, gent 3
4784074 2291022 2291022 defendant Halsall Henry son of Halsall, Robert, of Halsall, Lancs, gent   Halsall, Henry, son of Halsall, Robert, of Halsall, Lancs, gent 4
4784075 2291022 2291022 defendant Barton Thomas son of Barton, Gilbert, of Barton, Lancs, gent   Barton, Thomas, son of Barton, Gilbert, of Barton, Lancs, gent 5
4784076 2291022 2291022 defendant Holte Peter son of Holte, Robert, of Bere, Lancs, gent   Holte, Peter, son of Holte, Robert, of Bere, Lancs, gent 6
4784077 2291022 2291022 defendant Holte Geoffrey son of Holte, Robert, of Bere, Lancs, gent   Holte, Geoffrey, son of Holte, Robert, of Bere, Lancs, gent 7
4784078 2291022 2291022 defendant Bradshagh John gent 801797 801797 Bradshagh, John, of Bradshagh, Lancs, gent 8
4784079 2291022 2291022 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4784080 2291022 2291022 defendant Levir William gent 801798 801798 Levir, William, of Levir, Lancs, gent 10
4784081 2291022 2291022 defendant Levir Henry gent 801799 801799 Levir, Henry, of Levir, gent 11
4784082 2291022 2291022 defendant Levir Roger gent 801800 801800 Levir, Roger, of Lostok, Lancs, gent 12
4784083 2291022 2291022 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4784084 2291022 2291022 defendant Prestwych Edmund gent 725790 725790 Prestwych, Edmund, of Chetam, Lancs, gent 14
4784085 2291022 2291022 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);