names

13 rows where place_id = 770847

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4571947 2222801 2222801 defendant Gibthorp William   770847 770847 Gibthorp, William, of Thorp by Waynflete 0
4738034 2276997 2276997 plaintiff Watkynson William   770847 770847 Watkynson, William, of Thorp by Waynflete, perpetual vicar 0
4915847 2331453 2331453 defendant Kelsay Peter husbandman 770847 770847 Kelsay, Peter, of Thorp by Waynflete, husbandman 10
4921977 2333282 2333282 defendant Johnson Henry husbandman 770847 770847 Johnson, Henry, of Thorp by Waynflete, husbandman 0
4926317 2334655 2334655 defendant Wolby Richard husbandman 770847 770847 Wolby, Richard, of Thorp by Waynflete, husbandman 1
5131519 2395700 2395700 defendant Hochonson Walter husbandman 770847 770847 Hochonson, Walter, of Thorp by Waynflete, husbandman 1
5189097 2412542 2412542 defendant Sawer William yeoman 770847 770847 Sawer, William, of Thorp by Waynflete, yeoman 1
5196334 2414677 2414677 defendant Sawer Robert yeoman 770847 770847 Sawer, Robert, of Thorp by Waynflete, yeoman 0
5206373 2417598 2417598 defendant Sawer William yeoman 770847 770847 Sawer, William, of Thorp by Waynflete, yeoman 1
5206375 2417598 2417598 defendant Mabbyt Richard yeoman 770847 770847 Mabbyt, Richard, of Thorp by Waynflete, yeoman 3
5209599 2418547 2418547 defendant Sawer Robert yeoman 770847 770847 Sawer, Robert, of Thorp by Waynflete, yeoman 0
5302523 2445726 2445726 defendant Maltby Richard husbandman 770847 770847 Maltby, Richard, of Thorp by Waynflete, husbandman 0
5378543 2468873 2468873 defendant Gibthorp Thomas gent 770847 770847 Gibthorp, Thomas, of Thorp by Waynflete, gent 0

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