names

13 rows where case_id = 2386697

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5100969 2386697 2386697 plaintiff Andrewe Richard     Andrewe, Richard 0
5100970 2386697 2386697 defendant Bradhowe Robert butcher 587309 587309 Bradhowe, Robert, of Holbeche, butcher 0
5100971 2386697 2386697 defendant Pynder Richard husbandman 589460 589460 Pynder, Richard, of Spaldyng, husbandman 1
5100972 2386697 2386697 defendant Flete Richard   587309 587309 Flete, Richard, of Holbeche, shepherd 2
5100973 2386697 2386697 defendant Spylman Robert husbandman 587360 587360 Spylman, Robert, of Gedney, husbandman 3
5100974 2386697 2386697 defendant Wryght John, senior husbandman 588422 588422 Wryght, John, senior, of Croyland, husbandman 4
5100975 2386697 2386697 defendant Chapman John fisher 595953 595953 Chapman, John, of Whaplode, fisher 5
5100976 2386697 2386697 defendant Wryght Nicholas husbandman 588422 588422 Wryght, Nicholas, of Croyland, husbandman 6
5100977 2386697 2386697 defendant Skynner John skinner 825108 825108 Skynner, John, of Petyrburgh, Nhants, skinner 7
5100978 2386697 2386697 defendant Kyrkeby Robert chaplain 590073 590073 Kyrkeby, Robert, of Fryston, chaplain 8
5100979 2386697 2386697 defendant Parowe Thomas (legal representative) 586286 586286 Parowe, Thomas, of Boston, executors of 9
5100980 2386697 2386697 defendant Edon Alan mercer 586286 586286 (Edon, Alan, of Boston, mercer 10
5100981 2386697 2386697 defendant Wryght Robert   586286 586286 Wryght, Robert, of Boston, bailiff 11

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