names

17 rows where case_id = 2295074

✎ 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
4796537 2295074 2295074 plaintiff se Assheton John knight   se Assheton, John, knight 0
4796538 2295074 2295074 defendant Pilkynton John   801793 801793 Pilkynton, John, of Pilkynton, Lancs, knight 0
4796539 2295074 2295074 defendant Dalton Richard gent 801794 801794 Dalton, Richard, of Byspam, Lancs, gent 1
4796540 2295074 2295074 defendant Straysbrok Henry gent 801891 801891 Straysbrok, Henry, of Straysbrok, Lancs, gent 2
4796541 2295074 2295074 defendant Pilkynton Alexander gent 801796 801796 Pilkynton, Alexander, of Rovynton, Lancs, gent 3
4796542 2295074 2295074 defendant Halsall Henry son of Halsall, Robert, of Halsall, Lancs, gent   Halsall, Henry, son of Halsall, Robert, of Halsall, Lancs, gent 4
4796543 2295074 2295074 defendant Bartour Thomas son of Bartour, Gilbert, of Barton, Lancs, gent   Bartour, Thomas, son of Bartour, Gilbert, of Barton, Lancs, gent 5
4796544 2295074 2295074 defendant Holte Peter son of Holte, Robert, of Bere, Lancs, gent   Holte, Peter, son of Holte, Robert, of Bere, Lancs, gent 6
4796545 2295074 2295074 defendant Holte Geoffrey son of Holte, Robert, of Bere, Lancs, gent   Holte, Geoffrey, son of Holte, Robert, of Bere, Lancs, gent 7
4796546 2295074 2295074 defendant Bradshagh John gent 801797 801797 Bradshagh, John, of Bradshagh, Lancs, gent 8
4796547 2295074 2295074 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4796548 2295074 2295074 defendant Levir William gent 801798 801798 Levir, William, of Levir, Lancs, gent 10
4796549 2295074 2295074 defendant Levir Henry gent 801799 801799 Levir, Henry, of Levir, gent 11
4796550 2295074 2295074 defendant Levir Roger gent 801800 801800 Levir, Roger, of Lostok, Lancs, gent 12
4796551 2295074 2295074 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4796552 2295074 2295074 defendant Prestwych Edmund gent 725790 725790 Prestwych, Edmund, of Chetam, Lancs, gent 14
4796553 2295074 2295074 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);