names

34 rows where case_id = 2246513

✎ 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
4651798 2246513 2246513 plaintiff Arundell Thomas Archbishop of Canterbury   Arundell, Thomas, Archbishop of Canterbury, executors of 0
4651799 2246513 2246513 plaintiff Humfrevyll Gilbert knight   (Humfrevyll, Gilbert, knight 1
4651800 2246513 2246513 plaintiff (not given)   prior of Christ Church Priory, Canterbury   Christ Church Priory, Canterbury, prior of 2
4651801 2246513 2246513 plaintiff Morgan Philip     Morgan, Philip 3
4651802 2246513 2246513 plaintiff Mylton William     Mylton, William 4
4651803 2246513 2246513 plaintiff Wotton John master of Maydeston College   Wotton, John, master of Maydeston College 5
4651804 2246513 2246513 plaintiff Brokesby Bartholomew     Brokesby, Bartholomew 6
4651805 2246513 2246513 plaintiff Maydeston William     Maydeston, William 7
4651806 2246513 2246513 defendant Oxenden John husbandman 597142 597142 Oxenden, John, of Wyngham, Kent, husbandman 0
4651807 2246513 2246513 defendant Twytham James husbandman 594894 594894 Twytham, James, of Wyngham, husbandman 1
4651808 2246513 2246513 defendant Bysle Simon yeoman 778056 778056 Bysle, Simon, of Lymynge, Kent, yeoman 2
4651809 2246513 2246513 defendant Wodehall John husbandman 778057 778057 Wodehall, John, of Wyke, Kent, husbandman 3
4651810 2246513 2246513 defendant Gybon John husbandman 658022 658022 Gybon, John, of Lymynge, husbandman 4
4651811 2246513 2246513 defendant Gilberd Richard husbandman 658022 658022 Gilberd, Richard, of Lymynge, husbandman 5
4651812 2246513 2246513 defendant Gardyner Henry husbandman 658022 658022 Gardyner, Henry, of Lymynge, husbandman 6
4651813 2246513 2246513 defendant Grubbe William husbandman 658022 658022 Grubbe, William, of Lymynge, husbandman 7
4651814 2246513 2246513 defendant atte Downe William husbandman 778087 778087 atte Downe, William, of Saltwode, Kent, husbandman 8
4651815 2246513 2246513 defendant Andrewe Simoin husbandman 611875 611875 Andrewe, Simoin, of Saltwode, husbandman 9
4651816 2246513 2246513 defendant atte Stone Richard husbandman 611875 611875 atte Stone, Richard, of Saltwode, husbandman 10
4651817 2246513 2246513 defendant May Thomas carpenter 778088 778088 May, Thomas, of Recolvere, Kent, carpenter 11
4651818 2246513 2246513 defendant Thomasyn John husbandman 589383 589383 Thomasyn, John, of Maydeston, Kent, husbandman 12
4651819 2246513 2246513 defendant Barry Nicholas husbandman 589001 589001 Barry, Nicholas, of Maydeston, husbandman 13
4651820 2246513 2246513 defendant Hunte William husbandman 589344 589344 Hunte, William, of Potenhith, Surrey, husbandman 14
4651821 2246513 2246513 defendant Cartere John husbandman 778063 778063 Cartere, John, of Rokhampton, Surrey, husbandman 15
4651822 2246513 2246513 defendant Hoke Richard husbandman 677886 677886 Hoke, Richard, of Rokhampton, husbandman 16
4651823 2246513 2246513 defendant Savage Robert husbandman 620455 620455 Savage, Robert, of Wannesworth, Surrey, husbandman 17
4651824 2246513 2246513 defendant Hunte John husbandman 587171 587171 Hunte, John, of Wannesworth, husbandman 18
4651825 2246513 2246513 defendant Colman William husbandman 587171 587171 Colman, William, of Wannesworth, husbandman 19
4651826 2246513 2246513 defendant Blakewell John parson of Wymbyldon, Surrey   Blakewell, John, parson of Wymbyldon, Surrey 20
4651827 2246513 2246513 defendant Reculver Robert husbandman 615791 615791 Reculver, Robert, of Wymbyldon, husbandman 21
4651828 2246513 2246513 defendant Fayrefeld John Surrey, husbandman 908371 908371 Fayrefeld John, of Putenhith, Surrey, husbandman 22
4651829 2246513 2246513 defendant Taillour Walter clerk 608809 608809 Taillour, Walter, of Pagham, Sussex, clerk 23
4651830 2246513 2246513 defendant Tayllour William husbandman 778065 778065 Tayllour, William, of Nytymbre, Sussex, husbandman 24
4651831 2246513 2246513 defendant Chese John   778089 778089 Chese, John, of Nytymbrem husbandman 25

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