names

34 rows where case_id = 2246501

✎ 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
4651623 2246501 2246501 plaintiff Arundell Thomas Archbishop of Canterbury   Arundell, Thomas, Archbishop of Canterbury, executors of 0
4651624 2246501 2246501 plaintiff Humfrevill Gilbert knight   (Humfrevill, Gilbert, knight 1
4651625 2246501 2246501 plaintiff (not given)   prior of Christ Church Priory, Canterbury   Christ Church Priory, Canterbury, prior of 2
4651626 2246501 2246501 plaintiff Morgan Philip     Morgan, Philip 3
4651627 2246501 2246501 plaintiff Milton William     Milton, William 4
4651628 2246501 2246501 plaintiff Wotton John master of Maydeston College   Wotton, John, master of Maydeston College 5
4651629 2246501 2246501 plaintiff Brokesby Bartholmew     Brokesby, Bartholmew 6
4651630 2246501 2246501 plaintiff Maydeston William     Maydeston, William 7
4651631 2246501 2246501 defendant Oxenden John husbandman 597142 597142 Oxenden, John, of Wyngham, Kent, husbandman 0
4651632 2246501 2246501 defendant Twytham James husbandman 594894 594894 Twytham, James, of Wyngham, husbandman 1
4651633 2246501 2246501 defendant Bysle Simon yeoman 778056 778056 Bysle, Simon, of Lymynge, Kent, yeoman 2
4651634 2246501 2246501 defendant Wodehell John husbandman 778057 778057 Wodehell, John, of Wyke, Kent, husbandman 3
4651635 2246501 2246501 defendant Gybon John husbandman 778058 778058 Gybon, John, of Lyngynge, husbandman 4
4651636 2246501 2246501 defendant Gilberd Richard husbandman 658022 658022 Gilberd, Richard, of Lymynge, husbandman 5
4651637 2246501 2246501 defendant Gardyner Henry husbandman 658022 658022 Gardyner, Henry, of Lymynge, husbandman: Br-, William, of Lymynge, husbandman 6
4651638 2246501 2246501 defendant atte Downe William husbandman 778060 778060 atte Downe, William, of Saltsode, Kent, husbandman 7
4651639 2246501 2246501 defendant Andrewe Simon husbandman 611875 611875 Andrewe, Simon, of Saltwode, husbandman 8
4651640 2246501 2246501 defendant atte Stone Richard husbandman 611875 611875 atte Stone, Richard, of Saltwode, husbandman 9
4651641 2246501 2246501 defendant May Thomas carpenter 778061 778061 May, Thomas, of Rocolvere, Kent, carpenter 10
4651642 2246501 2246501 defendant Thomasyn John husbandman 589383 589383 Thomasyn, John, of Maydeston, Kent, husbandman 11
4651643 2246501 2246501 defendant Barry Nicholas husbandman 589001 589001 Barry, Nicholas, of Maydeston, husbandman 12
4651644 2246501 2246501 defendant Hunte William husbandman 778062 778062 Hunte, William, of Petenhith, Surrey, husbandman 13
4651645 2246501 2246501 defendant Cartere John husbandman 778063 778063 Cartere, John, of Rokhampton, Surrey, husbandman 14
4651646 2246501 2246501 defendant Hoke Richard husbandman 677886 677886 Hoke, Richard, of Rokhampton, husbandman 15
4651647 2246501 2246501 defendant Savage Robert husbandman 620455 620455 Savage, Robert, of Wannesworth, Surrey, husbandman 16
4651648 2246501 2246501 defendant Hunte John husbandman 587171 587171 Hunte, John, of Wannesworth, husbandman 17
4651649 2246501 2246501 defendant Colman William husbandman 587171 587171 Colman, William, of Wannesworth, husbandman 18
4651650 2246501 2246501 defendant Blakewell John parson of Wymbyldon, Surrey   Blakewell, John, parson of Wymbyldon, Surrey 19
4651651 2246501 2246501 defendant Recolver Robert husbandman 615791 615791 Recolver, Robert, of Wymbyldon, husbandman 20
4651652 2246501 2246501 defendant Fayrefeld John husbandman 778064 778064 Fayrefeld, John, of Putenhith, Surrey, husbandman 21
4651653 2246501 2246501 defendant Taillour Walter clerk 608809 608809 Taillour, Walter, of Pagham, Sussex, clerk 22
4651654 2246501 2246501 defendant Passhe Thomas husbandman 778065 778065 Passhe, Thomas, of Nytymbre, Sussex, husbandman 23
4651655 2246501 2246501 defendant Taillour William husbandman 778066 778066 Taillour, William, of Nytymbre, husbandman 24
4651656 2246501 2246501 defendant Chese John husbandman 778066 778066 Chese, John, of Nytymbre, 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);