names

16 rows where case_id = 1989592

✎ 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
3898152 1989592 1989592 plaintiff Aglyonby Edward     Aglyonby, Edward 0
3898153 1989592 1989592 defendant Richardson William husbandman 647780 647780 Richardson, William, of Lynstoke, husbandman 0
3898154 1989592 1989592 defendant Grame Thomas husbandman 647780 647780 Grame, Thomas, of Lynstoke, husbandman 1
3898155 1989592 1989592 defendant Nycolson John husbandman 647780 647780 Nycolson, John, of Lynstoke, husbandman 2
3898156 1989592 1989592 defendant Nycolson Alice spinster 647780 647780 Nycolson, Alice, of Lynstoke, spinster 3
3898157 1989592 1989592 defendant Grame John husbandman 647780 647780 Grame, John, of Lynstoke, husbandman 4
3898158 1989592 1989592 defendant Blakloke Thomas husbandman 647780 647780 Blakloke, Thomas, of Lynstoke, husbandman 5
3898159 1989592 1989592 defendant Nicolson Robert husbandman 647780 647780 Nicolson, Robert, of Lynstoke, husbandman 6
3898160 1989592 1989592 defendant Richardson Christopher husbandman 647780 647780 Richardson, Christopher, of Lynstoke, husbandman 7
3898161 1989592 1989592 defendant Clerke Edward husbandman 647780 647780 Clerke, Edward, of Lynstoke, husbandman 8
3898162 1989592 1989592 defendant Thomson James husbandman 647780 647780 Thomson, James, of Lynstoke, husbandman 9
3898163 1989592 1989592 defendant Nycolson Robert husbandman 647780 647780 Nycolson, Robert, of Lynstoke, husbandman 10
3898164 1989592 1989592 defendant Dowersten Roland husbandman 647780 647780 Dowersten, Roland, of Lynstoke, husbandman 11
3898165 1989592 1989592 defendant Nicolson Christopher husbandman 647780 647780 Nicolson, Christopher, of Lynstoke, husbandman 12
3898166 1989592 1989592 defendant Nicolson Isabel Edward, husbandman 647780 647780 Isabel his wife: Richardson, Edward, of Lynstoke, husbandman 13
3898167 1989592 1989592 defendant Blakeloke Richard husbandman 647780 647780 Blakeloke, Richard, of Lynstoke, husbandman 14

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