names

12 rows where case_id = 2283885

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4761318 2283885 2283885 plaintiff Drapur John (legal representative) 586696 586696 Drapur, John, of Staunford, executors of 0
4761319 2283885 2283885 plaintiff Knyght William     (Knyght, William 1
4761320 2283885 2283885 plaintiff Knyght Christine formerly wife of John Drapur   Christine, his wife, formerly wife of John Drapur 2
4761321 2283885 2283885 defendant Tendale John esq   Tendale, John, esq, executors of 0
4761322 2283885 2283885 defendant Warde Robert   632628 632628 (Warde, Robert, of Eston, Leics, vicar 1
4761323 2283885 2283885 defendant Wolf Richard   763751 763751 Wolf, Richard, of Stelton, parson 2
4761324 2283885 2283885 defendant (not given) William vicar of Glyn 781524 781524 Glyn, William, of Coventry, Warws, vicar of St Michael's church 3
4761325 2283885 2283885 defendant Broune Richard husbandman 798349 798349 Broune, Richard, of Broune or Bourn, Lincs, husbandman 4
4761326 2283885 2283885 defendant Tannar William husbandman 668520 668520 together with Tannar, William, of Uffyngton, Lincs, husbandman 5
4761327 2283885 2283885 defendant Bergham William   798350 798350 Bergham, William, of Litelport, Cambs, vicar 6
4761328 2283885 2283885 defendant Shepherd John husbandman 798351 798351 Shepherd, John, of Baston, Lincs, husbandman 7
4761329 2283885 2283885 defendant atte Welle Simon husbandman 728682 728682 together with atte Welle, Simon, of Uffington, Lincs, husbandman 8

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