names

17 rows where case_id = 2291021

✎ 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
4784052 2291021 2291021 plaintiff de Wadyngton Henry     de Wadyngton, Henry 0
4784053 2291021 2291021 defendant Pilkynton John   801793 801793 Pilkynton, John, of Pilkynton, Lancs, knight 0
4784054 2291021 2291021 defendant Dalton Richard gent 801794 801794 Dalton, Richard, of Byspam, Lancs, gent 1
4784055 2291021 2291021 defendant Straysbrok Henry gent 801891 801891 Straysbrok, Henry, of Straysbrok, Lancs, gent 2
4784056 2291021 2291021 defendant Pilkynton Alexander gent 801796 801796 Pilkynton, Alexander, of Rovynton, Lancs, gent 3
4784057 2291021 2291021 defendant Halsall Henry son of Halsall, Robert, of Halsall, Lancs, gent   Halsall, Henry, son of Halsall, Robert, of Halsall, Lancs, gent 4
4784058 2291021 2291021 defendant Bartour Thomas son of Bartour, Gilbert, of Barton, Lancs, gent   Bartour, Thomas, son of Bartour, Gilbert, of Barton, Lancs, gent 5
4784059 2291021 2291021 defendant Holte Peter son of Holte, Robert, of Bere, Lancs, gent   Holte, Peter, son of Holte, Robert, of Bere, Lancs, gent 6
4784060 2291021 2291021 defendant Holte Geoffrey son of Holte, Robert, of Bere, Lancs, gent   Holte, Geoffrey, son of Holte, Robert, of Bere, Lancs, gent 7
4784061 2291021 2291021 defendant Bradshagh John gent 801797 801797 Bradshagh, John, of Bradshagh, Lancs, gent 8
4784062 2291021 2291021 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4784063 2291021 2291021 defendant Levir William gent 801798 801798 Levir, William, of Levir, Lancs, gent 10
4784064 2291021 2291021 defendant Levir Henry gent 801799 801799 Levir, Henry, of Levir, gent 11
4784065 2291021 2291021 defendant Levir Roger gent 801800 801800 Levir, Roger, of Lostok, Lancs, gent 12
4784066 2291021 2291021 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4784067 2291021 2291021 defendant Prestwych Edmund gent 725790 725790 Prestwych, Edmund, of Chetam, Lancs, gent 14
4784068 2291021 2291021 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);