names

6 rows where case_id = 2315237

✎ 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
4862361 2315237 2315237 plaintiff de Louther Robert knight   de Louther, Robert, knight, executors of 0
4862362 2315237 2315237 plaintiff de Louther Margaret     (de Louther, Margaret 1
4862363 2315237 2315237 plaintiff de Louther William his son   de Louther, William, his son 2
4862364 2315237 2315237 plaintiff Dalamore Thomas     Dalamore, Thomas 3
4862365 2315237 2315237 defendant Ellergill Robert vicar of Torpenhowe, receiver for Penreth for Richard Nevyll, Earl of Alisbury   Ellergill, Robert, vicar of Torpenhowe, receiver for Penreth for Richard Nevyll, Earl of Alisbury 0
4862366 2315237 2315237 defendant Burgham Thomas gent 779934 779934 Burgham, Thomas, of Burgham, Westmor, gent 1

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