names

8 rows where case_id = 2357420

✎ 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
5001783 2357420 2357420 plaintiff Morton John clerk, formerly chancellor of Chichester cathedral, parson of the church of Mayden Neuton, and canon of Salisbury cathedral   Morton, John, clerk, formerly chancellor of Chichester cathedral, parson of the church of Mayden Neuton, and canon of Salisbury cathedral, executors of 0
5001784 2357420 2357420 plaintiff Morton William     (Morton, William 1
5001785 2357420 2357420 plaintiff Davy John     Davy, John 2
5001786 2357420 2357420 plaintiff Morton Richard brother of John Morton   Morton, Richard, brother of John Morton 3
5001787 2357420 2357420 plaintiff Morton William brother of the same John   Morton, William, brother of the same John 4
5001788 2357420 2357420 plaintiff Move or Mone John     Move or Mone, John 5
5001789 2357420 2357420 defendant Fordere John of Erlyngton Sussex, yeomen   Fordere, John of Erlyngton, Sussex, yeomen, executors of (Fordere, Agnes, widow, of Elyngton, Sussex, formerly wife of John Fordere 0
5001790 2357420 2357420 defendant Fordere Giles yeoman 588550 588550 Fordere, Giles, of Erlyngton, yeoman 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);