names

17 rows where case_id = 2295812

✎ 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
4798830 2295812 2295812 plaintiff Talbot Peter gent   Talbot, Peter, gent 0
4798831 2295812 2295812 defendant Pilkynton John   801793 801793 Pilkynton, John, of Pilkynton, Lancs, knight 0
4798832 2295812 2295812 defendant Dalton Richard gent 801794 801794 Dalton, Richard, of Byspam, Lancs, gent 1
4798833 2295812 2295812 defendant Scarysbrek Henry gent 801795 801795 Scarysbrek, Henry, of Scarysbrek, Lancs, gent 2
4798834 2295812 2295812 defendant Pilkynton Alexander gent 801796 801796 Pilkynton, Alexander, of Rovynton, Lancs, gent 3
4798835 2295812 2295812 defendant Halsall Henry son of Halsall, Robert, of Halsall, Lancs, gent   Halsall, Henry, son of Halsall, Robert, of Halsall, Lancs, gent 4
4798836 2295812 2295812 defendant Barton Thomas son of Barton, Gilbert, of Barton, Lancs, gent   Barton, Thomas, son of Barton, Gilbert, of Barton, Lancs, gent 5
4798837 2295812 2295812 defendant Holte Peter son of Holte, Robert, of Bere, Lancs, gent   Holte, Peter, son of Holte, Robert, of Bere, Lancs, gent 6
4798838 2295812 2295812 defendant Holte Geoffrey son of Holte, Robert, of Bere, Lancs, gent   Holte, Geoffrey, son of Holte, Robert, of Bere, Lancs, gent 7
4798839 2295812 2295812 defendant Bradshagh John gent 801797 801797 Bradshagh, John, of Bradshagh, Lancs, gent 8
4798840 2295812 2295812 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4798841 2295812 2295812 defendant Levir William gent 801798 801798 Levir, William, of Levir, Lancs, gent 10
4798842 2295812 2295812 defendant Levir Henry gent 801799 801799 Levir, Henry, of Levir, gent 11
4798843 2295812 2295812 defendant Levir Roger gent 801800 801800 Levir, Roger, of Lostok, Lancs, gent 12
4798844 2295812 2295812 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4798845 2295812 2295812 defendant Prestwych Edmund gent 725790 725790 Prestwych, Edmund, of Chetam, Lancs, gent 14
4798846 2295812 2295812 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);