names

33 rows where case_id = 2246508

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4651713 2246508 2246508 plaintiff Arundell Thomas Archbishop of Canterbury   Arundell, Thomas, Archbishop of Canterbury, executors of 0
4651714 2246508 2246508 plaintiff Humfrevyll Gilbert knight   (Humfrevyll, Gilbert, knight 1
4651715 2246508 2246508 plaintiff (not given)   prior of Christ Church Priory, Canterbury   Christ Church Priory, Canterbury, prior of 2
4651716 2246508 2246508 plaintiff Morgan Philip     Morgan, Philip 3
4651717 2246508 2246508 plaintiff Mylton William     Mylton, William 4
4651718 2246508 2246508 plaintiff Wotton John master of Maydeston College   Wotton, John, master of Maydeston College 5
4651719 2246508 2246508 plaintiff Brokesby Bartholomew     Brokesby, Bartholomew 6
4651720 2246508 2246508 plaintiff Maydeston William     Maydeston, William 7
4651721 2246508 2246508 defendant Hatfeld John husbandman 778068 778068 Hatfeld, John, of Lovent, Sussex, husbandman 0
4651722 2246508 2246508 defendant Corosle William husbandman 778069 778069 Corosle, William, of Maghfeld, Sussex, husbandman 1
4651723 2246508 2246508 defendant Grove Lawrence husbandman 778070 778070 Grove, Lawrence, of Ovyng, Sussex, husbandman 2
4651724 2246508 2246508 defendant Burry Stephen   778071 778071 Burry, Stephen, of Slyndon, Sussex 3
4651725 2246508 2246508 defendant Molet John gent 778072 778072 Molet, John, of Ryngmere, Sussex, husbandmanWolbald, Thomas, of Appuldure, Kent, gent 4
4651726 2246508 2246508 defendant Styer William husbandman 617084 617084 Styer, William, of Treng, Herts, husbandman 5
4651727 2246508 2246508 defendant Bukmayster John husbandman 776846 776846 Bukmayster, John, of Treng, husbandman 6
4651728 2246508 2246508 defendant Martyn Thomas husbandman 776846 776846 Martyn, Thomas, of Treng, husbandman 7
4651729 2246508 2246508 defendant Moone Henry husbandman 776846 776846 Moone, Henry, of Treng, husbandman 8
4651730 2246508 2246508 defendant Horsman Richard husbandman 776846 776846 Horsman, Richard, of Treng, husbandman 9
4651731 2246508 2246508 defendant Belche Nicholas husbandman 776846 776846 Belche, Nicholas, of Treng, husbandman 10
4651732 2246508 2246508 defendant Fordham Robert husbandman 776846 776846 Fordham, Robert, of Treng, husbandman 11
4651733 2246508 2246508 defendant Pacche Richard husbandman 778073 778073 Pacche, Richard, of Est Shene, Surrey, husbandman 12
4651734 2246508 2246508 defendant Hoke Richard husbandman 778074 778074 Hoke, Richard, of Rokehampton, Surrey, husbandman 13
4651735 2246508 2246508 defendant Jay Thomas husbandman 586179 586179 Jay, Thomas, of Croydon, Surrey, husbandman 14
4651736 2246508 2246508 defendant Roughshawe John yeoman 607060 607060 Roughshawe, John, of Otteford, Kent, yeoman 15
4651737 2246508 2246508 defendant Petygo John yeoman 594980 594980 Petygo, John, of Gravesende, Kent, yeoman 16
4651738 2246508 2246508 defendant Scarburgh John gent 596481 596481 Scarburgh, John, of Northflete, Kent, gent 17
4651739 2246508 2246508 defendant Baker Thomas husbandman 778075 778075 Baker, Thomas, of Maydenston, Kent, husbandman 18
4651740 2246508 2246508 defendant Ynan or Yvan Philip husbandman 778076 778076 Ynan or Yvan, Philip, of Bocton under Bleen, Kent, husbandman 19
4651741 2246508 2246508 defendant Ricard John husbandman 651449 651449 Ricard, John, of Bocton under Bleen, husbandman 20
4651742 2246508 2246508 defendant atte Thorne Philip husbandman 651449 651449 atte Thorne, Philip, of Bocton under Bleen, husbandman 21
4651743 2246508 2246508 defendant Bodyll Henry husbandman 651449 651449 Bodyll, Henry, of Bocton under Bleen, husbandman 22
4651744 2246508 2246508 defendant Waweter Richard gent 586175 586175 Waweter, Richard, of Canterbury, gent 23
4651745 2246508 2246508 defendant Daundelyon John husbandman 778078 778078 Daundelyon, John, of Bourne, Kent, husbandman 24

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