names

15 rows where case_id = 1907864

✎ 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
3641713 1907864 1907864 plaintiff Briscough John esq   Briscough, John, esq 0
3641714 1907864 1907864 defendant Bewle Ralph yeoman 592007 592007 Bewle, Ralph, of Wodhall, yeoman 0
3641715 1907864 1907864 defendant Richardson John yeoman 600602 600602 Richardson, John, of Hodstalles, yeoman 1
3641716 1907864 1907864 defendant Richardson Charles husbandman 600602 600602 Richardson, Charles, of Hodstalles, husbandman 2
3641717 1907864 1907864 defendant Richardson Thomas husbandman 600603 600603 Richardson, Thomas, of Caldwyke, husbandman 3
3641718 1907864 1907864 defendant Richardson William husbandman 600604 600604 Richardson, William, of Welpo, husbandman 4
3641719 1907864 1907864 defendant Halynbe Christopher husbandman 600604 600604 Halynbe, Christopher, of Welpo, husbandman 5
3641720 1907864 1907864 defendant Nicolson Richard husbandman 600605 600605 Nicolson, Richard, of Browreke, husbandman 6
3641721 1907864 1907864 defendant Williamson Robert husbandman 600605 600605 Williamson, Robert, of Browreke, husbandman 7
3641722 1907864 1907864 defendant Williamson Thomas husbandman 600606 600606 Williamson, Thomas, of Nether Hudstall, husbandman 8
3641723 1907864 1907864 defendant Parker Thomas husbandman 600607 600607 Parker, Thomas, of Hesketh, husbandman 9
3641724 1907864 1907864 defendant Parker Charles husbandman 600607 600607 Parker, Charles, of Hesketh, husbandman 10
3641725 1907864 1907864 defendant Richardson Christopher husbandman 600607 600607 Richardson, Christopher, of Hesketh, husbandman 11
3641726 1907864 1907864 defendant Richardson Nicholas husbandman 600608 600608 Richardson, Nicholas, of Neulandis, husbandman 12
3641727 1907864 1907864 defendant Richardson Edward husbandman 600608 600608 Richardson, Edward, of Neulandis, husbandman 13

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