names

19 rows where case_id = 2194427

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4480038 2194427 2194427 plaintiff Kirkbride Richard knight   Kirkbride, Richard, knight 0
4480039 2194427 2194427 defendant Ruke John     Ruke, John 0
4480040 2194427 2194427 defendant Richardson William   761568 761568 Richardson, William, of Scaleby 1
4480041 2194427 2194427 defendant Fleccher Robert   761568 761568 Fleccher, Robert, of Scaleby 2
4480042 2194427 2194427 defendant Thomson Richard   761568 761568 Thomson, Richard, of Scaleby 3
4480043 2194427 2194427 defendant Staynton William de Broun, William. Broun, Thomas   Staynton, William, de Broun, William. Broun, Thomas 4
4480044 2194427 2194427 defendant Dobson Andrew     Dobson, Andrew 5
4480045 2194427 2194427 defendant Merlay Lawrence     Merlay, Lawrence 6
4480046 2194427 2194427 defendant Rose Robert     Rose, Robert 7
4480047 2194427 2194427 defendant Dobyn-ogther Margaret     Dobyn-ogther, Margaret 8
4480048 2194427 2194427 defendant del Westend William     del Westend, William 9
4480049 2194427 2194427 defendant Dryburn William de     Dryburn, William de 10
4480050 2194427 2194427 defendant Shepherdson Robert     Shepherdson, Robert 11
4480051 2194427 2194427 defendant del Westend John     del Westend, John 12
4480052 2194427 2194427 defendant Coldance John de     Coldance, John de 13
4480053 2194427 2194427 defendant Thomson Richard, junior     Thomson, Richard, junior 14
4480054 2194427 2194427 defendant Wode Robert     Wode, Robert 15
4480055 2194427 2194427 defendant Bawenes Agnes de     Bawenes, Agnes de 16
4480056 2194427 2194427 defendant Stagger Adam     Stagger, Adam 17

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