names

12 rows where case_id = 2260554

✎ 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
4683830 2260554 2260554 plaintiff Pikeryng Richard (legal representative) 590487 590487 Pikeryng, Richard, of Hemmyngburgh, parson, executors of 0
4683831 2260554 2260554 plaintiff Sutton Thomas clerk   (Sutton, Thomas, clerk 1
4683832 2260554 2260554 plaintiff Dunham John prior fo   Dunham, John, prior fo 2
4683833 2260554 2260554 plaintiff Barry William another monk   Barry, William, another monk 3
4683834 2260554 2260554 plaintiff Hoton Robert     Hoton, Robert 4
4683835 2260554 2260554 defendant Barker William gent 783773 783773 Barker, William, of Osbodby, Yorks, gent 0
4683836 2260554 2260554 defendant Babthorp Robert husbandman 783774 783774 Babthorp, Robert, of Hemmyngburgh, Yorks, husbandman 1
4683837 2260554 2260554 defendant Burges John husbandman 783775 783775 Burges, John, of Duffeld, Yorks, husbandman 2
4683838 2260554 2260554 defendant Hadylsay John husbandman 783775 783775 Hadylsay, John, of Duffeld, Yorks, husbandman 3
4683839 2260554 2260554 defendant Everhirde William ofHemmyngburgh, Yorks, husandman   Everhirde, William, ofHemmyngburgh, Yorks, husandman 4
4683840 2260554 2260554 defendant Ty-- Robert husbandman 590487 590487 Ty--, Robert, of Hemmyngburgh, husbandman 5
4683841 2260554 2260554 defendant Grewe John husbandman 590487 590487 Grewe, John, of Hemmyngburgh, husbandman 6

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