names

13 rows where case_id = 2312455

✎ 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
4853325 2312455 2312455 plaintiff (not given) Christine abbess of Wilton   Wilton, Christine, abbess of 0
4853326 2312455 2312455 defendant Forthward William husbandman 812982 812982 Forthward, William, of _oell Abbisse or Isle Abbots, husbandman 0
4853327 2312455 2312455 defendant Hogons John thatcher 812983 812983 Hogons, John, of Wodelond, in the parish of Mere, thatcher 1
4853328 2312455 2312455 defendant Rigge John husbandman 764163 764163 Rigge, John, of Rigge, husbandman 2
4853329 2312455 2312455 defendant Stony John husbandman 764163 764163 Stony, John, of Rigge, husbandman 3
4853330 2312455 2312455 defendant Igenell John husbandman 765936 765936 Igenell, John, of Up Avon, husbandman 4
4853331 2312455 2312455 defendant Igenell Agnes     Agnes, his wife 5
4853332 2312455 2312455 defendant Farnham Thomas husbandman 640135 640135 Farnham, Thomas, of Churton, husbandman 6
4853333 2312455 2312455 defendant atte Wode Thomas of All Canynges husbandman   atte Wode, Thomas of All Canynges, husbandman 7
4853334 2312455 2312455 defendant Pasmere John husbandman 653626 653626 Pasmere, John, of All Canynges, husbandman 8
4853335 2312455 2312455 defendant Stokys Robert husbandman 627827 627827 Stokys, Robert, of Alcanynges, husbandman 9
4853336 2312455 2312455 defendant Stokes John husbandman 627827 627827 Stokes, John, of Alcanynges, husbandman 10
4853337 2312455 2312455 defendant Fader William jun, of Elingdon, husbandman   Fader, William, jun, of Elingdon, husbandman 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);