names

11 rows where case_id = 2199918

✎ 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
4497665 2199918 2199918 plaintiff Dymelton Walter     Dymelton, Walter 0
4497666 2199918 2199918 plaintiff Dymelton John     Dymelton, John 1
4497667 2199918 2199918 plaintiff Geffreyson Walter chaplain   Geffreyson, Walter, chaplain 2
4497668 2199918 2199918 defendant Pynder Thomas     Pynder, Thomas 0
4497669 2199918 2199918 defendant Pynder Lucy     Lucy, his wife 1
4497670 2199918 2199918 defendant Wyton Stephen     Wyton, Stephen 2
4497671 2199918 2199918 defendant Wyton Agnes     Agnes, his wife 3
4497672 2199918 2199918 defendant Parcour Thomas     Parcour, Thomas 4
4497673 2199918 2199918 defendant Smyth Robert   589402 589402 Smyth, Robert, of Patryngton 5
4497674 2199918 2199918 defendant Sprotley Beatrice     Sprotley, Beatrice 6
4497675 2199918 2199918 defendant Smyth Stephen   589402 589402 Smyth, Stephen, of Patryngton 7

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