names

21 rows where case_id = 2246512

✎ 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
4651777 2246512 2246512 plaintiff Arundell Thomas Archbishop of Canterbury   Arundell, Thomas, Archbishop of Canterbury, executors of 0
4651778 2246512 2246512 plaintiff Humfrevyll Gilbert knight   (Humfrevyll, Gilbert, knight 1
4651779 2246512 2246512 plaintiff (not given)   prior of Christ Church Priory, Canterbury   Christ Church Priory, Canterbury, prior of 2
4651780 2246512 2246512 plaintiff Morgan Philip     Morgan, Philip 3
4651781 2246512 2246512 plaintiff Mylton William     Mylton, William 4
4651782 2246512 2246512 plaintiff Wotton John master of Maydeston College   Wotton, John, master of Maydeston College 5
4651783 2246512 2246512 plaintiff Brokesby Bartholomew     Brokesby, Bartholomew 6
4651784 2246512 2246512 plaintiff Maydeston William     Maydeston, William 7
4651785 2246512 2246512 defendant Knyght Richard husbandman 778081 778081 Knyght, Richard, of Lympne, Kent, husbandman 0
4651786 2246512 2246512 defendant Knyght William husbandman 626765 626765 Knyght, William, of Sellyng, Kent, husbandman 1
4651787 2246512 2246512 defendant Clitherowe William husbandman 778082 778082 Clitherowe, William, of Romene, Kent, husbandman 2
4651788 2246512 2246512 defendant Ive John husbandman 761153 761153 Ive, John, of Romene, husbandman 3
4651789 2246512 2246512 defendant Chanew William husbandman 761153 761153 Chanew, William, of Romene, husbandman 4
4651790 2246512 2246512 defendant Brykenden John husbandman 778083 778083 Brykenden, John, of Appuldure, Kent, husbandman 5
4651791 2246512 2246512 defendant Lang John husbandman 778084 778084 Lang, John, of Appuldure, husbandman 6
4651792 2246512 2246512 defendant Brokere John husbandman 778085 778085 Brokere, John, of Isle of Oxene, Kent, husbandman 7
4651793 2246512 2246512 defendant Stevenys William clerk 590079 590079 Stevenys, William, of Cranebroke, Kent, clerk 8
4651794 2246512 2246512 defendant Knyght William husbandman 585864 585864 Knyght, William, of Cranebroke, husbandman 9
4651795 2246512 2246512 defendant Sharp William   778086 778086 Sharp, William, of Cranebrokem husbandman 10
4651796 2246512 2246512 defendant Thorpp William gent 666989 666989 Thorpp, William, of Gylyngham, Kent, gent 11
4651797 2246512 2246512 defendant Thorpp John gent 769828 769828 Thorpp, John, of Gylyngham, gent 12

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);