names

16 rows where case_id = 2198241

✎ 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
4492184 2198241 2198241 plaintiff Wynder John de adminstratrix of   Wynder, John de, adminstratrix of 0
4492185 2198241 2198241 plaintiff Wynder Margaret formerly wife of John   Wynder, Margaret, formerly wife of John 1
4492186 2198241 2198241 defendant Arnaldson Thomas     Arnaldson, Thomas 0
4492187 2198241 2198241 defendant del Kechyn William     del Kechyn, William 1
4492188 2198241 2198241 defendant Burgham John de barber   Burgham, John de, barber 2
4492189 2198241 2198241 defendant Brabaner Philip     Brabaner, Philip 3
4492190 2198241 2198241 defendant Yarum Thomas de tailor   Yarum, Thomas de, tailor 4
4492191 2198241 2198241 defendant Toppynge John     Toppynge, John 5
4492192 2198241 2198241 defendant Cutberd John   762882 762882 Cutberd, John, of Culgayth 6
4492193 2198241 2198241 defendant Verder Robert     Verder, Robert 7
4492194 2198241 2198241 defendant Spynkt Robert     Spynkt, Robert 8
4492195 2198241 2198241 defendant Blewehowe Thomas Stanger, Thomas, son of Richard   Blewehowe, Thomas, Stanger, Thomas, son of Richard 9
4492196 2198241 2198241 defendant Bakster John     Bakster, John 10
4492197 2198241 2198241 defendant Kirkebythore John de     Kirkebythore, John de 11
4492198 2198241 2198241 defendant Cariour Robert     Cariour, Robert 12
4492199 2198241 2198241 defendant Thomson John     Thomson, John 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);